Are you attempting an upgrade? These errors; > /* Mon May 17 2010 13:23:09.5320 */*** ERROR *** Cannot drop the table 'AR0int3692', because it does not exist in the system catalog. (SQL Server 3701)
Can be ignored - they're threads shutting down and trying to remove any temporary tables they may have created. Now this; Mon May 17 13:23:09 2010 390600 : The database is not the expected version (may need to run upgrade program) (ARERR 36) Mon May 17 13:23:09 2010 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) Suggest the upgrade failed for some reason and has left the db in the format of the previous version. There's a log of the SQL run by the installer in the temp directory (I think) that should explain what failed. If you're not upgrading what happened before these messages started appearing? Mark -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Opela, Gary L CTR USAF ABW 72 ABW/SCOOA Sent: 20 May 2010 18:01 To: [email protected] Subject: Re: sql server Okay, finally got a compatibility matrix, thanks for it you know who you are. So, the following line for 7.1: 32 or 64 bit x86 PC Compatible Windows 2000, 2003 (32 or x64) [Server, Advanced Server, Datacenter, Enterprise, Standard] Microsoft SQL Server 2000, 2005 (32 or 64-bit) [Enterprise, Standard] Oracle 9i, 10g [Standard, Std One, Enterprise + RAC] IBM DB2 8.2.2, 9.1 [Enterprise, Workgroup, Workgroup Unlimited] This clearly states that SQL Server 2000 32-bit Enterprise Edition will work with BMC AR System 7.1. However, I'm getting a bunch of errors: ARSql.log: <SQL > <TID: 0000003692> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon May 17 2010 13:23:09.5320 */*** ERROR *** Cannot drop the table 'AR0int3692', because it does not exist in the system catalog. (SQL Server 3701) <SQL > <TID: 0000003692> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon May 17 2010 13:23:09.5320 */DROP TABLE AR0float3692 <SQL > <TID: 0000003692> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon May 17 2010 13:23:09.5320 */*** ERROR *** Cannot drop the table 'AR0float3692', because it does not exist in the system catalog. (SQL Server 3701) <SQL > <TID: 0000003692> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon May 17 2010 13:23:09.5320 */DROP TABLE AR0char3692 <SQL > <TID: 0000003692> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon May 17 2010 13:23:09.5480 */*** ERROR *** Cannot drop the table 'AR0char3692', because it does not exist in the system catalog. (SQL Server 3701) <SQL > <TID: 0000003692> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon May 17 2010 13:23:09.5480 */DROP TABLE AR0decimal3692 <SQL > <TID: 0000003692> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon May 17 2010 13:23:09.5480 */*** ERROR *** Cannot drop the table 'AR0decimal3692', because it does not exist in the system catalog. (SQL Server 3701) <SQL > <TID: 0000003692> <RPC ID: 0000000000> <Queue: Admin > <Client-RPC: 000000 > <USER: > /* Mon May 17 2010 13:23:09.5790 */SQL Trace Log -- OFF And then the real confusing one from the arerror.log: Mon May 17 13:23:09 2010 390600 : The database is not the expected version (may need to run upgrade program) (ARERR 36) Mon May 17 13:23:09 2010 390600 : AR System server terminated -- fatal error encountered (ARNOTE 21) I'm running SQL Server 2k EE on Windows Server 2k3 EE SP2. According to the Compatibility Matrix, this should be a supported configuration. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of LJ LongWing Sent: Wednesday, May 19, 2010 4:00 PM To: [email protected] Subject: Re: sql server ** Well....Gary, as I'm sure you are aware that's not a supported configuration...I don't have any experience with it kuz I try to stay within supported configurations....but BMC I'm sure wouldn't recommend it J From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Opela, Gary L CTR USAF ABW 72 ABW/SCOOA Sent: Wednesday, May 19, 2010 2:42 PM To: [email protected] Subject: sql server ** Has anyone experienced any issues using SQL Server 2k8 standard edition instead of enterprise edition? This is with 7.1 version of AR System. Thanks, Gary Opela, Jr. Sr. Remedy Engineer Avaya Phone Admin RSP Cert, Sec+ COMM: 405 582 4272 _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
