Loading...

XML

Word

Printable

Details

Type: Bug
Resolution: Fixed
Priority: Medium
Fix Version/s: 10.109.0
Affects Version/s: 10.107.4
Component/s: Jira Connector
Labels:
- bulldog

Support reference count:
1
Symptom Severity:
Severity 3 - Minor
Does fix include system behavior or UI changes?:
No

Description

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

Attachments

Issue Links

mentioned in: Page Loading...; Page Loading...

relates to: ALIGNSP-14252 Loading...

Activity

People

Assignee:: Kyle Foreman

Reporter:: Leo Soronio

Votes:: 1 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 07/Jun/2022 5:04 AM

Updated:: 05/Aug/2022 1:33 PM

Resolved:: 01/Jul/2022 1:21 AM

Jira Connector - Consolidate User Error