Duplicate entry for key PRIMARY, but cannot see the record in the table...

Luiz Lucena
Mega Sage

‎10-03-2019 08:47 AM

Hi friends, 

Here is the story, we have PRD - DEV - TEST. 

Every time we do a clone, something funny happens. This time, I decided to add preserve the data on the table sys_auth_profile_basic where the user account contains "mule".

The reason for this is that we have Orchestration and Mulesoft uses an account for each instance, I don't want to import back the user profile every time we have cloning. So, decided to give a try to the Preserve Data. 

Instead of preserve, it get rid of the data in the target instance then I try to import the record back but got the error below:

Should be the case for a HI ticket?

find_real_file.png

Preview file
31 KB
0 Helpfuls
  • 5,496 Views
2 REPLIES 2

Lucas Vieites
Tera Guru

‎10-04-2019 01:03 AM

Hi Luiz,

I would check the system logs to see on which table exactly the "Duplicate entry..." occurs. Sometimes it comes from a parent table where you still have the data and that sys_id value is still there.

I know of a very useful script to find sys_ids in the platform; it's in the Dev Community, have a look here: Search for a specific sys_id.

I'm curious to see what you find, please share if you solve this issue.

Kind regards,
Lucas Vieites
P.S. If my reply helped you, please mark it as helpful or correct so other community members can benefit from this information.