Page 1 of 1

error reading the fixedwidth seq file

Posted: Wed Nov 14, 2007 1:34 pm
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.

Re: error reading the fixedwidth seq file

Posted: Wed Nov 14, 2007 1:59 pm
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)

Posted: Wed Nov 14, 2007 2:13 pm
by dsdev_123
hi Chulet,

Thankyou for your repy. I have seen it.
indeed there is a file but unable to read.

Posted: Wed Nov 14, 2007 3:59 pm
by dsdev_123
problem has been resolved.its just its not reading the path properly.

Thanks

Posted: Wed Nov 14, 2007 4:10 pm
by ray.wurlod
Why not?

And please mark the thread as Resolved.