Output File error!

[allavivek]

Hi All,

While writing to sequential file iam getting following error..

CFO,0: Export failed.
CFO,0: Output file full
CFO,0: Fatal Error: No file descriptor was supplied.
node_node0: operator [APT_RealFileExportOperator in CFO], partition 0 of 1, processID 2,441,310 on node0, player 18 terminated unexpectedly....

After searchig previous posts i tried following..
To check the file size , After executing job the output file is not created and getting this error...

ulimit -a is giving me..

file(blocks) unlimited
stcak (kbytes) 4194340
coredump(kbytes) 16384
and all are unlimited...

Any suggestions...

[allavivek]

Output file is only 83MB.

but getting this error...

Any suggestions..

[kandyshandy]

Check the file name in the sequential file stage. You may have passed some parameter without #...# or some typo.

[allavivek]

Check the file name in the sequential file stage. You may have passed some parameter without #...# or some typo.

Filename was correct .

i gave full path

xxx/xxx/xxx.dat

[anbu]

Your file system may be full.

Run this command and check whether you have free space in your file system.

Code: Select all

/bin/df

[kandyshandy]

Then check for the space in the disk. Did you try searching DSxchange database?

[allavivek]

When i checked ulimit from inside job

it gave
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) 2097152
stack(kbytes) 4194304
memory(kbytes) unlimited
coredump(blocks) 16384
nofiles(descriptors) unlimited

Any suggestions..

[anbu]

Your file system may be full.

Run this command and check whether you have free space in your file system.

Code: Select all

/bin/df

[creatingfusion]

ulimit -a is giving me..
It should be a warning and not an error. It is not causing the issue it should be something else.

Verify the file path and the file name and also the delimiter in the file properties probably quotes and others.

Probably try to copy some sequential file stage from any other running datastage job and use it here but remember to change the file path and name over here.

Probably this should resolve the issue.

Thanks
Abhijit

[allavivek]

Your file system may be full.

Run this command and check whether you have free space in your file system.

Code: Select all

/bin/df

Hi anbu

After executing command

in /home it says used 100%

is this my disk is full...

If so how to free the space..

Can i remove all files from Scratch dir..

[vivekgadwal]

How about your mount point being full? Can you rule that out?

[anbu]

Remove all the unnecessary files from /home.

If your Scratch directory comes under filesystem /home then remove those files.