Jira 4.4.5 - HTTP Status 500 error during the Jira Setup

[Harish]

Hi,

We are installing Jira 4.4.5.

We have copied the .tar file at the required Prodcution location ( Linux).

And then Untar the file.

Then created a Home directory

Then set the Jira_home and Java_Home paths.

Now started Jira using sh start-jira.sh

Open the Jira using the default port number ( http://abc.xyz.com:8080 )

The First Step of Setup is opened.

The Data base connection details are provided ahd the Test Connection is usccesfull.

Then when i click on "Next" it throws the HTTP Status 500 error.

When i referred the catalina.out file. It shows :-

Error was: java.sql.SQLException: ORA-01950: no privileges on tablespace 'JIRA_DATA'

Whereas the tablespace ( username) we created inthe Oracle Database is 'jira_prod'.

When i check the dbconfig.xml file even there the User name is 'jira_prod'.

No idea where the Jira_data is from. Do i need to make nay modification so that it points out to the correct DB - jira_prod.

Please guide me!

Thanks,

harish

[C_ Faysal · Accepted solution]

hey harish,

can you please try to connect to your DB as the user "jira_prod"

if this is ok you may want to check one of the following commands:

ALTER USER <username> QUOTA 100M ON <tablespace name>

or

GRANT UNLIMITED TABLESPACE TO <username>

[Harish]

Thank you Faysal!

The solution worked for me.

I took help from my DBA and you are correct.

after granting unimited tablespace to jira_prod , it was workign fine.

Thanks again,

harish.

[C_ Faysal]

you're welcome. glad you could get it fixed

[Harish]

Any update! Preety urgent!