DataStage Errors

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
seanc217
Premium Member
Premium Member
Posts: 188
Joined: Thu Sep 15, 2005 9:22 am

DataStage Errors

Post by seanc217 »

I have a job where I have an Oracle Enterprise Stage->Surrogate Key Stage->Transformer->Oracle Enterprise Stage. In my transformer I am converting integer values into dates the format is YYYYDDD. In my derivation I am using the following:

if DSLink26.CIRAMST_DATE_LAST_BNOTICE =0 then setnull() else DateFromDaysSince(DSLink26.CIRAMST_DATE_LAST_BNOTICE[5,3],StringtoDate(DSLink26.CIRAMST_DATE_LAST_BNOTICE[1,4]:"-01-01"))

The job compiles fine up to a point. The source table has many columns as I add more columns as I am testing I get a transformer error:

Output from transformer compilation follows:

##I TFCN 000001 10:52:14(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved


##I TOSH 000002 10:52:14(001) <main_program> orchgeneral: loaded
##I TOSH 000002 10:52:14(002) <main_program> orchsort: loaded
##I TOSH 000002 10:52:14(003) <main_program> orchstats: loaded
##W TFPA 000012 10:52:14(006) <main_program> Warning: the PWD environment variable is not defined. Remote process startup may be unsuccessful as a result.If your ORCHESTRATE job does not start up correctly, please set your PWD variable to a value that will work on all nodes of your system.
##E TBLD 000000 10:52:17(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 512
##E TFSR 000019 10:52:17(001) <main_program> Could not check all operators because of previous error(s)
##W TFCP 000000 10:52:17(002) <transform> Error when checking composite operator: The number of reject datasets "0"is less than the number of input datasets "1".
##W TFCP 000025 10:52:17(003) <transform> Error when checking composite operator: Possible range limitation
##W TFCP 000000 10:52:17(004) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "Decimal".
##W TFCP 000025 10:52:17(005) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(006) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(007) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(008) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(009) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(010) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(011) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(012) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(013) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(014) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(015) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(016) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(017) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(018) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(019) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(020) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(021) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(022) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(023) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(024) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(025) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(026) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(027) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(028) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(029) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(030) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(031) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(032) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(033) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(034) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(035) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(036) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(037) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(038) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(039) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(040) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(041) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(042) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(043) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(044) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(045) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(046) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(047) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(048) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(049) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(050) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(051) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(052) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(053) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(054) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(055) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(056) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(057) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(058) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(059) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(060) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(061) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(062) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(063) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(064) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(065) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(066) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:52:17(067) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 10:52:17(068) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TFCP 000025 10:52:17(069) <transform> Error when checking composite operator: Converting number to string
##W TFCP 000000 10:52:17(070) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##I TFCP 000008 10:52:17(071) <transform> Error when checking composite operator: cxx -O -IE:/Ascential/DataStage/PXEngine/include -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c e:/Ascential/DataStage/Projects/dw_s2/RT_BP6.O/V0S19_Load_Customer_Transformer_19.C -o e:/Ascential/DataStage/Projects/dw_s2/RT_BP6.O/V0S19_Load_Customer_Transformer_19.tmp.o
##I TBLD 000000 10:52:17(072) <main_program> Error when checking composite operator: Output from subprocess: e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(246) : warning C4244: '=' : conversion from 'APT_Int64' to 'int', possible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(382) : error C2026: string too big, trailing characters truncated
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(587) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of data
e:\Ascential
##I TBLD 000000 10:52:17(073) <main_program> Error when checking composite operator: Output from subprocess: \DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(616) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(645) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(674) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of da
##I TBLD 000000 10:52:17(074) <main_program> Error when checking composite operator: Output from subprocess: ta
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(703) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(732) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(761) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', pos
##I TBLD 000000 10:52:17(075) <main_program> Error when checking composite operator: Output from subprocess: sible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(790) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(819) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(848) : warning C4244: '=' : conversion from 'double' to
##I TBLD 000000 10:52:17(076) <main_program> Error when checking composite operator: Output from subprocess: 'APT_Int32', possible loss of data
e:\Ascential\DataStage\Projects\dw_s2\RT_BP6.O\V0S19_Load_Customer_Transformer_19.C(877) : warning C4244: '=' : conversion from 'double' to 'APT_Int32', possible loss of data

