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 Tel. +31-(0)612968592 Mail [EMAIL PROTECTED] Internet http://bsm.mansolutions.nl 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,'Demo',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: arslist@ARSLIST.ORG 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: arslist@ARSLIST.ORG 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 __20060125_______________________This posting was submitted with HTML in it___
_______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"