Skip to Content
0
Former Member
Jan 18, 2007 at 03:28 PM

Problem when creating an user from the program

40 Views

Hi,

I have a problem when creating a user from a program using the UME api. It throws the following exception when creating the user

com.sap.security.api.UserAlreadyExistsException: User with unique name

"ELLIOTMTEST508" already exists.: Batch rolled back. Caused by java.sql.BatchUpdateException: ORA-00001: unique constr

aint (SAPELQDB.SYS_C002042) violated

at oracle.jdbc.dbaccess.DBError.throwBatchUpdateException(DBError.java:460)

at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:4210)

at com.sap.sql.jdbc.basic.BasicPreparedStatement.executeBatch(BasicPreparedStatement.java:263)

at com.sap.sql.jdbc.oracle.Oracle9iPreparedStatement.executeBatch(Oracle9iPreparedStatement.java:302)

at com.sap.sql.jdbc.direct.DirectPreparedStatement.executeBatch(DirectPreparedStatement.java:1102)

at com.sap.sql.jdbc.common.CommonPreparedStatement.executeBatch(CommonPreparedStatement.java:1068)

at com.sap.engine.services.dbpool.wrappers.StatementWrapper.executeBatch(StatementWrapper.java:270)

at com.sap.security.core.persistence.datasource.imp.DataBasePersistence.createPrincipalDatabag(DataBasePersist

ence.java:4507)

at com.sap.security.core.persistence.datasource.imp.DataBaseDataSourceTransaction.createPrincipalDatabag(DataB

aseDataSourceTransaction.java:69)

at com.sap.security.core.persistence.imp.DistributedTransaction.commit(DistributedTransaction.java:746)

at com.sap.security.core.imp.UserMaint.commit(UserMaint.java:546)

at com.adp.admin.user.AdminUserImport.createNewUser(AdminUserImport.java:290)

at com.adp.admin.user.AdminUserImport.importFromFile(AdminUserImport.java:415)

at com.adp.admin.user.AdminUserImport.process(AdminUserImport.java:723)

at com.adp.service.SchUserImportService$1.run(SchUserImportService.java:98)

at java.util.TimerThread.mainLoop(Timer.java:432)

at java.util.TimerThread.run(Timer.java:382)

The funny thing is it still creates a user despite throwing this exception. There is no user with the same uid before running the program but still it manages to say that a user with that unique name already exists on the system.

Any clues will be greatful.

Thanks & Regards,

Sudhir