error while compiling transformer stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kavuri
Premium Member
Premium Member
Posts: 161
Joined: Mon Apr 16, 2007 2:56 pm

error while compiling transformer stage

Post by kavuri »

Hi,
I am getting following error while compiling in transformer stage. Can anybody give me a hint what is the problem

Ascential DataStage(tm) Enterprise Edition 7.5.1A
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved


##I TUTL 000031 10:22:38(001) <main_program> The open files limit is 2000; raising to 2147483647.
##I TOSH 000002 10:22:38(002) <main_program> orchgeneral: loaded
##I TOSH 000002 10:22:38(003) <main_program> orchsort: loaded
##I TOSH 000002 10:22:38(004) <main_program> orchstats: loaded
##I TFSC 000001 10:22:38(007) <main_program> APT configuration file: /medstat/advantage/ascential/Ascential/DataStage/Configurations/default.apt
##W TCOS 000049 10:22:38(008) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E TBLD 000000 10:22:39(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 32,512.
##E TFSR 000019 10:22:39(001) <main_program> Could not check all operators because of previous error(s)
##W TFCP 000000 10:22:39(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 10:22:39(003) <transform> Error when checking composite operator: Converting number to string.
##W TFCP 000000 10:22:39(004) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:22:39(005) <transform> Error when checking composite operator: Converting number to string.
##W TFCP 000000 10:22:39(006) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TBLD 000000 10:22:39(007) <main_program> Error when checking composite operator: Output from subprocess: sh: /usr/vacpp/bin/xlC_r: not found.

##I TFCP 000000 10:22:39(008) <transform> Error when checking composite operator: /usr/vacpp/bin/xlC_r -O -I/medstat/advantage/ascential/Ascential/DataStage/PXEngine/include -O -c -qspill=32704 /medstat/advantage/ascential/Ascential/DataStage/Projects/custdev/RT_BP1.O/V0S1_ex1_Transformer_1.C -o /medstat/advantage/ascential/Ascential/DataStage/Projects/custdev/RT_BP1.O/V0S1_ex1_Transformer_1.tmp.o.
##E TCOS 000029 10:22:39(009) <main_program> Creation of a step finished with status = FAILED. (ex1.Transformer_1)

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

Thanks in advance
Kavuri
Top
g_rkrish
Participant
Posts: 264
Joined: Wed Feb 08, 2006 12:06 am

Re: error while compiling transformer stage

Post by g_rkrish »

kavuri wrote:Hi,
I am getting following error while compiling in transformer stage. Can anybody give me a hint what is the problem

Ascential DataStage(tm) Enterprise Edition 7.5.1A
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved


##I TUTL 000031 10:22:38(001) <main_program> The open files limit is 2000; raising to 2147483647.
##I TOSH 000002 10:22:38(002) <main_program> orchgeneral: loaded
##I TOSH 000002 10:22:38(003) <main_program> orchsort: loaded
##I TOSH 000002 10:22:38(004) <main_program> orchstats: loaded
##I TFSC 000001 10:22:38(007) <main_program> APT configuration file: /medstat/advantage/ascential/Ascential/DataStage/Configurations/default.apt
##W TCOS 000049 10:22:38(008) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E TBLD 000000 10:22:39(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 32,512.
##E TFSR 000019 10:22:39(001) <main_program> Could not check all operators because of previous error(s)
##W TFCP 000000 10:22:39(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 10:22:39(003) <transform> Error when checking composite operator: Converting number to string.
##W TFCP 000000 10:22:39(004) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TFCP 000025 10:22:39(005) <transform> Error when checking composite operator: Converting number to string.
##W TFCP 000000 10:22:39(006) <transform> Error when checking composite operator: Implicit conversion from source type "Int32" to result type "String".
##W TBLD 000000 10:22:39(007) <main_program> Error when checking composite operator: Output from subprocess: sh: /usr/vacpp/bin/xlC_r: not found.

##I TFCP 000000 10:22:39(008) <transform> Error when checking composite operator: /usr/vacpp/bin/xlC_r -O -I/medstat/advantage/ascential/Ascential/DataStage/PXEngine/include -O -c -qspill=32704 /medstat/advantage/ascential/Ascential/DataStage/Projects/custdev/RT_BP1.O/V0S1_ex1_Transformer_1.C -o /medstat/advantage/ascential/Ascential/DataStage/Projects/custdev/RT_BP1.O/V0S1_ex1_Transformer_1.tmp.o.
##E TCOS 000029 10:22:39(009) <main_program> Creation of a step finished with status = FAILED. (ex1.Transformer_1)

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

Thanks in advance
Kavuri
did you have XLC compiler in your OS......Pls check that....
RK
Top
kavuri
Premium Member
Premium Member
Posts: 161
Joined: Mon Apr 16, 2007 2:56 pm

Re: error while compiling transformer stage

Post by kavuri »

Hi,
what is this xlc compiler? and How it is going to affect DataStage jobs? How to find I am having a xlc compiler?. If it is there, then what should I do to alleviate the problem?

Thanks
Kavuri
Top
ds_is_fun
Premium Member
Premium Member
Posts: 194
Joined: Fri Jan 07, 2005 12:00 pm

Re: error while compiling transformer stage

Post by ds_is_fun »

Go the end of this post. That should help you.
http://dsxchange.com/viewtopic.php?t=11 ... 5429fac921
Top
kavuri
Premium Member
Premium Member
Posts: 161
Joined: Mon Apr 16, 2007 2:56 pm

Re: error while compiling transformer stage

