Hi !
I'm attempting to create a test Software 8.20.1 install with sqlserver 2019 (JRASERVER-69989) since 8.17+ / MAY 2021. I've been following the Connecting Jira applications to SQL Server 2019 guide, have the bundled mssqldriver (v9.2.1), have SQL_Latin1_General_CP437_CI_AI collation and NOCOUNT set OFF (KB indicates NOCOUNT as a cause). On install we get table creation but then:
> Cannot insert the value NULL into column 'ID', table 'jira_8_20_1.dbo.propertyentry'
2022-02-07 17:25:25,096+0000 http-nio-8080-exec-9 INFO anonymous 1045x209x1 1j9tj6f 0:0:0:0:0:0:0:1 /secure/SetupDatabase.jspa [c.a.jira.startup.DatabaseChecklistLauncher] Jira database startup checks completed successfully.
2022-02-07 17:25:25,097+0000 http-nio-8080-exec-9 INFO anonymous 1045x209x1 1j9tj6f 0:0:0:0:0:0:0:1 /secure/SetupDatabase.jspa [c.a.j.config.properties.MemorySwitchToDatabaseBackedPropertiesManager] Switching from in-memory property set to database property set.
2022-02-07 17:25:25,173+0000 http-nio-8080-exec-9 ERROR anonymous 1045x209x1 1j9tj6f 0:0:0:0:0:0:0:1 /secure/SetupDatabase.jspa [o.o.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.getNextSeqId] Fill bank failed, returning null
2022-02-07 17:25:25,181+0000 http-nio-8080-exec-9 ERROR anonymous 1045x209x1 1j9tj6f 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 dbo.propertyentry (ID, ENTITY_NAME, ENTITY_ID, PROPERTY_KEY, prope
rtytype) VALUES (?, ?, ?, ?, ?) (Cannot insert the value NULL into column 'ID', table 'jira_8_20_1.dbo.propertyentry'; column does not allow nulls. INSERT fails.))
at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:210)
at org.ofbiz.core.entity.GenericDAO.singleStore(GenericDAO.java:388)
The table def shows the PK ID column as non null (as expected) so why would Jira be trying to set a null value there?
I've clean sweep installed a bunch of times, with the same outcome, also tried a restart after failed install to see if it could limp over the line, no dice. I've had earlier sqlserver versions running in the past/ not been blocked by this before.
I tried the 10.2 sql driver, apparently needs ssl stuff but (appending flags to databasename allowed progress), despite being a Java jdbc connector it apparently needs a DLL (DLL mssql-jdbc_auth-10.2.0.x64) to operate, doesn't help me as I don't run windows!
So, has anyone gone through a sqlserver 2019 based Jira 8.20+ install that actually worked? If so, is there anything you can share about getting a successful install ?!
