SMGR cannot start WP | exit code='60'.

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Start of WP is successful via command line, but when starting WP under Service Manager it fails:

In the WP log we can see messages:

20220425/154603.421 - U00029108 UCUDB: SQL_ERROR    Database handles  DB-HENV: 5e4272e0  DB-HDBC: 5e4273c0
20220425/154603.421 - U00003591 UCUDB - DB error info: OPC: 'SQLDriverConnect' Return code: 'ERROR'
20220425/154603.421 - U00003592 UCUDB - Status: 'IM002' Native error: '0' Msg: ' Data source name not found and no default driver specified'
20220425/154603.421 - U00003590 UCUDB - DB error: 'SQLDriverConnect', 'ERROR   ', 'IM002', ' Data source name not found and no default driver specified'
20220425/154603.421 - U00003611 DB OPEN executed. Return Code = '0000003590'
20220425/154603.421 - U00003620 Routine 'UCMAIN_R' forces trace because of error.
20220425/154603.421 - U00003590 UCUDB - DB error: 'SQLDriverConnect', 'ERROR   ', 'IM002', ' Data source name not found and no default driver specified'
20220425/154603.480 - U00003449 Output to the TRACE file is finished.
20220425/154603.480 - U00003100 Memory TRACE was opened with the switches '0000000000000000'.
20220425/154603.480 - U00003380 Server 'AASYSTEM#WP' version '21.0.2+build.31' (Runtime '0/00:00:00', Log# '1', Trc# '0').
20220425/154603.480 - U00003491 There is a time difference of '0/00:00:00' or '0' seconds to the Primary Server.
20220425/154603.480 - U00003375 Server usage of the last minute '0%', the last 10 minutes '0%' and the last hour '0%'.
20220425/154603.480 - U00003590 UCUDB - DB error: 'SQLDriverConnect', 'ERROR   ', 'IM002', ' Data source name not found and no default driver specified'
20220425/154603.480 - U00003410 Server 'AASYSTEM#WP' version '21.0.2+build.31' ended abnormally.

In Service Manager logs we can see messages:

20220425/150953.611 - U00022004 Starting process 'UC4 WP1' ...
20220425/150953.611 - U00022005 ... with command line  'C:\Automic\ServiceManager\bin\..\..\AutomationEngine\bin\UCsrvwp.exe -IC:\Automic\ServiceManager\bin\..\..\AutomationEngine\bin\ucsrv.ini -svc%port%'.
20220425/150953.611 - U00022006 ... and start directory  'C:\Automic\ServiceManager\bin\..\..\AutomationEngine\bin'.
20220425/150953.611 - U00022007 Process 'UC4 WP1' (ID '6352') successfully started.
20220425/150953.648 -          Window: Hnd=000c0030, Title='UC4 WP-Server'
20220425/150953.845 - U00022012 Process 'UC4 WP1/UC4 WP-Server - Termination in progress' (ID '6352') ended.
20220425/150953.845 - U00022022 Process 'UC4 WP1/UC4 WP-Server - Termination in progress' ended, exit code='60'.

Environment

Release : 12.3.x, 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