As a Spotfire administrator i like to have a flag to ignore the fact users have canceled IS_JOBS
encountered the following in Spotfire 14.6.2
I saw there is now an option in 15.0 to purge IS jobs like this too.
tools.log entry
**This email originated outside the company. Do not click links or attachments unless you are expecting something from the sender.**
WARN 2026-07-10T09:20:14,207+0000 config.tool.ConfigApp: Error executing command delete-disabled-users
com.spotfire.server.config.tool.CommandException: Unable to delete users: The DELETE statement conflicted with the REFERENCE constraint "FK_IS_JOBS_USERS_2". The conflict occurred in database "spotfire_server", table "dbo.IS_JOBS", column 'ENDED_BY'.
at com.spotfire.server.config.tool.DeleteDisabledUsersCommand.delete(DeleteDisabledUsersCommand.java:139)
at com.spotfire.server.config.tool.DeleteDisabledUsersCommand.run(DeleteDisabledUsersCommand.java:88)
at com.spotfire.server.config.tool.ConfigApp.executeCommand(ConfigApp.java:437)
at com.spotfire.server.config.tool.ConfigApp.main(ConfigApp.java:579)
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The DELETE statement conflicted with the REFERENCE constraint "FK_IS_JOBS_USERS_2". The conflict occurred in database "spotfire_server", table "dbo.IS_JOBS", column 'ENDED_BY'.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:278)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1788)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:975)
at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:869)
at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7825)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4828)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:321)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:253)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeUpdate(SQLServerStatement.java:808)
at com.spotfire.server.util.sql.WrappedStatement.executeUpdate(WrappedStatement.java:109)
at com.spotfire.server.config.tool.DeleteDisabledUsersCommand.delete(DeleteDisabledUsersCommand.java:137)
... 3 more