Full import on oracle MA is not picking up deleted rows
Hi All I have a feed from an oracle view using an Oracle MA. Every time i run a full import, all changes are picked up except deletion changes (which is odd, since the Connector space of an MA should be a copy of the data source). So now i ended up with more objects in the CS than what we actually have in the oracle view. The import process is pretty straight forward and out of the box, what could be a reason for this situation?! Note: The view has a duplicate, will this be the cause of not importing deleted rows correctly!! Thanks in advance Eihab
March 21st, 2011 5:07pm

Note: The view has a duplicate, will this be the cause of not importing deleted rows correctly! If the import cannot run cleanly and without error, the process of detecting which records did not come in cannot be done reliably, so the purge process gets skipped. Get rid of your duplicate records and see if that clears up the issue. Note that new records will be processed as well as changes to existing records, because these operations can be done reliably. If the Run Profile status comes back as "completed-discovery-errors", you will have an indication that deleted records were not processed. Check here for more information: http://msdn.microsoft.com/en-us/library/ms699322%28v=vs.85%29.aspx (Note that "obsoleted" means deleted in your case.) Rex
Free Windows Admin Tool Kit Click here and download it now
March 21st, 2011 9:29pm

Thanks Rex, That's what i thought too. Your reply verified that and make a lot of sense to me. I'll clean it up and get back. Eihab
March 21st, 2011 11:52pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics