One or more disabled Users who have not been active for a long time and are also not assigned to any project, cannot be deleted using the
Delete button. There is no error message in the User Interface, the User just stay disabled.In the ws log, you might find these entries:
[2020-12-14 07:29:43,082] WARN http-nio-8080-exec-23 com.idiominc.ws.servlet.ObjectDelete:
Encountered likely normal storage exception when deleting object.
com.idiominc.ws.storage.StorageException
(covers com.idiominc.ws.sql.WSSQLException
(covers java.sql.SQLException: [SDL WorldServer][Oracle JDBC Driver][Oracle]ORA-02292:
integrity constraint (IDIOMDEV.FILTERFKUSER) violated - child record found
or:
[2020-12-14 12:17:06,466] WARN http-nio-443-exec-1 com.idiominc.ws.servlet.ObjectDelete:
Encountered likely normal storage exception when deleting object.
com.idiominc.ws.storage.StorageException
(covers com.idiominc.ws.sql.WSSQLException
(covers java.sql.SQLIntegrityConstraintViolationException:
[SDL WorldServer][SQLServer JDBC Driver][SQLServer]
The DELETE statement conflicted with the REFERENCE constraint "SDFKPROJECT".
The conflict occurred in database "ECL-US1-WS145_WS",
table "dbo.SDPROJECTS", column 'CREATORID'.
