Can't create some type of reports

[Vietdt6]

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!

Technical details

Log's referral number: 8eab9c9e-ce3b-41ba-96d4-3221868526d9

Cause

Referer URL: https://jira.xxx.vn/secure/TimespentReport!default.jspa?selectedProjectId=10102&projectOrFilterId=project-10102&projectOrFilterName=V%C3%AD%203-%20Core%20V%C3%AD&reportKey=jira-timesheet-plugin:timespent

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

[Andy Heinzer]

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.