Hi everyone,
I can't create some types of reports as TimespentReport, TimeSheetReport, ProjectPivotReport.
Others like TimeTrackingReport is okey.
Here is details about the error, pls help me. Thank you all!
Log's referral number: 8eab9c9e-ce3b-41ba-96d4-3221868526d9
com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.fdu.jira.plugin.jira-timesheet-plugin]
com.atlassian.activeobjects.internal.ActiveObjectsInitException: bundle [com.fdu.jira.plugin.jira-timesheet-plugin] at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:97) [?:?] at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:88) [?:?] at com.atlassian.sal.core.executor.ThreadLocalDelegateCallable.call(ThreadLocalDelegateCallable.java:38) [?:?] at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?] at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?] at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?] at java.base/java.lang.Thread.run(Thread.java:829) [?:?] Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:H2 - version:2.1.214 (2022-06-13) - minor version:1 - major version:2 Driver: - name:H2 JDBC Driver - version:2.1.214 (2022-06-13) org.h2.jdbc.JdbcSQLSyntaxErrorException: Syntax error in SQL statement "CREATE TABLE PUBLIC.AO_E24DEA_HOLIDAY (\000a ""DAY"" INT,\000a ID INT AUTO_INCREMENT NOT NULL,\000a LOCALE VARCHAR(255),\000a [*]MONTH INT,\000a NAME VARCHAR(255),\000a YEAR INT,\000a PRIMARY KEY(ID)\000a)"; expected "identifier"; SQL statement: CREATE TABLE PUBLIC.AO_E24DEA_HOLIDAY ( "DAY" INT, ID INT AUTO_INCREMENT NOT NULL, LOCALE VARCHAR(255), MONTH INT, NAME VARCHAR(255), YEAR INT, PRIMARY KEY(ID) ) [42001-214] at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.migrate(EntityManagedActiveObjects.java:54) [?:?] at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.lambda$create$0(AbstractActiveObjectsFactory.java:73) [?:?] at com.atlassian.sal.core.transaction.HostContextTransactionTemplate$1.doInTransaction(HostContextTransactionTemplate.java:21) [?:?] at com.atlassian.jira.DefaultHostContextAccessor.doInTransaction(DefaultHostContextAccessor.java:50) [classes/:?] at jdk.internal.reflect.GeneratedMethodAccessor341.invoke(Unknown Source) [?:?] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [?:?] at java.base/java.lang.reflect.Method.invoke(Method.java:566) [?:?] at com.atlassian.plugin.util.ContextClassLoaderSettingInvocationHandler.invoke(ContextClassLoaderSettingInvocationHandler.java:26) [atlassian-plugins-core-7.1.4.jar:?] at com.sun.proxy.$Proxy145.doInTransaction(Unknown Source) [?:?] at jdk.internal.reflect.GeneratedMethodAccessor341.invoke(Unknown Source) [?:?] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [?:?] at java.base/java.lang.reflect.Method.invoke(Method.java:566) [?:?] at com.atlassian.plugin.osgi.bridge.external.HostComponentFactoryBean$DynamicServiceInvocationHandler.invoke(HostComponentFactoryBean.java:130) [?:?] at com.sun.proxy.$Proxy145.doInTransaction(Unknown Source) [?:?] at com.atlassian.sal.core.transaction.HostContextTransactionTemplate.execute(HostContextTransactionTemplate.java:18) [?:?] at jdk.internal.reflect.GeneratedMethodAccessor346.invoke(Unknown Source) [?:?] at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [?:?] at java.base/java.lang.reflect.Method.invoke(Method.java:566) [?:?] at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) [spring-aop-5.3.21.jar:5.3.21] at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.doInvoke(ServiceInvoker.java:56) [?:?] at org.eclipse.gemini.blueprint.service.importer.support.internal.aop.ServiceInvoker.invoke(ServiceInvoker.java:60) [?:?] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) [spring-aop-5.3.21.jar:5.3.21] at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:137) [spring-aop-5.3.21.jar:5.3.21] at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124) [spring-aop-5.3.21.jar:5.3.21] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) [spring-aop-5.3.21.jar:5.3.21] at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invokeUnprivileged(ServiceTCCLInterceptor.java:70) [?:?] at org.eclipse.gemini.blueprint.service.util.internal.aop.ServiceTCCLInterceptor.invoke(ServiceTCCLInterceptor.java:53) [?:?] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) [spring-aop-5.3.21.jar:5.3.21] at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57) [?:?] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) [spring-aop-5.3.21.jar:5.3.21] at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:137) [spring-aop-5.3.21.jar:5.3.21] at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124) [spring-aop-5.3.21.jar:5.3.21] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) [spring-aop-5.3.21.jar:5.3.21] at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215) [spring-aop-5.3.21.jar:5.3.21] at com.sun.proxy.$Proxy1293.execute(Unknown Source) [?:?] at com.atlassian.activeobjects.internal.AbstractActiveObjectsFactory.create(AbstractActiveObjectsFactory.java:70) [?:?] at com.atlassian.activeobjects.internal.DelegatingActiveObjectsFactory.create(DelegatingActiveObjectsFactory.java:32) [?:?] at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects$1$1$1.call(TenantAwareActiveObjects.java:93) [?:?] ... 6 more
The nature of the error you see there indicates that your SQL database is the H2 database. While this database can be included in the Jira installation process, it's actually not supported to use this database in a production environment.
I would recommend following the steps in Switching databases. You should be selecting a supported database from the Supported platforms documentation. Personally, I'd recommend using PostgreSQL 14. I expect that once you have migrated the data to a supported database, that this error won't appear.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.