Error viewing flat file in Px

[ashcar]

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"

[srikanthd1978]

.. this is not new in PX.. i believe that the data spitting out of ur Server Job may not be fixed length or if it is.. then u not plugging in the Meta data correctly in Ur seq file ...u need to play with all the options in the seq file to view the data..try using an implicit file type...also if it is fixed length..then u have to make sure that the sum of the data size in bytes in ur Job is equal to the file size..

..hope this helps...

[richdhan]

Hi,

Fix the first error

Parameter specified but not used in flow: DSProjectMapName

Still if the problem persists then let us know.

HTH
--Rich

Pride comes before a fall
Humility comes before honour

[ashcar]

This is a new PX installation ..what does that parameter "DSProjectMapName" mean
i have no such parameter in stage properties ..if that has to do something with my DSENV or any settings please help

Hi,

Fix the first error

Parameter specified but not used in flow: DSProjectMapName

Still if the problem persists then let us know.

HTH
--Rich

Pride comes before a fall
Humility comes before honour

[dsxdev]

Hi

Once you fix DSProjectMapName check these. This is a warning first ensure the below still problem persists then think of DSProjectMapName.

I hope there is some problem in the column PERSON_NO which is decimal type but length is not specified.
You specified precision but not scale. Scale is defaulted to zero check this.

Code: Select all

>##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} 

If the file format is fixed length you need to be careful as rightly said above you need to specify exact lengths of each column as in the ouput sequantial file stage in previous job.

Better option would be save the table definition in first job and use it in the second job this would eliminate any metadata issues.

[Eric]

Hi,

Fix the first error

Parameter specified but not used in flow: DSProjectMapName

Still if the problem persists then let us know.

HTH
--Rich

Pride comes before a fall
Humility comes before honour

messages with ##W are a warning
the errors start with ##E

[dkopniske]

Hey all,

Any input on specifically how to handle this DSProjectMapName error? I am trying to do a basic Oracle object writing out to a Peek to test my database connection and this is the only warning I am getting before it fails... Appreciate any input!


##I TFCN 000001 09:49:19(000) <main_program>
DataStage XE Parallel Extender V7.0.1
Copyright (C) 2003, 1997 - 2002 Ascential Software, Inc.
All Rights Reserved

##I TUTL 000031 09:49:19(001) <main_program> The open files limit is 100; raising to 1024.
##I TOSH 000002 09:49:19(002) <main_program> orchgeneral: loaded
##I TOSH 000002 09:49:19(003) <main_program> orchsort: loaded
##I TOSH 000002 09:49:19(004) <main_program> orchstats: loaded
##I TFSC 000001 09:49:19(005) <main_program> APT configuration file: /app/dsadm/Ascential/DataStage/Configurations/default.apt
##W TCOS 000049 09:49:20(000) <main_program> Parameter specified but not used in flow: DSProjectMapName
Segmentation Fault - core dumped

This is a new PX installation ..what does that parameter "DSProjectMapName" mean
i have no such parameter in stage properties ..if that has to do something with my DSENV or any settings please help