Jiri this is EXTREMELY helpful as I had set the snapshot isolation parameters based on BMC's recommendations. I will consult DBAs to turn on tracing as I retry upgrade.
Thanks again! From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Jiri Pospisil Sent: Tuesday, March 08, 2011 10:42 AM To: [email protected] Subject: Re: Upgrade from 7.5 to 7.6.4 Issue ** ++++++++++++++++++++++++++++++++++++++++++++++++++++++ Please Read The Disclaimer At The Bottom Of This Email ++++++++++++++++++++++++++++++++++++++++++++++++++++++ Rafael, This may be totally unrelated, but I thought I might share this information with you. We are experiencing a similar SQL error to yours, i.e. "The COMMIT TRANSACTION request has no ... ", but in our case we are running the ITSM 7.6.03 installer. The Remedy server is already on 7.6.03 version and the error appears when upgrading from ITSM 7.0.3 to 7.6.03. We have done some investigation with the DBA team here who turned on tracing on the database to see what is happening at the database level. Interestingly, the issue appears to be caused by deadlock on the GROUP_CACHE table when installer attempts to create 3 new groups, which AR Server translates into three simultaneous INSERT commands to the GROUP_CACHE table. At that point, only one of the inserts succeeds, while the other two fail with deadlock and rollback. The server then issues more commands followed by COMMIT and this causes the aforementioned error. I can see in your log that the command was also updating the Group form, so maybe the two are related after all. I would suggest trying to run the upgrade with the DB tracing on and see if you or your DBAs can spot the culprit. In our case, we managed to run through the install, but had to unset the snapshot isolation and read committed snapshot DB options. Hope this is of some help. Regards Jiri From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Rodriguez, Rafael J x23718 Sent: 08 March 2011 00:58 To: [email protected] Subject: Upgrade from 7.5 to 7.6.4 Issue ** Hello list, I have recently began trying to upgrade from ARS 7.5 fully custom (No ITSM) to 7.6.4 and the installer gives an error stating that it failed although I'm able to start the ARS service and it shows that its on 7.6.4 version. The indtall log show the following to Sever errors: Issue Details: Server: WIN2008 64bit SQL 2008 64bit ARS: 7.6.4 LOG EVENT {Description=[[resultType=COMPLETED,exitCode=2]],Detail=[RIK command ("C:\Users\hwrarod.JSQ\AppData\Local\Temp\Utilities\rik\rik.exe" loadapp -x EDIDVWREMA01.bsg.ad.adp.com -t 0 -u "Action Request Installer Account" -p <not_displayed> -l "D:\Program Files (x86)\Remedy" -n ARServer-RIK_PostUpgrade -f "D:\Program Files (x86)\Remedy\ARServer\installforms\en\adf_ServerApps1_en.xml" -m nosamp -k 0 -L -c) returned an exit code of 2, which was interpreted as a failure]} THROWABLE EVENT {Description=[Failed to execute Rule Engine],Detail=[[ERROR][Fri Mar 04 12:47:04.162] ImportFileNode- ARImport() for "Group.def" returned non-zero return code 2 [ERROR][Fri Mar 04 12:47:04.162] ImportFileNode- 552 The SQL database operation failed. The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. (SQL Server 3902) [ERROR][Fri Mar 04 12:47:04.162] LoadComponent- Definition Import failed for D:\Program Files (x86)\Remedy\ARServer\installforms\en\Group.def (return code 2) [ERROR][Fri Mar 04 12:47:12.591] ImportFileNode- ARImport() for "UserPasswordChange.def" returned non-zero return code 2 [ERROR][Fri Mar 04 12:47:12.591] ImportFileNode- 552 The SQL database operation failed. The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. (SQL Server 3902) [ERROR][Fri Mar 04 12:47:12.591] LoadComponent- Definition Import failed for D:\Program Files (x86)\Remedy\ARServer\installforms\en\UserPasswordChange.def (return code 2) [ERROR][Fri Mar 04 12:47:12.591] LoadComponent- At least one file in definitions list returned an error [ERROR][Fri Mar 04 12:47:19.650] LoadComponent- Errors processing component GroupUser, worst overall return code = 2 [ERROR][Fri Mar 04 12:47:22.129] ImportFileNode- ARImport() for "AlertList.def" returned non-zero return code 2 [ERROR][Fri Mar 04 12:47:22.129] ImportFileNode- 552 The SQL database operation failed. The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. (SQL Server 3902) [ERROR][Fri Mar 04 12:47:22.129] LoadComponent- Definition Import failed for D:\Program Files (x86)\Remedy\ARServer\installforms\en\AlertList.def (return code 2) ...]} ------------------------ Also, I tried importing the failed forms using dev studio and get the following message: The SQL database operation failed. The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION. (SQL Server 3902) I get the following errors when trying to perform search on the following forms: User form: ARERR [552] The SQL database operation failed. : Invalid column name 'C301600300'. (SQL Server 207) I also get the following error on Group form: ARERR [552] The SQL database operation failed. : Invalid column name 'C301600300'. (SQL Server 207)Invalid column name 'C139'. (SQL Server 207)Invalid column name 'C136'. (SQL Server 207)Invalid column name 'C134'. (SQL Server 207) Anyone see this problem before? Regards, Rafael Rodriguez|Manager Remedy/Mid-Tier Enterprise|Broadridge Financial Solutions 2 Journal Square Plaza|Jersey City, NJ 07306| 201.714.3718 p [cid:[email protected]] This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ ************************************************************************************************* This email is intended for the named recipient(s) only. Its contents are confidential and may only be retained by the named recipient(s) and may only be copied or disclosed with the consent of LCH.Clearnet Limited and/or LCH.Clearnet SA. If you are not an intended recipient please delete this e-mail and notify [email protected]. LCH.Clearnet Limited, LCH.Clearnet SA and each other member of the LCH.Clearnet Group accept no liability, including liability for negligence, in respect of any statement in this email. The contents of this email are subject to contract in all cases, and LCH.Clearnet Limited and/or LCH.Clearnet SA makes no contractual commitment save where confirmed by hard copy. Cet e-mail et toutes les pièces jointes (ci-après le "message") sont confidentiels et établis à l'intention exclusive de ses destinataires. Toute utilisation de ce message non conforme à sa destination, toute diffusion ou toute publication, est interdite, sauf autorisation expresse de LCH.Clearnet Limited et/ou LCH.Clearnet SA. Si ce message vous a été adressé par erreur, merci de le détruire et d'en avertir immédiatement [email protected]. LCH.Clearnet Limited, LCH.Clearnet SA et les autres entités du groupe LCH.Clearnet Group, ne peuvent en aucun cas être tenues responsables au titre de ce message à moins qu'il n'ait fait l'objet d'un contrat signé. LCH.Clearnet Limited, Registered Office: Aldgate House, 33 Aldgate High Street, London EC3N 1EA. Recognised as a Clearing House under the Financial Services & Markets Act 2000. Reg in England No.25932 Telephone: +44 20 7426 7000 Internet: http://www.lchclearnet.com LCH.Clearnet SA, Siège Social, 18 rue du Quatre Septembre, 75002 Paris, Chambre de Compensation conformément au Code Monétaire et Financier. ************************************************************************************************* _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
<<inline: image001.gif>>
