Affects Version/s: None
Fix Version/s: None
When trying to Delete an Object Schema, or a large number of Objects, you will get an Error "Something went wrong, please contact your Jira Administrator"
Jira is connected to Microsoft SQL DB. Insight v. 6.2.0 or 6.2.1
The Jira log shows:
Caused by: com.atlassian.activeobjects.internal.ActiveObjectsSqlException: There was a SQL exception thrown by the Active Objects library:
- name:Microsoft SQL Server
- minor version:0
- major version:12
- name:Microsoft JDBC Driver 6.2 for SQL Server
com.microsoft.sqlserver.jdbc.SQLServerException: The incoming request has too many parameters. The server supports a maximum of 2100 parameters. Reduce the number of parameters and resend the request.
Delete smaller batches of Objects each time (up to 2000). you can also delete one Object Type at a time with less than 2000 Objects.