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
FAILED TO IMPORT SUCCESSFULLY
Release : 15.1
Component : CA Datacom/AD
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