DBMaint Fails With Exit Code 1 When Executing archive_jobs

Document ID:  TEC1323288
Last Modified Date:  06/15/2017
{{active ? 'Hide' : 'Show'}} Technical Document Details

Products

  • CA Workload Automation AE

Releases

  • CA Workload Automation AE:Release:11.3.6

Components

  • CA Workload Automation AE (AutoSys):ATSYS
  • AUTOSYS RELEATED EEM:ATSEEM
Question:

When the Scheduler runs DBMaint, the following messages occur:

From The Scheduler Log:

05/22/2017 03:33:27] CAUAJM_E_20220 DB Maintenance returned an exit code of 1.  

[05/22/2017 03:33:27] ______________________________________________________________________________ 

05/22/2017 03:33:27] CAUAJM_I_40265 ****<Date:05/22/201703:33:27>**** 

[05/22/2017 03:33:27] CAUAJM_I_40245 EVENT: ALARM ALARM: DBMAINT_FAILURE TEXT: <Error encountered while running DBMaint script!> 

 

From $AUTOUSER/out/DBMaint out:

CAUAJM_W_10406 Control Execute Access Denied! 

CAUAJM_W_10439 No policies granting access to resource. 

CAUAJM_W_10440 Class: as-control Resource: PR1.ARCHIVE_JOBS User: SYSTEM Access: execute 

 

What is the cause of the message and how can it be prevented?

Answer:

The DBMaint script runs the archive_jobs command. Access to this command is controlled by the ARCHIVE_JOBS WAAE policy in EEM under the as_control resource class.  

The user that runs the Scheduler needs to be granted 'execute' in the ARCHIVE_JOBS policy.  In Windows this is usually SYSTEM. For Unix, it is typically the user that was specified as the application owner during installation.

 

 

Please help us improve!

Will this information enable you to resolve your issue?

Please tell us what we can do better.

{{feedbackText.length ? feedbackText.length : '0'}}/255

{{status}}

Not what you were looking for?

Search Again >

Product Information

Support by Product >

Communities

Join a Community >

Chat with CA

Just give us some brief information and we'll connect you to the right CA ExpertCA sales representative.

Our hours of availability are 8AM - 5PM CST.

All Fields Required

connecting

We're matching your request.

Unfortunately, we can't connect you to an agent. If you are not automatically redirected please click here.

  • {{message.agentProfile.name}} will be helping you today.

    View Profile


  • Transfered to {{message.agentProfile.name}}

    {{message.agentProfile.name}} joined the conversation

    {{message.agentProfile.name}} left the conversation

  • Your chat with {{$storage.chatSession.messages[$index - 1].agentProfile.name}} has ended.
    Thank you for your interest in CA.


    Rate Your Chat Experience.

    {{chat.statusMsg}}

agent is typing