Incomplete Insight Schema Import

Issue Summary

While attempting to import an Insight Schema, if one object fails, it does not continue for next rows on the same Object Type csv file leading to an incomplete import on target.

Steps to Reproduce

• On the Source instance
  • Create 2 Object Types with references. Use the below example:
    
    
  • Create some dummy objects on both Object Types
  • On Object Type "AD User 1", attribute "UserId" set Cardinality value to minimum 1
  • Create a few "AD User 1" objects. They will have the 'UserId' attribute required.
    
    
  • Export the Schema
    • Insight > Configure > Object Schema Export
      

• On the target instance
  • Import the Schema. Only 2 out of 5 were imported
    • Insight > Configure > Object Schema Import

Expected Results

If one object fails, it should be skipped and the import continues on the next row. In this case, user3 should have been imported as it got all required attributes values.

Actual Results

• None of the "AD User 1" objects were imported
  
  

The following appears in the insight_objectschema_import. log.

2021-10-14 15:14:08,918 [insight-InsightThreadGroup-worker-thread-1] | Unable to import objects for object type AD User 1 with id 19 due to null value encountered on line 2 on column 6
2021-10-14 15:14:08,918 [insight-InsightThreadGroup-worker-thread-1] | Invalid reference found, object key from export: ITSM-19
2021-10-14 15:14:08,918 [insight-InsightThreadGroup-worker-thread-1] | Finished object key lookup for objectId: 24, reference objects length: 1
2021-10-14 15:14:08,918 [insight-InsightThreadGroup-worker-thread-1] | No valid references for attribute type 107

• Search for the "AD User1" in the Schema.xml (included in the Schema Export) - to get the Object Type ID - (15)
• In the Schema export directory, open the file 15.csv.
  • As the first row is invalid (UserID is required but it has no value), next rows will not be imported either.
    

Workaround

In the source instance, ensure that every object has a value for those required attributes.

KB was published to find invalid data: Unable to import objects for object type X with id X due to null value encountered - Insight Schema import