I have notes that this query will identify the records that need to be updated (Note we are on SQL not Oracle)
select * from tms_task where (Flag = 1) AND (Status < 6000) AND (Status != 3000) AND (Expected_Time_Out>0) But it is TMS:SHR:CheckExpectedTimeOut is the object that is failing. Christie Pargeter | Sr Technical Analyst | tel 503-415-5149 From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Brittain, Mark Sent: Thursday, February 11, 2016 1: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]<mailto:[email protected]> Office: 315.634.9337 Mobile: 315.882.5360 [navsig] ________________________________ This E-mail and any of its attachments may contain Time Warner Cable proprietary information, which is privileged, confidential, or subject to copyright belonging to Time Warner Cable. This E-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this E-mail, you are hereby notified that any dissemination, distribution, copying, or action taken in relation to the contents of and attachments to this E-mail is strictly prohibited and may be unlawful. If you have received this E-mail in error, please notify the sender immediately and permanently delete the original and any copy of this E-mail and any printout. _ARSlist: "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"
