I have some strange issue.The thing is If I run the stored procedure thru webmethods the status of a particular field is not updating sometimes.and sometimes its updating.I did R&D for the last two days but unable to figure out the rootcause.I dont know whether its a patch issue or any fix or updates.I went thru the advantage but no result.
For example if I submit some 1000 records(trades) the status is updated for 900 and the for remaining the status its not updating in the database.
Did any one face this type of problem?Any help or ideas regarding will be greatly appreaciated.
I also went thru the stored proc and analysed some info like
[SIZE=2]Where is the transaction handling done?
TX Mgmt Done in the sproc
Are there any dependencies on the updated fields?
There was a trigger that was removed in uat
Is there a pattern around the failure?
No specific pattern found
Does it occur only for specific items or is it more random?
It’s random , no specific pattern found
Any help will be helpful.
Thanks & Regards