Advanced File Layout for Z/OS would register into TDM Repository table gtrep_layout_field_def

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

 

 

Use Case Data Masking z/OS files.

I found the issue is that two field names were 31 characters and I found the columns highlighted below was causing the registration Error. below that I snipped part of the DDL and highlighted the field I think causes the problem, because it is only 30 character. 

My customer team will ask me if renaming the column(s) in the AFL file will affect the export of the masking maps and masking jobs?

I removed the 1 at the end of the original name in the AFL file and changed a letter in each to avoid any naming conflict

Line 608  EMP_OCCUP_DESCRIPTION_CODE_NUM1 ->  EMP_ACCUP_DESCRIPTION_CODE_NUM

Line 623 EMP_STAT_SINCE_DT_AUDIT_DETAIL1 -> EMP_ATAT_SINCE_DT_AUDIT_DETAIL

CREATE TABLE [dbo].[gtrep_layout_field_def](
 [lof_id] [numeric](10, 0) NOT NULL,
 [lof_lod_id] [numeric](10, 0) NOT NULL,
 [lof_lor_id] [numeric](10, 0) NOT NULL,
 [lof_name] [varchar](254) NOT NULL,
 [lof_seq] [numeric](10, 0) NOT NULL,
 [lof_pv_id] [numeric](10, 0) NOT NULL,
 [lof_proj_id] [numeric](10, 0) NOT NULL,
 [lof_level] [numeric](10, 0) NULL,
 [lof_datatype] [varchar](30) NULL,
 [lof_reg_name] [varchar](30) NOT NULL,
 [lof_length] [numeric](10, 0) NULL,

 

Environment

Release : 4.9

Component : CA Agile Requirements Designer - TMX Script Generator

Cause

N/A

Resolution

To fix the problem, you can run this query:

ALTER TABLE [dbo].[gtrep_layout_field_def] ALTER COLUMN [lof_reg_name] [varchar](254);