Create project fails

[Patrick M]

I upgraded to Jira Core 7.9 and am unable to create a project.  Atalassian-jira.log shows these errors after trying to create the project:

/rest/hipchat/integrations/1.0/configuration/status [c.a.p.r.c.error.jersey.ThrowableExceptionMapper] Uncaught exception thrown by REST service: bundle [com.atlassian.labs.hipchat.hipchat-for-jira-plugin]

...

Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
Database:
 - name:Microsoft SQL Server
 - version:11.00.7462
 - minor version:0
 - major version:11
 - name:Microsoft JDBC Driver 6.2 for SQL Server
 - version:6.2.1.0

com.microsoft.sqlserver.jdbc.SQLServerException: 'pk_AO_587B34_GLANCE_CONFIG_ROOM_ID' is not a constraint.

Tried the following query from another post but it fails to find app_user; seemingly I'm in wrong table since schemepermissions didn't have that column.

select * from schemepermissions where perm_type = 'user' and (perm_parameter in (select user_key from app_user where lower_user_name not in (select lower_user_name from cwd_user)) or perm_parameter not in (select user_key from app_user));

[Marko Filipan]

Hi Patrick,

From the error you get, it seem it is referring to constraint 'pk_AO_587B34_GLANCE_CONFIG_ROOM_ID' in table AO_587B34_GLANCE_CONFIG.

Can you connect to the database and see what constraints do you have under this particular table? What is the primary key and constraint name for it?

Cheers,
Marko Filipan

[Patrick M]

Marko, it doesn't appear to have a primary key or constraint.  Should I add ROOM_ID as a pk?

[Marko Filipan]

Hi Patrick,

Yes, try adding ROOM_ID as a primary key and name the constraint as 'pk_AO_587B34_GLANCE_CONFIG_ROOM_ID', then restart JIRA and try creating project again.

Let us know how it goes.

Kind regards,
Marko Filipan

[Patrick M]

Marko,

I was able to add the primary key but am having trouble with the constraint.  I am using Microsoft SQL Server Management Studio.  It won't allow a blank expression.   What would be the expression for the constraint?

Thanks for your assistance with this matter.

[Marko Filipan]

Hi Patrick,

In MS SQL, adding primary key automatically makes the key as a constraint. Adding primary key is the same as executing ADD CONSTRAINT query:

ALTER TABLE jiraschema.AO_587B34_GLANCE_CONFIG
ADD CONSTRAINT PK_AO_587B43_GLANCE_CONFIG PRIMARY KEY (ROOM_ID)

 So, you don't need to add separate constraint, just exit this constraint wizard and restart JIRA, then try creating project again.

Cheers,
Marko

[Patrick M]

Marko,

Thanks for the input on the Glance table, I'm over that hurdle but have come across another.  What do you make of this Applied_Template not allowing Nulls?  I am getting the same "Hmm..." error when trying to add a project.

2018-04-12 16:54:59,604 http-nio-8080-exec-24 INFO patrickm 1014x61x1 t6f4wt 192.168.1.80 /rest/project-templates/1.0/templates [c.a.j.i.f.config.manager.FieldConfigSchemeManagerImpl] ConfigScheme TTW: Scrum Issue Type Scheme (13) (11401). Created with no associated contexts
2018-04-12 16:54:59,978 http-nio-8080-exec-24 ERROR patrickm 1014x61x1 t6f4wt 192.168.1.80 /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 "jiraschema"."AO_B9A0F0_APPLIED_TEMPLATE" ("PROJECT_ID", "PROJECT_TEMPLATE_MODULE_KEY", "PROJECT_TEMPLATE_WEB_ITEM_KEY") values (?, ?, ?)

... snip

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot insert the value NULL into column 'ID', table 'Jiradb2.jiraschema.AO_B9A0F0_APPLIED_TEMPLATE'; column does not allow nulls. INSERT fails.
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1535)

[Marko Filipan]

Hi Patrick,

Can you tell which steps did you follow while upgrading your JIRA Core?

Did you install it on a newly created database?

I am asking because it is strange that you experience these SQL database-related errors if the database was upgraded, however, if you have set up new database, it could be thad SET NOCOUNT option wasn't set during the database creation (please refer to JIRA startup with MS SQL Server fails with error "Cannot insert the value NULL ... column does not allow nulls. INSERT fails.")

Cheers,
Marko

[Patrick M]

I downloaded the jira-core-7.9 program and updated our jira program on a Windows Server 2008 R2.  The update was to an existing data base on a separate sql server running the same Server 2008 R2.  I may try and start fresh and create a new db.  Then try and import our projects.

[Shannon S]

Patrick,

The errors are mentioning HipChat. Do you have HipChat integration enabled? If not, could you try to disable the add-on?

Regards,
Shannon

[Patrick M]

We do not have the HipChat integration as a user add-on.  I see the add-on in the System add-ons with the recommendation not to disable them...