Uprocs are aborting with message in the job log : Access is denied.

Products

• CA Automic Dollar Universe

Issue/Introduction

Uproc executing some SQL command is aborting with the error messages below in the job log.

-------------------------------------------------
Access is denied.
The syntax of the command is incorrect.
-------------------------------------------------

Environment

Release : 6.x

Component : Dollar Unverse

Cause

Environmental issue

Resolution

Based on the job log below, this could be related to a permission issue on the submission user SQL_Execution_Account. The SQL_Execution_Account is mapped to a domain user SBB01\bta .

-------------------------------------------------
Access is denied.
The syntax of the command is incorrect.
-------------------------------------------------

The above error message could be thrown out by one of the command below.

==================================================================
REM EDIT THE FULL PATH TO DTEXEC BIN IF IT'S NOT IN THE PATH
::set DTSCMDPATH="C:\Program Files\Microsoft SQL Server\100\DTS\Binn"

REM ** CHECK MANDATORY PARAMETERS **
if not defined DTEXECFILE goto :PARAM_MISSING

REM - OPTIONAL PARAMETERS
:: CONFIGFILE
:: EXTRA_OPTS

REM - FINE TUNE PARAMETERS
if defined CONFIGFILE set CONFIGFILE=/ConfigFile %CONFIGFILE%
set EXTRA_OPTS=%EXTRA_OPTS% /MaxConcurrent -1 /CheckPointing off /Reporting V
==================================================================

 

Troubleshooting steps:

-Check if there's any change on the SBB01\bta in terms permission and access policies 

-Execute the same script outside $U with user SBB01\bta 

-Check if there's any error message in the Windows Event Viewer