Unable to load fixed width format file
Posted: Tue May 29, 2007 3:06 am
Hey Guys,
I 'm trying to extract a .dat file with fixed with format using a sequential file stage. I have set all the relevant properties including the actual size of all the files. eg. 110 bytes. But, whenever I try to do a view data and I get the below mentioned error.
>##E TOIX 000158 17:14:59(000) <SQ_SourceFile,0> Error reading on import.
>##E TOIX 000050 17:14:59(001) <SQ_SourceFile,0> Bad record delimiter after fixed-length record: expected "\n", got "\r"
>##E TOIX 000179 17:14:59(002) <SQ_SourceFile,0> Import error at record 0.
>##E TOIX 000089 17:14:59(003) <SQ_SourceFile,0> The runLocally() of the operator failed.
##I TOIX 000094 17:14:59(004) <SQ_SourceFile,0> Output 0 produced 0 records.
##I TOIX 000094 17:14:59(005) <SQ_SourceFile,0> Output 1 produced 0 records.
I tried to load all the data using Varchar but the moment I specify "decimal" it throws below mentioned msg
">##E TFIG 000000 17:23:49(002) <SQ_SourceFile> At field "CPI_ID": 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=10, scale=0, round=trunc_zero, ascii}.
"
Please guide as to what might be the possible issue.
I 'm trying to extract a .dat file with fixed with format using a sequential file stage. I have set all the relevant properties including the actual size of all the files. eg. 110 bytes. But, whenever I try to do a view data and I get the below mentioned error.
>##E TOIX 000158 17:14:59(000) <SQ_SourceFile,0> Error reading on import.
>##E TOIX 000050 17:14:59(001) <SQ_SourceFile,0> Bad record delimiter after fixed-length record: expected "\n", got "\r"
>##E TOIX 000179 17:14:59(002) <SQ_SourceFile,0> Import error at record 0.
>##E TOIX 000089 17:14:59(003) <SQ_SourceFile,0> The runLocally() of the operator failed.
##I TOIX 000094 17:14:59(004) <SQ_SourceFile,0> Output 0 produced 0 records.
##I TOIX 000094 17:14:59(005) <SQ_SourceFile,0> Output 1 produced 0 records.
I tried to load all the data using Varchar but the moment I specify "decimal" it throws below mentioned msg
">##E TFIG 000000 17:23:49(002) <SQ_SourceFile> At field "CPI_ID": 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=10, scale=0, round=trunc_zero, ascii}.
"
Please guide as to what might be the possible issue.