I am trying to create a integration service with the following flow:
SELECT count() without limit
Gets the “SELECT count()” value and divide it by 1,000 to get the “RepeatCount” using “divideInts”
REPEAT with Count == “%RepeatCount%”
SELECT 1,000 values WHERE integrated = ‘Nope’
Create a doc with 1,000 documents in a document list
Publishes the doc
Update 1,000 values SET integrated = ‘Processing’
But when I try to run the service I’m getting the following errors:
“Error while closing transactions at service completion Error:[ART.117.4015] Adapter Runtime (Adapter Service): Error(s) occurred while closing adapter connections.”
“[ART.117.4015] Adapter Runtime (Adapter Service): Error(s) occurred while closing adapter connections…”
Error while closing transactions at service completion
I am using a JDBC adapter with “Transaction Type” value set to “LOCAL_TRANSACTION”.
I don’t know why this is not working. What should I do to solve this issue?