##E TCOS 000029 10:52:17(077) <main_program> Creation of step finished with status = FAILED (Load_Customer.Transformer_19)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S19_repos_Transformer_19 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 DSLink26;
0007: outputname 0 DSLink21;
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_3;
0018:
0019: // initialise constant values which require conversion
0020: InterVar0_3 = "-01-01";
0021: }
0022:
0023: mainloop {
0024: // initialise our row rejected variable
0025: RowRejected0 = 1;
0026:
0027: // declare our intermediate variables for this section
0028: string InterVar0_0;
0029: int32 InterVar0_1;
0030: string InterVar0_2;
0031:
0032: // evaluate columns (no constraints) for link: DSLink21
0033: DSLink21.CUST_KEY = DSLink26.CUST_KEY;
0034: DSLink21.RECORD_CODE = DSLink26.CIRAMST_RECORD_CODE;
0035: DSLink21.BANK_NBR = DSLink26.CIRAMST_BANK_NBR;
0036: DSLink21.CUST_NAME_KEY = DSLink26.CIRAMST_CUST_NAME_KEY;
0037: DSLink21.TIE_BREAKER = DSLink26.CIRAMST_TIE_BREAKER;
0038: DSLink21.CS_POINTER = DSLink26.CIRAMST_CS_POINTER;
0039: DSLink21.VARB_LEN = DSLink26.CIRAMST_VARB_LEN;
0040: DSLink21.LINE_CODE_1 = DSLink26.CIRAMST_LINE_CODE_1;
0041: DSLink21.LINE_CODE_2 = DSLink26.CIRAMST_LINE_CODE_2;
0042: DSLink21.LINE_CODE_3 = DSLink26.CIRAMST_LINE_CODE_3;
0043: DSLink21.LINE_CODE_4 = DSLink26.CIRAMST_LINE_CODE_4;
0044: DSLink21.LINE_CODE_5 = DSLink26.CIRAMST_LINE_CODE_5;
0045: DSLink21.LINE_CODE_6 = DSLink26.CIRAMST_LINE_CODE_6;
0046: DSLink21.GREETING = DSLink26.CIRAMST_GREETING;
0047: DSLink21.COMPLIMENT = DSLink26.CIRAMST_COMPLIMENT;
0048: DSLink21.ALT_BANK_NBR = DSLink26.CIRAMST_ALT_BANK_NBR;
0049: DSLink21.ALT_NAME_KEY = DSLink26.CIRAMST_ALT_NAME_KEY;
0050: DSLink21.ALT_TIE_BREAKER = DSLink26.CIRAMST_ALT_TIE_BREAKER;
0051: DSLink21.REG_P_CODE = DSLink26.CIRAMST_REG_P_CODE;
0052: DSLink21.SPEC_HAND = DSLink26.CIRAMST_SPEC_HAND;
0053: DSLink21.RESTRICTED = DSLink26.CIRAMST_RESTRICTED;
0054: DSLink21.REG_O_CODE = DSLink26.CIRAMST_REG_O_CODE;
0055: DSLink21.USER_CODE1 = DSLink26.CIRAMST_USER_CODE1;
0056: DSLink21.USER_CODE2 = DSLink26.CIRAMST_USER_CODE2;
0057: DSLink21.USER_CODE3 = DSLink26.CIRAMST_USER_CODE3;
0058: DSLink21.LAS_MAX_LIABILITY = DSLink26.CIRAMST_LAS_MAX_LIABILITY;
0059: DSLink21.IRA_PART_ST = DSLink26.CIRAMST_IRA_PART_ST;
0060: DSLink21.IRA_DSTRB_WH_FED = DSLink26.CIRAMST_IRA_DSTRB_WH_FED;
0061: DSLink21.IRA_DSTRB_WH_OTH = DSLink26.CIRAMST_IRA_DSTRB_WH_OTH;
0062: DSLink21.IRA_CONTRB_LIMIT = DSLink26.CIRAMST_IRA_CONTRB_LIMIT;
0063: DSLink21.DT_LST_MAINT_TAX = DSLink26.CIRAMST_DT_LST_MAINT_TAX;
0064: DSLink21.DT_LST_MAINT = DSLink26.CIRAMST_DT_LST_MAINT;
0065: DSLink21.DT_ELIGIBLE_DELETE = DSLink26.CIRAMST_DT_ELIGIBLE_DELETE;
0066: DSLink21.USER_CODE4 = DSLink26.CIRAMST_USER_CODE4;
0067: DSLink21.USER_CODE5 = DSLink26.CIRAMST_USER_CODE5;
0068: DSLink21.USER_CODE6 = DSLink26.CIRAMST_USER_CODE6;
0069: DSLink21.FORCE_NOTICE = DSLink26.CIRAMST_FORCE_NOTICE;
0070: NullSetVar0 = 0;
0071: if ((DSLink26.CIRAMST_DATE_LAST_BNOTICE == 0)) {
0072: NullSetVar0 = 1;
0073: } else {
0074: InterVar0_0 = DSLink26.CIRAMST_DATE_LAST_BNOTICE;
0075: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0076: InterVar0_2 = DSLink26.CIRAMST_DATE_LAST_BNOTICE;
0077: DSLink21.DATE_LAST_BNOTICE = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0078: }
0079: //;
0080: DSLink21.NBR_BNOTICES = DSLink26.CIRAMST_NBR_BNOTICES;
0081: NullSetVar0 = 0;
0082: if ((DSLink26.CIRAMST_DATE_LAST_W9 == 0)) {
0083: NullSetVar0 = 1;
0084: } else {
0085: InterVar0_0 = DSLink26.CIRAMST_DATE_LAST_W9;
0086: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0087: InterVar0_2 = DSLink26.CIRAMST_DATE_LAST_W9;
0088: DSLink21.DATE_LAST_W9 = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0089: }
0090: //;
0091: DSLink21.NBR_W9S = DSLink26.CIRAMST_NBR_W9S;
0092: DSLink21.INT_WH_FED = DSLink26.CIRAMST_INT_WH_FED;
0093: DSLink21.INT_WH_OTH = DSLink26.CIRAMST_INT_WH_OTH;
0094: DSLink21.TIN_CERTIFIED = DSLink26.CIRAMST_TIN_CERTIFIED;
0095: NullSetVar0 = 0;
0096: if ((DSLink26.CIRAMST_DATE_CERTIFIED == 0)) {
0097: NullSetVar0 = 1;
0098: } else {
0099: InterVar0_0 = DSLink26.CIRAMST_DATE_CERTIFIED;
0100: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0101: InterVar0_2 = DSLink26.CIRAMST_DATE_CERTIFIED;
0102: DSLink21.DATE_CERTIFIED = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0103: }
0104: //;
0105: NullSetVar0 = 0;
0106: if ((DSLink26.CIRAMST_DATE_REQ_WITHHOLDING == 0)) {
0107: NullSetVar0 = 1;
0108: } else {
0109: InterVar0_0 = DSLink26.CIRAMST_DATE_REQ_WITHHOLDING;
0110: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0111: InterVar0_2 = DSLink26.CIRAMST_DATE_REQ_WITHHOLDING;
0112: DSLink21.DATE_REQ_WITHHOLDING = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0113: }
0114: //;
0115: DSLink21.TAX_EXEMPT = DSLink26.CIRAMST_TAX_EXEMPT;
0116: DSLink21.ID_TYPE = DSLink26.CIRAMST_ID_TYPE;
0117: DSLink21.ID_ISSUED_BY = DSLink26.CIRAMST_ID_ISSUED_BY;
0118: DSLink21.ID_NUMBER = DSLink26.CIRAMST_ID_NUMBER;
0119: DSLink21.REC_CREATE_PGM = DSLink26.CIRAMST_REC_CREATE_PGM;
0120: DSLink21.CUSTOMER_LEVEL = DSLink26.CIRAMST_CUSTOMER_LEVEL;
0121: DSLink21.CALL_AT_HOME = DSLink26.CIRAMST_CALL_AT_HOME;
0122: DSLink21.CALL_AT_WORK = DSLink26.CIRAMST_CALL_AT_WORK;
0123: DSLink21.COM_NBR_1 = DSLink26.CIRAMST_COM_NBR_1;
0124: DSLink21.COM_NBR_2 = DSLink26.CIRAMST_COM_NBR_2;
0125: DSLink21.COM_NBR_3 = DSLink26.CIRAMST_COM_NBR_3;
0126: DSLink21.CTR_EXEMPT = DSLink26.CIRAMST_CTR_EXEMPT;
0127: DSLink21.CRA_GROSS_SALES = DSLink26.CIRAMST_CRA_GROSS_SALES;
0128: DSLink21.CRA_GROSS_INCOME = DSLink26.CIRAMST_CRA_GROSS_INCOME;
0129: DSLink21.CRA_TOTAL_ASSETS = DSLink26.CIRAMST_CRA_TOTAL_ASSETS;
0130: DSLink21.CRA_TOTAL_LIAB = DSLink26.CIRAMST_CRA_TOTAL_LIAB;
0131: DSLink21.CRA_NET_WORTH = DSLink26.CIRAMST_CRA_NET_WORTH;
0132: NullSetVar0 = 0;
0133: if ((DSLink26.CIRAMST_CRA_DATE_LAST_FIN_STMT == 0)) {
0134: NullSetVar0 = 1;
0135: } else {
0136: InterVar0_0 = DSLink26.CIRAMST_CRA_DATE_LAST_FIN_STMT;
0137: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0138: InterVar0_2 = DSLink26.CIRAMST_CRA_DATE_LAST_FIN_STMT;
0139: DSLink21.CRA_DATE_LAST_FIN_STMT = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0140: }
0141: //;
0142: NullSetVar0 = 0;
0143: if ((DSLink26.CIRAMST_CRA_DATE_VERIFIED == 0)) {
0144: NullSetVar0 = 1;
0145: } else {
0146: InterVar0_0 = DSLink26.CIRAMST_CRA_DATE_VERIFIED;
0147: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0148: InterVar0_2 = DSLink26.CIRAMST_CRA_DATE_VERIFIED;
0149: DSLink21.CRA_DATE_VERIFIED = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0150: }
0151: //;
0152: DSLink21.CRA_FIN_STMT_REQUIRED = DSLink26.CIRAMST_CRA_FIN_STMT_REQUIRED;
0153: NullSetVar0 = 0;
0154: if ((DSLink26.CIRAMST_DATE_ADDED == 0)) {
0155: NullSetVar0 = 1;
0156: } else {
0157: InterVar0_0 = DSLink26.CIRAMST_DATE_ADDED;
0158: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0159: InterVar0_2 = DSLink26.CIRAMST_DATE_ADDED;
0160: DSLink21.DATE_ADDED = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0161: }
0162: //;
0163: DSLink21.TIME_ADDED = DSLink26.CIRAMST_TIME_ADDED;
0164: DSLink21.USER_ADDED = DSLink26.CIRAMST_USER_ADDED;
0165: DSLink21.TERM_ADDED = DSLink26.CIRAMST_TERM_ADDED;
0166: DSLink21.SIC = DSLink26.CIRAMST_SIC;
0167: NullSetVar0 = 0;
0168: if ((DSLink26.CIRAMST_DATE_FIRST_ROTH_IRA == 0)) {
0169: NullSetVar0 = 1;
0170: } else {
0171: InterVar0_0 = DSLink26.CIRAMST_DATE_FIRST_ROTH_IRA;
0172: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0173: InterVar0_2 = DSLink26.CIRAMST_DATE_FIRST_ROTH_IRA;
0174: DSLink21.DATE_FIRST_ROTH_IRA = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0175: }
0176: //;
0177: NullSetVar0 = 0;
0178: if ((DSLink26.CIRAMST_DATE_FIRST_ROTH_CONV == 0)) {
0179: NullSetVar0 = 1;
0180: } else {
0181: InterVar0_0 = DSLink26.CIRAMST_DATE_FIRST_ROTH_CONV;
0182: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0183: InterVar0_2 = DSLink26.CIRAMST_DATE_FIRST_ROTH_CONV;
0184: DSLink21.DATE_FIRST_ROTH_CONV = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0185: }
0186: //;
0187: NullSetVar0 = 0;
0188: if ((DSLink26.CIRAMST_DATE_FIRST_SIMPLE_IRA == 0)) {
0189: NullSetVar0 = 1;
0190: } else {
0191: InterVar0_0 = DSLink26.CIRAMST_DATE_FIRST_SIMPLE_IRA;
0192: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0193: InterVar0_2 = DSLink26.CIRAMST_DATE_FIRST_SIMPLE_IRA;
0194: DSLink21.DATE_FIRST_SIMPLE_IRA = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0195: }
0196: //;
0197: NullSetVar0 = 0;
0198: if ((DSLink26.CIRAMST_DATE_LAST_CREDIT_RPT == 0)) {
0199: NullSetVar0 = 1;
0200: } else {
0201: InterVar0_0 = DSLink26.CIRAMST_DATE_LAST_CREDIT_RPT;
0202: InterVar0_1 = substring_1(InterVar0_0 , 5 , 3);
0203: InterVar0_2 = DSLink26.CIRAMST_DATE_LAST_CREDIT_RPT;
0204: DSLink21.DATE_LAST_CREDIT_RPT = date_from_days_since(InterVar0_1 , string_from_date(date_from_string((substring_1(InterVar0_2 , 1 , 4) + InterVar0_3))));
0205: }
0206: //;
0207: DSLink21.CUST_TYPE = DSLink26.CIRAMST_CUST_TYPE;
0208: DSLink21.CREDIT_RATING = DSLink26.CIRAMST_CREDIT_RATING;
0209: DSLink21.CREDIT_RATED_BY = DSLink26.CIRAMST_CREDIT_RATED_BY;
0210: DSLink21.OFFICER = DSLink26.CIRAMST_OFFICER;
0211: DSLink21.BRANCH = DSLink26.CIRAMST_BRANCH;
0212: DSLink21.FED_WTHLD_PERCENT = DSLink26.CIRAMST_FED_WTHLD_PERCENT;
0213: DSLink21.ST_WTHLD_PERCENT = DSLink26.CIRAMST_ST_WTHLD_PERCENT;
0214: DSLink21.IRA_CONTR_ANNUAL_MAX = DSLink26.CIRAMST_IRA_CONTR_ANNUAL_MAX;
0215: DSLink21.CUST_SOURCE = DSLink26.CIRAMST_CUST_SOURCE;
0216: DSLink21.ADDL_SOURCE_INFO = DSLink26.CIRAMST_ADDL_SOURCE_INFO;
0217: DSLink21.BUS_TYPE = DSLink26.CIRAMST_BUS_TYPE;
0218: DSLink21.BUS_SUB_TYPE = DSLink26.CIRAMST_BUS_SUB_TYPE;
0219: DSLink21.BUS_STARTED_DATE = DSLink26.CIRAMST_BUS_STARTED_DATE;
0220: DSLink21.BUS_RESOLUTION_DATE = DSLink26.CIRAMST_BUS_RESOLUTION_DATE;
0221: DSLink21.BUS_WIRE_TRF_RES_DATE = DSLink26.CIRAMST_BUS_WIRE_TRF_RES_DATE;
0222: DSLink21.BUS_INCORPORATION_DATE = DSLink26.CIRAMST_BUS_INCORPORATION_DATE;
0223: DSLink21.BUS_INCORPORATION_ST = DSLink26.CIRAMST_BUS_INCORPORATION_ST;
0224: DSLink21.BUS_SIG_OPEN_DEPOSIT = DSLink26.CIRAMST_BUS_SIG_OPEN_DEPOSIT;
0225: DSLink21.BUS_SIG_WD_DEP_FUNDS = DSLink26.CIRAMST_BUS_SIG_WD_DEP_FUNDS;
0226: DSLink21.BUS_SIG_BORROW_FUNDS = DSLink26.CIRAMST_BUS_SIG_BORROW_FUNDS;
0227: DSLink21.BUS_SIG_PLEDGE_COLL = DSLink26.CIRAMST_BUS_SIG_PLEDGE_COLL;
0228: DSLink21.BUS_SIG_OPEN_SAFE_DEP = DSLink26.CIRAMST_BUS_SIG_OPEN_SAFE_DEP;
0229: DSLink21.BUS_SIG_RLSE_NOTICE = DSLink26.CIRAMST_BUS_SIG_RLSE_NOTICE;
0230: DSLink21.BUS_ORAL_IN_PERSON = DSLink26.CIRAMST_BUS_ORAL_IN_PERSON;
0231: DSLink21.BUS_ORAL_BY_PHONE = DSLink26.CIRAMST_BUS_ORAL_BY_PHONE;
0232: DSLink21.BUS_WRITING_ORIG_SIG = DSLink26.CIRAMST_BUS_WRITING_ORIG_SIG;
0233: DSLink21.BUS_FAX_TRANSMISSION = DSLink26.CIRAMST_BUS_FAX_TRANSMISSION;
0234: DSLink21.BUS_ELEC_TRANSMISSION = DSLink26.CIRAMST_BUS_ELEC_TRANSMISSION;
0235: DSLink21.BUS_CALL_REPET = DSLink26.CIRAMST_BUS_CALL_REPET;
0236: DSLink21.BUS_CALL_NONREPET = DSLink26.CIRAMST_BUS_CALL_NONREPET;
0237: DSLink21.BUS_WTRF_SECURITY = DSLink26.CIRAMST_BUS_WTRF_SECURITY;
0238: DSLink21.COMM_TRF_TYPE = DSLink26.CIRAMST_COMM_TRF_TYPE;
0239: DSLink21.COMM_TRF_LIMIT = DSLink26.CIRAMST_COMM_TRF_LIMIT;
0240: DSLink21.COMM_TRF_DLY_LIMIT = DSLink26.CIRAMST_COMM_TRF_DLY_LIMIT;
0241: DSLink21.COMM_TRF_ADV_DAYS = DSLink26.CIRAMST_COMM_TRF_ADV_DAYS;
0242: DSLink21.DATE_LAST_CHEX_RPT = DSLink26.CIRAMST_DATE_LAST_CHEX_RPT;
0243: DSLink21.CHEX_RPT_BY = DSLink26.CIRAMST_CHEX_RPT_BY;
0244: writerecord 0;
0245: RowRejected0 = 0;
0246: }
0247:
0248: finish {
0249: }
0250:
*** End of Internal Generated Transformer Code


