Getting error: Hmm... we couldn't create your project due to an unknown error. Try refreshing the pa

[Mike Eber]

I had a collation issue with my db on a new install. Made a new db with the required collation and copied tables over. Now when  I try and create a project I get "Hmm... we couldn't create your project due to an unknown error. Try refreshing the page to start again."

[Mike Eber · Accepted solution]

Turns out in the DB Jira uses the identity increment feature of SQL Server so just copying the table data won't work. The error is caused by Jira not getting a new ID for the record it tried to insert in the table. So we just wiped the DB and started over from scratch.

This whole problem was caused by Jira not using MSSQL servers default collation. 

The Jira installer should detect this and run the appropriate SQL querys to alter the database to it's liking. And not force the user to do this by hand.

I would say that is a bug.

[Fazila Ashraf]

@Mike Eber  ,  It is a new jira instance with no data?

If so, just take a backup of the dbconfig.xml and remove it. When you start the jira again, it will ask you to do the initial connection with the DB and the schema would be populated in the DB.

Suggesting this as the 'copied tables over' might have caused something..