Advance roadmaps permissions not run

[Philo]

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

[Philo]

[Philo]

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

[Philo]

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

[Philo]

Connecting Jira applications to MySQL 8.0 | Administering Jira applications Data Center and Server 8.20 | Atlassian Documentation

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

[Joévin VUILLEMET]

Hi,

same issue here but with an oracle database. SQL_MODE is a mysql parameter...

Any ideas?

Regards