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
