ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

CA 7 job AL2DCA70 DDTRS0016E DDTRS0606E

book

Article ID: 199008

calendar_today

Updated On:

Products

Datacom Datacom/AD CA 7 Workload Automation

Issue/Introduction

CA 7 configuration job AL2DCA70 program DDTRSLM fails with errors:

IMPORT ALL PLAN;

DDTRS0016E DBQPRPS FAILED SQL COMMAND QPRPS, RC: -9.
         SQL ERROR MESSAGE: ILLEGAL COLUMN NAME: JOB#

DDTRS0606E PLAN                             MFWA-CAL2IDJ#_PLANS
         MFWA.CAL2IDJ#_PLANS
         FAILED TO IMPORT SUCCESSFULLY

 

Environment

Release : 15.1

Component : CA Datacom/AD

Resolution

Job AL2DBI03 in CAL2JCL needs to be run before running AL2DCA70, it renames some columns used in AL2DCA70.

The step is documented in section Rename Reserved SQL Columns:

The CA Datacom tables that are used by CA 7 have reserved columns for future use. In Version 12.1, three of those reserved columns have new names. Execute CAL2JCL member AL2DBI03 to rename the columns. Be sure to change the ‘datacomhlq’ value in the STEPLIB DD to your high level qualifier before executing the job.

Return Code: 0

Installation Type: Both new and upgrade environments