Transformer not compiling
Posted: Wed Feb 03, 2010 10:03 am
**Note - Please do not entitle posts "DataStage" - put something meaningful in your title to enable searches to find it later. Title changed to be more descriptive - Andy**
I am installed datastage and i have used the transformer stage in my job,but the job is not running
Output from transformer compilation follows:
##I TFCN 000001 21:21:07(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TOSH 000002 21:21:07(001) <main_program> orchgeneral: loaded
##I TOSH 000002 21:21:07(002) <main_program> orchsort: loaded
##I TOSH 000002 21:21:07(003) <main_program> orchstats: loaded
##W TFPA 000012 21:21:07(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 21:21:08(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 256
##E TFSR 000019 21:21:08(001) <main_program> Could not check all operators because of previous error(s)
##W TFCP 000000 21:21:08(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 21:21:08(003) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 21:21:08(004) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TBLD 000000 21:21:08(005) <main_program> Error when checking composite operator: Output from subprocess: cxx: file 'C:/PROGRA~1/MKSTOO~1/etc/cxx.ccg': The system cannot find the file specified.
##I TFCP 000008 21:21:08(006) <transform> Error when checking composite operator: cxx -O -IC:/Ascential/DataStage/PXEngine/include -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c -W/Zc:wchar_t- C:/Ascential/DataStage/Projects/giri/RT_BP1.O/V0S11_tfr_Transformer_11.C -o C:/Ascential/DataStage/Projects/giri/RT_BP1.O/V0S11_tfr_Transformer_11.tmp.o
##E TCOS 000029 21:21:08(007) <main_program> Creation of step finished with status = FAILED (tfr.Transformer_11)
*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S11_repos_Transformer_11 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 DSLink2;
0007: outputname 0 DSLink4;
0008:
0009: initialize {
0010: // define our row rejected variable
0011: int8 RowRejected0;
0012:
0013: // define our null set variable
0014: int8 NullSetVar0;
0015:
0016: }
0017:
0018: mainloop {
0019: // initialise our row rejected variable
0020: RowRejected0 = 1;
0021:
0022: // evaluate columns (no constraints) for link: DSLink4
0023: DSLink4.numberss = DSLink2.numberss;
0024: writerecord 0;
0025: RowRejected0 = 0;
0026: }
0027:
0028: finish {
0029: }
0030:
*** End of Internal Generated Transformer Code
I am installed datastage and i have used the transformer stage in my job,but the job is not running
Output from transformer compilation follows:
##I TFCN 000001 21:21:07(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TOSH 000002 21:21:07(001) <main_program> orchgeneral: loaded
##I TOSH 000002 21:21:07(002) <main_program> orchsort: loaded
##I TOSH 000002 21:21:07(003) <main_program> orchstats: loaded
##W TFPA 000012 21:21:07(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 21:21:08(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 256
##E TFSR 000019 21:21:08(001) <main_program> Could not check all operators because of previous error(s)
##W TFCP 000000 21:21:08(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 21:21:08(003) <transform> Error when checking composite operator: Converting string to number
##W TFCP 000000 21:21:08(004) <transform> Error when checking composite operator: Implicit conversion from source type "String" to result type "Int32".
##W TBLD 000000 21:21:08(005) <main_program> Error when checking composite operator: Output from subprocess: cxx: file 'C:/PROGRA~1/MKSTOO~1/etc/cxx.ccg': The system cannot find the file specified.
##I TFCP 000008 21:21:08(006) <transform> Error when checking composite operator: cxx -O -IC:/Ascential/DataStage/PXEngine/include -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c -W/Zc:wchar_t- C:/Ascential/DataStage/Projects/giri/RT_BP1.O/V0S11_tfr_Transformer_11.C -o C:/Ascential/DataStage/Projects/giri/RT_BP1.O/V0S11_tfr_Transformer_11.tmp.o
##E TCOS 000029 21:21:08(007) <main_program> Creation of step finished with status = FAILED (tfr.Transformer_11)
*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S11_repos_Transformer_11 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 DSLink2;
0007: outputname 0 DSLink4;
0008:
0009: initialize {
0010: // define our row rejected variable
0011: int8 RowRejected0;
0012:
0013: // define our null set variable
0014: int8 NullSetVar0;
0015:
0016: }
0017:
0018: mainloop {
0019: // initialise our row rejected variable
0020: RowRejected0 = 1;
0021:
0022: // evaluate columns (no constraints) for link: DSLink4
0023: DSLink4.numberss = DSLink2.numberss;
0024: writerecord 0;
0025: RowRejected0 = 0;
0026: }
0027:
0028: finish {
0029: }
0030:
*** End of Internal Generated Transformer Code