Uploaded image for project: 'Insight Core - Server'
  1. Insight Core - Server
  2. ICS-1173

Cannot delete an Object schema / many objects

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: High
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
    • Affected Version:
      INSIGHT 6.2.0
    • Resolved Version:
      INSIGHT 8.0.2

      Description

      Symptoms:

      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:
      Database:

      • name:Microsoft SQL Server
      • version:12.00.4522
      • minor version:0
      • major version:12
      • name:Microsoft JDBC Driver 6.2 for SQL Server
      • version:6.2.1.0

      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.
      at ...

      Workaround:

      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.

        Attachments

          Activity

            People

            • Assignee:
              mathias Mathias Edblom [Riada]
              Reporter:
              yinon Yinon Negev
            • Votes:
              2 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: