Can't use an oracle database

When I try to use an oracle database I get the following error during creation of the schema:

The Hibernate SessionFactory could not be created. The database schema may not have been correctly applied

Hide details

The Hibernate SessionFactory could not be created. The database schema may not have been correctly applied

com.atlassian.stash.internal.migration.DefaultMigrationService.createSessionFactory(DefaultMigrationService.java:514)

com.atlassian.stash.internal.migration.DefaultMigrationService.startMigration(DefaultMigrationService.java:937)

com.atlassian.stash.internal.migration.DefaultMigrationService.migrate(DefaultMigrationService.java:163)

...

Missing column: is_local in CONFLUENCE.CWD_GROUP

org.hibernate.mapping.Table.validateColumns(Table.java:276)

org.hibernate.cfg.Configuration.validateSchema(Configuration.java:1343)

org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:139)

...

However the tables are created in the schema. With a local database everything seems to work and we have JIRA and Confluence working with the same database.

Oracle version 11.2.0.1.0, normally connecting through LDAP but I looked up the exact host since I can't use ldap with Stash.

2 answers

Ok for me. That was what I intended with posting the resolution.

Hey Jeroen,

I'm sharing the resolution here for future references of community users, ok?

"Apparently if you give the stash user the dba role, it doesn't work as it should.
Removing the DBA role (keeping connect and resource) solved the problem."

Cheers,

Leonardo.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published yesterday in Statuspage

194 years of downtime: looking back on incident data from 2018

Statuspage customers logged more than 194 years of collective incidents in 2018. That’s a whopping 87% increase from the  104 years logged in 2017 , and we aren’t even through December yet....

56 views 1 5
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you