error reading the fixedwidth seq file

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
dsdev_123
Participant
Posts: 25
Joined: Tue Oct 09, 2007 9:13 pm

error reading the fixedwidth seq file

Post by dsdev_123 »

hi

i have a problem reading the fixed width seq file produced. The seq fixed width file was produced in the previous job and i can view the data but when i was trying to read the data from that file in other job Its showing the following error.

##I TFCN 000001 14:30:49(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.1A
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved


##I TUTL 000031 14:30:49(001) <main_program> The open files limit is 5000; raising to 2147483647.
##I TOSH 000002 14:30:49(002) <main_program> orchgeneral: loaded
##I TOSH 000002 14:30:49(003) <main_program> orchsort: loaded
##I TOSH 000002 14:30:50(000) <main_program> orchstats: loaded
##I TFSC 000001 14:30:50(001) <main_program> APT configuration file: /bi/bustools/diws/iwd/751/Ascential/DataStage/Configurations/default.apt
##W TCOS 000049 14:30:50(002) <main_program> Parameter specified but not used in flow: _LP6_ROOTPATH_OUTPUT
##W TCOS 000049 14:30:50(003) <main_program> Parameter specified but not used in flow: _AZUR_ROOTPATH_WORKING
##W TCOS 000049 14:30:50(004) <main_program> Parameter specified but not used in flow: param_Date
##W TCOS 000049 14:30:50(005) <main_program> Parameter specified but not used in flow: DSProjectMapName
>##E TOIX 000049 14:30:51(000) <CommonFormat_File_PLS_PhysicalStocks,0> Unable to open /bi/busdata/dwbi/mna1/_lgi/dsdata/EUR/MNA/1/data/output/PhysicalStocks/PHYSICALSTOCKS.YYYYMMDD
>
>.dat: No such file or directory.
>##E TOIX 000000 14:30:51(001) <CommonFormat_File_PLS_PhysicalStocks,0> the runLocally() of combination of 4 operators [CommonFormat_File_PLS_PhysicalStocks; _Head; _PEEK_IDENT_; _ABORT_IDENT_], partition 0 of 1, processID 2,654,400 on node0 failed.
##I TOIX 000094 14:30:51(002) <CommonFormat_File_PLS_PhysicalStocks,0> Output 0 produced 0 records.
>##E TFOP 000000 14:30:51(003) <APT_CombinedOperatorController,0> the runLocally() of combination of 4 operators [CommonFormat_File_PLS_PhysicalStocks; _Head; _PEEK_IDENT_; _ABORT_IDENT_], partition 0 of 1, processID 2,654,400 on node0 failed.
>##E TFPM 000040 14:30:51(004) <APT_CombinedOperatorController,0> Operator terminated abnormally: runLocally did not return APT_StatusOk
>##E TFSR 000011 14:30:57(000) <main_program> Step execution finished with status = FAILED.
##I TCOS 000026 14:30:57(001) <main_program> Startup time, 0:06; production run time, 0:01.

Please can any one throw some light.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Re: error reading the fixedwidth seq file

Post by chulett »

dsdev_123 wrote:>##E TOIX 000049 14:30:51(000) <CommonFormat_File_PLS_PhysicalStocks,0> Unable to open /bi/busdata/dwbi/mna1/_lgi/dsdata/EUR/MNA/1/data/output/PhysicalStocks/PHYSICALSTOCKS.YYYYMMDD.dat: No such file or directory.
:idea: <- (light)
-craig

"You can never have too many knives" -- Logan Nine Fingers
dsdev_123
Participant
Posts: 25
Joined: Tue Oct 09, 2007 9:13 pm

Post by dsdev_123 »

hi Chulet,

Thankyou for your repy. I have seen it.
indeed there is a file but unable to read.
dsdev_123
Participant
Posts: 25
Joined: Tue Oct 09, 2007 9:13 pm

Post by dsdev_123 »

problem has been resolved.its just its not reading the path properly.

Thanks
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Why not?

And please mark the thread as Resolved.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply