nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

JIRA 5.0.3 (and 4.4.5) install on Windows using Oracle 11g failing

John Howard2

Install fails after putting the database details into the wizard. Connection test is successful, then the following error:

HTTP Status 500 -

--------------------------------------------------------------------------------

type Exception report

message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

javax.servlet.ServletException: com.opensymphony.module.propertyset.PropertyImplementationException: while inserting: [GenericEntity:OSPropertyEntry][id,null][entityId,1][propertyKey,webwork.i18n.encoding][type,5][entityName,jira.properties] (SQL Exception while executing the following:INSERT INTO propertyentry (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype) VALUES (?, ?, ?, ?, ?) (ORA-01400: cannot insert NULL into ("JIRA"."PROPERTYENTRY"."ID")
))

---------------------------------------------------------------------------------

(see attached txt file). (JIRA_inst_err.txt)

Oracle 11g/JIRA 5.0.3 & 4.4.5 tried

Accepted answers

All comments

Andre Lehmann

Same for us (jira 5.0.3) running on unix.

Even HSQL-DB crashes

Radu Dumitriu

What's the content of dbconfig.xml ? You will find this file in the JIRA home dir.

Andre Lehmann

here the dbconfig.xml

{code}

<?xml version="1.0" encoding="UTF-8"?>

<jira-database-config>
<name>defaultDS</name>
<delegator-name>default</delegator-name>
<database-type>hsql</database-type>
<schema-name>PUBLIC</schema-name>
<jdbc-datasource>
<url>jdbc:hsqldb:/home/atlassuser/jira/jirahome/database/jiradb</url>
<driver-class>org.hsqldb.jdbcDriver</driver-class>
<username>sa</username>
<password></password>
<pool-size>15</pool-size>
<min-evictable-idle-time-millis>4000</min-evictable-idle-time-millis>
<time-between-eviction-runs-millis>5000</time-between-eviction-runs-millis>
</jdbc-datasource>
</jira-database-config>

{code}

Norman Abramovitz

I would contact support, but this feels like someone forgot that Oracle supports identity column types differently by using sequences. It could also be the installation code did not recognize that an Oracle database is being used and sequence support was not added.