cannot create project

Question

After we had created some projects (Scrum) in Jira SW successfully, it is not possible any longer.

I get a "Hmm, ....something is wrong" message.

We have already re-setup the complete database and checked that  NOCOUNT is off.

From Jira log:

2019-01-03 16:33:11,647 http-nio-8080-exec-21 INFO dsentler 993x188x1 1uvz633 10.33.60.237 /rest/project-templates/1.0/templates [c.a.j.i.f.config.manager.FieldConfigSchemeManagerImpl] ConfigScheme TEST: Scrum Issue Type Scheme (10703). Created with no associated contexts
2019-01-03 16:33:11,805 http-nio-8080-exec-21 ERROR dsentler 993x188x1 1uvz633 10.33.60.237 /rest/project-templates/1.0/templates [c.a.jira.project.ProjectCreateRegistrarImpl] The handler with id com.atlassian.jira.project-templates-plugin:apply-project-template-handler threw an exception while handling a notification about a project being created
com.querydsl.core.QueryException: Caught SQLServerException for insert into "dbo"."AO_B9A0F0_APPLIED_TEMPLATE" ("PROJECT_ID", "PROJECT_TEMPLATE_MODULE_KEY", "PROJECT_TEMPLATE_WEB_ITEM_KEY") values (?, ?, ?)
    at com.querydsl.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:50)
    at com.querydsl.sql.Configuration.translate(Configuration.java:451)
    at com.querydsl.sql.dml.SQLInsertClause.executeWithKeys(SQLInsertClause.java:364)
    at com.querydsl.sql.dml.SQLInsertClause.executeWithKey(SQLInsertClause.java:172)

.....

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Der Wert NULL kann in die ID-Spalte, Jira3.dbo.AO_B9A0F0_APPLIED_TEMPLATE-Tabelle nicht eingefügt werden. Die Spalte lässt NULL-Werte nicht zu. Fehler bei INSERT.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258)
    at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1535)
    at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:467)

Database:
    - name:Microsoft SQL Server
    - version:13.00.4466
    - minor version:0
    - major version:13
    - name:Microsoft JDBC Driver 6.2 for SQL Server
    - version:6.2.1.0

We are using Jira SW Version 7.12.3

Hope that is enough info to get some ideas what's going wrong.

Shannon S · Answer

Daniel,

Thank you for letting us know you were able to resolve it. If you run into any issues again feel free to reach out. If our first solution doesn't correct the problem, we can keep working with you through the issue or help to raise a support ticket.

Regards,

Shannon

Daniel Sentler · Answer

Unfortunatlely this was not the solution. We tried so much things, that we decided to reinstall Jira + DB from scratch.

Hope we'll not run into this problem again.

Shannon S · Answer

Hello Daniel,

The user in this discussion was having the same error as you, and they were able to resolve it using this article:

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

The xml modification seems to have done the trick.

fyi: i had to readjust two tables.

those tables are using nvarchar type as ID.

the table activity_entity seems to be using activity_id as identity

AO_21F425_MESSAGE_AO
AO_563AEE_ACTIVITY_ENTITY

Could you have a look at the above article and please give that a try?

Regards,

Shannon