Error when using Transformer stage

BalageBaju · Post by **BalageBaju** » Thu Mar 27, 2008 6:58 am

Hi All,

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)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S5_repos_Transformer_5 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 DSLink2;
0007: outputname 0 DSLink6;
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: DSLink6
0023: writerecord 0;
0024: RowRejected0 = 0;
0025: }
0026:
0027: finish {
0028: }
0029:
*** End of Internal Generated Transformer Code

Please help us to rid out from this error.

rajngt · Post by **rajngt** » Thu Mar 27, 2008 7:21 am

You have to add a user-defined environment variable as PWD with value .(dot) in datastage administrator

ArndW · Post by **ArndW** » Thu Mar 27, 2008 7:24 am

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.

BalageBaju · Post by **BalageBaju** » Mon Mar 31, 2008 2:44 am

Hi,

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)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S2_repos_Transformer_2 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 DSLink3;
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: writerecord 0;
0024: RowRejected0 = 0;
0025: }
0026:
0027: finish {
0028: }
0029:
*** End of Internal Generated Transformer Code

Jobs are working fine if we are not using Transformer stage.

Do we need to install any c++ compilers seperately to run parallel jobs?

I am not able to find the option to move the post to Parallel forum.

Any help is appreciated!

ArndW · Post by **ArndW** » Mon Mar 31, 2008 4:15 am

Compiler "cl" not found.

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.

Minhajuddin · Post by **Minhajuddin** » Mon Mar 31, 2008 4:32 am

You need to install Microsoft dot net 2003 for this. Datastage uses the C++ compiler of this version to compile Transformer stages.

BalageBaju · Post by **BalageBaju** » Mon Mar 31, 2008 6:44 am

Hi,

We have installed dot net 2003 and its resolved our problem.

Thanks to everyone.

DS_FocusGroup · Post by **DS_FocusGroup** » Tue Jun 24, 2008 5:24 am

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

FROM

APT_COMPILEOPT=-W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c -W/Zc:wchar_t-
APT_LINKOPT =-s -W/dll -W/base:0x50000000 -W/Zc:wchar_t-

TO

APT_COMPILEOPT=-W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c
APT_LINKOPT =-s -W/dll -W/base:0x50000000

and it worked , hope it will do the same for your problem

DSXchange

Error when using Transformer stage

Error when using Transformer stage

Re: Error when using Transformer stage

Re: Error when using Transformer stage