Weired error on Transformer

g_rkrish · Post by **g_rkrish** » Thu Jun 21, 2007 4:28 pm

I have a parallel job which is just a data to data transfer....

When i complie that job it says error in compling the transformer..but i matched all the columns..I am not having nay stage variable..i am not creating any surrogate key..The partioning is kept to auto...It looks weired because there no red sign showed on the column match also there none i have done on the properties part is anysetting i need to do ..Pls help me out....

chalasaniamith · Post by **chalasaniamith** » Thu Jun 21, 2007 5:13 pm

Nothing wrong in your job.Just close your designer and recompile it it will work.Same thing i did it worked for me.If same thing repeated just ask your admin to restart your project.

g_rkrish · Post by **g_rkrish** » Thu Jun 21, 2007 5:54 pm

chalasaniamith wrote:Nothing wrong in your job.Just close your designer and recompile it it will work.Same thing i did it worked for me.If same thing repeated just ask your admin to restart your project.

I did what you have said still the same....

sanjay · Post by **sanjay** » Thu Jun 21, 2007 6:39 pm

Hi

check the datatype . i mean you are doing any conversion from string to number or decimal if yes use function for conversion

Thanks
Sanjay

g_rkrish wrote:
chalasaniamith wrote:Nothing wrong in your job.Just close your designer and recompile it it will work.Same thing i did it worked for me.If same thing repeated just ask your admin to restart your project.
I did what you have said still the same....

ray.wurlod · Post by **ray.wurlod** » Thu Jun 21, 2007 7:00 pm

Click the More button to get full output from the compiler. Read it carefully; try to understand the cause. There is usually a lot of useful diagnostic information in the compiler output. If you don't understand what it is telling you, post the message here.

g_rkrish · Post by **g_rkrish** » Fri Jun 22, 2007 11:44 am

ray.wurlod wrote:Click the More button to get full output from the compiler. Read it carefully; try to understand the cause. There is usually a lot of useful diagnostic information in the compiler output. If you do ...

this is what am getting from the more

Output from transformer compilation follows:

##I IIS-DSEE-TFCN-00001 10:41:29(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-TUTL-00031 10:41:29(001) <main_program> The open files limit is 2000; raising to 2147483647.
##I IIS-DSEE-TOSH-00002 10:41:29(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 10:41:29(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 10:41:29(004) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 10:41:29(007) <main_program> Parameter specified but not used in flow: DSPXWorkingDir##E IIS-DSEE-TBLD-00076 10:41:29(009) <main_program> Error when checking composite operator: Subprocess command failed with exit status 32512.
##E IIS-DSEE-TFSR-00019 10:41:29(010) <main_program> Could not check all operators because of previous error(s)
##W IIS-DSEE-TFTM-00012 10:41:29(011) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".##W IIS-DSEE-TFEV-00023 10:41:29(012) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "Int32".
##W IIS-DSEE-TFEV-00023 10:41:29(013) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "UString".
##W IIS-DSEE-TFEV-00025 10:41:29(014) <transform> Error when checking composite operator: Converting decimal to ustring.##W IIS-DSEE-TFEV-00023 10:41:29(015) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "UString".
##W IIS-DSEE-TFEV-00023 10:41:29(016) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "UString".
##W IIS-DSEE-TFEV-00025 10:41:29(017) <transform> Error when checking composite operator: Converting decimal to ustring.
##W IIS-DSEE-TFEV-00023 10:41:29(018) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "UString".
##W IIS-DSEE-TFEV-00023 10:41:29(019) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "UString".
##W IIS-DSEE-TFEV-00025 10:41:29(020) <transform> Error when checking composite operator: Converting decimal to ustring.
##W IIS-DSEE-TFEV-00023 10:41:29(021) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "UString".
##W IIS-DSEE-TFEV-00023 10:41:29(022) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "UString".
##W IIS-DSEE-TFEV-00025 10:41:29(023) <transform> Error when checking composite operator: Converting decimal to ustring.
##W IIS-DSEE-TFEV-00023 10:41:29(024) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "UString".
##W IIS-DSEE-TFEV-00023 10:41:29(025) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "UString".
##W IIS-DSEE-TFEV-00025 10:41:29(026) <transform> Error when checking composite operator: Converting decimal to ustring.
##W IIS-DSEE-TFEV-00023 10:41:29(027) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "UString".
##W IIS-DSEE-TFEV-00023 10:41:29(028) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "UString".
##W IIS-DSEE-TFEV-00025 10:41:29(029) <transform> Error when checking composite operator: Converting decimal to ustring.
##W IIS-DSEE-TFEV-00023 10:41:29(030) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "UString".
##W IIS-DSEE-TFEV-00023 10:41:29(031) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "UString".
##W IIS-DSEE-TFEV-00025 10:41:29(032) <transform> Error when checking composite operator: Converting decimal to ustring.
##W IIS-DSEE-TFEV-00023 10:41:29(033) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "UString".
##W IIS-DSEE-TFEV-00023 10:41:29(034) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "UString".
##W IIS-DSEE-TFEV-00025 10:41:29(035) <transform> Error when checking composite operator: Converting decimal to ustring.
##W IIS-DSEE-TFEV-00023 10:41:29(036) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "UString".
##W IIS-DSEE-TFEV-00023 10:41:29(037) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "UString".
##W IIS-DSEE-TFEV-00025 10:41:29(038) <transform> Error when checking composite operator: Converting decimal to ustring.
##W IIS-DSEE-TFEV-00023 10:41:29(039) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "UString".
##W IIS-DSEE-TFEV-00023 10:41:29(040) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "UString".
##W IIS-DSEE-TFEV-00025 10:41:29(041) <transform> Error when checking composite operator: Converting decimal to ustring.
##W IIS-DSEE-TFEV-00023 10:41:29(042) <transform> Error when checking composite operator: Implicit conversion from source type "Decimal" to result type "UString".
##W IIS-DSEE-TBLD-00000 10:41:29(043) <main_program> Error when checking composite operator: Output from subprocess: sh: /usr/vacpp/bin/xlC_r: not found

