Duplicate entry '145-' for key 'ENDPOINTKEY' for Sav4Sav REST connector

[Diptansu_Sinha]

Hello Team , 

We are using Sav4sav rest connector and using logical child endpoint. 

example:

Parent endpoint SAV4SAV REST : SAVIYNTA

Child endpoint based on filter criteria : SAVIYNTB,SAVIYNTC

Now we are facing one strange issue , say one user has left the organization and inactivated in parent and both the childs. Next time when we are re-activating it again and running Parent Account import facing the error. Since the user's account in Inactive in child endpoints. 

Error: Duplicate entry '145-' for key 'ENDPOINTKEY'

We have applied the remedy from Inactive Accounts not getting activated and creati... - Saviynt Forums - 20825 link. But thats not helping out. Please suggest.

[rushikeshvartak]

You need to change accountid of inactivated account in child endpoint append -Old using enhanced query

[Diptansu_Sinha]

can you kindly provide any sample query for this which we can use.

[rushikeshvartak]

select accountkey as accounts__primarykey , concat(REFERENCED_ACCOUNTKEY,'-old') from accounts where accountkey=1 and endpointkey=145 limit 1;

[Raghu]

@Diptansu_Sinha 

Error: Duplicate entry '145-' for key 'ENDPOINTKEY'

Endpointkey =145 looks like dublicate entry in this endpoint account check it and modify account or update the account status suspend if dont have any data inside account