SCD stage error

[srinivas.g]

I am getting following error message, It is just asample job which is using id, name mobile, address, startdate and enddate column. suource is a file and lookup is DB table and updates table and fact table data goes into dataset..

Prakash Rao K

Output from transformer compilation follows:

##I IIS-DSEE-TFCN-00001 06:33:05(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.0.1.4927
Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved



##I IIS-DSEE-TUTL-00031 06:33:05(001) <main_program> The open files limit is 15000; raising to 65536.
##I IIS-DSEE-TOSH-00002 06:33:05(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 06:33:05(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 06:33:05(004) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 06:33:05(007) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E IIS-DSEE-TBLD-00076 06:33:06(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 256.
##E IIS-DSEE-TFSR-00019 06:33:06(001) <main_program> Could not check all operators because of previous error(s)
##W IIS-DSEE-TFTM-00012 06:33:06(002) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
##W IIS-DSEE-TBLD-00000 06:33:06(003) <main_program> Error when checking composite operator: Output from subprocess: sh: /opt/SUNWspro/bin/CC
##W IIS-DSEE-TBLD-00000 06:33:06(004) <main_program> Error when checking composite operator: Output from subprocess: : not found

##I IIS-DSEE-TBLD-00079 06:33:06(005) <transform> Error when checking composite operator: /opt/SUNWspro/bin/CC -KPIC -O -I/opt/IBM/InformationServer/Server/PXEngine/include -dalign -O -PIC -library=iostream -c /opt/IBM/InformationServer/Server/Projects/GDRMigration/RT_BP198.O/V0S1_SCD_Slowly_Changing_Dimension_1.C -o /opt/IBM/InformationServer/Server/Projects/GDRMigration/RT_BP198.O/V0S1_SCD_Slowly_Changing_Dimension_1.tmp.o.
##E IIS-DSEE-TCOS-00029 06:33:06(006) <main_program> Creation of a step finished with status = FAILED. (SCD.Slowly_Changing_Dimension_1)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S1_SCD_Slowly_Changing_Dimension_1 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 DSLink10;
0007: tablename 0 DSLink4;
0008: outputname 0 DSLink7;
0009: outputname 1 DSLink8;
0010:
0011: initialize {
0012: // define our row rejected variable
0013: int8 RowRejected0;
0014:
0015: // define our null set variable
0016: int8 NullSetVar0;
0017:
0018: // define our SCD surrogate key variables
0019: string SurrKey_id0;
0020: int32 SurrKey_rc0;
0021: int32 SeedValue0;
0022: uint64 surrKey0;
0023:
0024: }
0025:
0026: mainloop {
0027: // initialise our row rejected variable
0028: RowRejected0 = 1;
0029:
0030: // no condition for lookup link: DSLink4
0031: lookup(DSLink4);
0032: if (!is_match(DSLink4))
0033: {
0034: // In memory list
0035: DSLink4.ID = DSLink10.ID;
0036: DSLink4.NAME = DSLink10.NAME;
0037: DSLink4.PHONE = DSLink10.PHONE;
0038: DSLink4.MOBILE = DSLink10.MOBILE;
0039: DSLink4.ADDRESS = DSLink10.ADDRESS;
0040: DSLink4.STARTDATE = timestamp_from_string(DSLink10.STARTDATE);
0041: DSLink4.ENDDATE = timestamp_from_string(DSLink10.ENDDATE);
0042:
0043: insert_record (DSLink4);
0044:
0045: // Update list
0046: DSLink8.ID = DSLink10.ID;
0047: DSLink8.NAME = DSLink10.NAME;
0048: DSLink8.PHONE = DSLink10.PHONE;
0049: DSLink8.MOBILE = DSLink10.MOBILE;
0050: DSLink8.ADDRESS = DSLink10.ADDRESS;
0051: DSLink8.STARTDATE = DSLink10.STARTDATE;
0052: DSLink8.ENDDATE = DSLink10.ENDDATE;
0053:
0054: writerecord 1;
0055:
0056: }
0057: else
0058: {
0059: //If there are SCD type 1 columns and their values have changed
0060: if (DSLink4.ID != DSLink10.ID)
0061: {
0062: // Update inmemory table
0063:
0064: fill_update_record(DSLink4);
0065:
0066: // In memory list type 1 only
0067: DSLink4.ID = DSLink10.ID;
0068:
0069: update_record (DSLink4);
0070:
0071: // Update dimension table row
0072: DSLink8.ID = DSLink10.ID;
0073: // Update expire list type 2 only
0074:
0075: writerecord 1;
0076:
0077: }
0078: }
0079: DSLink7.ID = DSLink10.ID;
0080: DSLink7.NAME = DSLink10.NAME;
0081: DSLink7.PHONE = DSLink10.PHONE;
0082: DSLink7.MOBILE = DSLink10.MOBILE;
0083: DSLink7.ADDRESS = DSLink10.ADDRESS;
0084: DSLink7.STARTDATE = DSLink10.STARTDATE;
0085: DSLink7.ENDDATE = DSLink10.ENDDATE;
0086: writerecord 0;
0087: }
0088:
0089: finish {
0090: }
0091:
*** End of Internal Generated Transformer Code

[JRodriguez]

Srinivas,

I was having same error and it was related to C++ compiler not properly set up

Try to compile any other job having a transformer stage ...


Hope that this help

Julio