DB load does not complete, last line of log: U00038284 Row versioning...

book

Article ID: 221049

calendar_today

Updated On:

Products

CA Automic One Automation

Issue/Introduction

The DB load utility does not complete when loading the initialdata into a SQL Server database, it appears to hang.  When looking at the latest ucybdbld_log_00.txt, the last line is:

20210729/123334.139 - U00038284 Row versioning for read-committed and snapshot transactions is disabled.

 

Cause

This is caused by the user having incorrect or incomplete permissions to the database

Environment

Release : 12.x

Component : db load utility

Database: SQL Server

Resolution

One of the first things the db load checks to see is if versioning (read_committed_snapshot) is on.  If it is not, it will write the following line to the log file:
U00038284 Row versioning for read-committed and snapshot transactions is disabled.

The next step the db load will attempt to do is run:

alter database "[database name]" set read_committed_snapshot on

as the user in the SQLDRIVERCONNECT= setting of the ini file.  If it is unable to, it will hang and not continue the load.  

To resolve this, close the db load utility and make sure that the instructions in the documentation under "Create a new login" are followed (note: a DBA may be needed for this): https://docs.automic.com/documentation/webhelp/english/AA/12.3/DOCU/12.3/Automic%20Automation%20Guides/help.htm#Installation_Common/PreparationSteps/PrepareAEDB_MSSQL.htm#link7

The user who is defined in the load ini file must be able to run the command:

alter database "[database name]" set read_committed_snapshot on