Facing the Transformation compilation error

[BMSK]

Hi all,

When i compiled the job i am gettine this error


Output from transformer compilation follows:

##I IIS-DSEE-TFCN-00001 18:15:34(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.0.1.4458
Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved



##I IIS-DSEE-TOSH-00002 18:15:34(001) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 18:15:34(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 18:15:34(003) <main_program> orchstats: loaded
##W IIS-DSEE-TCOS-00036 18:15:35(000) <main_program> Failed to initialize job monitoring. Monitor information will not be generated.
##W IIS-DSEE-TOSH-00049 18:15:35(001) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##W IIS-DSEE-TFTM-00012 18:15:35(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-TFTK-00001 18:15:35(003) <transform> Error when checking composite operator: Unexpected tokens: ; [line 11,character 8].
##E IIS-DSEE-TFPS-00012 18:15:35(004) <transform> Error when checking composite operator: Invalid local variable declaration: ; [line 11, character 8].
##E IIS-DSEE-TFTK-00001 18:15:35(005) <transform> Error when checking composite operator: Unexpected tokens: ; [line 39,character 23].
##E IIS-DSEE-TFPS-00038 18:15:35(006) <transform> Error when checking composite operator: Expected right paren; [line 39, character 23].
##E IIS-DSEE-TFPS-00038 18:15:35(007) <transform> Error when checking composite operator: Expected right paren; [line 39, character 24].
##E IIS-DSEE-TFPS-00038 18:15:35(008) <transform> Error when checking composite operator: Expected semi-colon; [line 39, character 45].
##E IIS-DSEE-TFTK-00001 18:15:35(009) <transform> Error when checking composite operator: Unexpected tokens: ; [line 39,character 49].
##E IIS-DSEE-TFPS-00038 18:15:35(010) <transform> Error when checking composite operator: Expected semi-colon; [line 39, character 49].
##E IIS-DSEE-TFPS-00038 18:15:35(011) <transform> Error when checking composite operator: Expected semi-colon; [line 39, character 57].
##E IIS-DSEE-TFTK-00001 18:15:35(012) <transform> Error when checking composite operator: Unexpected tokens: ; [line 42,character 14].
##E IIS-DSEE-TFPS-00027 18:15:35(013) <transform> Error when checking composite operator: Expected an operand; [line 42, character 12].
##E IIS-DSEE-TFPS-00038 18:15:35(014) <transform> Error when checking composite operator: Expected semi-colon; [line 42, character 14].
##E IIS-DSEE-TFSR-00019 18:15:35(015) <main_program> Could not check all operators because of previous error(s)
##E IIS-DSEE-TCOS-00029 18:15:35(016) <main_program> Creation of a step finished with status = FAILED. (CopyOfCopyOfp_SuspectDetMatch_Identifier.Transformer_71)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S71_CopyOfCopyOfp_SuspectDetMatch_Identifier_Transformer_71 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 InpExtrData;
0007: outputname 0 DSLink73;
0008:
0009: global {
0010: // Job parameter declaration
0011: ustring $Enttest;
0012: }
0013:
0014: initialize {
0015: // define our row rejected variable
0016: int8 RowRejected0;
0017:
0018: // define our null set variable
0019: int8 NullSetVar0;
0020:
0021: // declare our intermediate variables for this section
0022: ustring InterVar0_0;
0023:
0024: // initialise constant values which require conversion
0025: InterVar0_0 = "= B.";
0026: // Stage variable declaration and initialisation
0027: string StageVar0_StageVar;
0028: StageVar0_StageVar = "";
0029: }
0030:
0031: mainloop {
0032: // initialise our row rejected variable
0033: RowRejected0 = 1;
0034:
0035: // declare our intermediate variables for this section
0036: string InterVar0_1;
0037:
0038: // evaluate the stage variables first
0039: StageVar0_StageVar = (($Enttest + InterVar0_0) + $Enttest);
0040:
0041: // evaluate columns (no constraints) for link: DSLink73
0042: InterVar0_1 = $Enttest;
0043: DSLink73.SQLQUERY = (InpExtrData.SQLQUERY + InterVar0_1);
0044: writerecord 0;
0045: RowRejected0 = 0;
0046: }
0047:
0048: finish {
0049: }
0050:
*** End of Internal Generated Transformer Code

thanks
bmsk

[chulett]

Basic stuff first - is this the first time you're compiling a job with a transformer or you normally can but have a problem with this one in particular?

[Sainath.Srinivasan]

Why are you assigning "=B." to be the value of a stage variable and follow it with an add operation ? You cannot add characters.

If you need to concatenate them, you must use a colon (':') operator. If you need any mathematical derivation, you use stage variable as the names.

Maybe providing more details on what you are trying to accomplish may assist others to guide you.

[crystal_pup]

We had faced the same issue...however in our case the problem was that we were using lot of stage variables in a single transformer.We removed some of the stage variables and put them into another transformer and then the job compiled successfully...I hope this helps.

Cheers
KD

[nikhilanshuman]

The error lies with this line :
0011: ustring $Enttest


Are you using any Env variable "$Enttest" in a transformer? This is the cause of the error.

Solution : use GetEnvironment ('$Enttest') in your transformer stage

The error lines from your post :

##E IIS-DSEE-TFTK-00001 18:15:35(003) <transform> Error when checking composite operator: Unexpected tokens: ; [line 11,character 8].
##E IIS-DSEE-TFPS-00012 18:15:35(004) <transform> Error when checking composite operator: Invalid local variable declaration: ; [line 11, character 8].
[/b]

[BMSK]

Hi,

Thank you all,,

when I use the function Getenvironment('$Enttest')

My probelm was solved

thanks nikhilanshuman


BMSK.

[nikhilanshuman]

Hi,

Thank you all,,

when I use the function Getenvironment('$Enttest')

My probelm was solved

thanks nikhilanshuman


BMSK.

Welcome!!