Thanks for the help. The table is the User form, but when I check the contents there is no Mark Manager in there?
You can find out what table 22 is (by issuing a "select name from arschema where schemaid = 22; " command to your SQL database using the Query Analyser. Then you'll know the name of the form that the push was to. You will probably also see this name in a failed AL or Filter log. Then, check the indexes on this form and the contents. You will probably find a user with login Mark Manager already in there. -- Met vriendelijke groet / Kind regards Michiel Beijen ______________________________________________________ MANSOLUTIONS Energieweg 60-62 3771 NA Barneveld The Netherlands On 4/10/07, Morrison, David A. <[EMAIL PROTECTED]> wrote: > ** > Thanks for the reply. I had been able to add users directly from the > Admin Console in the Windows User client until the other day. > > I checked the log and the only message of interest was this: > > > /* Tue Apr 10 2007 09:23:49.2810 */INSERT INTO T22 > (C108,C104,C101,C8,C2,C179,C7,C109,C110,C3,C5,C6,C1) VALUES > (0,'1050;','Mark Manager','Mark > Manager','Demo','AG0050568A47EE5Y8bRgNndOxgePkB',0,0,0,1176211429,'Dem > o',1176211429,'000000000000008') > > > /* Tue Apr 10 2007 09:23:49.2810 */* WARNING * The statement has > > been > terminated. > ________________________________ > > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Roger Justice > Sent: Tuesday, April 10, 2007 9:47 AM > To: [email protected] > Subject: Re: Problem adding test users to version 7 > > It may be that oter forms are having entries created. I would suggest > that you use the standard configuration method which is to add new > uers through the People form. If the problem still occurs you will > need to do AL filter and possibly SQL logging.> > -----Original Message----- > From: [EMAIL PROTECTED] > To: [email protected] > Sent: Tue, 10 Apr 2007 9:40 AM > Subject: Problem adding test users to version 7 > > Good morning. > > While hoping to upgrade to AR 7 this summer, I am having a strange > problem while testing version 7. I have installed the demo version of > AR 7 on a test server using MS SQL 2005. Initially it seemed to work > quite well while leaning some of the new screens. I added a few users > and groups successfully. However after a short period of evaluation > the system would not let me add any new users. I know about the demo > limit of three write licenses, however it will not allow any type of > user to be added. I can remove users and edit existing ones, but when > I try to add a new one no matter what I put in the required fields I get this error message: > > "ARERR [382] The value(s) for this entry violate a unique index that > has been defined for this form."> > I have checked the "User" form in the Admin tool, but according to > Form Properties there is no unique index??> > I do a "clear all fields" before typing in the required data also.> > I have searched in the Knowledgebase on the BMC web site and have also > searched the archives of the list, but could not find any possible solution. > I did turn on the logs but found no help there. I am not very > familiar with SQL as it appears to be some kind of possible corruption > in the database. Any ideas or suggestions would be greatly appreciated! > Thanks in advance.> > David> > East Tennessee State University _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
