New installation of Bamboo on Oracle database fails with org.hibernate.id.IdentifierGenerationException: could not read a hi value
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
New installation of Bamboo on Oracle database fails with "org.hibernate.id.IdentifierGenerationException: could not read a hi value"
Environment
- Oracle database
- New Bamboo installation
Diagnosis
$BAMBOO_HOME/logs/atlassian-bamboo.log contains the below error on a new installation of Bamboo on Oracle:
2021-11-29 10:27:17,963 ERROR [http-nio-8085-exec-1] [TableStructure] could not read a hi value - you need to populate the table: hibernate_unique_key
2021-11-29 10:27:17,968 ERROR [http-nio-8085-exec-1] [ExceptionMappingInterceptor] could not read a hi value - you need to populate the table: hibernate_unique_key
org.hibernate.id.IdentifierGenerationException: could not read a hi value - you need to populate the table: hibernate_unique_key
at org.hibernate.id.enhanced.TableStructure$1$1.execute(TableStructure.java:142)
at org.hibernate.id.enhanced.TableStructure$1$1.execute(TableStructure.java:126)
at org.hibernate.jdbc.WorkExecutor.executeReturningWork(WorkExecutor.java:55)
at org.hibernate.jdbc.AbstractReturningWork.accept(AbstractReturningWork.java:34)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcIsolationDelegate.delegateWork(JdbcIsolationDelegate.java:57)
at org.hibernate.id.enhanced.TableStructure$1.getNextValue(TableStructure.java:125)
at org.hibernate.id.enhanced.NoopOptimizer.generate(NoopOptimizer.java:40)
at org.hibernate.id.enhanced.SequenceStyleGenerator.generate(SequenceStyleGenerator.java:523)
at com.atlassian.bamboo.persistence.ResettableTableHiLoGenerator.generate(ResettableTableHiLoGenerator.java:86)Cause
The database user configured does not have appropriate privileges over the assigned tablespace.
Solution
Fix the tablespace permissions on the database:
At this point it is likely that the installation has failed. It may be necessary to start from scratch with a fresh database and install while ensuring tablespace privileges are correct.