Job Preset value overflow

I have a job preset, that apparently is not able to represent an internal job id as it has exceeded INT MAX. May I please get some advice on where to look, so I can reset the job ID?

DEBUG: 01:37:35.566 [0068] Starting plugin Create Job - 1:37:35 AM
DEBUG: 01:37:35.570 [0068] Create the rest client
INFO : 01:37:35.647 [0068] Creating Job…
DEBUG: 01:37:35.648 [0068] Using cached config file (id = 2146524700).
DEBUG: 01:37:35.648 [0068] Starting job creation operation…
DEBUG: 01:37:35.652 [0068] [2025-03-11 01:37:35.652] Job creation> Retrieving results
ERROR: 01:37:36.540 [0068] W3001 : Error while executing plugin: ‘2147978139’ is not a valid integer value
ERROR: 01:37:36.540 [0068] 1: VIC_23_010M1QBD9QN2761
ERROR: 01:37:36.540 [0068] Create Job: W1603 : Plugin failed - 1:37:36 AM (elapsed time: 00:00:00.974)

This seems known issue as happen when there is a huge volume of entries created in one of the Connect database tables within a short time, and because the database ID numbers are of format big integer.
This is fixed in versions 2024.1.2 and later.

For older version the only solution is to delete the Connect Database completely to force Connect to create a new one with ID numbers starting at 0.

1 Like