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'.
Wrong configuration of ODBC Data Source.
Release : 12.3.x, 21.x
Component : Automic Workload Automation
OS: Windows
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.
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