If trigger is working in one org and not in another, then there can be few possible reasons as below which you can check at yourend.
1. If there is an apex class associated to the trigger and that apex class had incorrect value set in production as compared to sandbox. 2. Can be a possibility that additional trigger is present in production which is rolling back the changes for any one particular record. 3.Check if the trigger has been deployed properly from sandbox to production. 4. Check the status of the trigger, if it is active or inactive.
Also you can go through below link that covers few more things:
Thank You for your reply.....
Actually it was my interview question.i haven't been provided code.
so,could let me know most possible causes,if possible.
If trigger is working in one org and not in another, then there can be few possible reasons as below which you can check at yourend.
1. If there is an apex class associated to the trigger and that apex class had incorrect value set in production as compared to sandbox.
2. Can be a possibility that additional trigger is present in production which is rolling back the changes for any one particular record.
3.Check if the trigger has been deployed properly from sandbox to production.
4. Check the status of the trigger, if it is active or inactive.
Also you can go through below link that covers few more things:
https://developer.salesforce.com/forums/ForumsMain?id=906F000000092VpIAI.
Hope this answers your question.