Hi

Unfortunately, the cmn_location table is not audited, so I can't tell.

I can open each record by clicking on the "Name" column and everything looks fine, including its related records (asset, cases etc).

I have tried updating the record but there is no change in list view.

This one of the records in the import set.

find_real_file.png

This is the field map for the import set.

 

 

find_real_file.png

Was I wrong to coalesce on sys_id?

S.

Hi

I turned on auditing in Dev instance and tested the import on a few records.

The only field that has changed for the affected records is what was expected: the custom text field.  No other fields were updated.

The outcome is the same; the updated records do not show any field values in list view, but opening the record shows all fields present.  The fields are also displayed correctly in, say, the asset list view.

From the record, if I select Export->XML, the downloaded file is blank with only:

find_real_file.png

Really weird - would appreciate your thoughts.

S.

Hi thanks for the suggestion.

I am not sure how to check for a conflict.

The ACLs for the cmn_location table have had no updates for 6 months.

The issue only affects the records that were updated by the import.

Can you give me some guidance on what to look for?

Thanks

 

Hi - can you be clear what on I would configure on a new read ACL?  I am struggling a little to work out your fix - would really appreciate it - thanks in advance.

Note once more that the only records affected are those updated by the data import.

mcconnellsj
Mega Sage

Hi all

Fixed

The issue is that the import set had sys_id's in UPPER CASE.

Not entirely sure what this does, blows the indexing somehow - the import set will claim "success" which is also weird.

The fix?  Simply re-run the previous import set with similar data but has sys_id in lower case - bingo - the records can be viewed in the list again like nothing happened.

If anyone can explain this one I would be interested.

Thanks to all who responded.

View solution in original post