db load fails with U00037182 Unable to set row versioning

book

Article ID: 207417

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

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.

Cause

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

Resolution

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.