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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
