Hi Dwayne, It seems to me that if the SQL routine you specified was executing twice, it should impact performance but not the actual data.
But I can see you are running a Linux server. I have worked with several companies experiencing weird Linux problems. About a year ago BMC put a special support swat team into place to address Linux issues. I would recommend you putting a call into BMC Remedy support and having the issue escalated to them. Mike Ellertson Bushido Technologies, Inc. Phone: (949) 705-6991 Email: [EMAIL PROTECTED] -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin Sent: Tuesday, September 11, 2007 1:38 PM To: [email protected] Subject: Push field sometimes happens and sometimes doesn't Hello Everyone, We have a push fields action to a diary form. The same filter is pushing from the same form in all cases. Most of the time it works, but sometimes the field does not get updated. The filter log is identical in both cases, and it clearly shows the push taking place. Both when it work and when it doesn't sql log shows these actions: SELECT C536870931 [the field getting updated] FROM T580 WHERE C1 = 'PIQ00083' UPDATE T580 SET C536870931 = EMPTY_CLOB() WHERE C1 = 'PIQ00083' SELECT C536870931 FROM T580 WHERE C1 = 'PIQ00083' FOR UPDATE Set LOB into the above row ... But in the cases where the update fails, the sql log shows this routine happening twice. What would make the routine happen twice? Could second routine be overwriting the first? And what can I do to stop it? (ARS 7.0.1 p2, Linux server, Oracle 10.2 db) Dwayne Martin Computing Support James Madison University ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
