We have installed Datastage PX 7.5.2x recently. We developed some sample jobs and the jobs are working fine if we don't use Transformer stage.
When we are creating a job with Transformer stage, during compilation we are facing the below error.
Output from transformer compilation follows:
##I TFCN 000001 10:16:02(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:16:02(001) <main_program> orchgeneral: loaded
##I TOSH 000002 10:16:02(002) <main_program> orchsort: loaded
##I TOSH 000002 10:16:02(003) <main_program> orchstats: loaded
##W TFPA 000012 10:16:02(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:16:02(008) <main_program> Error when checking composite operator: Subprocess command failed with exit status 256
##E TFSR 000019 10:16:02(009) <main_program> Could not check all operators because of previous error(s)
##W TFCP 000000 10:16:02(010) <transform> Error when checking composite operator: The number of reject datasets "0"is less than the number of input datasets "1".
##W TBLD 000000 10:16:02(011) <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 10:16:02(012) <transform> Error when checking composite operator: cxx -O -ID:/ascential/datastage_server/PXEngine/include -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c D:/Ascential/datastage_server/ETL_Dev/RT_BP2.O/V0S5_Dbase_Test_Transformer_5.C -o D:/Ascential/datastage_server/ETL_Dev/RT_BP2.O/V0S5_Dbase_Test_Transformer_5.tmp.o
##E TCOS 000029 10:16:02(013) <main_program> Creation of step finished with status = FAILED (Dbase_Test.Transformer_5)
BalageBaju wrote:##W TBLD 000000 10:16:02(011) <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.
Looks like a missing or incorrectly set up C++ compiler.
We have re-installed Datastage but the problem is still persists. This time we are getting the error message as follows:
Output from transformer compilation follows:
##I TFCN 000001 13:55:13(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved
##I TOSH 000002 13:55:13(001) <main_program> orchgeneral: loaded
##I TOSH 000002 13:55:13(002) <main_program> orchsort: loaded
##I TOSH 000002 13:55:13(003) <main_program> orchstats: loaded
##E TBLD 000000 13:55:15(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 256
##E TFSR 000019 13:55:15(001) <main_program> Could not check all operators because of previous error(s)
##W TFCP 000000 13:55:15(002) <transform> Error when checking composite operator: The number of reject datasets "0"is less than the number of input datasets "1".
##I TFCP 000008 13:55:15(003) <transform> Error when checking composite operator: cxx -O -IC:/Ascential/DataStage/PXEngine/include -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c C:/Ascential/DataStage/Projects/ETL/RT_BP1.O/V0S2_Seq_File_Transformer_2.C -o C:/Ascential/DataStage/Projects/ETL/RT_BP1.O/V0S2_Seq_File_Transformer_2.tmp.o
##I TBLD 000000 13:55:15(004) <main_program> Error when checking composite operator: Output from subprocess: Compiler "cl" not found.
##E TCOS 000029 13:55:15(005) <main_program> Creation of step finished with status = FAILED (Seq_File.Transformer_2)
is pretty clear. You need a c++ compiler in order to compile transform stages. This is documented clearly (and often) in the docs as well posted many times here on DSXChange.
Install the C++ compiler version 2003 and try to remove the last few values from compiler environment variables,as i did when i got the same error message while compiling my job with range lookup