Hi,
When i try to collect the identity from a new csv file I have error in the unification process, so i used again my old csv file but the error persist. I think it is caused by the last collect (using the new csv file). I want know if i can reset the unification process to delete the last collect results.
Error:
Note: We can not open a support case for that, cause we are on test and buy periods
Regards.
Below were the queries suggested recently by a developer to resolve a similar issue. You may try this but it is better to take database dump before hand so that you can recover from any issue if required.
1. Run below query to check for duplicates..
select * from (
select idc_id, run_id, user_id, master_enterprise_user_id, id, count(*) over (partition by idc_id, run_id, user_id) ct
from t_raw_user
) where ct > 1
order by 1,2,3,4,5;
select * from (
select idc_id, user_id, id, deletion_date, count(*) over (partition by idc_id, user_id) ct
from t_master_enterprise_users
) where ct > 1
order by 1,2,3;
2. Take note of the RUN_ID's returned by them. Run the following queries for each RUN_ID (separately if multiple run ids are returned by above) to get rid of the duplicates causing the issue.
delete t_raw_user
where run_id = ?
and rowid in (
select rid from (
select rowid rid,
row_number() over (partition by user_id order by id) rn
from t_raw_user
where run_id = ?
)
where rn > 1
);
delete t_dc_sourcedata_change_log
where run_id = ?
and rowid in (
select rid from (
select rowid rid,
dc_id,
run_id,
srcid,
row_number() over (partition by srcid order by rowid) rn
from t_dc_sourcedata_change_log
where run_id = ?
)
where rn > 1
);
commit;
3. Unification is expected to be working after that.