Okay - I have 273 records in that table. Funny that this never raised an error in the installation logs.
Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Rodriguez, Rafael J x23718 Sent: Thursday, May 26, 2011 2:59 PM To: [email protected] Subject: Re: Errors when upgrading from ARS 7.5 to 7.6.04 SP1 ** Jason we had the same issue. If you enable SQL log during the install you will see that the culprit is the AR System User Central File form. The is a bug in 7.6.4 installer that tries to create an index on this form and if you have data in the form you will get this error. BMC recommended that we export the data, delete it and rerun the upgrade or re-import the form. Once it completes successfully remove the index from this form and bring back the data. Rafael From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Jason Miller Sent: Thursday, May 26, 2011 3:27 PM To: [email protected] Subject: Re: Errors when upgrading from ARS 7.5 to 7.6.04 SP1 ** Turns out that we have two different BMC Remedy Action Request System Release Notes for 7.6.04. Both are dated 1/28/2011 and have the same title but the one with this tidbit about the arsystem.tag file has a document number 184374 and the shorter one without is document 180022. That still leaves the entry violates a unique index and creation of an application form failed errors (ARERR 382 and ARERR 4550 respectively). Anybody have any ideas? Wed May 25 15:02:03 2011 390600 : The value(s) for this entry violate a unique index that has been defined for this form (ARERR 382) Wed May 25 15:02:02 2011 390600 : Creation of an application form failed. (ARERR 4550) Jason On Wed, May 25, 2011 at 4:12 PM, Jason Miller <[email protected]<mailto:[email protected]>> wrote: Nice! I am not finding it in the release notes (SP1 tech bulletin, etc). Do you know if I have two different errors, one of which can be ignored, or they are related an both can be ignored. Thank you! On Wed, May 25, 2011 at 3:54 PM, strauss <[email protected]<mailto:[email protected]>> wrote: ** Yes, it is a file installed by ITSM 7.6.04 as I recall, that the system bitches and whines about during the ARS and Atrium installs; I have been told that it is an ignorable error by support. "Workaround: You can ignore these messages. This is documented in the release notes for AR Server 7.6.04 version." Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Jason Miller Sent: Wednesday, May 25, 2011 5:35 PM To: [email protected]<mailto:[email protected]> Subject: Errors when upgrading from ARS 7.5 to 7.6.04 SP1 ** Has anybody seen these errors in the arerror.log when installing or upgrading to ARS 7.6.04? Wed May 25 15:01:05 2011 390600 : Could not find or read the tags file. (ARNOTE 452) Wed May 25 15:01:05 2011 C:\Program Files\Common Files\AR System\Licenses\<servername>\arsystem.tag Wed May 25 15:02:03 2011 390600 : The value(s) for this entry violate a unique index that has been defined for this form (ARERR 382) Wed May 25 15:02:02 2011 390600 : Creation of an application form failed. (ARERR 4550) We have seen this on two of our systems that went from 7.5 to 7.6.04 SP1. Both are Windows 2008 x64 (one is R2) with SQL 2008 x64. Thanks, Jason _attend WWRUG11 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com<http://www.wwrug.com> ARSlist: "Where the Answers Are"_ _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. _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
