Skip to Main Content
Spotfire Ideas Portal
Status To be Reviewed
Product Spotfire
Created by Guest
Created on Jul 17, 2026

Delete-disabled-users flag for IS_JOBS cancelations

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

  • Attach files