U0003590 DB error: 'SQLExecDirect', 'ERROR ', 'HY000', 'Connection is busy with results for anothe

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

U0003590 DB error: 'SQLExecDirect', 'ERROR ', 'HY000', 'Connection is busy with results for anothe

Environment

Release: AOATAM99000-9.0-Automic-One Automation Tools-Application Manager
Component:

Resolution

Detailed Description and Symptoms

When starting a WP or CP for the first time, you may receive the error message:
20101004/120222.918 - U0003590 DB error: 'SQLExecDirect', 'ERROR   ', 'HY000', 'Connection is busy with results for another command'

Investigation

In ucsrv.ini, be sure that the SQLDRIVERCONNECT= setting includes Mars_Connection=Yes

Solution

This message is indicating that you are not using the Mars_Connection=Yes setting.  Be sure that you are using the correct ODBCVAR in the SQLDRIVERCONNECT= setting of your ucsrv.ini file and are using Mars_connection=Yes at the end.  A correct SQLDRIVERCONNECT will look something like:
SQLDRIVERCONNECT = ODBCVAR=NNNNNNRN,DSN=UC4;UID=UC4;PWD=UC4;Mars_Connection=Yes

Problem Persists:
If you have attempted the above and are still seeing the same error, please send the following to Automic Support:
1) The full WP log file where this message is being displayed