error during compiling

sush26283 · Post by **sush26283** » Thu Sep 16, 2010 12:11 pm

Hi ...am trying to compile a job and this is the error that i am getting...can anyone please reflect upon it..
The number of reject datasets "0" is less than the number of input datasets "1"

vinothkumar · Post by **vinothkumar** » Thu Sep 16, 2010 12:19 pm

Please do a search in this forum and see whether it helps.

sush26283 · Post by **sush26283** » Thu Sep 16, 2010 12:28 pm

vinothkumar wrote:Please do a search in this forum and see whether it helps.

HI...i did so..but i guess either the page is expired or some other prob..as it didnt open up...

chulett · Post by **chulett** » Thu Sep 16, 2010 12:33 pm

What does that mean, exactly? An exact search for your full error message returned 134 matches and I'm sure they all "open up" just fine.

Can you be more precise on the problem you had with the search?

sush26283 · Post by **sush26283** » Thu Sep 16, 2010 12:39 pm

chulett wrote:What does that mean, exactly? An exact search for your full error message returned 134 matches and I'm sure they all "open up" just fine.

Can you be more precise on the problem you had with the search?

true...it has 134 matches, and when i try to open the link by clicking on the topic, it says IE cant open the page..

kwwilliams · Post by **kwwilliams** » Thu Sep 16, 2010 1:31 pm

One of your stages (probably a lookup, transformer, or database stage) is specified to reject but you don't have a reject link coming out of the stage.

sush26283 · Post by **sush26283** » Thu Sep 16, 2010 1:38 pm

kwwilliams wrote:One of your stages (probably a lookup, transformer, or database stage) is specified to reject but you don't have a reject link coming out of the stage.

Hi Keith...i checked for those, but they r fine...i have reject only at the target oracle level and that too is taken care off...

mhester · Post by **mhester** » Thu Sep 16, 2010 1:41 pm

Is this the entire error? Is it complaining about a lookup stage that is defined to reject, but there is no reject link?

sush26283 · Post by **sush26283** » Thu Sep 16, 2010 1:46 pm

mhester wrote:Is this the entire error? Is it complaining about a lookup stage that is defined to reject, but there is no reject link?

well its a part of the error....rest of the errors are regarding the data conversion...i am using the look up, but it is not to carry a reject link...after look up i have transformer, the error am gettin in transformer...then it is to the target oracle, which is defined to have reject and it does have,as from there it goes into the reject logic...

mhester · Post by **mhester** » Thu Sep 16, 2010 1:47 pm

Please post the entire error message.

sush26283 · Post by **sush26283** » Thu Sep 16, 2010 2:34 pm

mhester wrote:Please post the entire error message.

Output from transformer compilation follows:

##I TFCN 000001 15:32:17(000) <main_program>
IBM DataStage(tm) Parallel Extender 7.5.3
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved

##I TOSH 000002 15:32:17(001) <main_program> orchgeneral: loaded
##I TOSH 000002 15:32:17(002) <main_program> orchsort: loaded
##I TOSH 000002 15:32:17(003) <main_program> orchstats: loaded
##I TFSC 000001 15:32:17(006) <main_program> APT configuration file: /u01/app/dsadm/Ascential/DataStage/Configurations/etldevs1/7_node_7_mp.apt
##I TFSC 000000 15:32:17(007) <main_program>
This step has no datasets.

It has 1 operator:
op0[1p] {(sequential APT_CombinedOperatorController:
(APT_LicenseCountOp in APT_LicenseOperator)
(APT_LicenseCheckOp in APT_LicenseOperator)
) on nodes (
node1[op0,p0]
)}
It runs 1 process on 1 node.
##I TFOP 000094 15:32:17(000) <APT_LicenseCountOp in APT_LicenseOperator,0> Output 0 produced 1 records.
##I TLIC 000163 15:32:17(001) <APT_LicenseCheckOp in APT_LicenseOperator,0> Input 0 consumed 1 records.
##W TCOS 000049 15:32:17(008) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##W TCOS 000049 15:32:17(009) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##I TCOS 000023 15:32:17(011) <main_program> Dump:

