互联网服务商业智能
DataStage Job无法编译，报Transformer
具体错误如下：Output from transformer compilation follows:##I IIS-DSEE-TFCN-00001 14:16:39(000) IBM InfoSphere DataStage Enterprise Edition 8.7.0.6614 Copyright (c) 2001, 2005-2011 IBM Corporation. All rights reserved##I IIS-DSEE-TFCN-00006 14:16:39(0...显示全部
具体错误如下：Output from transformer compilation follows:
##I IIS-DSEE-TFCN-00001 14:16:39(000)
IBM InfoSphere DataStage Enterprise Edition 8.7.0.6614
Copyright (c) 2001, 2005-2011 IBM Corporation. All rights reserved
##I IIS-DSEE-TFCN-00006 14:16:39(001) conductor uname: -s=AIX; -r=1; -v=7; -n=yyrcbdwserver1; -m=00F848F34C00
##I IIS-DSEE-TOSH-00002 14:16:39(002) orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 14:16:39(003) orchsort: loaded
##I IIS-DSEE-TOSH-00002 14:16:39(004) orchstats: loaded
##W IIS-DSEE-TOSH-00049 14:16:39(007) Parameter specified but not used in flow: DSPXWorkingDir
##E IIS-DSEE-TBLD-00076 14:16:40(000) Error when checking composite operator: Subprocess command failed with exit status 256.
##E IIS-DSEE-TFSR-00019 14:16:40(001) Could not check all operators because of previous error(s)
##W IIS-DSEE-TFTM-00012 14:16:40(002) Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
##W IIS-DSEE-TFPS-00048 14:16:40(003) Error when checking composite operator: Function decimal_from_ustring, [line 98, character 19], returns a decimal; default precision is used.
##W IIS-DSEE-TFEV-00023 14:16:40(004) Error when checking composite operator: Implicit conversion from source type "String" to result type "UString".
##W IIS-DSEE-TFEV-00023 14:16:40(005) Error when checking composite operator: Implicit conversion from source type "String" to result type "UString".
##W IIS-DSEE-TFEV-00025 14:16:40(006) Error when checking composite operator: Converting ustring to string using codepage ISO-8859-1.
##W IIS-DSEE-TFEV-00023 14:16:40(007) Error when checking composite operator: Implicit conversion from source type "UString" to result type "String".
##W IIS-DSEE-TFEV-00025 14:16:40(008) Error when checking composite operator: Converting string to decimal.
##W IIS-DSEE-TFEV-00023 14:16:40(009) Error when checking composite operator: Implicit conversion from source type "String" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 14:16:40(010) Error when checking composite operator: Converting string to decimal.
##W IIS-DSEE-TFEV-00023 14:16:40(011) Error when checking composite operator: Implicit conversion from source type "String" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 14:16:40(012) Error when checking composite operator: Converting string to decimal.
##W IIS-DSEE-TFEV-00023 14:16:40(013) Error when checking composite operator: Implicit conversion from source type "String" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 14:16:40(014) Error when checking composite operator: Converting string to decimal.
##W IIS-DSEE-TFEV-00023 14:16:40(015) Error when checking composite operator: Implicit conversion from source type "String" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 14:16:40(016) Error when checking composite operator: Converting string to decimal.
##W IIS-DSEE-TFEV-00023 14:16:40(017) Error when checking composite operator: Implicit conversion from source type "String" to result type "Decimal".
##W IIS-DSEE-TFEV-00025 14:16:40(018) Error when checking composite operator: Converting string to decimal.
##W IIS-DSEE-TFEV-00023 14:16:40(019) Error when checking composite operator: Implicit conversion from source type "String" to result type "Decimal".
##W IIS-DSEE-TBLD-00000 14:16:40(020) Error when checking composite operator: Output from subprocess: The license for the Evaluation version of IBM XL C/C++ for AIX V12.1 compiler product has expired. Please send an email to [email]compiler@ca.ibm.com[/email] for more information. The evaluation license can be extended to 74 days in total by either a) setting an environment variable XLC_EXTEND_EVAL=yes; or, b) specifying a compiler command line option -qxflag=extend_eval. The extended evaluation license will expire on Sun Jun 16 13:52:52 2013. Use of the Program continues to be subject to the terms and conditions of the
##W IIS-DSEE-TBLD-00000 14:16:40(021) Error when checking composite operator: Output from subprocess: International License Agreement for Evaluation of Programs, including the accompanying License Information document (the "Agreement"). A copy of the Agreement can be found in the "LicAgree.pdf" and "LicInfo.pdf" files residing in the root directory of the installation media. If you do not agree to the terms and conditions of the Agreement, you may not use or access the Program. The evaluation version can be easily upgraded to the full, licensed version after purchase. Please refer to section "Before in
##W IIS-DSEE-TBLD-00000 14:16:40(022) Error when checking composite operator: Output from subprocess: stalling IBM XL C/C++ for AIX V12.1" in the Installation Guide.
##I IIS-DSEE-TBLD-00079 14:16:40(023) Error when checking composite operator: /usr/vacpp/bin/xlC_r -O -I/opt/IBM/DS8.7/InformationServer/Server/PXEngine/include -O -q64 -c /opt/IBM/DS8.7/InformationServer/Server/Projects/yyrcbdw/RT_BP2987.O/V0S2_ods_core_brfmpowt_phy20100618_Transformer.C -o /opt/IBM/DS8.7/InformationServer/Server/Projects/yyrcbdw/RT_BP2987.O/V0S2_ods_core_brfmpowt_phy20100618_Transformer.tmp.o.
##E IIS-DSEE-TCOS-00029 14:16:40(024) Creation of a step finished with status = FAILED. (ods_core_brfmpowt_phy20100618.Transformer)
*** 内部生成的 Transformer 代码如下：
0001: //
0002: // Generated file to implement the V0S2_ods_core_brfmpowt_phy20100618_Transformer transform operator.
0003: //
0004:
0005: // define external functions used
0006: extern string TransDate(string s);
0007:
0008: // define our input/output link names
0009: inputname 0 DSLink1;
0010: outputname 0 DSLink2;
0011:
0012: global {
0013:
// Job parameter declaration
0014:
ustring workdate;
0015: }
0016:
0017: initialize {
0018:
// define our control variables
0019:
int8 RowRejected0;
0020:
int8 NullSetVar0;
0021:
0022:
// declare our intermediate variables for this section
0023:
ustring InterVar0_1;
0024:
string InterVar0_2;
0025:
string InterVar0_3;
0026:
string InterVar0_4;
0027:
ustring InterVar0_5;
0028:
0029:
// initialise constant values which require conversion
0030:
InterVar0_1 = "1989-01-01";
0031:
InterVar0_2 = "%yyyy-%mm-%dd";
0032:
InterVar0_3 = " ";
0033:
InterVar0_4 = " ";
0034:
InterVar0_5 = "0000000000000.00";
0035: }
0036:
0037: mainloop {
0038:
0039:
// declare our intermediate variables for this section
0040:
string InterVar0_0;
0041:
0042:
// initialise the rejected row variable
0043:
RowRejected0 = 1;
0044:
0045:
// evaluate columns (no constraints) for link: DSLink2
0046:
DSLink2.workdate = workdate;
0047:
DSLink2.PONONO12 = DSLink1.PONONO12;
0048:
DSLink2.POTYBLTP = DSLink1.POTYBLTP;
0049:
DSLink2.POBLBLST = DSLink1.POBLBLST;
0050:
DSLink2.POBKBK12 = DSLink1.POBKBK12;
0051:
DSLink2.POBKFLNM = DSLink1.POBKFLNM;
0052:
DSLink2.POMNFNFR = DSLink1.POMNFNFR;
0053:
DSLink2.POAPAC32 = DSLink1.POAPAC32;
0054:
DSLink2.POAPFLNM = DSLink1.POAPFLNM;
0055:
DSLink2.POAPADDR = DSLink1.POAPADDR;
0056:
DSLink2.POHDSQNO = DSLink1.POHDSQNO;
0057:
DSLink2.PODYSQNO = DSLink1.PODYSQNO;
0058:
InterVar0_0 = TransDate(DSLink1.POAPDATE);
0059:
DSLink2.POAPDATE = date_from_string(InterVar0_0);
0060:
DSLink2.POAPPNAN = DSLink1.POAPPNAN;
0061:
DSLink2.POTPPNTP = DSLink1.POTPPNTP;
0062:
DSLink2.POCYCCYC = DSLink1.POCYCCYC;
0063:
DSLink2.POWTAMT = DSLink1.POWTAMT;
0064:
InterVar0_0 = TransDate(DSLink1.POWTDATE);
0065:
DSLink2.POWTDATE = date_from_string(InterVar0_0);
0066:
DSLink2.PORCAC32 = DSLink1.PORCAC32;
0067:
DSLink2.PORCFLNM = DSLink1.PORCFLNM;
0068:
DSLink2.POAGFLNM = DSLink1.POAGFLNM;
0069:
DSLink2.POAGBK12 = DSLink1.POAGBK12;
0070:
DSLink2.POINSN11 = DSLink1.POINSN11;
0071:
DSLink2.POCFSN11 = DSLink1.POCFSN11;
0072:
InterVar0_0 = TransDate(DSLink1.POINDATE);
0073:
DSLink2.POINDATE = date_from_string(InterVar0_0);
0074:
DSLink2.POCFSN08 = DSLink1.POCFSN08;
0075:
DSLink2.POBBBRNO = DSLink1.POBBBRNO;
0076:
DSLink2.POSDBRNO = DSLink1.POSDBRNO;
0077:
DSLink2.POMGMGST = DSLink1.POMGMGST;
0078:
DSLink2.PORKRMRK = DSLink1.PORKRMRK;
0079:
DSLink2.PODZBOOL = DSLink1.PODZBOOL;
0080:
DSLink2.POLSNO12 = DSLink1.POLSNO12;
0081:
InterVar0_0 = TransDate(DSLink1.POTDDATE);
0082:
DSLink2.POTDDATE = date_from_string(InterVar0_0);
0083:
DSLink2.POTDBRNO = DSLink1.POTDBRNO;
0084:
DSLink2.POTDSTAF = DSLink1.POTDSTAF;
0085:
InterVar0_0 = TransDate(DSLink1.POTDSTAM);
0086:
DSLink2.POTDSTAM = timestamp_from_string(InterVar0_0);
0087:
DSLink2.POCHSTAF = DSLink1.POCHSTAF;
0088:
InterVar0_0 = TransDate(DSLink1.POCHSTAM);
0089:
DSLink2.POCHSTAM = timestamp_from_string(InterVar0_0);
0090:
DSLink2.POCFSTAF = DSLink1.POCFSTAF;
0091:
InterVar0_0 = TransDate(DSLink1.POCKSTAM);
0092:
DSLink2.POCKSTAM = timestamp_from_string(InterVar0_0);
0093:
DSLink2.POAUSTAF = DSLink1.POAUSTAF;
0094:
DSLink2.PORDRDST = DSLink1.PORDRDST;
0095:
DSLink2.POPYDATE = date_from_ustring(InterVar0_1 , InterVar0_2);
0096:
DSLink2.POBRBK12 = InterVar0_3;
0097:
DSLink2.POTRFLAG = InterVar0_4;
0098:
DSLink2.POBAAMT = decimal_from_ustring(InterVar0_5);
0099:
DSLink2.etldate = current_timestamp();
0100:
writerecord 0;
0101:
RowRejected0 = 0;
0102: }
0103:
0104: finish {
0105: }
0106:
*** 内部生成的 Transformer 代码结束收起
##I IIS-DSEE-TFCN-00001 14:16:39(000)
IBM InfoSphere DataStage Enterprise Edition 8.7.0.6614
Copyright (c) 2001, 2005-2011 IBM Corporation. All rights reserved
##I IIS-DSEE-TFCN-00006 14:16:39(001)
##I IIS-DSEE-TOSH-00002 14:16:39(002)
##I IIS-DSEE-TOSH-00002 14:16:39(003)
##I IIS-DSEE-TOSH-00002 14:16:39(004)
##W IIS-DSEE-TOSH-00049 14:16:39(007)
##E IIS-DSEE-TBLD-00076 14:16:40(000)
##E IIS-DSEE-TFSR-00019 14:16:40(001)
##W IIS-DSEE-TFTM-00012 14:16:40(002)
##W IIS-DSEE-TFPS-00048 14:16:40(003)
##W IIS-DSEE-TFEV-00023 14:16:40(004)
##W IIS-DSEE-TFEV-00023 14:16:40(005)
##W IIS-DSEE-TFEV-00025 14:16:40(006)
##W IIS-DSEE-TFEV-00023 14:16:40(007)
##W IIS-DSEE-TFEV-00025 14:16:40(008)
##W IIS-DSEE-TFEV-00023 14:16:40(009)
##W IIS-DSEE-TFEV-00025 14:16:40(010)
##W IIS-DSEE-TFEV-00023 14:16:40(011)
##W IIS-DSEE-TFEV-00025 14:16:40(012)
##W IIS-DSEE-TFEV-00023 14:16:40(013)
##W IIS-DSEE-TFEV-00025 14:16:40(014)
##W IIS-DSEE-TFEV-00023 14:16:40(015)
##W IIS-DSEE-TFEV-00025 14:16:40(016)
##W IIS-DSEE-TFEV-00023 14:16:40(017)
##W IIS-DSEE-TFEV-00025 14:16:40(018)
##W IIS-DSEE-TFEV-00023 14:16:40(019)
##W IIS-DSEE-TBLD-00000 14:16:40(020)
##W IIS-DSEE-TBLD-00000 14:16:40(021)
##W IIS-DSEE-TBLD-00000 14:16:40(022)
##I IIS-DSEE-TBLD-00079 14:16:40(023)
##E IIS-DSEE-TCOS-00029 14:16:40(024)
*** 内部生成的 Transformer 代码如下：
0001: //
0002: // Generated file to implement the V0S2_ods_core_brfmpowt_phy20100618_Transformer transform operator.
0003: //
0004:
0005: // define external functions used
0006: extern string TransDate(string s);
0007:
0008: // define our input/output link names
0009: inputname 0 DSLink1;
0010: outputname 0 DSLink2;
0011:
0012: global {
0013:
// Job parameter declaration
0014:
ustring workdate;
0015: }
0016:
0017: initialize {
0018:
// define our control variables
0019:
int8 RowRejected0;
0020:
int8 NullSetVar0;
0021:
0022:
// declare our intermediate variables for this section
0023:
ustring InterVar0_1;
0024:
string InterVar0_2;
0025:
string InterVar0_3;
0026:
string InterVar0_4;
0027:
ustring InterVar0_5;
0028:
0029:
// initialise constant values which require conversion
0030:
InterVar0_1 = "1989-01-01";
0031:
InterVar0_2 = "%yyyy-%mm-%dd";
0032:
InterVar0_3 = " ";
0033:
InterVar0_4 = " ";
0034:
InterVar0_5 = "0000000000000.00";
0035: }
0036:
0037: mainloop {
0038:
0039:
// declare our intermediate variables for this section
0040:
string InterVar0_0;
0041:
0042:
// initialise the rejected row variable
0043:
RowRejected0 = 1;
0044:
0045:
// evaluate columns (no constraints) for link: DSLink2
0046:
DSLink2.workdate = workdate;
0047:
DSLink2.PONONO12 = DSLink1.PONONO12;
0048:
DSLink2.POTYBLTP = DSLink1.POTYBLTP;
0049:
DSLink2.POBLBLST = DSLink1.POBLBLST;
0050:
DSLink2.POBKBK12 = DSLink1.POBKBK12;
0051:
DSLink2.POBKFLNM = DSLink1.POBKFLNM;
0052:
DSLink2.POMNFNFR = DSLink1.POMNFNFR;
0053:
DSLink2.POAPAC32 = DSLink1.POAPAC32;
0054:
DSLink2.POAPFLNM = DSLink1.POAPFLNM;
0055:
DSLink2.POAPADDR = DSLink1.POAPADDR;
0056:
DSLink2.POHDSQNO = DSLink1.POHDSQNO;
0057:
DSLink2.PODYSQNO = DSLink1.PODYSQNO;
0058:
InterVar0_0 = TransDate(DSLink1.POAPDATE);
0059:
DSLink2.POAPDATE = date_from_string(InterVar0_0);
0060:
DSLink2.POAPPNAN = DSLink1.POAPPNAN;
0061:
DSLink2.POTPPNTP = DSLink1.POTPPNTP;
0062:
DSLink2.POCYCCYC = DSLink1.POCYCCYC;
0063:
DSLink2.POWTAMT = DSLink1.POWTAMT;
0064:
InterVar0_0 = TransDate(DSLink1.POWTDATE);
0065:
DSLink2.POWTDATE = date_from_string(InterVar0_0);
0066:
DSLink2.PORCAC32 = DSLink1.PORCAC32;
0067:
DSLink2.PORCFLNM = DSLink1.PORCFLNM;
0068:
DSLink2.POAGFLNM = DSLink1.POAGFLNM;
0069:
DSLink2.POAGBK12 = DSLink1.POAGBK12;
0070:
DSLink2.POINSN11 = DSLink1.POINSN11;
0071:
DSLink2.POCFSN11 = DSLink1.POCFSN11;
0072:
InterVar0_0 = TransDate(DSLink1.POINDATE);
0073:
DSLink2.POINDATE = date_from_string(InterVar0_0);
0074:
DSLink2.POCFSN08 = DSLink1.POCFSN08;
0075:
DSLink2.POBBBRNO = DSLink1.POBBBRNO;
0076:
DSLink2.POSDBRNO = DSLink1.POSDBRNO;
0077:
DSLink2.POMGMGST = DSLink1.POMGMGST;
0078:
DSLink2.PORKRMRK = DSLink1.PORKRMRK;
0079:
DSLink2.PODZBOOL = DSLink1.PODZBOOL;
0080:
DSLink2.POLSNO12 = DSLink1.POLSNO12;
0081:
InterVar0_0 = TransDate(DSLink1.POTDDATE);
0082:
DSLink2.POTDDATE = date_from_string(InterVar0_0);
0083:
DSLink2.POTDBRNO = DSLink1.POTDBRNO;
0084:
DSLink2.POTDSTAF = DSLink1.POTDSTAF;
0085:
InterVar0_0 = TransDate(DSLink1.POTDSTAM);
0086:
DSLink2.POTDSTAM = timestamp_from_string(InterVar0_0);
0087:
DSLink2.POCHSTAF = DSLink1.POCHSTAF;
0088:
InterVar0_0 = TransDate(DSLink1.POCHSTAM);
0089:
DSLink2.POCHSTAM = timestamp_from_string(InterVar0_0);
0090:
DSLink2.POCFSTAF = DSLink1.POCFSTAF;
0091:
InterVar0_0 = TransDate(DSLink1.POCKSTAM);
0092:
DSLink2.POCKSTAM = timestamp_from_string(InterVar0_0);
0093:
DSLink2.POAUSTAF = DSLink1.POAUSTAF;
0094:
DSLink2.PORDRDST = DSLink1.PORDRDST;
0095:
DSLink2.POPYDATE = date_from_ustring(InterVar0_1 , InterVar0_2);
0096:
DSLink2.POBRBK12 = InterVar0_3;
0097:
DSLink2.POTRFLAG = InterVar0_4;
0098:
DSLink2.POBAAMT = decimal_from_ustring(InterVar0_5);
0099:
DSLink2.etldate = current_timestamp();
0100:
writerecord 0;
0101:
RowRejected0 = 0;
0102: }
0103:
0104: finish {
0105: }
0106:
*** 内部生成的 Transformer 代码结束收起