CA 7 job AL2DCA70 DDTRS0016E RC -9
Article ID: 199008
Updated On:
Products
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 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
Feedback
