search cancel

Error while loading database structures via DBLOAD utility

book

Article ID: 256516

calendar_today

Updated On:

Products

CA Automic Workload Automation - Automation Engine

Issue/Introduction

When running dbload for v12 we get an error. 

20221209/172829.410 - U00033103 Automation Engine - Utilities Version 12.3.3+build.1591950825399 @ xxxxxx
20221209/172831.295 - U00038017 File read: '..\db\'
20221209/172854.506 - U00038017 File read: 'C:\AutoUAT_V12.3.3\Utility\db\general\12.3\UC_UPD.TXT'
20221209/172854.507 - U00038091 Change application directory to '..\db\'.
20221209/172854.507 - U00038091 Change application directory to '..\db\'.
20221209/172854.508 - U00038091 Change application directory to 'C:\AutoUAT_V12.3.3\Utility\bin'.
20221209/172854.564 - U00003545 UCUDB: Opening database ...
20221209/172854.565 - U00029112 UCUDB - Length of the DB-History area: 100
20221209/172854.584 - U-00000001 ??? ""
20221209/172854.584 - U-00000001 ??? ""

 

Environment

Release : 12.3

Resolution

The trace logs shows that the DBLOAD was not able to connect to the database.

20221209/172854.565 - U00029112 UCUDB - Length of the DB-History area: 100
20221209/172854.582 - UCUDB32 OPEN RET -001 HSTMT: 0000000000000000 VALUE: 0000000000000000 ALL:  0.07291 DB:  0.00000 ODBC:  0.01672 UDB:  0.05619

SQLDRIVERCONNECT=ODBCVAR=NNJNIORO,DSN=autsit;UID=xxxx;new_PWD4xxxxx

The password field does not seem correct.

After the Password string was resolved. we could connect to the DB and it ran fine.