Transformer wont compile
Posted: Tue Mar 06, 2007 11:00 am
We have several jobs that are set up the same way. Each job contains a transformer in which we add the DSJobStartTimestamp as well as reassign the change data capture code 1,2,3 to I,D,C other then that the only difference are the fields. All the jobs work but one. When trying to compile it fails at the transformer stage and spits out the below information. Has anyone seen this before? I even tried to recreate the job and received the same result.
Output from transformer compilation follows:
##I TFCN 000001 10:58:31(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.1A
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TUTL 000031 10:58:31(001) <main_program> The open files limit is 2000; raising to 2147483647.
##W TOSH 000001 10:58:31(002) <main_program> orchgeneral: Could not load "orchgeneral": Bad address
##W TOSH 000001 10:58:31(003) <main_program> orchsort: Could not load "orchsort": Bad address
##W TOSH 000001 10:58:31(004) <main_program> orchstats: Could not load "orchstats": Bad address
##I TFSC 000001 10:58:31(007) <main_program> APT configuration file: /opt/Ascential/DataStage/Configurations/defaultcw.apt
##W TCOS 000049 10:58:31(008) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E TOSH 000205 10:58:31(009) <main_program> PATH search failure:
##E TOSH 000000 10:58:31(010) <main_program> Error loading "orchbuildop": Could not load "orchbuildop": Bad address.
##E TOSH 000000 10:58:31(011) <main_program> Could not locate operator definition, wrapper, or Unix command for "transform"; please check that all needed libraries are preloaded, and check the PATH for the wrappers
##E TCOS 000029 10:58:31(012) <main_program> Creation of a step finished with status = FAILED. (JACPAYM0_CHANGE2.Transformer_28)
*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S28_repos_Transformer_28 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 DSLink11;
0007: outputname 0 DSLink29;
0008:
0009: global {
0010: string DSJobStartTimestamp;
0011: }
0012:
0013: initialize {
0014: // define our row rejected variable
0015: int8 RowRejected0;
0016:
0017: // define our null set variable
0018: int8 NullSetVar0;
0019:
0020: // declare our intermediate variables for this section
0021: string InterVar0_0;
0022: string InterVar0_1;
0023: string InterVar0_2;
0024:
0025: // initialise constant values which require conversion
0026: InterVar0_0 = "I";
0027: InterVar0_1 = "D";
0028: InterVar0_2 = "C";
0029: }
0030:
0031: mainloop {
0032: // initialise our row rejected variable
0033: RowRejected0 = 1;
0034:
0035: // evaluate columns (no constraints) for link: DSLink29
0036: DSLink29.DATESTAMP = timestamp_from_string(DSJobStartTimestamp);
0037: if ((DSLink11.CHANGE_TYPE == 1)) {
0038: DSLink29.CHANGE_TYPE = InterVar0_0;
0039: } else {
0040: if ((DSLink11.CHANGE_TYPE == 2)) {
0041: DSLink29.CHANGE_TYPE = InterVar0_1;
0042: } else {
0043: DSLink29.CHANGE_TYPE = InterVar0_2;
0044: }
0045: //;
0046: }
0047: //;
0048: writerecord 0;
0049: RowRejected0 = 0;
0050: }
0051:
0052: finish {
0053: }
0054:
*** End of Internal Generated Transformer Code
Output from transformer compilation follows:
##I TFCN 000001 10:58:31(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.1A
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TUTL 000031 10:58:31(001) <main_program> The open files limit is 2000; raising to 2147483647.
##W TOSH 000001 10:58:31(002) <main_program> orchgeneral: Could not load "orchgeneral": Bad address
##W TOSH 000001 10:58:31(003) <main_program> orchsort: Could not load "orchsort": Bad address
##W TOSH 000001 10:58:31(004) <main_program> orchstats: Could not load "orchstats": Bad address
##I TFSC 000001 10:58:31(007) <main_program> APT configuration file: /opt/Ascential/DataStage/Configurations/defaultcw.apt
##W TCOS 000049 10:58:31(008) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E TOSH 000205 10:58:31(009) <main_program> PATH search failure:
##E TOSH 000000 10:58:31(010) <main_program> Error loading "orchbuildop": Could not load "orchbuildop": Bad address.
##E TOSH 000000 10:58:31(011) <main_program> Could not locate operator definition, wrapper, or Unix command for "transform"; please check that all needed libraries are preloaded, and check the PATH for the wrappers
##E TCOS 000029 10:58:31(012) <main_program> Creation of a step finished with status = FAILED. (JACPAYM0_CHANGE2.Transformer_28)
*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S28_repos_Transformer_28 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 DSLink11;
0007: outputname 0 DSLink29;
0008:
0009: global {
0010: string DSJobStartTimestamp;
0011: }
0012:
0013: initialize {
0014: // define our row rejected variable
0015: int8 RowRejected0;
0016:
0017: // define our null set variable
0018: int8 NullSetVar0;
0019:
0020: // declare our intermediate variables for this section
0021: string InterVar0_0;
0022: string InterVar0_1;
0023: string InterVar0_2;
0024:
0025: // initialise constant values which require conversion
0026: InterVar0_0 = "I";
0027: InterVar0_1 = "D";
0028: InterVar0_2 = "C";
0029: }
0030:
0031: mainloop {
0032: // initialise our row rejected variable
0033: RowRejected0 = 1;
0034:
0035: // evaluate columns (no constraints) for link: DSLink29
0036: DSLink29.DATESTAMP = timestamp_from_string(DSJobStartTimestamp);
0037: if ((DSLink11.CHANGE_TYPE == 1)) {
0038: DSLink29.CHANGE_TYPE = InterVar0_0;
0039: } else {
0040: if ((DSLink11.CHANGE_TYPE == 2)) {
0041: DSLink29.CHANGE_TYPE = InterVar0_1;
0042: } else {
0043: DSLink29.CHANGE_TYPE = InterVar0_2;
0044: }
0045: //;
0046: }
0047: //;
0048: writerecord 0;
0049: RowRejected0 = 0;
0050: }
0051:
0052: finish {
0053: }
0054:
*** End of Internal Generated Transformer Code