User Resources Import Export Rule columns are shifting after running import

Products

• IT Management Suite

Issue/Introduction

The customer reported that after upgrading to 8.6 RU1 (he upgraded from 8.5 RU2>8.5 RU4>8.6>8.6 RU1), he started noticing that his User Import (Settings>Notification Server>Connector>Import/Export Rules>New>Resources Import Export Rule) is acting unexpectedly. He started 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 he reviewed the User Connector Import rule, he saw that the columns that he selected had shifted.

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

But after he 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 we looked at the "View Log", we 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

This issue has been reported to the Broadcom Development team. A fix for this issue has been scheduled for 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"