Thanks
Top
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post by DSguru2B »

I would suggest you to check your column datatypes.
There should be no explecit conversion of datatypes.Proper null handling should also be adhered.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Top
seanc217
Premium Member
Premium Member
Posts: 188
Joined: Thu Sep 15, 2005 9:22 am

Post by seanc217 »

Hi everyone.

I got a reply from tech support on this one, it's an issue with the c++ compiler. I have been waiting about 3 weeks or so now for a resolution to this. Fortunately I will be migrating to Linux boxes which should resolve the issue.

The text of the problem as defined by tech support follows:

Engineering has looked at the issue and it looks like the length of one of
the strings being put into your data is too long for one of the fields.
The error that is being referred to here is coming from the Microsoft
compiler...

See
http://msdn.microsoft.com/library/defau ... vccore/htm
l/C2026.asp for a deeper description.

They asked me to set APT_TRANSFORM_OPERATOR_DEBUG, which allows the .C that
is generated during the failed compile to be left around. I have done this
and sent them the .C file. Now that they have this they feel that they
should be able to find the issue and generate a fix.

So we have moved forward, but no final resolution yet. Please let me know
if you have any questions. Thanks.
Top
sidharth
Participant
Posts: 19
Joined: Mon Nov 07, 2005 1:47 am

Post by sidharth »

Hi seanc217,
I am facing a similar kind of issue, pls view the below thread

viewtopic.php?t=103467&highlight=c2026

Did you get a resolution for the error code:c2026 .

Thanks,
Sidharth
Top
seanc217
Premium Member
Premium Member
Posts: 188
Joined: Thu Sep 15, 2005 9:22 am

Post by seanc217 »

Yes.

Same problem I have.
Still do. Engineering provided me a patch, but when I install it, it does not work. I have not heard anything new from them in quite some time now.

I would report it.

Sean
Top
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Try to create a userdefined variable PWD and point to your project directory or '.'.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Top
sidharth
Participant
Posts: 19
Joined: Mon Nov 07, 2005 1:47 am

Post by sidharth »

I tried, this doent work either.
Top
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

I guess, now you got different error than what you pasted above :roll:
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”