Fatal Error - Unable to initialize exporter

PeterBZ · Post by **PeterBZ** » Sun Feb 01, 2009 1:36 pm

I currently have a Lookup stage that outpus rejects to a Sequential File (REJECT_2_FF). Before the data goes into the Lookup stage, I have a modify stage that changes one of my fields from a Char to Integer (So I can properly match the keys in the Lookup stage). However, when I run the job I get an Fatal error with the following message:

REJECT_2_FF: Error when checking operator: Unable to initialize the exporter.

Help would be greatly appreciated. Thanks in advanced!

ray.wurlod · Post by **ray.wurlod** » Sun Feb 01, 2009 2:46 pm

Welcome aboard. In this case "export" is the action performed by the Sequential File stage in writing to a human-readable (text) file. Do you have problems with other Sequential File stages? Can you please outline your job design - in particular does your Lookup stage have one or two output links, and how is its "Lookup Failed" rule set?

PeterBZ · Post by **PeterBZ** » Sun Feb 01, 2009 7:23 pm

I have a an incoming Sequential File (named IN_FILE_FF) that connects to a Modify stage. The modify stage changes one of the fields from a Char to Integer. It then connects to a Lookup Stage (which is also linked to a DB2 stage). The Lookup stage's Lookup Failure is set to "Reject", meaning there are two output links from the Lookup stage. The "Reject" output link is linked to a Sequential File stage (named REJECT_2_FF), which has the Fatal Error.

Code: Select all

[IN_FILE_FF]     [DB2]
    |              |  
    |              |
   \|/            \|/
[MODIFY]------>[LOOKUP]-------->[REJECT_2_FF]
                   |
                   |
                   |
                  \|/
              [CONTINUES AND IS IRRELEVANT]

ray.wurlod · Post by **ray.wurlod** » Mon Feb 02, 2009 12:37 am

Can you please check the Score of the job (set APT_DUMP_SCORE to True and inspect it in the log) to determine the characteristics of the export operator associated with REJECT_2_FF ?

Can you also verify that the pathname, filename and other properties of this Sequential File stage are correct?

mk_ds09 · Post by **mk_ds09** » Mon Feb 02, 2009 2:45 am

REJECT_2_FF: Error when checking operator: Unable to initialize the exporter.

What are the data type you are using in the lookup stage for the given column..
from the error, it seems that there is issue while writing to the reject file..

Use debug to check what values are coming to modify and then what values are going to the lookup stage..

----------------

Hope this helps..

------------

MK