I have a workflow that either inserts or updates a record in a db.
One component of the workflow is an insert query, the input of which is a form, which is filled out by the user.
This has been working perfectly thus far, however now it is persistently throwing an error that "you must satisfy the constraint 'trades pkey' ".
I am not sure what could be causing the issue; the primary key is set to an auto-incrementing integer id. I'm not sure why the default value is not just populating, or why the query would work fine for 100 runs and now stop working.
Now something even stranger has happened. After writing out the rest of this post, i decided to spam click the button that submits the workflow. I clicked it about 20 times, with 20 fails, and then all of a sudden it ran successfully and the record was inserted in my table.
???
What could be causing this?
Here is the pkey settings
Here is the failing query
And here is the start trigger input
