User Resources Import Export Rule columns are shifting after running import

Products

• IT Management Suite

Issue/Introduction

You started noticing that your User Import (Settings>Notification Server>Connector>Import/Export Rules>New>Resources Import Export Rule) is acting unexpectedly. You are noticing that after the schedule for this User Connector Import finished running, a lot of locks/deadlocks started to happen and NSEs started to accumulate in the queues. When you are reviewing the User Connector Import rule, you are seeing that the columns that you selected had shifted.

You originally set up the associations/columns mappings this way:

But after you ran "Test Rule" or when the schedule kicked up, when it was done, those associations and columns had shifted:

You can notice that the order changed:

When you looked at the "View Log", you can see that the columns had shifted 

and then the connector import rule refreshes and then things are wrong.

If the rule runs again in that condition, it causes a lot of problems with the database and performance.

Environment

ITMS 8.6, 8.6 RU1

Cause

Known issue. the cause of this issue was because GUID lists of association/mappings were not sorted in any way. The fix provided will sort sections of the page by the item name.

Resolution

A fix for this issue has been added to ITMS 8.6 RU2 release.

A pointfix is available for those with ITMS 8.6 RU1. Please refer to KB 221269 "CUMULATIVE POST ITMS 8.6 RU1 POINT FIXES"