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