Apex Code Development You need to sign in to do that
Don't have an account?
VishZ How to prevent partial update/ insert while using dataloader
When we inserted records using dataloader, one record got validation error and failed. The rest of them are inserted succesfully.
But, the changes done by trigger for the entire batch ( including succesfully inserted records) are rolled back.
I guess it is how it works. Using batch size as 1 might prevent this issue but will have performance issues.
Could someone please answer my below queries.
I read some where Dataloader uses DATABASE.UPDATE which allows partial success in DML operation. Is there any setting/ workaround to avoid partial update through dataloader ?
Or is there any better alternative or best practices to avoid these kind of issues ?
But, the changes done by trigger for the entire batch ( including succesfully inserted records) are rolled back.
I guess it is how it works. Using batch size as 1 might prevent this issue but will have performance issues.
Could someone please answer my below queries.
I read some where Dataloader uses DATABASE.UPDATE which allows partial success in DML operation. Is there any setting/ workaround to avoid partial update through dataloader ?
Or is there any better alternative or best practices to avoid these kind of issues ?
http://salesforce.stackexchange.com/questions/8122/rollback-whole-batch-on-error
Thanks for the reply.
That post is regarding rollback in BATCH APEX.
What I am looking for is a way to rollback Dataloader operations in case of any error.
Thank you.
Vishnu