Oracle DB - The database is not using Unicode. Crucible requires that the database uses a UTF8 encoding to support internalization

Still need help?

The Atlassian Community is here for you.

Ask the community

Symptoms

When trying to migrate to an Oracle DB, the following ERROR is shown "The database is not using case-sensitive Unicode. Fisheye and Crucible require that the database is case-sensitive and uses a UTF8 encoding to support internalization."

Cause

The problem on the UI is happening because the encoding set in your Oracle server is more restrictive than UTF8.

We know that Oracle allows a unique Server level Char Encoding only as per: https://forums.oracle.com/forums/thread.jspa?threadID=578469

Resolution

Since FeCru supports UTF8 DBs only, this will demand a change on the DB Server side (changing its encoding to AL32UTF8).

There are no supported methods to run Crucible with a non-UTF-8 supporting database. Some users have had success modifying the Crucible configuration directly (but this is not supported by Atlassian):

  • Stop your instance of crucible.
  • Open your <<FISHEYE_INST>/config.xml and change the <<database>> tag as the following (Insert this xml snippet just before the <snippet/> tag): 
<database type="oracle">
<connection dialect="org.hibernate.dialect.Oracle10gDialect" driver="oracle.jdbc.driver.OracleDriver" jdbcurl="jdbc:oracle:thin:@<hostname>:1521:<orcl>" password="<password>" username="userid>" maxPoolSize="20" minPoolSize="5" driverSource="bundled"/>
</database>
  • Change the values of the: jdbcurl, password and username properties.

  • Save and restart your instance.

PS: This won't migrate your data if you were previously using another database but it will allow you to install a brand new crucible instance using Oracle.

Last modified on Jul 31, 2018

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.