System info: Windows 2k3 server ARS 6.3 patch 22 MS-SQL 2005 9.0 Yipes! Several users, including myself, are receiving the following error while attempting to perform any sort of action in Remedy:
ARERR [552] Failure during SQL operation to the database : Invalid column name 'authString'. (SQL Server 207) The "authString" sounds like a column in the dbo.user_cache table. When I check, I don't see that column, which would certainly explain the error. However, I now have TWO columns called "shortAuthString" and "longAuthString". My question is "why?" I searched the archives for ARERR 552 and it seems that the database would make such a change during an upgrade to 7.0. I can assure you that I've made no such attempt, in fact I've been away from the system most of the morning (ha, that'll show me!). I see nothing relevant in the arerror or aruser.log files (and since I'm getting the error, I can't turn the logs on or off via the admin tool). The SQL log file only shows that a transaction log was successfully backed up - no errors or anything that suggests "dropped column, inserted 2 columns." Same with the Windows event viewer. The one thing I notice is that around the last transaction log backup ballooned to 800MB, normally it sits around a few MB depending on the level of activity. Anyone seen this? Any ideas? Mine right now is restore to the transaction log before the 800MB one, which I assume to be good. And of course this is without knowing what happened. Thanks in advance for any insight. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
