Hi, Turn on API/FLTR/SQL/ESCL logging into the same file.
The log should tell you exactly what happens and which SQL/FLTR is responsible. Best Regards - Misi, RRR AB, http://www.rrr.se Products from RRR Scandinavia: * RRR|License - Not enough Remedy licenses? Save money by optimizing. * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs. * RRR|Translator - Manage and automate your language translations. Find these products, and many free tools and utilities, at http://rrr.se. > I deleted all of them once and it still happens. It is an ongoing thing. > > Kevin Begosh, RSP > Tech Ops > Enterprise Business Services > 301-791-3540 Phone > 410-422-3623 Cell > kevin.beg...@lmco.com > > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Frex Popo > Sent: Tuesday, June 09, 2009 12:21 AM > To: arslist@ARSLIST.ORG > Subject: Re: The values for this entry violate a unique index that has > been defined for this form. : NTE:SYS-Group NT Control entry > > ** > Hello Kevin, > > Does NTE:SYS-NT Process Control have any old entries? I am tempted to > remove them, they could have been left because of some filter failing to > delete them! > > Thanks for your feedback. > frex > > --- En date de : Lun 8.6.09, Begosh, Kevin <kevin.beg...@lmco.com> a écrit > : > > De: Begosh, Kevin <kevin.beg...@lmco.com> > Objet: Re: The values for this entry violate a unique index that has been > defined for this form. : NTE:SYS-Group NT Control entry > À: arslist@ARSLIST.ORG > Date: Lundi 8 Juin 2009, 16h14 > ** > I am currently getting these same errors frequently. I have opened a > ticket with BMC and they really did not find anything. I am still > researching the problem, I will let you know if I find anything. > > Kevin Begosh, RSP > Tech Ops > Enterprise Business Services > 301-791-3540 Phone > 410-422-3623 Cell > kevin.beg...@lmco.com > > From: Action Request System discussion list(ARSList) > [mailto:arsl...@arslist.org] On Behalf Of Frex Popo > Sent: Monday, June 08, 2009 4:14 AM > To: arslist@ARSLIST.ORG > Subject: The values for this entry violate a unique index that has been > defined for this form. : NTE:SYS-Group NT Control entry > > ** > Dear all, > > ARS. 7.1 patch 4 / OS. NT2003 SRV Edition / DB. MS SQL SRV 2005 > > It states in the performance and optimisation manual, only one node in a > server group should be used as the server for admin changes (i.e forms, > workflow etc..) but both should be accessed when making other changes (i.e > adding threads to a particular queue). > I added two threads to the list queue through the admin tool to node1 and > node2 in a server group. I did a restart and got the following errors on > both. > > 390603 : Entry does not exist in database. (ARERR 302) > 390603 : The values for this entry violate a unique index that has been > defined for this form. : NTE:SYS-Group NT Control entry:NTG000000156348 > > I enabled the SQL/Filter/API logs and noticed few errors relating to > escalation SYS:NPC:IM1-TriggerGroupNTG (attached to form NTE:SYS-NT > Process Control) which runs every 1 minute. The escalation updates field > z1D Action with the value "START GROUP NOTIFICATION". It fails with the > first error: > > 390603 : Entry does not exist in database. (ARERR 302) > > This action in turn causes a filter NTE:NPC:CreateGroupNTG_050_PNTG to do > an insert to form NTE:SYS-Group NT Control which fails with the second > error: > > 390603 : The values for this entry violate a unique index that has been > defined for this form. : NTE:SYS-Group NT Control entry:NTG000000156348 > > When removing the two threads I have added and doing a restart I get no > errors. > > I also noticed that form NTE:SYS-NT Process Control still has some old > entries with submit dates as far back as 2007, some 22 of them in total. > > Regards > frex > > > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ > > > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are" > > -- > This message was scanned by ESVA and is believed to be clean. > > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"