Did anyone change the nextid for any of those supporting forms which was possibly the reason why it couldn't create information in those forms when it was trying to create with a push after finding no matching requests?
Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Mary Dollus Sent: Wednesday, March 12, 2008 2:57 PM To: arslist@ARSLIST.ORG Subject: Re: Can't delete a user from CTM:People ** Thanks Joe, I looked at that one last night; and checked the forms it’s pushing to which are the CTM:Support Group Association form, CTM:SupportGroupFunctionalRole and the CTM:Support Group Shift Assoc. None of these had any records for the users. I did just receive a call from BMC for the ticket I opened with them and other than checking all we checked, she said to possibly do an arreload or arcache command. What we finally did is to restore the User T, B, and H tables to what they were on the dev server; once that was done I was able to delete records again. It’s still interesting what was causing the deletes to fail though… still don’t know other than somehow the links between the forms were deleted and it seemingly was trying to create new records somewhere… So thank you all so much for your time!!! J - Mary ---------------------------------------------------------------------------- -- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe D'Souza Sent: Wednesday, March 12, 2008 11:58 AM To: arslist@ARSLIST.ORG Subject: Re: Can't delete a user from CTM:People Mary, I just had a minutes look at your logs, as I do not really have too much time on my hands right now.. What I noticed is that its a Phase 2 action that is failing so look at the first possible phase 2 action in your logs.. I would look for a push fields action.. It appears like your logs are incomplete so it would be hard to tell from your logs which was the first phase 2 action that should have been fired.. From your logs you have sent, they start at order 500? Certainly there must be filters that fire before that default order?? IF not and if that is the complete log, I would look at the very first filter that does a push fields, and check the form it pushes the information to, to see if there is something there that it could break a unique index of.. <FLTR> <TID: 0000002892> <RPC ID: 0000168599> <Queue: Fast > <Client-RPC: 390620 > <USER: mdollus > Checking CTM:PPL:DeleteAssoc_780_PSGA/C/R+ (780) <FLTR> <TID: 0000002892> <RPC ID: 0000168599> <Queue: Fast > <Client-RPC: 390620 > <USER: mdollus > --> Passed -- perform actions <FLTR> <TID: 0000002892> <RPC ID: 0000168599> <Queue: Fast > <Client-RPC: 390620 > <USER: mdollus > 0: Push Fields <FLTR> <TID: 0000002892> <RPC ID: 0000168599> <Queue: Fast > <Client-RPC: 390620 > <USER: mdollus > <deferred to phase 2> <FLTR> <TID: 0000002892> <RPC ID: 0000168599> <Queue: Fast > <Client-RPC: 390620 > <USER: mdollus > 1: Push Fields <FLTR> <TID: 0000002892> <RPC ID: 0000168599> <Queue: Fast > <Client-RPC: 390620 > <USER: mdollus > <deferred to phase 2> <FLTR> <TID: 0000002892> <RPC ID: 0000168599> <Queue: Fast > <Client-RPC: 390620 > <USER: mdollus > 2: Push Fields <FLTR> <TID: 0000002892> <RPC ID: 0000168599> <Queue: Fast > <Client-RPC: 390620 > <USER: mdollus > <deferred to phase 2> If it is trying to create a new record, I would even check for the nextid field as if that had been reset its often known to be a culprit for unique index errors.. Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Mary Dollus Sent: Wednesday, March 12, 2008 10:16 AM To: arslist@ARSLIST.ORG Subject: Re: Can't delete a user from CTM:People Trying a zip file... -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of T. Dee Sent: Tuesday, March 11, 2008 9:06 PM To: arslist@ARSLIST.ORG Subject: Re: Can't delete a user from CTM:People Could I be the licenses or permissions they belong to? Try removing their groups / permissions and try again. On Tue, Mar 11, 2008 at 7:43 PM, Mary Dollus <[EMAIL PROTECTED]> wrote: > ** > > > Hi All, > > > > I'm trying to delete some users out of the CTM:People form however I keep > getting the error ARERR (382) The value(s) for this entry violate a unique > index that has been identified for this form. I ran logs but can't find > what it's talking about... I even tried adding a new record and deleting it > (which works). The records I can't seem to delete were restored from > another server. > > > > Setting the status to Delete saved okay... it's just when I try to delete it. > > > > I checked the "CTM:SupportGroupFunctionalRole", "CTM:Support Group > Association" and there are no entries for the users. > > > > They do have entries in CTM:People, CTM:People Permission Groups, and User. > If I try to delete the user from any of these forms, I get the unique index > error... L > > > > Has anyone encountered this? If so, is there a way to resolve it? I have > over 7k records I need to dump and reload... but I have to delete them first. > > > > Thanks!!! > > Mary Dollus > > > > ARS 7.0.01 patch 005 > > SQL server 2005 No virus found in this outgoing message. Checked by AVG. Version: 7.5.518 / Virus Database: 269.21.7/1327 - Release Date: 3/12/2008 1:27 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"