Page 1 of 1

compilation error

Posted: Fri Nov 12, 2010 1:08 am
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;

Posted: Fri Nov 12, 2010 1:30 am
by adityavarma
I think the input table doesnot have field READ_D_Equipment,

Please check the metadata in the table.

Posted: Fri Nov 12, 2010 1:32 am
by tanaya.deshpande@tieto.co
READ_D_Equipment is not a field its a stage name

Posted: Fri Nov 12, 2010 1:53 am
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...