Why can't I add a new user to cs_security?  I getan error that says the user code is already taken.

Why can't I add a new user to cs_security?  I get an error that says the user code is already taken.

When adding a new user through the ChemOffice Webserver interface, a user may receive the following error:

User code is already taken by another user

This indicates that the Oracle sequence used to assign user ids is out of sequence with respect to the users in the people table.  This typically occurs when users are directly inserted into the people table without using the cs_security interface.

The following PL/SQL block will realign the sequence:

Connect cs_security/oracle@;
DECLARE
I PLS_INTEGER;
J PLS_INTEGER;
C PLS_INTEGER;
BEGIN
select max(person_id) into C from cs_security.people;
  FOR I IN 1..C LOOP
     SELECT cs_security.people_Seq.NEXTVAL INTO J FROM DUAL;
  END LOOP;
END;

Run the above in Oracle SQL Plus Worksheet.