DSXchange

I am getting an error about "field was not found" when the "field" stipulated is actually a link name (see error messages below). The actual field names the error messages describe are defined in the input. What causes this to happen and how can this be remedied?

Output from transformer compilation follows:

##I IIS-DSEE-TFCN-00001 11:17:37(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.1.0.5447
Copyright (c) 2001, 2005-2008 IBM Corporation. All rights reserved



##I IIS-DSEE-TFCN-00006 11:17:37(001) <main_program> conductor uname: -s=AIX; -r=1; -v=6; -n=etl-edapp1; -m=00C72CE44C00
##I IIS-DSEE-TOSH-00002 11:17:37(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 11:17:37(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 11:17:37(004) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 11:17:37(007) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E IIS-DSEE-TFPS-00039 11:17:37(009) <transform> Error when checking composite operator: This field was not found: File_Header; [line 23, character 29].
##E IIS-DSEE-TFPS-00039 11:17:37(010) <transform> Error when checking composite operator: This field was not found: File_Header; [line 24, character 35].
##E IIS-DSEE-TFPS-00039 11:17:37(011) <transform> Error when checking composite operator: This field was not found: File_Header; [line 25, character 24].##E IIS-DSEE-TFSR-00019 11:17:37(012) <main_program> Could not check all operators because of previous error(s)
##E IIS-DSEE-TCOS-00029 11:17:37(013) <main_program> Creation of a step finished with status = FAILED. (Get_DISH20_Records_Into_1_File.Transformer_CFH_2_Dummy_DISH20)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S7_Get_DISH20_Records_Into_1_File_Transformer_CFH_2_Dummy_DISH20 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 File_Header;
0007: outputname 0 DSLink23;
0008:
0009: initialize {
0010: // define our row rejected variable
0011: int8 RowRejected0;
0012:
0013: // define our null set variable
0014: int8 NullSetVar0;
0015:
0016: }
0017:
0018: mainloop {
0019: // initialise our row rejected variable
0020: RowRejected0 = 1;
0021:
0022: // evaluate columns (no constraints) for link: DSLink23
0023: DSLink23.DISH20_SEGMENT_ID = File_Header.Standard_Message_Identifier;
0024: DSLink23.DISH20_SEQUENCE_NUMBER = File_Header.Sequence_Number;
0025: DSLink23.DISH20_DATA = File_Header.File_Header_Data;
0026: writerecord 0;
0027: RowRejected0 = 0;
0028: }
0029:
0030: finish {
0031: }
0032:
*** End of Internal Generated Transformer Code

What happens to the compile if you change the link name - does it remain the same? Also, is RCP enable for the link coming into the transform stage?

I tried what you suggested about changeing the input link name but receieved the same errors (see below). RCP is on.

Output from transformer compilation follows:

##I IIS-DSEE-TFCN-00001 13:14:31(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.1.0.5447
Copyright (c) 2001, 2005-2008 IBM Corporation. All rights reserved



