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 <[email protected]> a écrit : De: Begosh, Kevin <[email protected]> Objet: Re: The values for this entry violate a unique index that has been defined for this form. : NTE:SYS-Group NT Control entry À: [email protected] 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 [email protected] From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Frex Popo Sent: Monday, June 08, 2009 4:14 AM To: [email protected] 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: [email protected] ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
