Jira Connector - Consolidate User Error

XMLWordPrintable

      Issue Summary

      An exception is thrown when the connector tries to consolidate duplicate users in Jira Align.

      Steps to Reproduce

      This issue was observed after a customer was migrated from Jira Server to Cloud with a Jira Connector and some Jira Align accounts are duplicated.

      Expected Results

      No exception is thrown and duplicate accounts should be consolidated successfully.

      Actual Results

      Exception is thrown
      The below exception is thrown in Splunk:

      Exception: System.InvalidCastException: Unable to cast object of type 'System.Int32' to type 'System.String'.
         at AgileCraft.Common.SqlData.ExecuteScalar[T](SqlConnection connection, String sql, SqlParameter[] parameters) in C:\projects\alignapi\AgileCraft.Common\SqlData.cs:line 153
         at AgileCraft.Common.SqlData.ExecuteScalar[T](String connectionString, String sql, SqlParameter[] parameters) in C:\projects\alignapi\AgileCraft.Common\SqlData.cs:line 170
         at AgileCraft_Jira.AgileCraft.ConsolidateUser(Int32 fromUniq, Int32 toUniq) in C:\projects\alignintegration\Connectors\JiraServiceProduction\AgileCraft_Jira\AgileCraft.cs:line 9915
         Level: Error
         MessageTemplate: ConsolidateUser
      

      Workaround

      Currently there is no known workaround for this behavior. A workaround will be added here when available

            Assignee:
            Kyle Foreman
            Reporter:
            Leo.Soronio
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: