Did anyone delete data in the h tables? You can get the entry does not exist errors if someone has done that..
Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Harry Pugh Sent: Thursday, January 31, 2008 8:18 AM To: [email protected] Subject: Re: Strange behavior - ITSM Applications suddenly unlicensed and getting errors left and right ** The arerror.log had those “Entry does not exist in database” errors. We’re looking at the other servers now – it looks like the DB server may have required a reboot. It was quite strange though – Remedy could get some data from the DB but not everything it needed I guess. Mike Pugh Software Engineer 13990 Parkeast Circle Chantilly, VA 20151 www.AmericanSystems.com phone: (703) 968-5265 mobile: (203) 434-5082 [EMAIL PROTECTED] "Contractor of the Year - 5th Annual Greater Washington Government Contractor Awards" From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of John Joseph Sent: Thursday, January 31, 2008 2:55 AM To: [email protected] Subject: Re: Strange behavior - ITSM Applications suddenly unlicensed and getting errors left and right ** what does the arerr.log say? do check the network connectivity and the SQL logs as well. ---------------------------------------------------------------------------- -- Date: Wed, 30 Jan 2008 23:15:38 -0500 From: [EMAIL PROTECTED] Subject: Strange behavior - ITSM Applications suddenly unlicensed and getting errors left and right To: [email protected] ** Hi, To add to the performance problems we’ve had, I just ran into the strangest issue over the past 30 minutes. To the best of my knowledge – no changes have been pushed to production since last Friday (our staging environment where I do development is completely fine). We’re running ARServer 7.1 and ITSM 7.0.02 patch 6 on SQL 2000 (on separate DB server). I log into Remedy and I go to Incident Management and an error comes up that says there is an Invalid Object Container and that Incident Management is not licensed (unfortunately I do not have a screenshot of the error message). I check the error log file and notice: Wed Jan 30 22:41:28 2008 390603 : Entry does not exist in database (ARERR 302) (repeat 5x above) Wed Jan 30 22:41:28 2008 390603 : Failure during SQL operation to the database : Warning: Fatal error 9001 occurred at Jan 30 2008 10:41PM (SQL Server 21) (ARERR 552) Earlier at 21:54:06, there are several hundred of those “Entry does not exist in database” messages followed by the final Fatal Error message. I restart the ARServer service and log back into Remedy – now the Home Page Quick Links are all jumbled together, unsorted, and missing the application names. I’m getting all sorts of active link error messages relating to user preferences, server entries, and Incident Management not being licensed. Flashboards were also 50/50 whether or not they showed up or displayed an ARERROR message. I verified our server licenses and our licenses were still in there (for ARServer and ITSM). So I go to the Server Info console to turn on logging – I turn on logging for SQL, API, and THREAD then I log out and back in – now suddenly everything works fine. I then turned logging off and everything still works fine as of right now. Has anyone ever run into this? Any idea what might have caused it? Why would turning on logging fix it (or is this just coincidence)? Thanks! Mike Pugh Software Engineer 13990 Parkeast Circle Chantilly, VA 20151 www.AmericanSystems.com phone: (703) 968-5265 mobile: (203) 434-5082 [EMAIL PROTECTED] "Contractor of the Year - 5th Annual Greater Washington Government Contractor Awards" LEGAL DISCLAIMER: The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.19.17/1253 - Release Date: 1/31/2008 9:09 AM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
<<logo.gif>>
<<image001.gif>>
