XOG update initiated from a process shows good statistic but the update is not done. Why?

Document ID : KB000100923
Last Modified Date : 12/06/2018
Show Technical Document Details
Question:
XOG update initiated from a process shows good statistic, but the update is not done.

Example:
(state="SUCCESS"/> <Statistics failureRecords="0" insertedRecords="0" totalNumberOfRecords="1" updatedRecords="1"/> ) 

Why the update is not done?
Answer:
The overall process of running a XOG and it getting to the end without aborting in the middle is all that needs to happen to denote a SUCCESS result. 
If something aborted midway and it didn’t process the rest of the records (assuming there are multiple inside the XOG) then you might expect to see a FAILURE result instead. 
An individual record in the process can ‘fail’ for reasons determined and given in the error message, but just a ‘poor user data’ entry in the XOG generally isn’t enough to throw the entire thing off. 
So you get a ‘SUCCESS’ and then you look at the individual records status (inserted, updated, failed) to see what happened at the granular level for each record.