Ok...shot in the dark here..
I have seen the 'unique index' error when you are trying to rename an object to the exact same name, but with case difference..so, as I said, shot in the dark On startup, your system may be trying to import email forms (default behavior) if they don't exist..but may be trying to import one with a single (or more) field with a different case. There is a config option, I think in the aremail.properties file, or it may be ar.cfg, that tells it not to import the forms by default on startup..check the docs to be sure.you could try turning that off, and restart to see if it's not happening anymore.if so, you have the painstaking task of trying to figure out which one.. To figure that out I would turn on sql logging, stop the server, clear the log, start the server, then look for some SQL errors of some sort.that would likely help you pinpoint. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Jason Miller Sent: Thursday, May 26, 2011 1: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]> 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]> 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]] On Behalf Of Jason Miller Sent: Wednesday, May 25, 2011 5:35 PM To: [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 ARSlist: "Where the Answers Are"_ _attend WWRUG11 www.wwrug.com ARSlist: "Where the Answers Are"_ _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"
