I am trying to upgrade from 6.3 to 7.1. I had looked at the ar_install log from the c:\documents and settings\<me>\local settings\temp\1 and all it gave me was that there was a failure updating the database because of a unique index violation. I had seen that before, but without knowing exactly where the violation was, it was hard to determine anything.
Well, I also just now noticed there is an arsql.log in the same .....\temp\1 folder. I looked at it, and it let me know that the error was in the user_cache table. That prompted me to go there to find the unique error issue. I was able to see the exact sql it was running, and it was with the user_cache table. I went in and removed the two duplicate entries that I found, and that seemed to fix the issue. Thanks for the help! 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 Walters, Mark Sent: Thursday, May 20, 2010 1:14 PM To: [email protected] Subject: Re: sql server 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
