ORA-01400: cannot insert NULL in("DDBB"."AO_60DB71_COLUMN"."ID")

[Juan Luis]

After upgrade jira I got the next error when access into boards

Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
    Database:
    	- name:Oracle
    	- version:Oracle Database 11g Release 11.2.0.3.0 - 64bit Production
    	- minor version:2
    	- major version:11
    Driver:
    	- name:Oracle JDBC driver
    	- version:12.1.0.1.0
    
    java.sql.SQLIntegrityConstraintViolationException: ORA-01400: no se puede realizar una inserción NULL en ("DDBB"."AO_60DB71_COLUMN"."ID")
    
	at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.create(EntityManagedActiveObjects.java:102) [?:?]
	at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects.create(TenantAwareActiveObjects.java:271) [?:?]
	at sun.reflect.GeneratedMethodAccessor1707.invoke(Unknown Source) [?:?]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [?:1.8.0_102]
	at java.lang.reflect.Method.invoke(Method.java:498) [?:1.8.0_102]
	at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302) [spring-aop-4.2.5.RELEASE.jar:4.2.5.RELEASE]
	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:179) [spring-aop-4.2.5.RELEASE.jar:4.2.5.RELEASE]
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133) [spring-aop-4.2.5.RELEASE.jar:4.2.5.RELEASE]
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121) [spring-aop-4.2.5.RELEASE.jar:4.2.5.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.5.RELEASE.jar:4.2.5.RELEASE]
	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:179) [spring-aop-4.2.5.RELEASE.jar:4.2.5.RELEASE]
	at org.eclipse.gemini.blueprint.service.importer.support.LocalBundleContextAdvice.invoke(LocalBundleContextAdvice.java:57) [?:?]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.5.RELEASE.jar:4.2.5.RELEASE]
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:133) [spring-aop-4.2.5.RELEASE.jar:4.2.5.RELEASE]
	at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:121) [spring-aop-4.2.5.RELEASE.jar:4.2.5.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.5.RELEASE.jar:4.2.5.RELEASE]
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208) [spring-aop-4.2.5.RELEASE.jar:4.2.5.RELEASE]
	at com.sun.proxy.$Proxy7211.create(Unknown Source) [?:?]
	at com.atlassian.greenhopper.service.rapid.view.AOUtil.setListValues(AOUtil.java:66) [?:?]
	at com.atlassian.greenhopper.service.rapid.view.ColumnDao.updateForParent(ColumnDao.java:49) [?:?]
	at com.atlassian.greenhopper.service.rapid.view.ColumnServiceImpl.updateColumns(ColumnServiceImpl.java:373) [?:?]
	at com.atlassian.greenhopper.service.rapid.view.ColumnServiceImpl.addBacklogColumn(ColumnServiceImpl.java:224) [?:?]
	at com.atlassian.greenhopper.service.rapid.view.ColumnServiceImpl.getAllColumns(ColumnServiceImpl.java:112) [?:?]
	at com.atlassian.greenhopper.service.rapid.view.ColumnServiceImpl.getKanbanBacklogColumn(ColumnServiceImpl.java:206) [?:?]
	at com.atlassian.greenhopper.service.rapid.view.ColumnServiceImpl.isKanPlanEnabledForBoard(ColumnServiceImpl.java:197) [?:?]
	... 286 more

[Divya TV]

We have a the same problem, we upgraded from JIRA 8.5.3 to 8.5.4 datacenter and one node in the cluster works fine. The other node throws 

- name:Oracle
- version:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
- minor version:1
- major version:12
Driver:
- name:Oracle JDBC driver
- version:19.3.0.0.0
java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("DB OWNER"."AO_A415DF_AODOOR_STOP"."ID")

Can you please help me understand the problem and possible workarounds? We see this error in the atlassian-jira.log

[somethingblue]

Hi Juan,

I see you put in a support ticket for this issue.  Once the issue is resolved please let us know the resolution so the community can benefit as well.

Cheers,

Branden

[Juan Luis]

After update Oracle from 11g to 12c, the upgrade to the last version of jira works fine