Import validation failed - Checked all previous posts

[vikibemech]

I am getting error as below when trying to view the input data in Seq file. Please advice to resolve the issue.


##I IIS-DSEE-TFCN-00006 13:59:46(001) <main_program> conductor uname: -s=AIX; -r=3; -v=5; -n=p23109dev394; -m=00CF15C44C00
##I IIS-DSEE-TOSH-00002 13:59:46(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 13:59:46(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 13:59:46(004) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 13:59:46(005) <main_program> Parameter specified but not used in flow: _pArrivals
##W IIS-DSEE-TOSH-00049 13:59:46(006) <main_program> Parameter specified but not used in flow: _pDataset
##W IIS-DSEE-TOSH-00049 13:59:46(007) <main_program> Parameter specified but not used in flow: _pDataReject
##W IIS-DSEE-TOSH-00049 13:59:46(008) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##E IIS-DSEE-TOIX-00139 13:59:46(010) <Agreement_File> Import validation failed.
>##E IIS-DSEE-TFDE-00049 13:59:46(011) <Agreement_File> At field "Start_Date": When validating import/export function: APT_GFIX_Decimal::validateParameters: the decimal "text" format is variable length, and no external length is specified;
>you should possibly specify an appropriate "width" property; external format: {text, padchar=32, nofix_zero, precision=8, scale=0, round=trunc_zero, ascii}.
>##E IIS-DSEE-TFIG-00119 13:59:46(012) <Agreement_File> At field "Start_Date": Error validating import/export function
>##E IIS-DSEE-TFDE-00049 13:59:46(013) <Agreement_File> At field "End_Date": When validating import/export function: APT_GFIX_Decimal::validateParameters: the decimal "text" format is variable length, and no external length is specified;
>you should possibly specify an appropriate "width" property; external format: {text, padchar=32, nofix_zero, precision=8, scale=0, round=trunc_zero, ascii}.
>##E IIS-DSEE-TFIG-00119 13:59:46(014) <Agreement_File> At field "End_Date": Error validating import/export function
>##E IIS-DSEE-TOPK-00007 13:59:46(019) <_PEEK_IDENT_> Input dataset does not have field: "Record_Type".
>##E IIS-DSEE-TOPK-00007 13:59:46(020) <_PEEK_IDENT_> Input dataset does not have field: "Change_Indicator".
>##E IIS-DSEE-TOPK-00007 13:59:46(021) <_PEEK_IDENT_> Input dataset does not have field: "Policy_number".
>##E IIS-DSEE-TOPK-00007 13:59:46(022) <_PEEK_IDENT_> Input dataset does not have field: "Start_Date".
>##E IIS-DSEE-TOPK-00007 13:59:46(023) <_PEEK_IDENT_> Input dataset does not have field: "End_Date".
>##E IIS-DSEE-TOPK-00007 13:59:46(024) <_PEEK_IDENT_> Input dataset does not have field: "Status".
>##E IIS-DSEE-TOPK-00007 13:59:46(025) <_PEEK_IDENT_> Input dataset does not have field: "Policy_Type".
>##E IIS-DSEE-TFSR-00019 13:59:46(027) <main_program> Could not check all operators because of previous error(s)
>##E IIS-DSEE-TCOS-00029 13:59:46(028) <main_program> Creation of a step finished with status = FAILED.

[asorrell]

Your column metadata definitions are off. Specifically it is complaining you aren't specifying lengths for varchar feilds.

If you want anything more specific you'll need to post your column definitions and a couple of lines of the data.

[_Mike]

I dont have any Varchar fields in metadata

[chulett]

Tell us what you do have by posting the information Andy asked for.

[vikibemech]

No varchar fields, only char & numerical fields and lengh defined.