Jira 6.1.3 & Oracle 11g

[Quentin Deldycke]

Hi,

We are trynig to install Jira with a oracle database in our infrastructure.

We currently have

1 virtual machine Windows server 2008 32b

• hosting jira 6.1.3

1 virtual machine Windows server 2008 32b

• hostring oracle 11gr2

At the beginning of installation process, we are facing a SQL problem:

com.opensymphony.module.propertyset.PropertyImplementationException: while inserting: [GenericEntity:OSPropertyEntry][id,null][entityId,1][propertyKey,jira.i18n.language.index][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: impossible d'insérer NULL dans ("JIRADBUSER"."PROPERTYENTRY"."ID")

if we try to relaunch the install process, jira complain about the database not being empty. We have verified the user rights for oracle following the documentation. Was granted:

• connect
• create table
• create sequence
• create trigger

Thanks for your help.

[Quentin Deldycke · Accepted solution]

Hi,

We have manage to correct the issue with the help of 2 other brains inside our company:

• We tried the same sql request from a command line on the oracle server with our jira user and password.
• There, we received a 'No privileges on tablespace 'XXX'
• We went to see the rights of our user with the web interface of oracle.
• There we could see our rights:
  • Connect, create table, create sequence, create trigger
  • And that was all!
• So we also added all the rights available, like insert, DROP and other "normal sql commands"
• From there, everything is working fine!

So it seems:

• Somehow, our installation don't give correct default rights
• The error printed is completely not the real problem! (oracle seems to have a funny way of reporting errors....)

So, it is now working, but i think it won't be bad to add to documentation all the rights jira could need.

Anyway, thanks for your help and your reactivity! It is always pleasent to work with reactive people!

[Peter Van de Voorde]

Hi Quentin,

Did you try to empty the database completely and retry again?

Is this a new install or an upgrade?

Best regards,

Peter

[Quentin Deldycke]

Hi,

Yes, it is the ones in the installer 'atlassian-jira-6.1.3-x32.exe'. No modification was made to jira installation to reproduce this bug.

We also have tried to replace the ojdbc6-11.2.0.2.0.jar from the lib/ repertory of JIRA. We have replaced by the revision: 11.2.0.4 present in this page: http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html

But the problem still remains.

[Peter Van de Voorde]

Hi Quentin,

Which Database drivers are you using? The build in Jira ones?

Best regards,

Peter

[Quentin Deldycke]

Yes, the base was made empty a couple of time and the process restarted.

It is a new install.

132 tables are created during the operation. But none of them jhave rows.

[Peter Van de Voorde]

Hi Quentin,

Could you try it with the latest release? version 6.1.4 : https://www.atlassian.com/software/jira/download

And before you try to install that version remove your complete home and installation directory from your system (or even better: reset your virtual machine to a point before you did the first Jira installation)

Best regards,

Peter

[Quentin Deldycke]

Hi,

Ok, i will do this and keep you up to date in a couple of minutes.

[Quentin Deldycke]

Hi,

I have the exact same error. with jira 6.1.4

• A ctrl+u on my webbrowser show a jump of version of jira from 6.1.3 to 6.1.4
• The schema is now made of 135 tables. All empty.

[Peter Van de Voorde]

Just wondering, what happens if you use the build in HDBSQL database?

Did you use the exact same permissions and drivers as explained here : https://confluence.atlassian.com/display/JIRA/Connecting+JIRA+to+Oracle ?

Are you using the correct jdk (1.7) ?

Best regards,

Peter

[Quentin Deldycke]

Ok, i will try this build on demo mode to see if database installation in this mode is correct.

By the way, my windows server is a clean build (freshly installed from dvd with only jira installer). I don't have any java.exe in my environnement. It report an unknown command.

The only available java.exe is the one in the installer.

Version 1.7.0_25-b17.

Yes, these are the exact same permissions. The only difference is the quota i put on my database (256mo + extension to 1go...)

[Quentin Deldycke]

I confirm that i can use the demo mode without problems! The installation process worked perfectly!

It seems to be a oracle specific problem.

[Peter Van de Voorde]

Could you try the installation without the quota in the DB?

And maybe check your dbconfig.xml file in the Jira-home directory for errors?

(see if the correct dialect is being used for example)

Or simply past it here.

Best regards,

Peter

[Quentin Deldycke]

I retried without the quota, same problem.

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

<jira-database-config>
  <name>defaultDS</name>
  <delegator-name>default</delegator-name>
  <database-type>oracle10g</database-type>
  <jdbc-datasource>
    <url>jdbc:oracle:thin:@172.21.0.56:1522:siioracle</url>
    <driver-class>oracle.jdbc.OracleDriver</driver-class>
    <username>jiradbuser</username>
    <password>jiradbpassword</password>
    <pool-min-size>20</pool-min-size>
    <pool-max-size>20</pool-max-size>
    <pool-max-wait>30000</pool-max-wait>
    <pool-max-idle>20</pool-max-idle>
    <pool-remove-abandoned>true</pool-remove-abandoned>
    <pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>
  </jdbc-datasource>
</jira-database-config>

Here is my dbconfig.xml. Note that nothing have been replaced.

My server is correctly available at the defined ip and port. as tables are created.

However i don't know the details of oracle... But this informations look strange to me:

<database-type>oracle10g</database-type>

And i don't know what is this:

<url>jdbc:oracle:thin:@172.21.0.56:1522:siioracle</url>

Edit: oops, seems i can't put in bold with code...

[Peter Van de Voorde]

the databasetype isn't really an issue

and the thin means you are using the Oracle thin client to connect to your Oracle instance, which is the standard for Jira.

I have no idea's left, I think it's best if you contact Atlassian support directly here :https://support.atlassian.com , I hope they can help you out.

Good luck.

Best regards,

Peter