Advance roadmaps permissions not run as I installed in the production enviorentment with 8.20.6,but it runs well in the test-enviorentment,how to fixed it ,without permission,I can't initial it to use.
===================
=== Client Info ===
===================
User agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/98.0.4758.102 Safari/537.36 Edg/98.0.1108.62
Local time: Mon Mar 07 2022 09:14:20 GMT+0800
===============
=== Request ===
===============
URL: /systempermissions/admin.json?_=1646615651619
Type: GET
Status: 404
Data: undefined
===================
=== System Info ===
===================
Plugin build: undefined
Ensure the sql_mode parameter does not specify NO_AUTO_VALUE_ON_ZERO
// remove this if it exists
sql_mode = NO_AUTO_VALUE_ON_ZERO
Hi,
same issue here but with an oracle database. SQL_MODE is a mysql parameter...
Any ideas?
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
System log:
Caused by: java.lang.RuntimeException: Entity Manager not accessible via AODoorStop.
at com.radiantminds.roadmap.common.data.activeobjects.ActiveObjectsAccessorImpl.getEntityManager(ActiveObjectsAccessorImpl.java:123)
at com.radiantminds.roadmap.common.data.activeobjects.ActiveObjectsUtilitiesImpl.getOrCreateConnection(ActiveObjectsUtilitiesImpl.java:325)
at com.radiantminds.roadmap.common.data.persistence.ao.sql.BaseAOPersistenceSQL.sql(BaseAOPersistenceSQL.java:261)
at com.radiantminds.roadmap.common.data.persistence.ao.entities.configuration.sql.CustomWordingSQL.getCustomWordings(CustomWordingSQL.java:23)
at com.radiantminds.roadmap.common.data.persistence.ao.entities.configuration.PortfolioActiveObjectsCustomWordingPersistence.getCustomWordings(PortfolioActiveObjectsCustomWordingPersistence.java:62)
... 308 more
Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:
- name:MySQL
- version:8.0.28
- minor version:0
- major version:8
- name:MySQL Connector/J
- version:mysql-connector-java-8.0.26 (Revision: 9aae1e450989d62c06616c1dcda3e404ef84df70)
java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '0' for key 'AO_A415DF_AODOOR_STOP.PRIMARY'
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.create(EntityManagedActiveObjects.java:95)
at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects.create(TenantAwareActiveObjects.java:267)
... 2 filtered
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343)
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)
at org.springframework.aop.support.Deleg
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
jira error log citation
Caused by: java.lang.RuntimeException: Entity Manager not accessible via AODoorStop. at com.radiantminds.roadmap.common.data.activeobjects.ActiveObjectsAccessorImpl.getEntityManager(ActiveObjectsAccessorImpl.java:123) at com.radiantminds.roadmap.common.data.activeobjects.ActiveObjectsUtilitiesImpl.getOrCreateConnection(ActiveObjectsUtilitiesImpl.java:325) at com.radiantminds.roadmap.common.data.persistence.ao.sql.BaseAOPersistenceSQL.sql(BaseAOPersistenceSQL.java:261) at com.radiantminds.roadmap.common.data.persistence.ao.entities.configuration.sql.CustomWordingSQL.getCustomWordings(CustomWordingSQL.java:23) at com.radiantminds.roadmap.common.data.persistence.ao.entities.configuration.PortfolioActiveObjectsCustomWordingPersistence.getCustomWordings(PortfolioActiveObjectsCustomWordingPersistence.java:62) ... 308 more Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library: Database: - name:MySQL - version:8.0.28 - minor version:0 - major version:8 - name:MySQL Connector/J - version:mysql-connector-java-8.0.26 (Revision: 9aae1e450989d62c06616c1dcda3e404ef84df70) java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '0' for key 'AO_A415DF_AODOOR_STOP.PRIMARY' at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.create(EntityManagedActiveObjects.java:95) at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects.create(TenantAwareActiveObjects.java:267) ... 2 filtered at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:343) 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) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:136) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) 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) at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:136) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:124) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212) at com.sun.proxy.$Proxy5052.create(Unknown Source) at com.radiantminds.roadmap.common.data.activeobjects.ActiveObjectsAccessorImpl.getEntityManager(ActiveObjectsAccessorImpl.java:107) ... 313 more Caused by: java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '0' for key 'AO_A415DF_AODOOR_STOP.PRIMARY' at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:117) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092) at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1040) at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1025) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:98) at com.atlassian.jira.ofbiz.sql.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:47) at com.atlassian.jira.diagnostic.connection.DiagnosticPreparedStatement.lambda$executeUpdate$7(DiagnosticPreparedStatement.java:69) at com.atlassian.diagnostics.internal.platform.monitor.db.DefaultDatabaseDiagnosticsCollector.recordExecutionTime(DefaultDatabaseDiagnosticsCollector.java:70) at com.atlassian.jira.diagnostic.connection.DatabaseDiagnosticsCollectorDelegate.recordExecutionTime(DatabaseDiagnosticsCollectorDelegate.java:55) at com.atlassian.jira.diagnostic.connection.DiagnosticPreparedStatement.executeUpdate(DiagnosticPreparedStatement.java:69) at net.java.ao.ForwardingPreparedStatement.executeUpdate(ForwardingPreparedStatement.java:45) at net.java.ao.ParameterMetadataCachingPreparedStatement.executeUpdate(ParameterMetadataCachingPreparedStatement.java:10) at net.java.ao.DatabaseProvider.executeInsertReturningKey(DatabaseProvider.java:2003) at net.java.ao.DatabaseProvider.insertReturningKey(DatabaseProvider.java:1867) at net.java.ao.EntityManager.create(EntityManager.java:369) at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.create(EntityManagedActiveObjects.java:93) ... 335 more
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.