search cancel

db load fails with U00037182 Unable to set row versioning


Article ID: 207417


Updated On:


CA Automic Workload Automation - Automation Engine


First time running db load utility throws error:

U00037182  Unable to set row versioning for read-committed and snapshot transactions due to multiple database connections.


This can be caused by the ODBC connection pointing to the incorrect database or READ_COMMITTED_SNAPSHOT being off.


Note the "DSN" entry in the SQLDRIVERCONNECT setting of ucsrv.ini

Open Windows utility - ODBC Data Source Administrator (64-bit)

Go to "System DSN" tab

Click on the corresponding ODBC connection and choose "Configure..."

Click Next from the first screen, enter user and password info on second screen and hit Next

Make sure that the third screen setting "Change the default database to:" has the correct database chosen.

Also have a DBA doublecheck that the database has READ_COMMITTED_SNAPSHOT on on the same database.