ConnectR Interface Troubleshooting

Debug Procedure

1. Ensure Error Message Definitions are loaded into ConnectR database. Run ConnectR Error Message script available via Allscripts Interface Team Wiki: http://intwiki/wiki/index.php?title=ConnectR_ErrorMessage (Allscripts VPN access required).
File:ConnectRTroubleshoot Image7

2. Copy command from Target Message Grid into SQL Query window
File:ConnectRTroubleshoot Image2

3. Remove beginning and end parens
4. Find ‘ -> Replace with ‘’
File:ConnectRTroubleshoot Image6

5. Run sp_idxgenspcall, sp_name, SQLCommand encapsulated in single quotes (ensure results are sent to text for easy copying)
File:ConnectRTroubleshoot Image3

6. Copy text results & paste into new query window
File:ConnectRTroubleshoot Image4

7. Execute query and Utilize this information to root cause the error.

Example

In the example shown below, required fields were present in the Stored Procedure called by the mapping, but were not present in the current Interface mapping. Thus the outcome was that the target message had to be changed to include the additional fields.
File:ConnectRTroubleshoot Image5

Hint

Cycle systems after changing a mapping
File:ConnectRTroubleshoot Image8