Post by kavuri »

As I tried the commands, I got following results.

$ lslpp -l | grep xlc
$ find / -name gcc -print 2>/dev/null
/usr/local/bin/gcc
/usr/local/lib/gcc
/usr/local/libexec/gcc

Is this the meaning of where my c++ compiler is installed?

If so Is this in the correct path or not?

What is xlc?

Thanks
Kavuri
Top
kavuri
Premium Member
Premium Member
Posts: 161
Joined: Mon Apr 16, 2007 2:56 pm

Re: error while compiling transformer stage

Post by kavuri »

If I am trying which cc and which gcc commands I am getting following information.

$ which cc
which: 0652-141 There is no cc in /usr/bin /etc /usr/sbin /usr/ucb /home/bhi/bin /usr/bin/X11 /sbin . /home/bhi/sqllib/bin /home/bhi/sqllib/adm /home/bhi/sqllib/misc.
$ which gcc
which: 0652-141 There is no gcc in /usr/bin /etc /usr/sbin /usr/ucb /home/bhi/bin /usr/bin/X11 /sbin . /home/bhi/sqllib/bin /home/bhi/sqllib/adm /home/bhi/sqllib/misc.

Thanks
Kavuri
Top
ds_is_fun
Premium Member
Premium Member
Posts: 194
Joined: Fri Jan 07, 2005 12:00 pm

Re: error while compiling transformer stage

Post by ds_is_fun »

Pl. check with your DS Admin what the APT_COMPILER env variable is set to?
It should be set to a functional c++ compler.
Those who throw objects at crocodiles should be asked to retreive 'em.
Top
kavuri
Premium Member
Premium Member
Posts: 161
Joined: Mon Apr 16, 2007 2:56 pm

Re: error while compiling transformer stage

Post by kavuri »

Hi,
I am able to check in administrator tool that "APT_COMPILER= /usr/vacpp/bin/xlC_r" and APT_LINKER is also set to same.

Can you tell me where the wrong goes.

Thanks
Bhargava
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

Contact your vendor to purchase the xlC compiler.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
kavuri
Premium Member
Premium Member
Posts: 161
Joined: Mon Apr 16, 2007 2:56 pm

Post by kavuri »

I think generally gcc compiler is available on Unix servers, right? Is it compulsory to buy the xlc compiler? or can we change any parameters so that it can run on gcc compiler? Or do we have any alternate way?

Thanks
Kavuri
Top
kavuri
Premium Member
Premium Member
Posts: 161
Joined: Mon Apr 16, 2007 2:56 pm

Post by kavuri »

Can anybody explain what is the problem in Transformer?

Output from transformer compilation follows:

##I TFCN 000001 14:23:16(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 14:23:16(001) <main_program> The open files limit is 2000; raising to 2147483647.
##I TOSH 000002 14:23:16(002) <main_program> orchgeneral: loaded
##I TOSH 000002 14:23:16(003) <main_program> orchsort: loaded
##I TOSH 000002 14:23:16(004) <main_program> orchstats: loaded
##I TFSC 000001 14:23:16(007) <main_program> APT configuration file: /medstat/advantage/ascential/Ascential/DataStage/Configurations/default.apt
##W TCOS 000049 14:23:17(000) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E TBLD 000000 14:23:17(002) <main_program> Error when checking composite operator: Subprocess command failed with exit status 32,512.
##E TFSR 000019 14:23:17(003) <main_program> Could not check all operators because of previous error(s)
##W TFCP 000000 14:23:17(004) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
##W TBLD 000000 14:23:17(005) <main_program> Error when checking composite operator: Output from subprocess: sh: /usr/local/bin/gcc:/usr/local/lib/gcc:/usr/local/libexec/gcc: not found.

##I TFCP 000000 14:23:17(006) <transform> Error when checking composite operator: /usr/local/bin/gcc:/usr/local/lib/gcc:/usr/local/libexec/gcc -O -I/medstat/advantage/ascential/Ascential/DataStage/PXEngine/include -O -c -qspill=32704 /medstat/advantage/ascential/Ascential/DataStage/Projects/custdev/RT_BP1.O/V0S1_ex1_Transformer_1.C -o /medstat/advantage/ascential/Ascential/DataStage/Projects/custdev/RT_BP1.O/V0S1_ex1_Transformer_1.tmp.o.
##E TCOS 000029 14:23:17(007) <main_program> Creation of a step finished with status = FAILED. (ex1.Transformer_1)

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


Thanks
Kavuri
Top
ArndW
Participant
Posts: 16318
Joined: Tue Nov 16, 2004 9:08 am
Location: Germany
Contact:
Contact ArndW

Post by ArndW »

kavuri wrote:...
##W TBLD 000000 14:23:17(005) <main_program> Error when checking composite operator: Output from subprocess: sh: /usr/local/bin/gcc:/usr/local/lib/gcc:/usr/local/libexec/gcc: not found.
Top
kavuri
Premium Member
Premium Member
Posts: 161
Joined: Mon Apr 16, 2007 2:56 pm

Post by kavuri »

Hi,
does this mean there is no gcc compiler?
Can you tell me what is the best compiler suitable for DataStage EE 7.5.1.
Here my problem is currently the server on which we had DataStage is installed is a production server so admin team is not ready to install C++ compiler.
So, now we are finding a new server on which we need to install fresh DataStage. So I would like to know what are the various other components (like C++ compiler etc) are required for proper working of DataStage and what are the best versions or providers.
I appreciate for your valueble comments.

Thanks
Kavuri
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”