compilation error

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
tanaya.deshpande@tieto.co
Participant
Posts: 94
Joined: Sun Jul 18, 2010 11:35 pm

compilation error

Post by tanaya.deshpande@tieto.co »

I am getting following compilation error I dont understand why ?
can anyone please explain

Output from transformer compilation follows:

##I IIS-DSEE-TFCN-00001 09:05:13(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 09:05:13(001) <main_program> conductor uname: -s=Windows_NT; -r=2; -v=5; -n=FIHEL-S-TE00047; -m=Pentium
##I IIS-DSEE-TOSH-00002 09:05:13(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 09:05:13(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 09:05:13(004) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 09:05:14(000) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##W IIS-DSEE-TFTM-00012 09:05:14(002) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
##E IIS-DSEE-TFPS-00039 09:05:14(003) <transform> Error when checking composite operator: This field was not found: READ_D_Equipment; [line 170, character 10].
##E IIS-DSEE-TFPS-00039 09:05:14(004) <transform> Error when checking composite operator: This field was not found: READ_D_Equipment; [line 181, character 9].
##E IIS-DSEE-TFSR-00019 09:05:14(005) <main_program> Could not check all operators because of previous error(s)
##E IIS-DSEE-TCOS-00029 09:05:14(006) <main_program> Creation of a step finished with status = FAILED. (D_Equipment_1.Slowly_Changing_Dimension_188)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S188_D_Equipment_1_Slowly_Changing_Dimension_188 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 V2;
0007: tablename 0 READ_D_Equipment;
0008: outputname 0 D_Equipment;
0009: outputname 1 Fact_Load;
0010:
0011: global {
0012: // Job parameter declaration
0013: ustring TRANSFORMER_ProjectParams_ProjectPath;
0014: }
0015:
0016: initialize {
0017: // define our row rejected variable
0018: int8 RowRejected0;
0019:
0020: // define our null set variable
0021: int8 NullSetVar0;
0022:
0023: // define our force_error call variables
0024: ustring FErrorMsg0;
0025: ustring FErrorLink0;
0026:
0027: // define our SCD surrogate key variables
0028: ustring SurrKey_id0;
0029: int32 SurrKey_rc0;
0030: int32 SeedValue0;
0031: uint64 surrKey0;
0032:
0033: // declare our intermediate variables for this section
0034: int32 InterVar0_0;
0035:
0036: // initialise constant values which require conversion
0037: InterVar0_0 = get_partition_num();
0038: // Stage variable declaration and initialisation
0039: int32 StageVar0_SCDTYPE1TEST_PlantCode;
0040: StageVar0_SCDTYPE1TEST_PlantCode = 0;
0041: int32 StageVar0_SCDTYPE1TEST_EquipmentCode;
0042: StageVar0_SCDTYPE1TEST_EquipmentCode = 0;
0043: int32 StageVar0_SCDTYPE1TEST_EquipmentMainGroup;
0044: StageVar0_SCDTYPE1TEST_EquipmentMainGroup = 0;
adityavarma
Premium Member
Premium Member
Posts: 104
Joined: Thu Jul 12, 2007 11:32 pm
Location: Canada

Post by adityavarma »

I think the input table doesnot have field READ_D_Equipment,

Please check the metadata in the table.
tanaya.deshpande@tieto.co
Participant
Posts: 94
Joined: Sun Jul 18, 2010 11:35 pm

Post by tanaya.deshpande@tieto.co »

READ_D_Equipment is not a field its a stage name
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

One (or more) of the input fields is not found.

This could be in a stage variable derivation, a constraint expression or an output column derivation. You did not post enough of the Transformer code for this to be diagnosed any more accurately than that.

Therefore I can only suggest you check your work thoroughly or, and perhaps better, have someone else check it. A new pair of eyes and all that...
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply