JIRA — Internal Server Error

[yim ranith]

Dear Supporter,

I have problem install Jira software connect to database MS SQL 2012 server and it has message error "Error reference: db875ea6-8756-46b1-8711-83136aa6d1a5" and i checked in database created for Jira generated many tables.

Jira software version: atlassian-jira-software-7.4.3-x64

MS SQL 2012 server

Please help fix issue.

Thanks,

[Reg Hawkins · Accepted solution]

Get the lastest version of JIRA there has been a patch 

[yim ranith]

I have fixed

[gagan m s]

hello yim we are facing same issue... can you guide us to fix it?

[Reg Hawkins]

Do you need any help with this?

[Reg Hawkins]

I used a newer version of Java 8 to fix the issue

[gagan m s]

Reg ,

just installing the JAVA 8 fixed the issue? or did you do anything else?

[Reg Hawkins]

@gagan m sYes, Issue was resolved by using Java 8 confirm the classpath has been setup after updating the java -version

[Reg Hawkins · Accepted solution]

Confirm Java class path has been setup correctly and what version of java you are using

in CMD or terminal java -version

[yim ranith · Accepted solution]

i have found message error

Cause

Referer URL: http://localhost:8080/secure/SetupDatabase!default.jspa
com.opensymphony.module.propertyset.PropertyImplementationException: while inserting: [GenericEntity:OSPropertyEntry][propertyKey,jira.i18n.language.index][entityName,jira.properties][entityId,1][id,null][type,5] (SQL Exception while executing the following:INSERT INTO dbo.propertyentry (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype) VALUES (?, ?, ?, ?, ?) (Cannot insert the value NULL into column 'ID', table 'DMC_JIRASoftware.dbo.propertyentry'; column does not allow nulls. INSERT fails.))

How can i fix this error?

Thanks.

[Randolph Tuquero]

Hi Yim,

We have got the same issue,

Can you please let me know how do you fix it?

Thanks.

[Reg Hawkins]

See my responses below, Confirm you have Java 8 installed and the classpath is set

[Reg Hawkins · Accepted solution]

https://confluence.atlassian.com/adminjiraserver071/connecting-jira-applications-to-sql-server-2012-802592195.html 

Have you followed this guide? 

[yim ranith]

I have followed wtih your link and it still error.

[yim ranith]

connection from jira wtih database it can connect because i saw many tables generated but it has error message 

JIRA — Internal Server Error
Error reference: db875ea6-8756-46b1-8711-83136aa6d1a5

refeshed page it just display just message in header "HTTP 500 internal message error"