.
##W TFCP 000000 15:32:18(000) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
##W TFCP 000025 15:32:18(001) <transform> Error when checking composite operator: Converting number to string.
##W TFCP 000000 15:32:18(002) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 15:32:18(003) <transform> Error when checking composite operator: Converting number to string.
##W TFCP 000000 15:32:18(004) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 15:32:18(005) <transform> Error when checking composite operator: Converting number to string.
##W TFCP 000000 15:32:18(006) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 15:32:18(007) <transform> Error when checking composite operator: Possible range limitation.
##W TFCP 000000 15:32:18(008) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W TFCP 000025 15:32:18(009) <transform> Error when checking composite operator: Possible range limitation.
##W TFCP 000000 15:32:18(010) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W TFCP 000025 15:32:18(011) <transform> Error when checking composite operator: Possible range limitation.
##W TFCP 000000 15:32:18(012) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W TFCP 000025 15:32:18(013) <transform> Error when checking composite operator: Possible range limitation.
##W TFCP 000000 15:32:18(014) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W TFCP 000025 15:32:18(015) <transform> Error when checking composite operator: Possible range limitation.
##W TFCP 000000 15:32:18(016) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W TFCP 000025 15:32:18(017) <transform> Error when checking composite operator: Possible range limitation.
##W TFCP 000000 15:32:18(018) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W TFCP 000025 15:32:18(019) <transform> Error when checking composite operator: Possible range limitation.
##W TFCP 000000 15:32:18(020) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##E TFCP 000000 15:32:18(021) <transform> Error when checking composite operator: Only an input field can be "null"; function argument: [line 118,character 102].
##E TFSR 000019 15:32:18(022) <main_program> Could not check all operators because of previous error(s)
##E TCOS 000029 15:32:18(023) <main_program> Creation of a step finished with status = FAILED. (DM_INDIVIDUAL_X_BPC_SUMM.Combine)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S7_repos_Combine transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 In1;
0007: outputname 0 ToLoad;
0008:
0009: initialize {
0010: // define our row rejected variable
0011: int8 RowRejected0;
0012:
0013: // define our null set variable
0014: int8 NullSetVar0;
0015:
0016: // declare our intermediate variables for this section
0017: string InterVar0_0;
0018: string InterVar0_1;
0019: string InterVar0_2;
0020: string InterVar0_3;
0021: string InterVar0_4;
0022: string InterVar0_5;
0023: string InterVar0_6;
0024: string InterVar0_7;
0025: string InterVar0_8;
0026: string InterVar0_9;
0027: string InterVar0_10;
0028: string InterVar0_11;
0029: date InterVar0_12;
0030: string InterVar0_13;
0031: string InterVar0_14;
0032: string InterVar0_15;
0033:
0034: // initialise constant values which require conversion
0035: InterVar0_0 = "I";
0036: InterVar0_1 = "GF";
0037: InterVar0_2 = "CC";
0038: InterVar0_3 = "EV";
0039: InterVar0_4 = "sw";
0040: InterVar0_5 = "SW";
0041: InterVar0_6 = "HR";
0042: InterVar0_7 = "CT, ML, MS, PR, UK, SW, HR";
0043: InterVar0_8 = "O";
0044: InterVar0_9 = 1;
0045: InterVar0_10 = 2;
0046: InterVar0_11 = 0;
0047: InterVar0_12 = date_from_string("NULL");
0048: InterVar0_13 = "EM";
0049: InterVar0_14 = "OPN";
0050: InterVar0_15 = "C";
0051: // Stage variable declaration and initialisation
0052: timestamp StageVar0_LastGiftResponseDate;
0053: StageVar0_LastGiftResponseDate = timestamp_from_string("2001-01-01 00:00:01");
0054: timestamp StageVar0_LastCouponResponseDate;
0055: StageVar0_LastCouponResponseDate = timestamp_from_string("2001-01-01 00:00:01");
0056: timestamp StageVar0_LastEventResponseDate;
0057: StageVar0_LastEventResponseDate = timestamp_from_string("2001-01-01 00:00:01");
0058: timestamp StageVar0_LastSweepsContestRespDate;
0059: StageVar0_LastSweepsContestRespDate = timestamp_from_string("2001-01-01 00:00:01");
0060: timestamp StageVar0_LastSurveyResponseDate;
0061: StageVar0_LastSurveyResponseDate = timestamp_from_string("2001-01-01 00:00:01");
0062: timestamp StageVar0_LastMiscResponseDate;
0063: StageVar0_LastMiscResponseDate = timestamp_from_string("2001-01-01 00:00:01");
0064: timestamp StageVar0_LastMailedDate;
0065: StageVar0_LastMailedDate = timestamp_from_string("2001-01-01 00:00:01");
0066: timestamp StageVar0_LastPackRedemptionDate;
0067: StageVar0_LastPackRedemptionDate = timestamp_from_string("2001-01-01 00:00:01");
0068: timestamp StageVar0_LastCartonRedemptionDate;
0069: StageVar0_LastCartonRedemptionDate = timestamp_from_string("2001-01-01 00:00:01");
0070: timestamp StageVar0_LastComboRedemptionDate;
0071: StageVar0_LastComboRedemptionDate = timestamp_from_string("2001-01-01 00:00:01");
0072: date StageVar0_LastCouponOfferedDate;
0073: StageVar0_LastCouponOfferedDate = date_from_string("2001-01-01");
0074: date StageVar0_LastGiftOfferedDate;
0075: StageVar0_LastGiftOfferedDate = date_from_string("2001-01-01");
0076: timestamp StageVar0_LastProgramRespondedDate;
0077: StageVar0_LastProgramRespondedDate = timestamp_from_string("2001-01-01 00:00:01");
0078: timestamp StageVar0_LastOpenDate;
0079: StageVar0_LastOpenDate = timestamp_from_string("2001-01-01 00:00:01");
0080: timestamp StageVar0_LastClickDate;
0081: StageVar0_LastClickDate = timestamp_from_string("2001-01-01 00:00:01");
0082: decimal[7,0] StageVar0_LifeTimeGiftResposes;
0083: StageVar0_LifeTimeGiftResposes = 0;
0084: decimal[7,0] StageVar0_LifeTimeCouponResponses;
0085: StageVar0_LifeTimeCouponResponses = 0;
0086: decimal[7,0] StageVar0_LifeTimeEventResponses;
0087: StageVar0_LifeTimeEventResponses = 0;
0088: decimal[7,0] StageVar0_LifeTimeSweepsResponses;
0089: StageVar0_LifeTimeSweepsResponses = 0;
0090: decimal[7,0] StageVar0_LifeTimeProgramsMailed;
0091: StageVar0_LifeTimeProgramsMailed = 0;
0092: decimal[7,0] StageVar0_LifeTimeOpened;
0093: StageVar0_LifeTimeOpened = 0;
0094: string StageVar0_LastProgramRespondedTo;
0095: StageVar0_LastProgramRespondedTo = "";
0096: decimal[7,0] StageVar0_LifeTimeClicked;
0097: StageVar0_LifeTimeClicked = 0;
0098: }
0099:
0100: mainloop {
0101: // initialise our row rejected variable
0102: RowRejected0 = 1;
0103:
0104: // declare our intermediate variables for this section
0105: decimal InterVar0_16;
0106: string InterVar0_17;
0107: string InterVar0_18;
0108: string InterVar0_19;
0109:
0110: // evaluate the stage variables first
0111: NullSetVar0 = 0;
0112: if ((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.OFFER_CATEGORY_CD == InterVar0_1))) {
0113: StageVar0_LastGiftResponseDate = In1.CONTACT_DATE;
0114: } else {
0115: if ((In1.keyChange == 1)) {
0116: NullSetVar0 = 1;
0117: } else {
0118: if ((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_1)) && null(StageVar0_LastGiftResponseDate))) {
0119: StageVar0_LastGiftResponseDate = In1.CONTACT_DATE;
0120: } else {
0121: if ((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_1)) && (In1.CONTACT_DATE > StageVar0_LastGiftResponseDate))) {
0122: StageVar0_LastGiftResponseDate = In1.CONTACT_DATE;
0123: } else {
0124: StageVar0_LastGiftResponseDate = StageVar0_LastGiftResponseDate;
0125: }
0126: //;
0127: }
0128: //;
0129: }
0130: //;
0131: }
0132: StageVar0_LastGiftResponseDate = (NullSetVar0 == 1) ? set_null() : StageVar0_LastGiftResponseDate;
0133: NullSetVar0 = 0;
0134: if ((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.OFFER_CATEGORY_CD == InterVar0_2))) {
0135: StageVar0_LastCouponResponseDate = In1.CONTACT_DATE;
0136: } else {
0137: if ((In1.keyChange == 1)) {
0138: NullSetVar0 = 1;
0139: } else {
0140: if ((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_2)) && null(StageVar0_LastCouponResponseDate))) {
0141: StageVar0_LastCouponResponseDate = In1.CONTACT_DATE;
0142: } else {
0143: if ((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_2)) && (In1.CONTACT_DATE > StageVar0_LastCouponResponseDate))) {
0144: StageVar0_LastCouponResponseDate = In1.CONTACT_DATE;
0145: } else {
0146: StageVar0_LastCouponResponseDate = StageVar0_LastCouponResponseDate;
0147: }
0148: //;
0149: }
0150: //;
0151: }
0152: //;
0153: }
0154: StageVar0_LastCouponResponseDate = (NullSetVar0 == 1) ? set_null() : StageVar0_LastCouponResponseDate;
0155: NullSetVar0 = 0;
0156: if ((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.MEDIA_CATEGORY_CD == InterVar0_3))) {
0157: StageVar0_LastEventResponseDate = In1.CONTACT_DATE;
0158: } else {
0159: if ((In1.keyChange == 1)) {
0160: NullSetVar0 = 1;
0161: } else {
0162: if ((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.MEDIA_CATEGORY_CD == InterVar0_3)) && null(StageVar0_LastEventResponseDate))) {
0163: StageVar0_LastEventResponseDate = In1.CONTACT_DATE;
0164: } else {
0165: if ((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.MEDIA_CATEGORY_CD == InterVar0_3)) && (In1.CONTACT_DATE > StageVar0_LastEventResponseDate))) {
0166: StageVar0_LastEventResponseDate = In1.CONTACT_DATE;
0167: } else {
0168: StageVar0_LastEventResponseDate = StageVar0_LastEventResponseDate;
0169: }
0170: //;
0171: }
0172: //;
0173: }
0174: //;
0175: }
0176: StageVar0_LastEventResponseDate = (NullSetVar0 == 1) ? set_null() : StageVar0_LastEventResponseDate;
0177: NullSetVar0 = 0;
0178: if ((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.OFFER_CATEGORY_CD == InterVar0_4))) {
0179: StageVar0_LastSweepsContestRespDate = In1.CONTACT_DATE;
0180: } else {
0181: if ((In1.keyChange == 1)) {
0182: NullSetVar0 = 1;
0183: } else {
0184: if ((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_5)) && null(StageVar0_LastSweepsContestRespDate))) {
0185: StageVar0_LastSweepsContestRespDate = In1.CONTACT_DATE;
0186: } else {
0187: if ((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_5)) && (In1.CONTACT_DATE > StageVar0_LastSweepsContestRespDate))) {
0188: StageVar0_LastSweepsContestRespDate = In1.CONTACT_DATE;
0189: } else {
0190: StageVar0_LastSweepsContestRespDate = StageVar0_LastSweepsContestRespDate;
0191: }
0192: //;
0193: }
0194: //;
0195: }
0196: //;
0197: }
0198: StageVar0_LastSweepsContestRespDate = (NullSetVar0 == 1) ? set_null() : StageVar0_LastSweepsContestRespDate;
0199: NullSetVar0 = 0;
0200: if ((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.OFFER_CATEGORY_CD == InterVar0_6))) {
0201: StageVar0_LastSurveyResponseDate = In1.CONTACT_DATE;
0202: } else {
0203: if ((In1.keyChange == 1)) {
0204: NullSetVar0 = 1;
0205: } else {
0206: if ((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_6)) && null(StageVar0_LastSurveyResponseDate))) {
0207: StageVar0_LastSurveyResponseDate = In1.CONTACT_DATE;
0208: } else {
0209: if ((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_6)) && (In1.CONTACT_DATE > StageVar0_LastSurveyResponseDate))) {
0210: StageVar0_LastSurveyResponseDate = In1.CONTACT_DATE;
0211: } else {
0212: StageVar0_LastSurveyResponseDate = StageVar0_LastSurveyResponseDate;
0213: }
0214: //;
0215: }
0216: //;
0217: }
0218: //;
0219: }
0220: StageVar0_LastSurveyResponseDate = (NullSetVar0 == 1) ? set_null() : StageVar0_LastSurveyResponseDate;
0221: NullSetVar0 = 0;
0222: if ((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.OFFER_CATEGORY_CD == InterVar0_7))) {
0223: StageVar0_LastMiscResponseDate = In1.CONTACT_DATE;
0224: } else {
0225: if ((In1.keyChange == 1)) {
0226: NullSetVar0 = 1;
0227: } else {
0228: if ((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_7)) && null(StageVar0_LastMiscResponseDate))) {
0229: StageVar0_LastMiscResponseDate = In1.CONTACT_DATE;
0230: } else {
0231: if ((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_7)) && (In1.CONTACT_DATE > StageVar0_LastMiscResponseDate))) {
0232: StageVar0_LastMiscResponseDate = In1.CONTACT_DATE;
0233: } else {
0234: StageVar0_LastMiscResponseDate = StageVar0_LastMiscResponseDate;
0235: }
0236: //;
0237: }
0238: //;
0239: }
0240: //;
0241: }
0242: StageVar0_LastMiscResponseDate = (NullSetVar0 == 1) ? set_null() : StageVar0_LastMiscResponseDate;
0243: NullSetVar0 = 0;
0244: if (((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_8))) {
0245: StageVar0_LastMailedDate = In1.CONTACT_DATE;
0246: } else {
0247: if ((In1.keyChange == 1)) {
0248: NullSetVar0 = 1;
0249: } else {
0250: if (((In1.CONTACT_INITIATOR_CD == InterVar0_8) && null(StageVar0_LastMailedDate))) {
0251: StageVar0_LastMailedDate = In1.CONTACT_DATE;
0252: } else {
0253: if (((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.CONTACT_DATE > StageVar0_LastMailedDate))) {
0254: StageVar0_LastMailedDate = In1.CONTACT_DATE;
0255: } else {
0256: StageVar0_LastMailedDate = StageVar0_LastMailedDate;
0257: }
0258: //;
0259: }
0260: //;
0261: }
0262: //;
0263: }
0264: StageVar0_LastMailedDate = (NullSetVar0 == 1) ? set_null() : StageVar0_LastMailedDate;
0265: NullSetVar0 = 0;
0266: if (((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.OFFER_CATEGORY_CD == InterVar0_2)) && (In1.PACKAGE_TYPE_CD == InterVar0_9))) {
0267: StageVar0_LastPackRedemptionDate = In1.CONTACT_DATE;
0268: } else {
0269: if ((In1.keyChange == 1)) {
0270: NullSetVar0 = 1;
0271: } else {
0272: if (((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_2)) && (In1.PACKAGE_TYPE_CD == InterVar0_9)) && null(StageVar0_LastPackRedemptionDate))) {
0273: StageVar0_LastPackRedemptionDate = In1.CONTACT_DATE;
0274: } else {
0275: if (((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_2)) && (In1.PACKAGE_TYPE_CD == InterVar0_9)) && (In1.CONTACT_DATE > StageVar0_LastPackRedemptionDate))) {
0276: StageVar0_LastPackRedemptionDate = In1.CONTACT_DATE;
0277: } else {
0278: StageVar0_LastPackRedemptionDate = StageVar0_LastPackRedemptionDate;
0279: }
0280: //;
0281: }
0282: //;
0283: }
0284: //;
0285: }
0286: StageVar0_LastPackRedemptionDate = (NullSetVar0 == 1) ? set_null() : StageVar0_LastPackRedemptionDate;
0287: NullSetVar0 = 0;
0288: if (((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.OFFER_CATEGORY_CD == InterVar0_2)) && (In1.PACKAGE_TYPE_CD == InterVar0_10))) {
0289: StageVar0_LastCartonRedemptionDate = In1.CONTACT_DATE;
0290: } else {
0291: if ((In1.keyChange == 1)) {
0292: NullSetVar0 = 1;
0293: } else {
0294: if (((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_2)) && (In1.PACKAGE_TYPE_CD == InterVar0_10)) && null(StageVar0_LastCartonRedemptionDate))) {
0295: StageVar0_LastCartonRedemptionDate = In1.CONTACT_DATE;
0296: } else {
0297: if (((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_2)) && (In1.PACKAGE_TYPE_CD == InterVar0_10)) && (In1.CONTACT_DATE > StageVar0_LastCartonRedemptionDate))) {
0298: StageVar0_LastCartonRedemptionDate = In1.CONTACT_DATE;
0299: } else {
0300: StageVar0_LastCartonRedemptionDate = StageVar0_LastCartonRedemptionDate;
0301: }
0302: //;
0303: }
0304: //;
0305: }
0306: //;
0307: }
0308: StageVar0_LastCartonRedemptionDate = (NullSetVar0 == 1) ? set_null() : StageVar0_LastCartonRedemptionDate;
0309: NullSetVar0 = 0;
0310: if (((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.OFFER_CATEGORY_CD == InterVar0_2)) && (In1.PACKAGE_TYPE_CD == InterVar0_11))) {
0311: StageVar0_LastComboRedemptionDate = In1.CONTACT_DATE;
0312: } else {
0313: if ((In1.keyChange == 1)) {
0314: NullSetVar0 = 1;
0315: } else {
0316: if (((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_2)) && (In1.PACKAGE_TYPE_CD == InterVar0_11)) && null(StageVar0_LastComboRedemptionDate))) {
0317: StageVar0_LastComboRedemptionDate = In1.CONTACT_DATE;
0318: } else {
0319: if (((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.OFFER_CATEGORY_CD == InterVar0_2)) && (In1.PACKAGE_TYPE_CD == InterVar0_11)) && (In1.CONTACT_DATE > StageVar0_LastComboRedemptionDate))) {
0320: StageVar0_LastComboRedemptionDate = In1.CONTACT_DATE;
0321: } else {
0322: StageVar0_LastComboRedemptionDate = StageVar0_LastComboRedemptionDate;
0323: }
0324: //;
0325: }
0326: //;
0327: }
0328: //;
0329: }
0330: StageVar0_LastComboRedemptionDate = (NullSetVar0 == 1) ? set_null() : StageVar0_LastComboRedemptionDate;
0331: StageVar0_LastCouponOfferedDate = InterVar0_12;
0332: StageVar0_LastGiftOfferedDate = InterVar0_12;
0333: NullSetVar0 = 0;
0334: if (((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0))) {
0335: StageVar0_LastProgramRespondedDate = In1.CONTACT_DATE;
0336: } else {
0337: if ((In1.keyChange == 1)) {
0338: NullSetVar0 = 1;
0339: } else {
0340: if (((In1.CONTACT_INITIATOR_CD == InterVar0_0) && null(StageVar0_LastProgramRespondedDate))) {
0341: StageVar0_LastProgramRespondedDate = In1.CONTACT_DATE;
0342: } else {
0343: if (((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.CONTACT_DATE > StageVar0_LastProgramRespondedDate))) {
0344: StageVar0_LastProgramRespondedDate = In1.CONTACT_DATE;
0345: } else {
0346: StageVar0_LastProgramRespondedDate = StageVar0_LastProgramRespondedDate;
0347: }
0348: //;
0349: }
0350: //;
0351: }
0352: //;
0353: }
0354: StageVar0_LastProgramRespondedDate = (NullSetVar0 == 1) ? set_null() : StageVar0_LastProgramRespondedDate;
0355: NullSetVar0 = 0;
0356: if (((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.MEDIA_CATEGORY_CD == InterVar0_13)) && (In1.OFFER_CD == InterVar0_14))) {
0357: StageVar0_LastOpenDate = In1.CONTACT_DATE;
0358: } else {
0359: if ((In1.keyChange == 1)) {
0360: NullSetVar0 = 1;
0361: } else {
0362: if (((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.MEDIA_CATEGORY_CD == InterVar0_13)) && (In1.OFFER_CD == InterVar0_14)) && null(StageVar0_LastOpenDate))) {
0363: StageVar0_LastOpenDate = In1.CONTACT_DATE;
0364: } else {
0365: if (((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.MEDIA_CATEGORY_CD == InterVar0_13)) && (In1.OFFER_CD == InterVar0_14)) && (In1.CONTACT_DATE > StageVar0_LastOpenDate))) {
0366: StageVar0_LastOpenDate = In1.CONTACT_DATE;
0367: } else {
0368: StageVar0_LastOpenDate = StageVar0_LastOpenDate;
0369: }
0370: //;
0371: }
0372: //;
0373: }
0374: //;
0375: }
0376: StageVar0_LastOpenDate = (NullSetVar0 == 1) ? set_null() : StageVar0_LastOpenDate;
0377: NullSetVar0 = 0;
0378: if (((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.MEDIA_CATEGORY_CD == InterVar0_13)) && (substring_1(In1.OFFER_CD , 1 , 1) == InterVar0_15))) {
0379: StageVar0_LastClickDate = In1.CONTACT_DATE;
0380: } else {
0381: if ((In1.keyChange == 1)) {
0382: NullSetVar0 = 1;
0383: } else {
0384: if (((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.MEDIA_CATEGORY_CD == InterVar0_13)) && (substring_1(In1.OFFER_CD , 1 , 1) == InterVar0_15)) && null(StageVar0_LastClickDate))) {
0385: StageVar0_LastClickDate = In1.CONTACT_DATE;
0386: } else {
0387: if (((((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.MEDIA_CATEGORY_CD == InterVar0_13)) && (substring_1(In1.OFFER_CD , 1 , 1) == InterVar0_15)) && (In1.CONTACT_DATE > StageVar0_LastClickDate))) {
0388: StageVar0_LastClickDate = In1.CONTACT_DATE;
0389: } else {
0390: StageVar0_LastClickDate = StageVar0_LastClickDate;
0391: }
0392: //;
0393: }
0394: //;
0395: }
0396: //;
0397: }
0398: StageVar0_LastClickDate = (NullSetVar0 == 1) ? set_null() : StageVar0_LastClickDate;
0399: NullSetVar0 = 0;
0400: if ((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.OFFER_CATEGORY_CD == InterVar0_1))) {
0401: InterVar0_16 = string_num_compare(In1.CONTACT_INITIATOR_CD , In1.OFFER_CATEGORY_CD , 2);
0402: StageVar0_LifeTimeGiftResposes = InterVar0_16;
0403: } else {
0404: NullSetVar0 = 1;
0405: }
0406: StageVar0_LifeTimeGiftResposes = (NullSetVar0 == 1) ? set_null() : StageVar0_LifeTimeGiftResposes;
0407: NullSetVar0 = 0;
0408: if ((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.OFFER_CATEGORY_CD == InterVar0_2))) {
0409: InterVar0_16 = string_num_compare(In1.CONTACT_INITIATOR_CD , In1.OFFER_CATEGORY_CD , 2);
0410: StageVar0_LifeTimeCouponResponses = InterVar0_16;
0411: } else {
0412: NullSetVar0 = 1;
0413: }
0414: StageVar0_LifeTimeCouponResponses = (NullSetVar0 == 1) ? set_null() : StageVar0_LifeTimeCouponResponses;
0415: NullSetVar0 = 0;
0416: if ((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.MEDIA_CATEGORY_CD == InterVar0_3))) {
0417: InterVar0_16 = string_num_compare(In1.CONTACT_INITIATOR_CD , In1.MEDIA_CATEGORY_CD , 2);
0418: StageVar0_LifeTimeEventResponses = InterVar0_16;
0419: } else {
0420: NullSetVar0 = 1;
0421: }
0422: StageVar0_LifeTimeEventResponses = (NullSetVar0 == 1) ? set_null() : StageVar0_LifeTimeEventResponses;
0423: NullSetVar0 = 0;
0424: if ((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.OFFER_CATEGORY_CD == InterVar0_5))) {
0425: InterVar0_16 = string_num_compare(In1.CONTACT_INITIATOR_CD , In1.OFFER_CATEGORY_CD , 2);
0426: StageVar0_LifeTimeSweepsResponses = InterVar0_16;
0427: } else {
0428: NullSetVar0 = 1;
0429: }
0430: StageVar0_LifeTimeSweepsResponses = (NullSetVar0 == 1) ? set_null() : StageVar0_LifeTimeSweepsResponses;
0431: NullSetVar0 = 0;
0432: if (((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_8))) {
0433: InterVar0_16 = string_num_compare(In1.CONTACT_INITIATOR_CD , In1.CONTACT_INITIATOR_CD , 1);
0434: StageVar0_LifeTimeProgramsMailed = InterVar0_16;
0435: } else {
0436: NullSetVar0 = 1;
0437: }
0438: StageVar0_LifeTimeProgramsMailed = (NullSetVar0 == 1) ? set_null() : StageVar0_LifeTimeProgramsMailed;
0439: NullSetVar0 = 0;
0440: if (((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.MEDIA_CATEGORY_CD == InterVar0_13)) && (In1.OFFER_CD == InterVar0_14))) {
0441: InterVar0_17 = string_num_compare(In1.MEDIA_CATEGORY_CD , In1.OFFER_CD , 3);
0442: InterVar0_16 = string_num_compare(In1.CONTACT_INITIATOR_CD , InterVar0_17 , 3);
0443: StageVar0_LifeTimeOpened = InterVar0_16;
0444: } else {
0445: NullSetVar0 = 1;
0446: }
0447: StageVar0_LifeTimeOpened = (NullSetVar0 == 1) ? set_null() : StageVar0_LifeTimeOpened;
0448: NullSetVar0 = 0;
0449: if (((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0))) {
0450: InterVar0_17 = In1.PROGRAM_NUMBER == string_from_timestamp(In1.CONTACT_DATE);
0451: StageVar0_LastProgramRespondedTo = InterVar0_17;
0452: } else {
0453: if ((In1.keyChange == 1)) {
0454: NullSetVar0 = 1;
0455: } else {
0456: if (((In1.CONTACT_INITIATOR_CD == InterVar0_0) && null(StageVar0_LastProgramRespondedTo))) {
0457: InterVar0_18 = In1.PROGRAM_NUMBER == string_from_timestamp(In1.CONTACT_DATE);
0458: StageVar0_LastProgramRespondedTo = InterVar0_18;
0459: } else {
0460: if (((In1.CONTACT_INITIATOR_CD == InterVar0_0) && (In1.CONTACT_DATE > timestamp_from_string(StageVar0_LastProgramRespondedTo)))) {
0461: InterVar0_19 = In1.PROGRAM_NUMBER == string_from_timestamp(In1.CONTACT_DATE);
0462: StageVar0_LastProgramRespondedTo = InterVar0_19;
0463: } else {
0464: StageVar0_LastProgramRespondedTo = StageVar0_LastProgramRespondedTo;
0465: }
0466: //;
0467: }
0468: //;
0469: }
0470: //;
0471: }
0472: StageVar0_LastProgramRespondedTo = (NullSetVar0 == 1) ? set_null() : StageVar0_LastProgramRespondedTo;
0473: NullSetVar0 = 0;
0474: if (((((In1.keyChange == 1) && (In1.CONTACT_INITIATOR_CD == InterVar0_0)) && (In1.MEDIA_CATEGORY_CD == InterVar0_13)) && (substring_1(In1.OFFER_CD , 1 , 1) == InterVar0_15))) {
0475: InterVar0_17 = string_num_compare(In1.MEDIA_CATEGORY_CD , In1.OFFER_CD , 2);
0476: InterVar0_16 = string_num_compare(In1.CONTACT_INITIATOR_CD , InterVar0_17 , 2);
0477: StageVar0_LifeTimeClicked = InterVar0_16;
0478: } else {
0479: NullSetVar0 = 1;
0480: }
0481: StageVar0_LifeTimeClicked = (NullSetVar0 == 1) ? set_null() : StageVar0_LifeTimeClicked;
0482:
0483: // evaluate columns (no constraints) for link: ToLoad
0484: ToLoad.OPCO_CD = In1.OPCO_CD;
0485: ToLoad.INDIVIDUAL_ID = In1.INDIVIDUAL_ID;
0486: ToLoad.BRAND_CD = In1.BRAND_CD;
0487: ToLoad.PRODUCT_LINE_CD = In1.PRODUCT_LINE_CD;
0488: ToLoad.CHANNEL_TYPE_CD = In1.CHANNEL_TYPE_CD;
0489: ToLoad.LAST_GIFT_RESPONSE_DATE = StageVar0_LastGiftResponseDate;
0490: ToLoad.LAST_COUPON_RESPONSE_DATE = StageVar0_LastCouponResponseDate;
0491: ToLoad.LAST_EVENT_RESPONSE_DATE = StageVar0_LastEventResponseDate;
0492: ToLoad.LAST_SWEEPS_CONTEST_RESP_DATE = StageVar0_LastSweepsContestRespDate;
0493: ToLoad.LAST_SURVEY_RESPONSE_DATE = StageVar0_LastSurveyResponseDate;
0494: ToLoad.LAST_MISC_RESPONSE_DATE = StageVar0_LastMiscResponseDate;
0495: ToLoad.LAST_MAILED_DATE = StageVar0_LastMailedDate;
0496: ToLoad.LIFETIME_GIFT_RESPONSES = StageVar0_LifeTimeGiftResposes;
0497: ToLoad.LIFETIME_COUPON_RESPONSES = StageVar0_LifeTimeCouponResponses;
0498: ToLoad.LIFETIME_EVENT_RESPONSES = StageVar0_LifeTimeEventResponses;
0499: ToLoad.LIFETIME_SWEEPS_RESPONSES = StageVar0_LifeTimeSweepsResponses;
0500: ToLoad.LIFETIME_PROGRAMS_MAILED = StageVar0_LifeTimeProgramsMailed;
0501: ToLoad.LAST_PACK_REDEMPTION_DATE = StageVar0_LastPackRedemptionDate;
0502: ToLoad.LAST_CARTON_REDEMPTION_DATE = StageVar0_LastCartonRedemptionDate;
0503: ToLoad.LAST_COMBO_REDEMPTION_DATE = StageVar0_LastComboRedemptionDate;
0504: ToLoad.LAST_COUPON_OFFERED_DATE = StageVar0_LastCouponOfferedDate;
0505: ToLoad.LAST_GIFT_OFFERED_DATE = StageVar0_LastGiftOfferedDate;
0506: ToLoad.LAST_PROGRAM_RESPONDED_TO = StageVar0_LastProgramRespondedTo;
0507: ToLoad.LAST_PROGRAM_RESPONDED_DATE = StageVar0_LastProgramRespondedDate;
0508: ToLoad.LAST_OPEN_DATE = StageVar0_LastOpenDate;
0509: ToLoad.LAST_CLICK_DATE = StageVar0_LastClickDate;
0510: ToLoad.LIFETIME_OPENED = StageVar0_LifeTimeOpened;
0511: ToLoad.LIFETIME_CLICKED = StageVar0_LifeTimeClicked;
0512: writerecord 0;
0513: RowRejected0 = 0;
0514: }
0515:
0516: finish {
0517: }
0518:
*** End of Internal Generated Transformer Code

kwwilliams · Post by **kwwilliams** » Thu Sep 16, 2010 2:46 pm

That helps. You are checking if the stage variable LastGiftResponseDate is null on line 118. There is no property to allow a stage variable to be null. So you cannot set it to null or check to see if it is null.

Many times the error that is causing you grief is not the first thing that you see a warning or error.

lstsaur · Post by **lstsaur** » Thu Sep 16, 2010 2:47 pm

Are you running 7.5.3 version on Windows platform?

sush26283 · Post by **sush26283** » Thu Sep 16, 2010 2:50 pm

lstsaur wrote:Are you running 7.5.3 version on Windows platform?

yup...

sush26283 · Post by **sush26283** » Thu Sep 16, 2010 2:53 pm

kwwilliams wrote:That helps. You are checking if the stage variable LastGiftResponseDate is null on line 118. There is no property to allow a stage variable to be null. So you cannot set it to null or check to see if it is null.

Many times the error that is causing you grief is not the first thing that you see a warning or error.

thanks that does help, can u also plz let me know if how to set the property to set SV as null...