Issue Summary

We see the "Conversion failed when converting the nvarchar value 'XXX12-34' to data type int" errors that prevent the successful sync with "Reverse Sync All Project Work Items Failed" errors. These logs are not showing in the ADO Connector logs even the logging level is verbose. Why are these not visible? We request you to make the necessary improvements for them to appear.

Steps to Reproduce

• A feature created on a program linked to Jira had been changed to a program linked to ADO. This is why the strange numbering (XXX12-34) of the link came up. By moving them back to the correct program, the sync created all missing features in DevOps and all seems to be ok again.

Expected Results

Features are synchronizing from JA to ADO.

Actual Results

Features are not synchronizing from JA to ADO. Getting the following error on the server level but no logs shown in the JA ADO section:

{ [-]
   Exception: System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the nvarchar value 'XXX12-34' to data type int.
   
Error Number:245,State:1,Class:16
   Level: Error
   MessageTemplate: Reverse Sync All Project Work Items Failed.
   Properties: { [-]
     Build: 10.102.3.19003
     ConnectorId: 2
     CorrelationId: 274311126
     Customer: xxxxx
     Direction: FROM Jira Align
     Event: OnElapsedTimer
     Interval: Normal
     Method: Elapsed_WorkItemTimer
   }
   RenderedMessage: Reverse Sync All Project Work Items Failed.
   Timestamp: 2021-12-02T05:09:15.0127886-05:00
}

Workaround

• Could you check which Feature contains the XXX12-34 field? The system seems to have problems when a value containing non-number characters is entered into a field that will only contain numbers.
• Check if a feature created on a program linked to Jira had been changed to a program linked to ADO. ( see Steps to Reproduce section )
•