We have an IDC collecting from SQL DB. What happen was the job to updating that SQL DB failed and wipe out all data. So when IDC collected from an empty table, it marked everyone as terminated and deleted. It also triggered all subsequence automation we have.
Did anyone have similar situation and how did you handle it?
Here are some questions
- Is there a pre-process to check say not running the IDC if table is empty? Did anyone have similar experience?
- Is there a way, we can revert back the IDC to previous IDC run without revert whole database back ?
- After restored SQL DB, the IDC re-ran, it created second entries for some users, one is deleted and the other is active. But it didn't create second entries for all of users.Does anyone know when it creates second one and when it just re-uses the same entry and only reverted back deletion date and termination date?
- How do I remove the duplicated entry for each user?