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));
