Skip to main content

Jobflow Manager SQL - Unable to add record to table wf_task in JobFlow Manager SQL

Updated over a month ago

When editing/adding a job in the SQL version of JobFlow Manager, the following error may occur.

Jobflow error: Unable to add record to table wf_task

To resolve this error message, the following SQL query will need to be run on the relevant HandiSoft SQL database in Microsoft SQL Server Management Studio.
If you are unfamiliar with the use of Microsoft SQL Server Management Studio, you may require the assistance of your IT technician or SQL Server Administrator.

  1. Ensure there is a working backup of the SQL data before running this script.

  2. Ensure all users have exited all HandiSoft programs.

  3. Run the following SQL query on the appropriate database:

  • delete from wf_task

    where ID >= 104758

Replace the ID number with the number specified in the error. Once the query has been run, open JobFlow Manager and check that the issue has been resolved. If unhappy with the result, revert to the backup.

Did this answer your question?