##I IIS-DSEE-TFCN-00006 13:14:31(001) <main_program> conductor uname: -s=AIX; -r=1; -v=6; -n=etl-edapp1; -m=00C72CE44C00
##I IIS-DSEE-TOSH-00002 13:14:31(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 13:14:31(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 13:14:31(004) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 13:14:31(007) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E IIS-DSEE-TFPS-00039 13:14:31(009) <transform> Error when checking composite operator: This field was not found: File_Header_Input; [line 23, character 29].
##E IIS-DSEE-TFPS-00039 13:14:31(010) <transform> Error when checking composite operator: This field was not found: File_Header_Input; [line 24, character 35].
##E IIS-DSEE-TFPS-00039 13:14:31(011) <transform> Error when checking composite operator: This field was not found: File_Header_Input; [line 25, character 24].##E IIS-DSEE-TFSR-00019 13:14:31(012) <main_program> Could not check all operators because of previous error(s)
##E IIS-DSEE-TCOS-00029 13:14:31(013) <main_program> Creation of a step finished with status = FAILED. (Get_DISH20_Records_Into_1_File.Transformer_CFH_2_Dummy_DISH20)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S7_Get_DISH20_Records_Into_1_File_Transformer_CFH_2_Dummy_DISH20 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 File_Header_Input;
0007: outputname 0 DSLink23;
0008:
0009: initialize {
0010: // define our row rejected variable
0011: int8 RowRejected0;
0012:
0013: // define our null set variable
0014: int8 NullSetVar0;
0015:
0016: }
0017:
0018: mainloop {
0019: // initialise our row rejected variable
0020: RowRejected0 = 1;
0021:
0022: // evaluate columns (no constraints) for link: DSLink23
0023: DSLink23.DISH20_SEGMENT_ID = File_Header_Input.Standard_Message_Identifier;
0024: DSLink23.DISH20_SEQUENCE_NUMBER = File_Header_Input.Sequence_Number;
0025: DSLink23.DISH20_DATA = File_Header_Input.File_Header_Data;
0026: writerecord 0;
0027: RowRejected0 = 0;
0028: }
0029:
0030: finish {
0031: }
0032:
*** End of Internal Generated Transformer Code

Try disabling RCP in the link leading to the Transform stage and in the Transform stage itself. Are there red derivations in the stage? Does it compile?

Took off RCP on input link, output link, and transformation with no change (see below).

Output from transformer compilation follows:

##I IIS-DSEE-TFCN-00001 13:49:07(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.1.0.5447
Copyright (c) 2001, 2005-2008 IBM Corporation. All rights reserved



##I IIS-DSEE-TFCN-00006 13:49:07(001) <main_program> conductor uname: -s=AIX; -r=1; -v=6; -n=etl-edapp1; -m=00C72CE44C00
##I IIS-DSEE-TOSH-00002 13:49:07(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 13:49:07(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 13:49:07(004) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 13:49:07(007) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E IIS-DSEE-TFPS-00039 13:49:07(009) <transform> Error when checking composite operator: This field was not found: File_Header_Input; [line 23, character 29].
##E IIS-DSEE-TFPS-00039 13:49:07(010) <transform> Error when checking composite operator: This field was not found: File_Header_Input; [line 24, character 35].
##E IIS-DSEE-TFPS-00039 13:49:07(011) <transform> Error when checking composite operator: This field was not found: File_Header_Input; [line 25, character 24].##E IIS-DSEE-TFSR-00019 13:49:07(012) <main_program> Could not check all operators because of previous error(s)
##E IIS-DSEE-TCOS-00029 13:49:07(013) <main_program> Creation of a step finished with status = FAILED. (Get_DISH20_Records_Into_1_File.Transformer_CFH_2_Dummy_DISH20)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S7_Get_DISH20_Records_Into_1_File_Transformer_CFH_2_Dummy_DISH20 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 File_Header_Input;
0007: outputname 0 DSLink23;
0008:
0009: initialize {
0010: // define our row rejected variable
0011: int8 RowRejected0;
0012:
0013: // define our null set variable
0014: int8 NullSetVar0;
0015:
0016: }
0017:
0018: mainloop {
0019: // initialise our row rejected variable
0020: RowRejected0 = 1;
0021:
0022: // evaluate columns (no constraints) for link: DSLink23
0023: DSLink23.DISH20_SEGMENT_ID = File_Header_Input.Standard_Message_Identifier;
0024: DSLink23.DISH20_SEQUENCE_NUMBER = File_Header_Input.Sequence_Number;
0025: DSLink23.DISH20_DATA = File_Header_Input.File_Header_Data;
0026: writerecord 0;
0027: RowRejected0 = 0;
0028: }
0029:
0030: finish {
0031: }
0032:
*** End of Internal Generated Transformer Code

Hi,

Did you got the solution for the issue?..I getting the same error..

Start a new post with the details of your error, please.

Are you using stage variable?