This is a definite sign that someone is monkeying around with your database. Have you asked your DBAs to help with performance tuning on Remedy lately?
Thanks, Shawn Pierson Remedy Developer | Energy Transfer From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Tommy Morris Sent: Thursday, February 20, 2014 9:10 AM To: [email protected] Subject: SQL Error when Refreshing Incident Console ** I am receiving "ARERR [552] The SQL database operation failed. : ORA-38141: SQL plan baseline SYS_SQL_PLAN_19c5fd83b7bfd1e7 does not exist" when refreshing the Incident Console. When the Console first opens and the table refreshes it returns the error, when I hit the Refresh icon it returns. However, if I select Open (under Incident Counts) then the table refreshes fine. This is only affecting Incident Console and is present in both in User Tool and mid-Tier. ARS 7.6.04 ITSM 7.6.sp3 Oracle Tommy Morris Sr. Remedy Developer | RadioShack Office# 817-415-2510 _ARSlist: "Where the Answers Are" and have been for 20 years_ Private and confidential as detailed here: http://www.energytransfer.com/mail_disclaimer.aspx . If you cannot access the link, please e-mail sender. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
