500 error on create User Log says Caused by: oracle.jdbc.OracleDatabaseException: ORA-00001: unique

[Sue Bridges]

Use Create User.  Enter details and get 500 Database error with skull and cross bones.  Can't fit it all in here (...)

All help much appreciated.  TIA

could not execute batch...?

atlassian-bitbucket log file

2022-11-08 11:51:15,548 ERROR [http-nio-7990-exec-4] sueb @1GNYAP5x711x9605x0 15t3pby 192.100.100.203 "POST /admin/users HTTP/1.1" o.h.e.j.batch.internal.BatchingBatch HHH000315: Exception executing batch [java.sql.BatchUpdateException: ORA-00001: unique constraint (STASH.SYS_PK_10202) violated
], SQL: insert into cwd_user_attribute (user_id, directory_id, attribute_name, attribute_value, attribute_lower_value, attribute_numeric_value, id) values (?, ?, ?, ?, ?, ?, ?)
2022-11-08 11:51:15,548 WARN [http-nio-7990-exec-4] sueb @1GNYAP5x711x9605x0 15t3pby 192.100.100.203 "POST /admin/users HTTP/1.1" o.h.e.jdbc.spi.SqlExceptionHelper SQL Error: 1, SQLState: 23000
2022-11-08 11:51:15,564 ERROR [http-nio-7990-exec-4] sueb @1GNYAP5x711x9605x0 15t3pby 192.100.100.203 "POST /admin/users HTTP/1.1" o.h.e.jdbc.spi.SqlExceptionHelper ORA-00001: unique constraint (STASH.SYS_PK_10202) violated

2022-11-08 11:51:15,564 ERROR [http-nio-7990-exec-4] sueb @1GNYAP5x711x9605x0 15t3pby 192.100.100.203 "POST /admin/users HTTP/1.1" c.a.s.i.w.HandlerExceptionResolverImpl A database error has occurred.
com.atlassian.bitbucket.DataStoreException: A database error has occurred.
at com.atlassian.stash.internal.aop.ExceptionRewriteAdvice.afterThrowing(ExceptionRewriteAdvice.java:47)
at com.atlassian.stash.internal.web.admin.UserCreateController.createUser(UserCreateController.java:112)
at com.atlassian.stash.internal.web.admin.UserCreateController.validateAndCreateUser(UserCreateController.java:105)
at com.atlassian.stash.internal.web.admin.UserCreateController.createUserWithoutPassword(UserCreateController.java:59)
at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:24)
at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:24)
at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:24)
at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:24)
at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:24)
at

...

com.atlassian.stash.internal.crowd.RiotPolice$VoidCrowdCallback.execute(RiotPolice.java:802)
at com.atlassian.stash.internal.crowd.RiotPolice.execute(RiotPolice.java:756)
at com.atlassian.stash.internal.crowd.RiotPolice.setUserAttribute(RiotPolice.java:607)
at com.atlassian.stash.internal.user.CrowdPasswordResetHelper.addToken(CrowdPasswordResetHelper.java:41)
at com.atlassian.stash.internal.user.DefaultUserAdminService.createUserWithGeneratedPassword(DefaultUserAdminService.java:324)
... 39 common frames omitted
Caused by: java.sql.BatchUpdateException: ORA-00001: unique constraint (STASH.SYS_PK_10202) violated

at oracle.jdbc.driver.OraclePreparedStatement.executeLargeBatch(OraclePreparedStatement.java:10032)
at oracle.jdbc.driver.T4CPreparedStatement.executeLargeBatch(T4CPreparedStatement.java:1364)
at oracle.jdbc.driver.OraclePreparedStatement.executeBatch(OraclePreparedStatement.java:9839)
at oracle.jdbc.driver.OracleStatementWrapper.executeBatch(OracleStatementWrapper.java:234)
at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:127)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
at org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:121)
... 72 common frames omitted
Next exception: java.sql.SQLIntegrityConstraintViolationException: ORA-00001: unique constraint (STASH.SYS_PK_10202) violated

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:910)
at oracle.jdbc.driver.OraclePreparedStatement.executeForRowsWithTimeout(OraclePreparedStatement.java:9804)
at

...

org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215)
at com.sun.proxy.$Proxy255.storeUserAttributes(Unknown Source)
at com.atlassian.crowd.manager.application.ApplicationServiceGeneric.storeUserAttributes(ApplicationServiceGeneric.java:587)
at sun.reflect.GeneratedMethodAccessor1005.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)

...

at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:893)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1726)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Unknown Source)
Caused by: oracle.jdbc.OracleDatabaseException: ORA-00001: unique constraint (STASH.SYS_PK_10202) violated

at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
... 457 common frames omitted