Re: The values for this entry violate a unique index that has been defined for this form. : NTE:SYS-Group NT Control entry
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 a écrit > : > > De: Begosh, Kevin > 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:NTG00156348 > > 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:NTG00156348 > > 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"
Re: The values for this entry violate a unique index that has been defined for this form. : NTE:SYS-Group NT Control entry
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 a écrit : De: Begosh, Kevin 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:NTG00156348 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:NTG00156348 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"
Re: The values for this entry violate a unique index that has been defined for this form. : NTE:SYS-Group NT Control entry
Forgot to enable the server group logging :-( so will have to do this when I plan another test. Does this log show any errors in your case? --- En date de : Mar 9.6.09, Frex Popo a écrit : De: Frex Popo 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: Mardi 9 Juin 2009, 8h21 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 a écrit : De: Begosh, Kevin 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:NTG00156348 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:NTG00156348 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"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
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 a écrit : De: Begosh, Kevin 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:NTG00156348 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:NTG00156348 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"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
Re: The values for this entry violate a unique index that has been defined for this form. : NTE:SYS-Group NT Control entry
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:NTG00156348 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:NTG00156348 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"_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
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:NTG00156348 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:NTG00156348 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 ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
