WP does not start: Data source name not found and no default driver specified'

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The WP does start with the error message below in the WP log.

U00029112 UCUDB - Length of the DB-History area: 100
U00029108 UCUDB: SQL_ERROR    Database handles  DB-HENV: 357b7160  DB-HDBC: 357b7240
U00003591 UCUDB - DB error info: OPC: 'SQLDriverConnect' Return code: 'ERROR'
U00003592 UCUDB - Status: 'IM002' Native error: '0' Msg: ' Data source name not found and no default driver specified'

Environment

Release :  21.x

Component : Automic Workload Automation

OS: Windows

Cause

Wrong configuration of ODBC Data Source.

Resolution

Check if ODBC Data Source is properly setup. Use System DSN that all users can use this data source and not just the user who created it.

Additional Information

https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU/21.0/Automic%20Automation%20Guides/Content/Installation_Common/PreparationSteps/PrepareAEDB_MSSQL.htm?Highlight=Preparing%20the%20AE%20Database%20-%20MS%20SQL