What is causing this error message? Again, there is not a syntax error, nor is the statement actually "timing out", as there is a 6000 second timeout limit, and this error occurs instantly.
I see there are other posts over the last year with this issue, none of which seem to offer any solution.
Plz advise, thanks.
More detail: this bot uses a nested loop: the inner loop iterates through a datatable, for each row composing a SQL Insert statement using row data variables, and then stores the statement into a string variable $sSqlInsert$. For each iteration it then combines the sql inserts into one long string: $sSqlTransaction$ (SqlTransaction = SqlTransaction+SqlInsert). when the inner loop finishes, the outer loop composes another SQL Update statement $SqlUpdate$, and concatenates that with $SqlTransaction$ (SqlTransaction = SqlTransaction+SqlUpdate).
Then I attempt to Start Transaction, run the whole statement $sSqlTransaction$ in a single Database INSERT/UPDATE/DELETE action. and then End Transaction.
This has been working successfully for weeks, and only stopped working when switching to a different database.
In my attempts to isolate the problem, after validating my sql statements, I have also now tried skipping all the above concatenation, and only running a single insert statement, and that also is giving the same error.