I created a workflow that insert if new type in my SQL server table (with RecordID as primary key). When the scheduler executes at the end of the execution message it appears that the new data is being inserted into the sql table, but it also provides Error 22 (violation of primary key.
If i ran the workflow manually there's no primary key violation, but when the scheduler runs that is where the primary key violation appears. I'm puzzled.
Please advise. Thanks in advance!
