JIRA Upgrade Fails Due to Invalid Database Configuration
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
Symptoms
Starting JIRA with Oracle database integrated fails with exception:
1
2
3
4
5
6
7
8
9
10
11
2008-04-03 14:17:22,946 main [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
ALTER TABLE jiraaction ADD UPDATED DATETIME
Error was: java.sql.SQLException: ORA-00902: invalid datatype
....
2008-04-03 14:17:23,394 main [core.entity.jdbc.DatabaseUtil] SQL Exception while executing the following:
CREATE TABLE trustedapp (ID DECIMAL(18,0) NOT NULL, APPLICATION_ID VARCHAR(255), NAME VARCHAR(255), PUBLIC_KEY TEXT, IP_MATCH TEXT, URL_MATCH TEXT, TIMEOUT DECIMAL(18,0), CREATED DATETIME, CREATED_BY VARCHAR(255), UPDATED DATETIME, UPDATED_BY VARCHAR(255), CONSTRAINT PK_trustedapp PRIMARY KEY (ID))
Error was: java.sql.SQLException: ORA-00902: invalid datatype
....
CREATE TABLE worklog (ID DECIMAL(18,0) NOT NULL, issueid DECIMAL(18,0), AUTHOR VARCHAR(255), grouplevel VARCHAR(255), rolelevel DECIMAL(18,0), worklogbody LONGTEXT, CREATED DATETIME, UPDATEAUTHOR VARCHAR(255), UPDATED DATETIME, STARTDATE DATETIME, timeworked DECIMAL(18,0), CONSTRAINT PK_worklog PRIMARY KEY (ID))
Error was: java.sql.SQLException: ORA-00902: invalid datatype
....
Cause
JIRA is connecting to the Oracle database but the field-type of database in the /edit-webapp/WEB-INF/classes/entityengine.xml is configured with a different database type.
This causes JIRA to create columns in the database with incorrect Oracle data type.
Resolution
Modify the field-type to the corresponding database in the entityengine.xml datasource. You will need to update this tag for your installation:
1
<datasource name="defaultDS" field-type-name="oracle10g"
For more information see Connecting JIRA to Oracle.
Was this helpful?