compilation error in transformer

[kiranh_1214]

Hi,
I'm getting following type of message on compilation error datastage9.1

RCP is off
ALL stage variables are valid
I am able to compile other Transformer stages



Output from transformer compilation follows:

##I IIS-DSEE-TFCN-00001 05:52:40(000) <main_program>
IBM InfoSphere DataStage Enterprise Edition 9.1.0.6670
Copyright (c) 2001, 2005-2012 IBM Corporation. All rights reserved



##I IIS-DSEE-TFCN-00006 05:52:40(001) <main_program> conductor uname: -s=Linux; -r=2.6.32-279.9.1.el6.x86_64; -v=#1 SMP Fri Aug 31 09:04:24 EDT 2012; -n=lrdne10gh01.bankofamerica.com; -m=x86_64
##I IIS-DSEE-TOSH-00002 05:52:40(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 05:52:40(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 05:52:40(004) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 05:52:40(007) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##W IIS-DSEE-TFTM-00012 05:52:40(009) <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 05:52:40(010) <transform> Error when checking composite operator: This field was not found: Joined_DATA_200; [line 270, character 62].
##E IIS-DSEE-TFPS-00039 05:52:40(011) <transform> Error when checking composite operator: This field was not found: Joined_DATA_200; [line 279, character 34].
##E IIS-DSEE-TFPS-00039 05:52:40(012) <transform> Error when checking composite operator: This field was not found: Joined_DATA_200; [line 280, character 38].
##E IIS-DSEE-TFPS-00039 05:52:40(013) <transform> Error when checking composite operator: This field was not found: Joined_DATA_200; [line 281, character 34].
##E IIS-DSEE-TFPS-00039 05:52:40(014) <transform> Error when checking composite operator: This field was not found: Joined_DATA_200; [line 299, character 35].
##E IIS-DSEE-TFPS-00039 05:52:40(015) <transform> Error when checking composite operator: This field was not found: Joined_DATA_200; [line 304, character 23].
##E IIS-DSEE-TFPS-00039 05:52:40(016) <transform> Error when checking composite operator: This field was not found: Joined_DATA_200; [line 308, character 29].
##E IIS-DSEE-TFPS-00039 05:52:40(017) <transform> Error when checking composite operator: This field was not found: Joined_DATA_200; [line 319, character 42].
##E IIS-DSEE-TFPS-00039 05:52:40(018) <transform> Error when checking composite operator: This field was not found: Joined_DATA_200; [line 320, character 41].
##E IIS-DSEE-TFPS-00039 05:52:40(019) <transform> Error when checking composite operator: This field was not found: Joined_DATA_200; [line 344, character 22].
##E IIS-DSEE-TFPS-00039 05:52:40(020) <transform> Error when checking composite operator: This field was not found: Joined_DATA_200; [line 345, character 22].
##E IIS-DSEE-TFPS-00039 05:52:40(021) <transform> Error when checking composite operator: This field was not found: Joined_DATA_200; [line 346, character 22].
##E IIS-DSEE-TFPS-00039 05:52:40(022) <transform> Error when checking composite operator: This field was not found: Joined_DATA_200; [line 347, character 22].
##E IIS-DSEE-TFPS-00039 05:52:40(023) <transform> Error when checking composite operator: This field was not found: Joined_DATA_200; [line 348, character 22].
##E IIS-DSEE-TFPS-00039 05:52:40(024) <transform> Error when checking composite operator: This field was not found: Joined_DATA_200; [line 349, character 22].
##E IIS-DSEE-TFPS-00039 05:52:40(025) <transform> Error when checking composite operator: This field was not found: Joined_DATA_200; [line 350, character 22].
##E IIS-DSEE-TFSR-00019 05:52:40(026) <main_program> Could not check all operators because of previous error(s)
##E IIS-DSEE-TCOS-00029 05:52:40(027) <main_program> Creation of a step finished with status = FAILED. (CopyOfCSMR_GEN_XML_JOB_K6_CF_1.XML_Transformer)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S18_CSMR_GEN_XML_JOB_K6_CF_1_XML_Transformer transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 Joined_DATA_200;
0007: outputname 0 XML_DATA;
0008: outputname 1 BATCH_XMLDONE_DATA;
0009: outputname 2 CT2_DATA;
0010: outputname 3 BATCH_TRIGGER;
0011: outputname 4 TRIGGER_INFO;
0012: outputname 5 XML_DONE_REQ;
0013:
0014: global {
0015: // Job parameter declaration
0016: ustring LOCAL_WORKING_DIR;
0017: ustring GEO_SRC;
0018: ustring RUN_DATE;
0019: ustring FILE_ID;
0020: ustring NDM_INPUT_DIR;
0021: ustring DATAFILE;
0022: ustring TH_OUTPUT_FLDR;
0023: ustring HOST_NAME;
0024: ustring DOC_ID;
0025: ustring USERID;
0026: ustring USERIDTYPE;
0027: ustring DOCUMENT_TYPE;
0028: ustring OST_APPLICATION_ID;
0029: ustring HDR_PROCESS_DATE;
0030: ustring ARCH_DOCUMENT_TYPE;
0031: ustring INPUT_CONTENT_CLASS;
0032: ustring PRINT_IND;
0033: }
0034:
0035: initialize {
0036: // define our control variables
0037: int8 RowRejected0;
0038: int8 NullSetVar0;
0039:
0040: // declare our intermediate variables for this section
0041: string InterVar0_0;
0042: ustring InterVar0_1;
0043: ustring InterVar0_2;
0044: ustring InterVar0_6;
0045: ustring InterVar0_8;
0046: ustring InterVar0_9;
0047: ustring InterVar0_10;
0048: ustring InterVar0_11;
0049: ustring InterVar0_12;
0050: string InterVar0_13;
0051: ustring InterVar0_15;
0052: string InterVar0_16;
0053: string InterVar0_17;
0054: decimal InterVar0_18;
0055: sfloat InterVar0_19;
0056: string InterVar0_20;
0057: string InterVar0_21;
0058: ustring InterVar0_22;
0059: string InterVar0_23;
0060: string InterVar0_24;
0061: string InterVar0_25;
0062: string InterVar0_26;
0063: string InterVar0_27;
0064: string InterVar0_28;
0065: ustring InterVar0_29;
0066: ustring InterVar0_30;
0067: ustring InterVar0_31;
0068: ustring InterVar0_32;
0069: ustring InterVar0_33;
0070: string InterVar0_34;
0071: ustring InterVar0_35;
0072: string InterVar0_36;
0073: ustring InterVar0_37;
0074: string InterVar0_38;
0075: ustring InterVar0_39;
0076: string InterVar0_40;
0077: ustring InterVar0_41;
0078: string InterVar0_42;
0079: ustring InterVar0_43;
0080: string InterVar0_44;
0081: ustring InterVar0_45;
0082:
0083: // initialise constant values which require conversion
0084: InterVar0_0 = "DOC_ID";
0085: InterVar0_1 = "/XML";
0086: InterVar0_2 = "/";
0087: InterVar0_6 = "_";
0088: InterVar0_8 = ".xml";
0089: InterVar0_9 = "-";
0090: InterVar0_10 = ".xmldone";
0091: InterVar0_11 = "/CT2";
0092: InterVar0_12 = ".ct2";
0093: InterVar0_13 = "_";
0094: InterVar0_15 = "/th/";
0095: InterVar0_16 = "CommonSvcs";
0096: InterVar0_17 = "test_K";
0097: InterVar0_18 = "test_K";
0098: InterVar0_19 = "test_K";
0099: InterVar0_20 = "Batch";
0100: InterVar0_21 = "ETL";
0101: InterVar0_22 = "T";
0102: InterVar0_23 = "T";
0103: InterVar0_24 = " ";
0104: InterVar0_25 = "";
0105: InterVar0_26 = "<defns:attribute><defns:name>JOB_NAME_MAIN_FRAME</defns:name><defns:type>String</defns:type><defns:value>";
0106: InterVar0_27 = "</defns:value></defns:attribute>";
0107: InterVar0_28 = "<defns:attribute><defns:name>OST_APP_ID</defns:name><defns:type>String</defns:type><defns:value>";
0108: InterVar0_29 = "";
0109: InterVar0_30 = "title";
0110: InterVar0_31 = "DATASTAGE";
0111: InterVar0_32 = "Confidential";
0112: InterVar0_33 = "TRN001";
0113: InterVar0_34 = "124";
0114: InterVar0_35 = "CA";
0115: InterVar0_36 = "372";
0116: InterVar0_37 = "IR";
0117: InterVar0_38 = "484";
0118: InterVar0_39 = "MX";
0119: InterVar0_40 = "724";
0120: InterVar0_41 = "SP";
0121: InterVar0_42 = "826";
0122: InterVar0_43 = "UK";
0123: InterVar0_44 = "840";
0124: InterVar0_45 = "US";
0125: // Stage variable declaration and initialisation
0126: string[] StageVar0_DOCID;
0127: StageVar0_DOCID = "";
0128: string[] StageVar0_NEWARCHIVEFILENAME;
0129: StageVar0_NEWARCHIVEFILENAME = "";
0130: string[] StageVar0_NEWBATCHFILENAME;
0131: StageVar0_NEWBATCHFILENAME = "";
0132: string[] StageVar0_NEWXMLDONEFILENAME;
0133: StageVar0_NEWXMLDONEFILENAME = "";
0134: string StageVar0_NEWCT2FILENAME;
0135: StageVar0_NEWCT2FILENAME = "";
0136: string StageVar0_REQUESTID;
0137: StageVar0_REQUESTID = "";
0138: string StageVar0_OUTPUTFILENAMEPREFIX;
0139: StageVar0_OUTPUTFILENAMEPREFIX = "";
0140: string StageVar0_BATCHXMLFILENAME;
0141: StageVar0_BATCHXMLFILENAME = "";
0142: }
0143:
0144: mainloop {
0145:
0146: // declare our intermediate variables for this section
0147: ustring InterVar0_3;
0148: ustring InterVar0_4;
0149: ustring InterVar0_5;
0150: ustring InterVar0_7;
0151: string InterVar0_14;
0152:
0153: // evaluate the stage variables first
0154: StageVar0_DOCID = InterVar0_0;
0155: InterVar0_3 = StageVar0_DOCID;
0156: InterVar0_4 = Joined_DATA_200.TH_BATCH_NUMBER;
0157: InterVar0_5 = Joined_DATA_200.TH_BATCH_NUMBER;
0158: InterVar0_7 = Joined_DATA_200.TH_DOC_SEQ_NUMBER;
0159: StageVar0_NEWARCHIVEFILENAME = ((((((((((((((((LOCAL_WORKING_DIR + InterVar0_1) + InterVar0_2) + InterVar0_3) + InterVar0_2) + GEO_SRC) + InterVar0_2) + RUN_DATE) + InterVar0_2) + FILE_ID) + InterVar0_2) + InterVar0_4) + InterVar0_2) + InterVar0_5) + InterVar0_6) + InterVar0_7) + InterVar0_8);
0160: InterVar0_3 = Joined_DATA_200.TH_BATCH_NUMBER;
0161: StageVar0_NEWBATCHFILENAME = (((((NDM_INPUT_DIR + InterVar0_2) + DATAFILE) + InterVar0_9) + InterVar0_3) + InterVar0_8);
0162: InterVar0_3 = Joined_DATA_200.TH_BATCH_NUMBER;
0163: StageVar0_NEWXMLDONEFILENAME = (((((NDM_INPUT_DIR + InterVar0_2) + DATAFILE) + InterVar0_9) + InterVar0_3) + InterVar0_10);
0164: InterVar0_3 = StageVar0_DOCID;
0165: InterVar0_4 = Joined_DATA_200.TH_BATCH_NUMBER;
0166: InterVar0_5 = Joined_DATA_200.TH_BATCH_NUMBER;
0167: InterVar0_7 = Joined_DATA_200.TH_DOC_SEQ_NUMBER;
0168: StageVar0_NEWCT2FILENAME = ((((((((((((((((LOCAL_WORKING_DIR + InterVar0_11) + InterVar0_2) + InterVar0_3) + InterVar0_2) + GEO_SRC) + InterVar0_2) + RUN_DATE) + InterVar0_2) + FILE_ID) + InterVar0_2) + InterVar0_4) + InterVar0_2) + InterVar0_5) + InterVar0_6) + InterVar0_7) + InterVar0_12);
0169: InterVar0_14 = GEO_SRC;
0170: StageVar0_REQUESTID = ((((((StageVar0_DOCID + InterVar0_13) + InterVar0_14) + InterVar0_13) + Joined_DATA_200.TH_BATCH_NUMBER) + InterVar0_13) + Joined_DATA_200.TH_DOC_SEQ_NUMBER);
0171: InterVar0_3 = StageVar0_DOCID;
0172: InterVar0_4 = Joined_DATA_200.TH_BATCH_NUMBER;
0173: InterVar0_5 = Joined_DATA_200.EFFDATE;
0174: StageVar0_OUTPUTFILENAMEPREFIX = ((((((((((((((TH_OUTPUT_FLDR + InterVar0_2) + GEO_SRC) + InterVar0_15) + InterVar0_3) + InterVar0_2) + RUN_DATE) + InterVar0_2) + FILE_ID) + InterVar0_2) + InterVar0_4) + InterVar0_2) + DATAFILE) + InterVar0_9) + InterVar0_5);
0175: InterVar0_3 = Joined_DATA_200.TH_BATCH_NUMBER;
0176: StageVar0_BATCHXMLFILENAME = (((DATAFILE + InterVar0_9) + InterVar0_3) + InterVar0_8);
0177:
0178: // initialise the rejected row variable
0179: RowRejected0 = 1;
0180:
0181: // evaluate columns (no constraints) for link: XML_DATA
0182: XML_DATA.NEWFILEPATH = StageVar0_NEWARCHIVEFILENAME;
0183: XML_DATA.NEWBATCHFILEPATH = StageVar0_NEWBATCHFILENAME;
0184: XML_DATA.documentName = Joined_DATA_200.TH_DOCUMENT_NAME;
0185: XML_DATA.effectiveDate = Joined_DATA_200.EFFDATE;
0186: XML_DATA.formCode = Joined_DATA_200.FORM_CODE;
0187: XML_DATA.salesChannelCode = Joined_DATA_200.SALES_CHANNEL_CODE;
0188: XML_DATA.applicationName = InterVar0_16;
0189: XML_DATA.traceId = InterVar0_17;
0190: XML_DATA.accountNumber = Joined_DATA_200.NON_ACCT_NUM;
0191: XML_DATA.creditLimit = Joined_DATA_200.CREDIT_LINE;
0192: XML_DATA.jobNameMainframe = Joined_DATA_200.JOB_NAME_MAIN_FRAME;
0193: XML_DATA.FMrunDate = InterVar0_17;
0194: XML_DATA.accountSequenceNumber = InterVar0_18;
0195: XML_DATA.creditAccountNumber = InterVar0_18;
0196: XML_DATA.productAccountNumber = Joined_DATA_200.PROD_ACCT_NO;
0197: XML_DATA.addressLine1 = Joined_DATA_200.ADDR_1;
0198: XML_DATA.addressLine2 = Joined_DATA_200.ADDR_2;
0199: XML_DATA.addressLine3 = Joined_DATA_200.ADDR_3;
0200: XML_DATA.addressLine4 = Joined_DATA_200.ADDR_4;
0201: XML_DATA.zipCode = InterVar0_18;
0202: XML_DATA.combinedAccountIndicator = InterVar0_17;
0203: XML_DATA.cardholderSinceYear = Joined_DATA_200.CH_SINCE;
0204: XML_DATA.lastStatementDate = Joined_DATA_200.LAST_STATEMENT_DATE;
0205: XML_DATA.securedIndicator = InterVar0_17;
0206: XML_DATA.riskManagementFactorType = Joined_DATA_200.RISK_MGMT_FACTOR_TYPE;
0207: XML_DATA.specialPaymentAmount = Joined_DATA_200.SPAY_AMOUNT;
0208: XML_DATA.delinquencyDaysAtEOM = InterVar0_18;
0209: XML_DATA.currentBalanceAmount = Joined_DATA_200.CURRENT_BAL_AMT;
0210: XML_DATA.originalCreditLine = Joined_DATA_200.ORIGINAL_CREDIT_LINE;
0211: XML_DATA.cashCreditLine = Joined_DATA_200.CASH_CREDIT_LINE;
0212: XML_DATA.originalCashCreditLine = InterVar0_18;
0213: XML_DATA.marketingMessageOverride = InterVar0_18;
0214: XML_DATA.endorsedFlag = Joined_DATA_200.ENDORSED_FLAG;
0215: XML_DATA.groupName = Joined_DATA_200.GROUP_NAME;
0216: XML_DATA.ancillaryCreditProductTypeStatusCode = InterVar0_18;
0217: XML_DATA.scoreTypeNumberX = Joined_DATA_200.SCORE_TP_SCORE_NO_X;
0218: XML_DATA.scoreTypeNumberY = Joined_DATA_200.SCORE_TP_SCORE_NO_Y;
0219: XML_DATA.rewardsNumber = Joined_DATA_200.REWARDS_NO;
0220: XML_DATA.vipTierNumber = Joined_DATA_200.VIP_TIER;
0221: XML_DATA.issuer = Joined_DATA_200.ISSUER;
0222: XML_DATA.campaignNumber = InterVar0_18;
0223: XML_DATA.countryISONumber = Joined_DATA_200.COUNTRY_ISO_CODE;
0224: XML_DATA.language = Joined_DATA_200.LANGUAGE;
0225: XML_DATA.groupCode = Joined_DATA_200.GROUP_CODE;
0226: XML_DATA.fiTransparancyIndicator = Joined_DATA_200.FI_TRANSPARENT_IND;
0227: XML_DATA.associateBank = InterVar0_19;
0228: XML_DATA.productBrandNo = InterVar0_18;
0229: XML_DATA.productOfferCode = Joined_DATA_200.PRODUCT_OFR_CD;
0230: XML_DATA.productTypeNo = InterVar0_18;
0231: XML_DATA.sourceCode = InterVar0_17;
0232: XML_DATA.businessLineTypeNo = InterVar0_18;
0233: XML_DATA.odpFeeEligibilityIndicator = Joined_DATA_200.ODP_ELIG;
0234: XML_DATA.chpActiveCycles = InterVar0_18;
0235: XML_DATA.campaignTypeNumber = InterVar0_18;
0236: XML_DATA.campaignAcquisitionChannelNo = InterVar0_18;
0237: XML_DATA.affinityCode = Joined_DATA_200.AFFINITY_CODE;
0238: XML_DATA.finChargeSched = InterVar0_17;
0239: XML_DATA.minimumPaymentScheduleNumber = InterVar0_18;
0240: XML_DATA.minimumPaymentConstantAmount = Joined_DATA_200.MIN_PAY_CNSTNT_AMT;
0241: XML_DATA.minimumPaymentConstantPercentage = Joined_DATA_200.MIN_PAY_CNSTNT_AMT;
0242: XML_DATA.minimumPaymentPercentage = Joined_DATA_200.MIN_PAY_PCT;
0243: XML_DATA.minimumPaymentThresholdAmount = Joined_DATA_200.MIN_PAY_THRSHLD_AMT;
0244: XML_DATA.includeAMFFeeIndicator = Joined_DATA_200.MIN_PAY_AMF_IN;
0245: XML_DATA.includeAncillaryCreditIndicator = InterVar0_17;
0246: XML_DATA.includeCashFinanceChargesIndicator = Joined_DATA_200.MIN_PAY_CASH_FC_IN;
0247: XML_DATA.includeCashTransactionFeeIndicator = Joined_DATA_200.MIN_PAY_CASH_TRAN_IN;
0248: XML_DATA.includeFTFFeeIndicator = Joined_DATA_200.MIN_PAY_FRGN_TRAN_IN;
0249: XML_DATA.includeLateFeeIndicator = Joined_DATA_200.MIN_PAY_LATE_FEE_IND_FTR;
0250: XML_DATA.includeNSFFeeIndicator = Joined_DATA_200.MIN_PAY_NSF_FEE_IND_FTR;
0251: XML_DATA.includeOCLAmountIndicator = InterVar0_17;
0252: XML_DATA.includeOCLFeeIndicator = Joined_DATA_200.MIN_PAY_OCL_FEE_IND_FTR;
0253: XML_DATA.includePremiumIndicator = InterVar0_17;
0254: XML_DATA.includeRetailFinanceChargesIndicator = Joined_DATA_200.MIN_PAY_RETAIL_FC_IN;
0255: XML_DATA.includeRetailQuasiCashFeeIndicator = Joined_DATA_200.MIN_PAY_RETAIL_QCSH_IN;
0256: XML_DATA.termNumberofCycles = InterVar0_18;
0257: XML_DATA.curingBasisScheduleNumber = Joined_DATA_200.CURE_BASIS_SCHD_NO;
0258: XML_DATA.curingScheduleMinimumBasisPoint = Joined_DATA_200.MBP_CURE_RDUC_PT;
0259: XML_DATA.defaultRuleNumber = Joined_DATA_200.DFLT_RULE_NO;
0260: XML_DATA.curingRuleNumber = Joined_DATA_200.CURE_RULE_NO;
0261: XML_DATA.difCycleIndicator = InterVar0_17;
0262: XML_DATA.durationCycleCount = Joined_DATA_200.DFLT_DRTN_CYCLE_CT;
0263: XML_DATA.delinquencyTriggerCount = Joined_DATA_200.DFLT_DELQ_TRGR_CT;
0264: XML_DATA.delinquencyTriggerIndicator = Joined_DATA_200.DFLT_DELQ_TRGR_IN;
0265: XML_DATA.lateTriggerCount = Joined_DATA_200.DFLT_LATE_TRGR_CT;
0266: XML_DATA.lateTriggerIndicator = Joined_DATA_200.DFLT_LATE_TRGR_IN;
0267: XML_DATA.overCreditLimitTriggerCount = Joined_DATA_200.DFLT_OCL_TRGR_CT;
0268: XML_DATA.overCreditLimitTriggerIndicator = Joined_DATA_200.DFLT_OCL_TRGR_IN;
0269: XML_DATA.totalTriggerCount = Joined_DATA_200.DFLT_TOTAL_TRGR_CT;
0270: XML_DATA.curingRuleStandardPricingTriggerdifCycleIndicator = Joined_DATA_200.CURE_DIF_CYCLE_IN;
0271: XML_DATA.curingRuleStandardPricingTriggerdurationCycleCount = Joined_DATA_200.CURE_DRTN_CYCLE_CT;
0272: XML_DATA.curingRuleStandardPricingTriggerdelinquencyTriggerCount = Joined_DATA_200.CURE_DELQ_TRGR_CT;
0273: XML_DATA.curingRuleStandardPricingTriggerdelinquencyTriggerIndicator = Joined_DATA_200.CURE_DELQ_TRGR_IN;
0274: XML_DATA.curingRuleStandardPricingTriggerlateTriggerCount = Joined_DATA_200.CURE_LATE_TRGR_CT;
0275: XML_DATA.curingRuleStandardPricingTriggerlateTriggerIndicator = Joined_DATA_200.CURE_LATE_TRGR_IN;
0276: XML_DATA.curingRuleStandardPricingTriggeroverCreditLimitTriggerCount = Joined_DATA_200.CURE_LATE_TRGR_CT;
0277: XML_DATA.curingRuleStandardPricingTriggeroverCreditLimitTriggerIndicator = Joined_DATA_200.CURE_OCL_TRGR_CT;
0278: XML_DATA.curingRuleStandardPricingTriggertotalTriggerCount = Joined_DATA_200.CURE_OCL_TRGR_IN;
0279: XML_DATA.variableRateIndexCode = Joined_DATA_200.VAR_RT_INDEX_CODE;
0280: XML_DATA.variableRateEffectiveDate = Joined_DATA_200.VAR_RT_INDEX_EFF_DT;
0281: XML_DATA.variableRateIndexRate = Joined_DATA_200.VAR_RT_INDEX_RATE;
0282: XML_DATA.financeChargeOnLateTransSchedNo = InterVar0_18;
0283: XML_DATA.riskBasedPricingTierSPCAT1 = InterVar0_18;
0284: XML_DATA.riskBasedPricingTierSPCAT2 = InterVar0_18;
0285: XML_DATA.riskBasedPricingTierSPCAT3 = InterVar0_18;
0286: XML_DATA.riskBasedPricingTierSPCAT4 = InterVar0_18;
0287: XML_DATA.riskBasedPricingTierPromo1 = InterVar0_18;
0288: XML_DATA.riskBasedPricingTierPromo2 = InterVar0_18;
0289: XML_DATA.pointsOutstandingBalance = Joined_DATA_200.SUM_AVAIL_PNT_QT;
0290: XML_DATA.pointsEarned = Joined_DATA_200.SUM_ISSUED_PNT_QT;
0291: XML_DATA.pointsRedeemed = Joined_DATA_200.SUM_REDEEM_PNT_QT;
0292: XML_DATA.pointsProgramNumber = Joined_DATA_200.PNT_PGM_NO;
0293: XML_DATA.pointsEnrollmentCostAmount = Joined_DATA_200.PNT_ENRL_COST_AM;
0294: XML_DATA.pointsEnrollmentMonthsDelayed = Joined_DATA_200.PNT_ENRL_DLAY_MTH_CT;
0295: XML_DATA.fraudStrategyTypeNumber = Joined_DATA_200.FRAUD_STRATEGY_TP_NO;
0296: XML_DATA.fraudStrategyTypeNumber2 = Joined_DATA_200.FRAUD_STRATEGY_TP_NO_2;
0297: XML_DATA.fraudStrategyTypeNumber3 = Joined_DATA_200.FRAUD_STRATEGY_TP_NO_3;
0298: XML_DATA.pricingPaymentSchedminimumPaymentScheduleNumber = InterVar0_18;
0299: XML_DATA.triggerAPRindexAPRrate = Joined_DATA_200.TRGR_INDEX_RATE_FTR;
0300: XML_DATA.THBatchNumber = Joined_DATA_200.TH_BATCH_NUMBER;
0301: XML_DATA.THdocumentSequenceNumber = Joined_DATA_200.TH_DOC_SEQ_NUMBER;
0302: XML_DATA.systemID = Joined_DATA_200.SYSTEM_ID;
0303: XML_DATA.logoImageID1 = Joined_DATA_200.LOGO_IMAGE_ID_1;
0304: XML_DATA.paperType1 = Joined_DATA_200.PAPER_TYPE_1;
0305: XML_DATA.paperType2 = Joined_DATA_200.PAPER_TYPE_2;
0306: XML_DATA.OSEoutsideEnvelopeType = Joined_DATA_200.OSE_TYPE;
0307: XML_DATA.plasticRequestTypeCode = Joined_DATA_200.PLASTIC_REQ_TYPE;
0308: XML_DATA.insertPartNumber = Joined_DATA_200.INSERT_PART_NBR;
0309: XML_DATA.outputFileNamePrefix = InterVar0_17;
0310: XML_DATA.CFmultiPackageIndicator = Joined_DATA_200.MULTI_PACKAGE_IND;
0311: XML_DATA.CFdisclosureIndicator = Joined_DATA_200.DISCL_FLAG;
0312: XML_DATA.CFcolorIndicator = Joined_DATA_200.COLOR_IND;
0313: XML_DATA.CFinsertJobNumber = Joined_DATA_200.INSERT_JOB_NUM;
0314: XML_DATA.CFinsertJobSequenceNumber = Joined_DATA_200.INSERT_JOB_SEQ_NUM;
0315: XML_DATA.CFembossingJobNumber = Joined_DATA_200.EMB_JOB_NUM;
0316: XML_DATA.CFtotalNumberOfCards = Joined_DATA_200.TOT_NUM_CARDS;
0317: XML_DATA.CFtrackAndTraceNumber = InterVar0_18;
0318: XML_DATA.CFchipCardIndicator = Joined_DATA_200.CHIP_CARD_IND;
0319: XML_DATA.CFembossingCardMediumTypeCode = Joined_DATA_200.CARD_MED_TYPE;
0320: XML_DATA.CFembossingCardPhotoTypeCode = Joined_DATA_200.PHOTO_TYPE;
0321: XML_DATA.CFmailerPageCount = Joined_DATA_200.MAILER_PAGE_CNT;
0322: XML_DATA.CFmailer__Barcode = Joined_DATA_200.MAILER_BARCODE;
0323: XML_DATA.CFbannerCycleType = Joined_DATA_200.BAN_CYCLE_TYP;
0324: XML_DATA.CFplasticMailerBannerPrintGroup = Joined_DATA_200.PM_BAN_PRT_GRP;
0325: XML_DATA.CFdisclosureBannerPrintGroup = Joined_DATA_200.DA_BAN_PRT_GRP;
0326: XML_DATA.CFbannerInsertJobNumber = Joined_DATA_200.BAN_INSERT_JOB_NBR;
0327: XML_DATA.CFmailerLabel = Joined_DATA_200.PM_DOCUMENT_LABEL;
0328: XML_DATA.CFdisclosureAgreementLabel = Joined_DATA_200.DA_DOCUMENT_LABEL;
0329: XML_DATA.CFprintGroupLabel = Joined_DATA_200.PRT_GRP_TYP;
0330: XML_DATA.TLE__JES0__NA = Joined_DATA_200.TLE_JES0_NA;
0331: XML_DATA.TLE__DBD0 = Joined_DATA_200.TLE_DBD0;
0332: XML_DATA.TLE__DBD1__Before = Joined_DATA_200.TLE_DBD1_BEFORE;
0333: XML_DATA.TLE__DBD1__ErrorBINindicator = Joined_DATA_200.TLE_DBD1_ERROR_BIN_IND;
0334: XML_DATA.TLE__DBD1__Middle = Joined_DATA_200.TLE_DBD1_MIDDLE;
0335: XML_DATA.TLE__DBD1__PostageMeter1 = Joined_DATA_200.TLE_DBD1_POSTAGE_METER1;
0336: XML_DATA.TLE__DBD1__PostageMeter2 = Joined_DATA_200.TLE_DBD1_POSTAGE_METER2;
0337: XML_DATA.TLE__DBD1__PostageMeter3 = Joined_DATA_200.TLE_DBD1_POSTAGE_METER3;
0338: XML_DATA.TLE__DBD1__ZipMark1 = Joined_DATA_200.TLE_DBD1_ZIP_MARK1;
0339: XML_DATA.TLE__DBD1__ZipMark2 = Joined_DATA_200.TLE_DBD1_ZIP_MARK2;
0340: XML_DATA.TLE__DBD1__After = Joined_DATA_200.TLE_DBD1_AFTER;
0341: XML_DATA.TLE__DBD2__Before = Joined_DATA_200.TLE_DBD2_BEFORE;
0342: XML_DATA.TLE__DBD2__PackageWeight = Joined_DATA_200.TLE_DBD2_PACKAGE_WEIGHT;
0343: XML_DATA.TLE__DBD2__After = Joined_DATA_200.TLE_DBD2_AFTER;
0344: XML_DATA.TLE__ACC1 = Joined_DATA_200.TLE_ACC1;
0345: XML_DATA.TLE__ADR1 = Joined_DATA_200.TLE_ADR;
0346: XML_DATA.TLE__ADR2 = Joined_DATA_200.TLE_ADR_2;
0347: XML_DATA.TLE__ADR3 = Joined_DATA_200.TLE_ADR_3;
0348: XML_DATA.TLE__ADR4 = Joined_DATA_200.TLE_ADR_4;
0349: XML_DATA.TLE__ADR5 = Joined_DATA_200.TLE_ADR_5;
0350: XML_DATA.TLE__ADR6 = Joined_DATA_200.TLE_ADR_6;
0351: writerecord 0;
0352: RowRejected0 = 0;
0353: // evaluate columns (no constraints) for link: BATCH_XMLDONE_DATA
0354: BATCH_XMLDONE_DATA.NEWFILEPATH = StageVar0_NEWXMLDONEFILENAME;
0355: BATCH_XMLDONE_DATA.BATCH_NUMBER = Joined_DATA_200.TH_BATCH_NUMBER;
0356: BATCH_XMLDONE_DATA.component = InterVar0_20;
0357: BATCH_XMLDONE_DATA.channel = InterVar0_21;
0358: BATCH_XMLDONE_DATA.serverInstance = HOST_NAME;
0359: InterVar0_3 = u_trim_leading_trailing(Joined_DATA_200.TH_BATCH_NUMBER);
0360: BATCH_XMLDONE_DATA.traceId = ((((((((DOC_ID + InterVar0_6) + GEO_SRC) + InterVar0_6) + InterVar0_3) + InterVar0_6) + ustring_from_date(current_date())) + InterVar0_22) + ustring_from_time(current_time()));
0361: BATCH_XMLDONE_DATA.applicationId = InterVar0_21;
0362: BATCH_XMLDONE_DATA.userId = u_trim_leading_trailing(USERID);
0363: BATCH_XMLDONE_DATA.userIdType = u_trim_leading_trailing(USERIDTYPE);
0364: BATCH_XMLDONE_DATA.timestamp = ((string_from_date(current_date()) + InterVar0_23) + string_from_time(current_time()));
0365: BATCH_XMLDONE_DATA.documentId = StageVar0_DOCID;
0366: BATCH_XMLDONE_DATA.geoSrc = u_trim_leading_trailing(GEO_SRC);
0367: BATCH_XMLDONE_DATA.jobType = replace_substring(InterVar0_24 , InterVar0_25 , trim_leading_trailing(Joined_DATA_200.BAN_CYCLE_TYP));
0368: BATCH_XMLDONE_DATA.thBatchNumber = trim_leading_trailing(Joined_DATA_200.TH_BATCH_NUMBER);
0369: BATCH_XMLDONE_DATA.documentType = u_trim_leading_trailing(DOCUMENT_TYPE);
0370: InterVar0_14 = u_trim_leading_trailing(OST_APPLICATION_ID);
0371: BATCH_XMLDONE_DATA.printAttributesXml = (((((InterVar0_26 + trim_leading_trailing(Joined_DATA_200.JOB_NAME_MAIN_FRAME)) + InterVar0_27) + InterVar0_28) + InterVar0_14) + InterVar0_27);
0372: BATCH_XMLDONE_DATA.dataFile = StageVar0_BATCHXMLFILENAME;
0373: BATCH_XMLDONE_DATA.processDate = HDR_PROCESS_DATE;
0374: writerecord 1;
0375: RowRejected0 = 0;
0376: // evaluate columns (no constraints) for link: CT2_DATA
0377: CT2_DATA.NEWFILEPATH = StageVar0_NEWCT2FILENAME;
0378: CT2_DATA.requestID = StageVar0_REQUESTID;
0379: CT2_DATA.productAccountNumber = InterVar0_29;
0380: CT2_DATA.creditAccountNumber = InterVar0_29;
0381: CT2_DATA.accountNumber = u_trim_leading_trailing(Joined_DATA_200.NON_ACCT_NUM);
0382: CT2_DATA.referenceNumber = u_trim_leading_trailing(Joined_DATA_200.JOB_NAME_MAIN_FRAME);
0383: CT2_DATA.documentDate = ((((u_substring_1(HDR_PROCESS_DATE , 6 , 2) + InterVar0_2) + u_substring_1(HDR_PROCESS_DATE , 9 , 2)) + InterVar0_2) + u_substring_1(HDR_PROCESS_DATE , 1 , 4));
0384: CT2_DATA.title = InterVar0_30;
0385: CT2_DATA.author = InterVar0_31;
0386: CT2_DATA.classification = InterVar0_32;
0387: CT2_DATA.keywords = InterVar0_29;
0388: CT2_DATA.summary = InterVar0_29;
0389: CT2_DATA.recordCode = InterVar0_33;
0390: CT2_DATA.documentType = u_trim_leading_trailing(ARCH_DOCUMENT_TYPE);
0391: CT2_DATA.contentClass = u_trim_leading_trailing(INPUT_CONTENT_CLASS);
0392: if ((trim_leading_trailing(Joined_DATA_200.COUNTRY_ISO_CODE) == InterVar0_34)) {
0393: CT2_DATA.countryCode = InterVar0_35;
0394: } else {
0395: if ((trim_leading_trailing(Joined_DATA_200.COUNTRY_ISO_CODE) == InterVar0_36)) {
0396: CT2_DATA.countryCode = InterVar0_37;
0397: } else {
0398: if ((trim_leading_trailing(Joined_DATA_200.COUNTRY_ISO_CODE) == InterVar0_38)) {
0399: CT2_DATA.countryCode = InterVar0_39;
0400: } else {
0401: if ((trim_leading_trailing(Joined_DATA_200.COUNTRY_ISO_CODE) == InterVar0_40)) {
0402: CT2_DATA.countryCode = InterVar0_41;
0403: } else {
0404: if ((trim_leading_trailing(Joined_DATA_200.COUNTRY_ISO_CODE) == InterVar0_42)) {
0405: CT2_DATA.countryCode = InterVar0_43;
0406: } else {
0407: if ((trim_leading_trailing(Joined_DATA_200.COUNTRY_ISO_CODE) == InterVar0_44)) {
0408: CT2_DATA.countryCode = InterVar0_45;
0409: } else {
0410: CT2_DATA.countryCode = InterVar0_45;
0411: }
0412: //;
0413: }
0414: //;
0415: }
0416: //;
0417: }
0418: //;
0419: }
0420: //;
0421: }
0422: //;
0423: writerecord 2;
0424: RowRejected0 = 0;
0425: // evaluate columns (no constraints) for link: BATCH_TRIGGER
0426: BATCH_TRIGGER.BATCH_NUMBER = trim_leading_trailing(Joined_DATA_200.TH_BATCH_NUMBER);
0427: BATCH_TRIGGER.DOC_SEQ_NUMBER = trim_leading_trailing(Joined_DATA_200.TH_DOC_SEQ_NUMBER);
0428: writerecord 3;
0429: RowRejected0 = 0;
0430: // evaluate columns (no constraints) for link: TRIGGER_INFO
0431: TRIGGER_INFO.BATCH_NUMBER = Joined_DATA_200.TH_BATCH_NUMBER;
0432: TRIGGER_INFO.docId = StageVar0_DOCID;
0433: TRIGGER_INFO.geoCode = GEO_SRC;
0434: TRIGGER_INFO.runDate = RUN_DATE;
0435: TRIGGER_INFO.fileId = FILE_ID;
0436: TRIGGER_INFO.printInd = PRINT_IND;
0437: writerecord 4;
0438: RowRejected0 = 0;
0439: // evaluate columns (no constraints) for link: XML_DONE_REQ
0440: XML_DONE_REQ.BATCH_NUMBER = Joined_DATA_200.TH_BATCH_NUMBER;
0441: XML_DONE_REQ.customerId = trim_leading_trailing(Joined_DATA_200.NON_ACCT_NUM);
0442: XML_DONE_REQ.countryCode = GEO_SRC;
0443: XML_DONE_REQ.documentSequenceNumber = Joined_DATA_200.TH_DOC_SEQ_NUMBER;
0444: writerecord 5;
0445: RowRejected0 = 0;
0446: }
0447:
0448: finish {
0449: }
0450:
*** End of Internal Generated Transformer Code

