JIRA - Internal Server error

[Randolph Tuquero]

We are in the process of migrating the JIRA service desk to MS SQL Server 2012 database.

Connection can be established, however during the migration we encountered an internal server error.

See below 

2018-08-16 17:58:40,752 http-nio-8090-exec-18 ERROR anonymous 1078x7x1 m8j5hj 0:0:0:0:0:0:0:1 /secure/SetupDatabase.jspa [c.o.m.propertyset.ofbiz.OFBizPropertySet] Error setting value in PropertySet
org.ofbiz.core.entity.GenericEntityException: 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 jiraschema.propertyentry (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, propertytype) VALUES (?, ?, ?, ?, ?) (Cannot insert the value NULL into column 'ID', table 'jiradb.jiraschema.propertyentry'; column does not allow nulls. INSERT fails.))

We have followed your instructions in the below link for the collation settings, schema, port and nocount, etc. but still failing.

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

[AhmadDanial]

Hi there, Randolph.

Before we dig deeper into this issue, I would like us to go through the following KB which has similar error as the one you shared in the description:

"Cannot insert the value NULL into column 'ID', table 'xxxxx'; column does not allow nulls. INSERT fails".

Can you please go through the diagnosis steps first before we verify if you are indeed impacted by the same issue and complete the resolution steps? 

Let me know how it goes on your end. Thanks.