New installation of Bamboo on Oracle database fails with org.hibernate.id.IdentifierGenerationException: could not read a hi value
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. 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:
1
2
3
4
5
6
7
8
9
10
11
12
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.
Was this helpful?