Fatal error

Mhasan · Post by **Mhasan** » Mon Sep 24, 2007 2:44 am

Hi
Can you please give wat could be the reason for these Fatal Error

InsStgCcAccounts,1: write() failed: Bad file number
InsStgCcAccounts,1: Operator signalled one or more errors.
Export Failed

Maveric · Post by **Maveric** » Mon Sep 24, 2007 2:51 am

Not much information to provide a resolution. What stage is giving this error? what are you trying to do in this job?

Mhasan · Post by **Mhasan** » Mon Sep 24, 2007 3:15 am

Hi ,

I have input file from where Iam readign the data thorugh Sequential stage and have a transformation in between and doind transformationl like StringtoTimestamp Target is a Oracle Data base....
when i run the job i get the fatal error sent before.

SequentialfileStage ---> XFM----->OracleDB

Maveric · Post by **Maveric** » Mon Sep 24, 2007 3:30 am

"InsStgCcAccounts" is this your oracle stage? Looks to me like the error is coming from this stage. After the fatal error is there any log entry which states the log file is written to a path along with the file name? If so post the entries from the log file here. What method are you using to load the data in the Oracle stage? If there are any other error messages then post them here.

Mhasan · Post by **Mhasan** » Mon Sep 24, 2007 3:53 am

"InsStgCcAccounts" is this your oracle stage?
--Yes this my oracale stage...
After the fatal error is there any log entry which states the log file is written to a path along with the file name?
---- No such entry shown that was just one liner fatal error
What method are you using to load the data in the Oracle stage?
----Load /Truncate

The Fatal error which i copied earlier was repeated for sevral times.

Maveric · Post by **Maveric** » Mon Sep 24, 2007 4:14 am

Now i have no clue. You will have to wait for the gurus. One last option. Do a search on "write() failed" and "Bad file number". See if those posts help.