##I IIS-DSEE-TBLD-00079 10:41:29(044) <transform> Error when checking composite operator: /usr/vacpp/bin/xlC_r -O -I/etlinstall/IBM/InformationServer/Server/PXEngine/include -O -c /etljobs/dw/RT_BP4.O/V0S7_ARFSPAREParllel_Transformer_7.C -o /etljobs/dw/RT_BP4.O/V0S7_ARFSPAREParllel_Transformer_7.tmp.o.
##E IIS-DSEE-TCOS-00029 10:41:29(045) <main_program> Creation of a step finished with status = FAILED. (ARFSPAREParllel.Transformer_7)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S7_ARFSPAREParllel_Transformer_7 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 DSLink3;
0007: outputname 0 DSLink4;
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: DSLink4
0023: DSLink4.ARSPA_CUSTOMER_NO = DSLink3.ARSPA_CUSTOMER_NO;
0024: DSLink4.ARSPA_SPARE3_X = DSLink3.ARSPA_SPARE3_X;
0025: DSLink4.ARSPA_SPARE3_9 = DSLink3.ARSPA_SPARE3_9;
0026: DSLink4.ARSPA_SPARE4_X = DSLink3.ARSPA_SPARE4_X;
0027: DSLink4.ARSPA_SPARE4_9 = DSLink3.ARSPA_SPARE4_9;
0028: DSLink4.ARSPA_SPARE5_X = DSLink3.ARSPA_SPARE5_X;
0029: DSLink4.ARSPA_SPARE5_9 = DSLink3.ARSPA_SPARE5_9;
0030: DSLink4.ARSPA_SPARE6_X = DSLink3.ARSPA_SPARE6_X;
0031: DSLink4.ARSPA_SPARE6_9 = DSLink3.ARSPA_SPARE6_9;
0032: DSLink4.ARSPA_SPARE7_X = DSLink3.ARSPA_SPARE7_X;
0033: DSLink4.ARSPA_SPARE7_9 = DSLink3.ARSPA_SPARE7_9;
0034: DSLink4.ARSPA_SPARE8_X = DSLink3.ARSPA_SPARE8_X;
0035: DSLink4.ARSPA_SPARE8_9 = DSLink3.ARSPA_SPARE8_9;
0036: DSLink4.ARSPA_SPARE9_X = DSLink3.ARSPA_SPARE9_X;
0037: DSLink4.ARSPA_SPARE9_9 = DSLink3.ARSPA_SPARE9_9;
0038: DSLink4.ARSPA_SPARE10_X = DSLink3.ARSPA_SPARE10_X;
0039: DSLink4.ARSPA_SPARE10_9 = DSLink3.ARSPA_SPARE10_9;
0040: DSLink4.ARSPA_SPARE11_X = DSLink3.ARSPA_SPARE11_X;
0041: DSLink4.ARSPA_SPARE11_9 = DSLink3.ARSPA_SPARE11_9;
0042: DSLink4.ARSPA_SPARE12_X = DSLink3.ARSPA_SPARE12_X;
0043: DSLink4.ARSPA_SPARE12_9 = DSLink3.ARSPA_SPARE12_9;
0044: writerecord 0;
0045: RowRejected0 = 0;
0046: }
0047:
0048: finish {
0049: }
0050:
*** End of Internal Generated Transformer Code

g_rkrish · Post by **g_rkrish** » Fri Jun 22, 2007 11:46 am

the one i marked in red i don't have any dir called that...

the one i marked in blude i have no idea about that....

The one i marked in green i am not doing any decimal to string conversions

Pls help me out.....

DSguru2B · Post by **DSguru2B** » Fri Jun 22, 2007 1:07 pm

Forget about the error in Red. Its not an error.
The one in blue and green means that your source and target datatypes are not identical. If they are not, you need to explicitly do datatype conversions, using either the transformer functions or modify stage.
Do an "search on all terms" on keywords, Implicit conversion from source type "String" to result type "UString" and Implicit conversion from source type "Decimal" to result type "UString".

g_rkrish · Post by **g_rkrish** » Tue Jun 26, 2007 5:32 pm

