DB Load fails with U00038076 File '..\db\sql_9\21.0\check_privileges.sql' not found. 
search cancel

DB Load fails with U00038076 File '..\db\sql_9\21.0\check_privileges.sql' not found. 

book

Article ID: 376602

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine CA Automic One Automation

Issue/Introduction

The DB Load fails with a popup that states:

U00038261 "The path ""'{Path to Automic Utility}\db\general\21.0\UC_UPD.TXT'"" does not match with the path ""'{Path to Utility directory housing ucybdbldg}'"" defined in ucybdbld.ini, however, the Initial data are loaded from the path defined in the ini file!"

The load log shows something like:

20240905/172607.947 - U00038017 File read: '..\db\'
20240905/172620.372 - U00038017 File read: 'C:\automic\21110\Utility\Temp\db\general\21.0\UC_UPD.TXT'
20240905/172620.372 - U00038090 Warning: It was not possible to change current application directory to '..\db\'.
...
20240905/172624.397 - U00038090 Warning: It was not possible to change current application directory to '..\db\'.
...
20240905/172624.413 - U00038090 Warning: It was not possible to change current application directory to '..\db\'.
...
20240905/172629.372 - U00038090 Warning: It was not possible to change current application directory to '..\db\'.
...
20240905/172629.935 - U00038282 Row versioning for read-committed and snapshot transactions is enabled.
20240905/172631.536 - U00038042 ..\db\sql_9\21.0\check_privileges.sql
20240905/172631.536 - U00038076 File '..\db\sql_9\21.0\check_privileges.sql' not found. 
 
Please copy the necessary files and then continue.
20240905/172651.095 - U00038245 If you cancel the Database will probably be in an inconsistent state. Please contact Automic Support to evaluate the best approach. Do you really want to cancel?

Cause

/db/ directory is not directly in the /utility directory

Resolution

Make sure the /db/ directory provided on the Automic image or initialdata download is directly in the /utility/ directory so that it is parallel to /bin and /temp:

If on windows, be sure the utilities have been fully installed by running the setup.exe as an administrator into a /utility/bin directory.