Can't create some type of reports

Vietdt6
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 25, 2024

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

1 answer

0 votes
Andy Heinzer
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
April 26, 2024

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.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
9.8.1
PRODUCT PLAN
STANDARD
TAGS
AUG Leaders

Atlassian Community Events