Bamboo ORA-01400: cannot insert NULL into ("BAMBOO"."BRS_ARTIFACT_LINK"."LABEL")

[Edwin Priebernig]

Hi,

I upraded Bamboo from 4.4.5 to 5.1.1. Now a build plan fails with this message:

org.springframework.dao.DataIntegrityViolationException: Hibernate operation: Could not execute JDBC batch update; SQL []; ORA-01400: cannot insert NULL into ("BAMBOO"."BRS_ARTIFACT_LINK"."LABEL")
; nested exception is java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("BAMBOO"."BRS_ARTIFACT_LINK"."LABEL")

Caused by: java.sql.BatchUpdateException: ORA-01400: cannot insert NULL into ("BAMBOO"."BRS_ARTIFACT_LINK"."LABEL")

Additionally it seems that the artifacts of old successful builds cannto be found. The Artifacts Tab shows an empty list and "No files found". If I check the path in bamboo-home, I see lots of files.

So I'm afraid that the database upgrade did fail.

[Marcin Gardias · Accepted solution]

Please contact Atlassian Support. Attach all the log files you can find to the ticket. (just zip everything in <bamboo_home>\logs)