Error message about field not found

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
mstaton
Participant
Posts: 5
Joined: Fri Jul 16, 2010 5:10 am

Error message about field not found

Post by mstaton »

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
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

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?
Top
mstaton
Participant
Posts: 5
Joined: Fri Jul 16, 2010 5:10 am

Post by mstaton »

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
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

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?
Top
mstaton
Participant
Posts: 5
Joined: Fri Jul 16, 2010 5:10 am

Post by mstaton »

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
Top
gowrishankar_h
Participant
Posts: 42
Joined: Wed Dec 26, 2012 1:13 pm

Post by gowrishankar_h »

Hi,

Did you got the solution for the issue?..I getting the same error..
Top
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

:!: Start a new post with the details of your error, please.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Top
priyadharsini
Participant
Posts: 40
Joined: Mon May 11, 2009 12:19 am
Location: Madurai

Post by priyadharsini »

Are you using stage variable?
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”