[crystal_pup]

Is Joined_DATA_200 an input link? Can you share the metadata of the input link?

[kiranh_1214]

Joined_DATA_200 is input link to transformer(XML_Transformer) . I have 605 columns in the Joined_DATA_200 link.

[asorrell]

Can't tell you exactly from the error, but I have seen similar issues when there's a bad transform function. Can you make a copy of the job and try stripping out transforms till it compiles? that will tell you which one.

[DataStage_Sterling]

What Andy suggested works perfectly. I had a similar situation in our migration from 7.5.1 to 8.7. The jobs compiled successfully in 7.5.1 but not in 8.7. I started by removing 80% of the columns and increasing it gradually until I finally found out the problem was with a transformation from null value in source to non null value in output in the transformer stage. The error resolution from IBM website on the first part of the message can be misleading

Thanks
DataStage_Sterling

[kiranh_1214]

Andy/DataStage_Sterling,

As you suggested i removed transformer and placesd new transformer still i am geeting same error.

my source data coming from dataset and nullable as No.

[DataStage_Sterling]

Kiran,
I am not sure why you replaced the transformer.

Assuming you have only one transformer with 10 columns + any constraints,
1. Make copy of the job
2. Remove the constraint and compile, if successful it means the problem is with constraint
3. Revert the copy of the job, remove 5 of the 10 columns, if successful the problem is in one or more of the 5 columns removed.
4. Continue until you zero in on the column
5. You may want to do a similar exercise if you have stage variables.

Thank you.
DataStage Sterling

[rkashyap]

We have received similar error messages on multiple occasions ... and the cause has been metadata mismatch between source and target. Please follow the process suggested by DataStage_Sterling to investigate and root cause this issue.

[FranklinE]

I have a possilbe "solution" for this situation when the metadata is based on COBOL FD table definition.

It's ridiculously simple: the metadata includes the level numbers from the Cobol copybook, and if you have level numbers out of synch with each other this can cause the listed error message.

Edit the input table definition in the transformer to change the level numbers to be in synch. For example:

Code: Select all

05 Column-a
02 Column-b
05 Column-c

The error is generated for Column-b. Change the level number to 05 and the error disappears.