Weired error on Transformer
Moderators: chulett, rschirm, roy
Weired error on Transformer
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....
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....
RK
-
- Participant
- Posts: 36
- Joined: Wed Feb 16, 2005 5:20 pm
- Location: IL
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
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:I did what you have said still the same....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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
this is what am getting from the moreray.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 ...
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
RK
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".
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".
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
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.....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".
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
RK
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: