WP and CP's fail with U00003526 UCUDB: Database version ('0.0.0') does not match your program version

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

When attempting to start Worker Processes or Communication Processes, the processes fail with an error similar to:

20210208/131157.280 - U00003526 UCUDB: Database version ('0.0.0') does not match your program version ('12.2.2').

Environment

Component : AUTOMATION ENGINE

Cause

Improper configuration of SQLDRIVERCONNECT

Resolution

In the log above, you can see the DB connection information:

20210208/131157.272 - U00003535 DB INFO: 'DATABASE-NAME         = master'
20210208/131157.272 - U00003535 DB INFO: 'DBMS-NAME             = Microsoft SQL Server'
20210208/131157.272 - U00003535 DB INFO: 'DBMS-VER              = 13.00.5865'
20210208/131157.272 - U00003535 DB INFO: 'ODBC-VER              = 03.80.0000'
20210208/131157.272 - U00003535 DB INFO: 'DRIVER-NAME           = msodbcsql11.dll'
20210208/131157.272 - U00003535 DB INFO: 'DRIVER-ODBC-VER       = 03.80'
20210208/131157.272 - U00003535 DB INFO: 'DRIVER-VER            = 12.00.5543'
20210208/131157.272 - U00003535 DB INFO: 'ODBC-API-CONFORMANCE  = 2'
20210208/131157.272 - U00003535 DB INFO: 'TXN-CAPABLE           = 2'
20210208/131157.272 - U00003535 DB INFO: 'DEFAULT-TXN-ISOLATION = 2'
20210208/131157.272 - U00003535 DB INFO: 'TXN-ISOLATION-OPTION  = 0000000000101111B ( 47)'
20210208/131157.272 - U00003535 DB INFO: 'POS-OPERATIONS        = 0000000000011111B ( 31)'
20210208/131157.272 - U00003535 DB INFO: 'POSITIONED-STATEMENTS = 0000000000000111B (  7)'
20210208/131157.272 - U00003535 DB INFO: 'SCROLL-CONCURRENCY    = 0000000000001111B ( 15)'
20210208/131157.272 - U00003535 DB INFO: 'SCROLL-OPTIONS        = 0000000000010111B ( 23)'
20210208/131157.272 - U00003535 DB INFO: 'STATIC-SENSITIVITY    = 0000000000000101B (  5)'
20210208/131157.272 - U00003535 DB INFO: 'LOCK-TYPES            = 0000000000000001B (  1)'
20210208/131157.272 - U00003535 DB INFO: 'ODBC_TRACE            = 0'

If this connection does not match the expected database (i.e. master), please check the connection string SQLDRIVERCONNECT and make sure both the user and ID are correct.