+ Start a Discussion
Vetriselvan ManoharanVetriselvan Manoharan 

Bulk update via data loader causing problem because of trigger

Hi,

I have written a trigger on account. On updating the Program status on Account, it update the Opportunity Stage Name and there is another trigger return on Opportunity. The problem is while using bulk update from data loader it is causing problem. Can anyone please provide suggestion
Ramanarayanan PadmanabhanRamanarayanan Padmanabhan
Hi,

Its better to deactivate the trigger and perform DML operations.
The trigger needs to be bulkified to handle bulk DML operations.
If you dont want to modify the trigger, try updating with batch size 1. 

Regards,
ram
priya sripriya sri
Always using dataloader better deactivate the validations and trigger and then perform DML OPERATIONS..
 
Ramanarayanan PadmanabhanRamanarayanan Padmanabhan
Hi vetri,
 Curious to know whether my suggestion was useful to solve the problem. Please acknowledge if it solved your problem

Regards,
ram