DSguru2B wrote:Forget about the error in Red. Its not an error.
The one in blue and green means that your source and target datatypes are not identical. If they are not, you need to explicitly do datatype conversions, using either the transformer functions or modify stage.
Do an "search on all terms" on keywords, Implicit conversion from source type "String" to result type "UString" and Implicit conversion from source type "Decimal" to result type "UString".

now i have the complition error like this it's not with the data type it is some thing different which i don't now what is going on.....

Output from transformer compilation follows:

##I IIS-DSEE-TFCN-00001 16:28:00(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-TUTL-00031 16:28:00(001) <main_program> The open files limit is 2000; raising to 2147483647.
##I IIS-DSEE-TOSH-00002 16:28:01(000) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 16:28:01(001) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 16:28:01(002) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 16:28:01(005) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E IIS-DSEE-TBLD-00076 16:28:01(007) <main_program> Error when checking composite operator: Subprocess command failed with exit status 32,512.##E IIS-DSEE-TFSR-00019 16:28:01(008) <main_program> Could not check all operators because of previous error(s)
##W IIS-DSEE-TFTM-00012 16:28:01(009) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".##W IIS-DSEE-TBLD-00000 16:28:01(010) <main_program> Error when checking composite operator: Output from subprocess: sh: /usr/vacpp/bin/xlC_r: not found

##I IIS-DSEE-TBLD-00079 16:28:01(011) <transform> Error when checking composite operator: /usr/vacpp/bin/xlC_r -O -I/etlinstall/IBM/InformationServer/Server/PXEngine/include -O -c /etljobs/dw/RT_BP4.O/V0S18_ARFSPAREParllel_Process.C -o /etljobs/dw/RT_BP4.O/V0S18_ARFSPAREParllel_Process.tmp.o.
##E IIS-DSEE-TCOS-00029 16:28:01(012) <main_program> Creation of a step finished with status = FAILED. (ARFSPAREParllel.Process)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S18_ARFSPAREParllel_Process transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 InARFSPARE;
0007: outputname 0 OutARFSPARE;
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: OutARFSPARE
0023: OutARFSPARE.ARSPA_CUSTOMER_NO = InARFSPARE.ARSPA_CUSTOMER_NO;
0024: OutARFSPARE.ARSPA_SPARE3_X = InARFSPARE.ARSPA_SPARE3_X;
0025: OutARFSPARE.ARSPA_SPARE3_9 = InARFSPARE.ARSPA_SPARE3_9;
0026: OutARFSPARE.ARSPA_SPARE4_X = InARFSPARE.ARSPA_SPARE4_X;
0027: OutARFSPARE.ARSPA_SPARE4_9 = InARFSPARE.ARSPA_SPARE4_9;
0028: OutARFSPARE.ARSPA_SPARE5_X = InARFSPARE.ARSPA_SPARE5_X;
0029: OutARFSPARE.ARSPA_SPARE5_9 = InARFSPARE.ARSPA_SPARE5_9;
0030: OutARFSPARE.ARSPA_SPARE6_X = InARFSPARE.ARSPA_SPARE6_X;
0031: OutARFSPARE.ARSPA_SPARE6_9 = InARFSPARE.ARSPA_SPARE6_9;
0032: OutARFSPARE.ARSPA_SPARE7_X = InARFSPARE.ARSPA_SPARE7_X;
0033: OutARFSPARE.ARSPA_SPARE7_9 = InARFSPARE.ARSPA_SPARE7_9;
0034: OutARFSPARE.ARSPA_SPARE8_X = InARFSPARE.ARSPA_SPARE8_X;
0035: OutARFSPARE.ARSPA_SPARE8_9 = InARFSPARE.ARSPA_SPARE8_9;
0036: OutARFSPARE.ARSPA_SPARE9_X = InARFSPARE.ARSPA_SPARE9_X;
0037: OutARFSPARE.ARSPA_SPARE9_9 = InARFSPARE.ARSPA_SPARE9_9;
0038: OutARFSPARE.ARSPA_SPARE10_X = InARFSPARE.ARSPA_SPARE10_X;
0039: OutARFSPARE.ARSPA_SPARE10_9 = InARFSPARE.ARSPA_SPARE10_9;
0040: OutARFSPARE.ARSPA_SPARE11_X = InARFSPARE.ARSPA_SPARE11_X;
0041: OutARFSPARE.ARSPA_SPARE11_9 = InARFSPARE.ARSPA_SPARE11_9;
0042: OutARFSPARE.ARSPA_SPARE12_X = InARFSPARE.ARSPA_SPARE12_X;
0043: OutARFSPARE.ARSPA_SPARE12_9 = InARFSPARE.ARSPA_SPARE12_9;
0044: writerecord 0;
0045: RowRejected0 = 0;
0046: }
0047:
0048: finish {
0049: }
0050:
*** End of Internal Generated Transformer Code

lstsaur · Post by **lstsaur** » Tue Jun 26, 2007 6:30 pm

Actually your job problem is caused by the C++ compiler.

ray.wurlod · Post by **ray.wurlod** » Tue Jun 26, 2007 6:59 pm

... possibly the licence expiry thereof.