Error viewing flat file in Px
Posted: Fri Oct 29, 2004 9:39 am
I get the following error when i try to view the sequential file using PX sequential file stage
the metadata for this job comes from a previous server job
Its a fixed width flat file ..
any suggestions
Error executing View Data command:
##E TOIX 000139 10:28:25(007) <Sequential_File_4> Import validation failed:
DataStage XE Parallel Extender V7.0.1
Copyright (C) 2003, 1997 - 2002 Ascential Software, Inc.
All Rights Reserved
##I TOSH 000002 10:28:25(001) <main_program> orchgeneral: loaded
##I TOSH 000002 10:28:25(002) <main_program> orchsort: loaded
##I TOSH 000002 10:28:25(003) <main_program> orchstats: loaded
##I TFSC 000001 10:28:25(004) <main_program> APT configuration file: /proj/dsadm/Ascential/DataStage/Configurations/default.apt
##W TCOS 000049 10:28:25(005) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##E TOIX 000139 10:28:25(007) <Sequential_File_4> Import validation failed:
>##E TFIG 000000 10:28:25(008) <Sequential_File_4> At field "PERSON_NO": When validating import/export function: APT_GFIX_Decimal::validateParameters: Decimal "text" format is variable length and no external length is specified. Possibly you should specify an appropriate "width" property? External format: {text, padchar=32, nofix_zero, precision=20, scale=0, round=trunc_zero, ascii}
>##E TFIG 000119 10:28:25(009) <Sequential_File_4> At field "PERSON_NO": Error validating import/export function
>##E TFIG 000000 10:28:25(010) <Sequential_File_4> At field "PATIENT_NO": When validating import/export function: APT_GFIX_Decimal::validateParameters: Decimal "text" format is variable length and no external length is specified. Possibly you should specify an appropriate "width" property? External format: {text, padchar=32, nofix_zero, precision=2, scale=0, round=trunc_zero, ascii}
>##E TFIG 000119 10:28:25(011) <Sequential_File_4> At field "PATIENT_NO": Error validating import/export function
>##E TOPK 000000 10:28:25(090) <_PEEK_IDENT_> Input dataset does not have field: "PERSON_NO"
>##E TOPK 000000 10:28:25(091) <_PEEK_IDENT_> Input dataset does not have field: "VEHICLE_NO"
the metadata for this job comes from a previous server job
Its a fixed width flat file ..
any suggestions
Error executing View Data command:
##E TOIX 000139 10:28:25(007) <Sequential_File_4> Import validation failed:
DataStage XE Parallel Extender V7.0.1
Copyright (C) 2003, 1997 - 2002 Ascential Software, Inc.
All Rights Reserved
##I TOSH 000002 10:28:25(001) <main_program> orchgeneral: loaded
##I TOSH 000002 10:28:25(002) <main_program> orchsort: loaded
##I TOSH 000002 10:28:25(003) <main_program> orchstats: loaded
##I TFSC 000001 10:28:25(004) <main_program> APT configuration file: /proj/dsadm/Ascential/DataStage/Configurations/default.apt
##W TCOS 000049 10:28:25(005) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##E TOIX 000139 10:28:25(007) <Sequential_File_4> Import validation failed:
>##E TFIG 000000 10:28:25(008) <Sequential_File_4> At field "PERSON_NO": When validating import/export function: APT_GFIX_Decimal::validateParameters: Decimal "text" format is variable length and no external length is specified. Possibly you should specify an appropriate "width" property? External format: {text, padchar=32, nofix_zero, precision=20, scale=0, round=trunc_zero, ascii}
>##E TFIG 000119 10:28:25(009) <Sequential_File_4> At field "PERSON_NO": Error validating import/export function
>##E TFIG 000000 10:28:25(010) <Sequential_File_4> At field "PATIENT_NO": When validating import/export function: APT_GFIX_Decimal::validateParameters: Decimal "text" format is variable length and no external length is specified. Possibly you should specify an appropriate "width" property? External format: {text, padchar=32, nofix_zero, precision=2, scale=0, round=trunc_zero, ascii}
>##E TFIG 000119 10:28:25(011) <Sequential_File_4> At field "PATIENT_NO": Error validating import/export function
>##E TOPK 000000 10:28:25(090) <_PEEK_IDENT_> Input dataset does not have field: "PERSON_NO"
>##E TOPK 000000 10:28:25(091) <_PEEK_IDENT_> Input dataset does not have field: "VEHICLE_NO"