Parameter for GTExcel filename is throwing an error

book

Article ID: 225273

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

Wheil generating fixed width file, I have added parameter for filename as below:

Below is the parameters for the registered file.

PARAMETERS,HEADER=Y,TRAILER=Y,DELIM=FIXED,STYLE=COMPLEX,OUTPUT_FILE_EXT=TXT,[email protected](@nextval(sequence)@,0,10)@@string(~SDATE~,YYYYMMDD)@,LINE_SEPARATOR=<CR><LF>

 

Note: we are able to get the required value with [email protected](@nextval(sequence)@,0,10)@@string(~SDATE~,YYYYMMDD)@ when executed in data painter

 

Below is the File Naming Convention:

<CING><XXXXX>DLY<9999999999><YYYYMMDD> Where: XXXXX - Reseller short description 9999999999 - 10 digit File sequence number, padded to the left with ‘0’s . YYYYMMDD - Date of generation in format yyyymmdd; Example: CINGDSHNWDLY000000000120210727

    This is throwing an error during publish.

 

ERROR:  resolve_meta_data_item: leftpad is missing the terminating @ character in expression: [email protected](@nextval(sequence)@

Environment

Release : 4.9.1

Component : TDM Web Portal

Resolution

 It looks like there is a limitation of 40 characters in meta data column where it stores the file name attribute details. Due to that, its not considerign the complete string here.

    To fix this, create a variable say FILE_NAME with value as [email protected](@nextval(sequence)@,0,10)@@string(~SDATE~,YYYYMMDD)@. Make sure you select "Resolve prior to publish" checkbox and then use this variable in GTEXECL file like below:

    PARAMETERS,HEADER=Y,TRAILER=Y,DELIM=FIXED,STYLE=COMPLEX,OUTPUT_FILE_EXT=TXT,FILEMASK=~FILE_NAME~,LINE_SEPARATOR=<CR><LF>

   With this change, I am able to get the filenames in required format. Please try this and let us know.