Mark, It appears that the escalation or the workflow triggered by the escalation is setting up the 'status' field to NULL, which is a mandatory field. Can you check the form name for T1060 in the schema tables and see, why the status is updating it to null.
Thanks, Bala ________________________________________ From: Action Request System discussion list(ARSList) <[email protected]> on behalf of Grooms, Frederick W <[email protected]> Sent: Friday, February 12, 2016 2:37 PM To: [email protected] Subject: Re: Goofy Error Since it is from 390603 it is from an Escalation (At least the Escalation kicked off the transaction) To find it turn on SQL and Filter logging. Either put them in the same log file or find the error in the SQL log and using the TID find it in the Filter log Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Brittain, Mark Sent: Thursday, February 11, 2016 3:40 PM To: [email protected] Subject: Goofy Error ** Hi All Has anyone seen this error before? I thought it was about a KB article with an expired review date. But after changing the review date I am still getting this error. Get this error in 5 times every minute. Can't find an escalation or anything Thu Feb 11 16:35:21 2016 390603 : The SQL database operation failed. : ORA-01407: cannot update ("ARADMIN"."T1060"."C7") to NULL (ARERR 552 ARS 7.6.04 SP5 ITSM 7.6.04 SP2 Mark Mark Brittain Sr. OSD Systems Engineer ITILv3 Foundation, Continual Service Improvement NaviSite, Inc. - A Time Warner Cable Company [email protected] Office: 315.634.9337 Mobile: 315.882.5360 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
