Page 1 of 2
No File Descriptor --ERROR
Posted: Tue Jan 23, 2007 3:12 pm
by just4geeks
I am trying to extract ODBC tables into a seq file. I get the following error when I try to do that.
Code: Select all
##I TFCN 000001 15:06:14(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.2
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TOSH 000002 15:06:14(001) <main_program> orchgeneral: loaded
##I TOSH 000002 15:06:14(002) <main_program> orchsort: loaded
##I TOSH 000002 15:06:14(003) <main_program> orchstats: loaded
##I TFSC 000001 15:06:14(004) <main_program> APT configuration file: /opt/datastage/Ascential/DataStage/Configurations/default.apt
##I TFSC 000000 15:06:14(005) <main_program>
This step has no datasets.
It has 1 operator:
op0[1p] {(sequential APT_CombinedOperatorController:
(APT_LicenseCountOp in APT_LicenseOperator)
(APT_LicenseCheckOp in APT_LicenseOperator)
) on nodes (
node1[op0,p0]
)}
It runs 1 process on 1 node.
##W TCOS 000049 15:06:14(006) <main_program> Parameter specified but not used in flow: DSProjectMapName
##I TFSC 000000 15:06:14(011) <main_program>
This step has no datasets.
It has 1 operator:
op0[1p] {(sequential APT_CombinedOperatorController:
(Sequential_File_1)
(_Head)
(_PEEK_IDENT_)
(_ABORT_IDENT_)
) on nodes (
node1[op0,p0]
)}
It runs 1 process on 1 node.
##I TOIX 000163 15:06:14(000) <Sequential_File_1,0> Import complete; 0 records imported successfully, 0 rejected.
**VIEWDATA ROW LIMITER HIT**
It also says that "APT_CombinedOperatorController,0: Fatal Error: No file descriptor was supplied."
Can anyone tell me what is going wrong. Thanks for your time.
Posted: Tue Jan 23, 2007 3:32 pm
by ray.wurlod
Can you please post the job design and generated OSH? Somewhere there is a file unit not being allocated. This may be because of a missing property, or that you have hit a limit on your system.
Posted: Tue Jan 23, 2007 3:52 pm
by just4geeks
ray.wurlod wrote:Can you please post the job design and generated OSH? Somewhere there is a file unit not being allocated. This may be because of a missing property, or that you have hit a limit on your system.
The Job design is like this.
ODBC Enterprise Stage--->Seq File Stage
How do I obtain the OSH?
Posted: Tue Jan 23, 2007 3:54 pm
by pavankvk
just4geeks wrote:ray.wurlod wrote:Can you please post the job design and generated OSH? Somewhere there is a file unit not being allocated. This may be because of a missing property, or that you have hit a limit on your system.
The Job design is like this.
ODBC Enterprise Stage--->Seq File Stage
How do I obtain the OSH?
Look in properties in the generated osh tab
Posted: Tue Jan 23, 2007 3:54 pm
by ray.wurlod
Job properties window has a "Generated OSH" tab. It should be there. If not, you need to enable Generated OSH in Administrator (project properties, Parallel tab).
Posted: Tue Jan 23, 2007 3:56 pm
by pavankvk
just4geeks wrote:ray.wurlod wrote:Can you please post the job design and generated OSH? Somewhere there is a file unit not being allocated. This may be because of a missing property, or that you have hit a limit on your system.
The Job design is like this.
ODBC Enterprise Stage--->Seq File Stage
How do I obtain the OSH?
Why is it trying to import from the sequential file when you are writing to it?
Posted: Tue Jan 23, 2007 3:58 pm
by DSguru2B
pavankvk wrote:Why is it trying to import from the sequential file when you are writing to it?
Thats only for view data.
Posted: Tue Jan 23, 2007 4:00 pm
by just4geeks
ray.wurlod wrote:Job properties window has a "Generated OSH" tab. It should be there. If not, you need to enable Generated OSH in Administrator (project properties, Parallel tab).
I cannot enable generate OSH because I dont have write access to the installed directory. Is it very important to generate OSH, else I can request my DSAdmin to do it.
Posted: Tue Jan 23, 2007 4:01 pm
by pavankvk
DSguru2B wrote:pavankvk wrote:Why is it trying to import from the sequential file when you are writing to it?
Thats only for view data. ...
Will it give job score when its a view data..i never observed closely.
Posted: Tue Jan 23, 2007 4:01 pm
by DSguru2B
It generates it regardless. That option is just to get the OSH script for your viewing.
Posted: Tue Jan 23, 2007 4:07 pm
by just4geeks
How do I resolve the error "APT_CombinedOperatorController,0: Fatal Error: No file descriptor was supplied" ?
Posted: Tue Jan 23, 2007 4:10 pm
by pavankvk
just4geeks wrote:How do I resolve the error "APT_CombinedOperatorController,0: Fatal Error: No file descriptor was supplied" ?
i got this error many times, but dont remember the scenario. can u explain if this is a run time failure or view data failure
Posted: Tue Jan 23, 2007 4:11 pm
by just4geeks
pavankvk wrote:just4geeks wrote:How do I resolve the error "APT_CombinedOperatorController,0: Fatal Error: No file descriptor was supplied" ?
i got this error many times, but dont remember the scenario. can u explain if this is a run time failure or view data failure
Its a runtime failure
Posted: Tue Jan 23, 2007 4:14 pm
by pavankvk
just4geeks wrote:pavankvk wrote:just4geeks wrote:How do I resolve the error "APT_CombinedOperatorController,0: Fatal Error: No file descriptor was supplied" ?
i got this error many times, but dont remember the scenario. can u explain if this is a run time failure or view data failure
Its a runtime failure
is it the error log, what u posted in your first post of the thread??
Posted: Tue Jan 23, 2007 4:17 pm
by pavankvk
just4geeks wrote:pavankvk wrote:just4geeks wrote:How do I resolve the error "APT_CombinedOperatorController,0: Fatal Error: No file descriptor was supplied" ?
i got this error many times, but dont remember the scenario. can u explain if this is a run time failure or view data failure
Its a runtime failure
please post the complete log.