Exclusion List in Clone Profile for User Table Not Working

[green jason]

I set the preserve conditions on the User, User_has_role, and Grmember tables, and also excluded these tables to prevent their data from being overwritten by the Source instance.

However, while the preserve conditions worked, the exclusions did not. Does anyone have any ideas on why this might be happening?

[green jason]

You mean that if my current table have all data (domain a, b, c,etc.) and I exclude + preserver for only data which belong to domain A. System will keep everything and just do not pull any new data? If yes, that’s not make sense. Hmmm

[Shivalika · Accepted solution]

Hello @green jason 

No, as I mentioned in my above answer it completely depends on conditions you specified in your preserved and exclude which data you want to keep and which data you want to hamper. So be very specific with handling conditions. 

So when you said Domain A is in preserver - means it's data will be preserved and not overwritten but added if there is no excluder.

But if you have added excluder as well then this table will be excluded from clone alltogether means no data added or overwritten nothing. Data will be kept as it is for ONLY domain A. Not the same for domain B and Domain C or other whatever conditions of data. 

I hope this clears your queries. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway,

, 

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwN

eEISQCY

[green jason]

Thank you for your explaination. But sadly, i set up correctly as you said and all data have been pulled into my target instance. Have you have any advice on where should i double check?

[Shivalika]

Hello @green jason 

It's great that my answer helped you. All data has been pulled into your target instance - by this you mean data has been overwritten or data has been added to existing one ? Means what conditions you have exactly - preserver, excluder both - you can share. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY

[green jason]

Data hase been override and add as well. I knew it because before clone, I try to delete 1k record first and it still there after clone finished.

I want to preserve User record belong to Domain A and also for Service Account. So my condition is: Domain is A OR web access only = true + exclude user table. Hope you can help. For the clone schedule request, i also ticked preserve/exclude specific table option.