Import log errors are not clear in section "Details per object types"

[Mark van der Spoel]

Dear reader,

We use an automated import with "Microsoft Intune Importer for JSM Assets"
The import runs a few times a day and i get errors. The devices section, it states 116 errors found in source data. I would like to try and fix this but i can not determine what or which device fails. When i open the section it states:

116 error(s) found in source data

• Unique constraint violation

The 'Unique constraint violation' is 116 times listed. But no info which objects and i am in a loss to find which device has the error. No idea where to look.

Any ideas to start my investigation would be apreciated.

[Evgenii · Accepted solution]

Hi, @Mark van der Spoel 

Welcome to Atlassian Community.

Jira Cloud isn't always easy to debug, but the error name can help identify the root cause.
A "unique constraint violation" means that one or more attributes of an object are defined as unique, so you cannot create multiple objects with the same value for that attribute.

To resolve this:
- Check the object's attributes and identify which one is unique.
- Either remove the uniqueness constraint (if appropriate), or
- Review the data you're importing and ensure the source values don't contain duplicates for that attribute.

Here is a small example for you:

[Mark van der Spoel]

aaaaaaaaaa   i see

I have changed a setting because everytime a device was re-enrolled we got another entry. So i made the Serial nr the Unique identifier.

I need to find why the other items are (supposed) to be unique but apperantly not unique.
Enfin you pointed me in the right direction and i can solve my issue.

You showed that your badge is wel earned :) Champion...   THX

ps and thx also for the SUPER quick respons.

[Evgenii]

Thanks!

Just a quick supposal - check, that serial number exists, is not empty. It can be the reason too.

[Mark van der Spoel]

another bulls eye!

I am working here with a relatively new setup and the previous fella has made manuall imports. And didnt clean it properly.
So your suggestion hit a fair few records...

Battling the odds.
Learning on the way
THX  :) 

Apreciated the volentary tip.