Transformer Compilation Error in AIX

vkoppala · Post by **vkoppala** » Wed Feb 21, 2007 2:56 pm

I had installed EEdition & Server(7.5.1a) in the AIX Machine and i work from the client on windows (7.5.1a), the server jobs are working properly, but the parallel job which contains a transformer was not getting compiled. the error is as follows

----------------------------------------------
------------------------------------------------
Output from transformer compilation follows:

##I TFCN 000001 14:20:56(000) <main_program>
Ascential DataStage(tm) Enterprise Edition 7.5.1A
Copyright (c) 2004, 1997-2004 Ascential Software Corporation.
All Rights Reserved

##I TOSH 000002 14:20:56(001) <main_program> orchgeneral: loaded
##I TOSH 000002 14:20:56(002) <main_program> orchsort: loaded
##I TOSH 000002 14:20:56(003) <main_program> orchstats: loaded
##I TFSC 000001 14:20:56(006) <main_program> APT configuration file: /home/dsadm/Ascential/DataStage/Configurations/default.apt
##W TCOS 000049 14:20:56(007) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E TBLD 000000 14:20:56(009) <main_program> Error when checking composite operator: Subprocess command failed with exit status 32,512.
##E TFSR 000019 14:20:56(010) <main_program> Could not check all operators because of previous error(s)
##W TFCP 000000 14:20:56(011) <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:20:56(012) <main_program> Error when checking composite operator: Output from subprocess: sh: /usr/bin:/usr/lib:/usr/ccs/lib:: not found.

##I TFCP 000000 14:20:56(013) <transform> Error when checking composite operator: /usr/bin:/usr/lib:/usr/ccs/lib: -O -I/home/dsadm/Ascential/DataStage/PXEngine/include -O -c -qspill=32704 /home/dsadm/Ascential/DataStage/Projects/Sample/RT_BP1.O/V0S0_sam1_Transformer_0.C -o /home/dsadm/Ascential/DataStage/Projects/Sample/RT_BP1.O/V0S0_sam1_Transformer_0.tmp.o.
##E TCOS 000029 14:20:56(014) <main_program> Creation of a step finished with status = FAILED. (sam1.Transformer_0)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S0_repos_Transformer_0 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: DSLink4.field1 = DSLink3.file1;
0024: writerecord 0;
0025: RowRejected0 = 0;
0026: }
0027:
0028: finish {
0029: }
0030:
*** End of Internal Generated Transformer Code
------------------------------------------------------------------------
--------------------------------------------------------------------------

Help is appreciated..

DSguru2B · Post by **DSguru2B** » Wed Feb 21, 2007 3:06 pm

Welcome Aboard
Have you installed the C++ compiler?

vkoppala · Post by **vkoppala** » Thu Feb 22, 2007 3:55 am

Yes we had installed C++ compiler.

ArndW · Post by **ArndW** » Thu Feb 22, 2007 4:53 am

vkoppola - you might have installed the compiler, but your environment isn't set up correctly, please check your PATH,LIB,LIBPATH settings - datastage seems to be calling the c compiler with the command

/usr/bin:/usr/lib:/usr/ccs/lib:

.

vkoppala · Post by **vkoppala** » Thu Feb 22, 2007 5:28 am

ArndW wrote:vkoppola - you might have installed the compiler, but your environment isn't set up correctly, please check your PATH,LIB,LIBPATH settings - datastage seems to be calling the c compiler with the command
/usr/bin:/usr/lib:/usr/ccs/lib:
.

ya we have done that the below is our environmental list ..

_=/usr/bin/env
LANG=en_US
LOGIN=root
SSH_TTY=/dev/pts/0
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java14/jre/bin:/usr/java14/bin://bin:/home/dsadm/Ascential/DataStage/PXEngine/lib:/usr/bin:/usr/lib:/usr/ccs/lib:.:/home/dsadm/Ascential/DataStage/PXEngine/lib:/usr/bin:/usr/lib:/usr/ccs/lib:.
LC__FASTMSG=true
LOGNAME=root
MAIL=/usr/spool/mail/root
LOCPATH=/usr/lib/nls/loc
USER=root
AUTHSTATE=compat
SHELL=/usr/bin/ksh
ODMDIR=/etc/objrepos
HOME=/
SSH_CONNECTION=172.17.4.150 3434 172.17.3.26 22
SSH_CLIENT=172.17.4.150 3434 22
TERM=xterm
MAILMSG=[YOU HAVE NEW MAIL]
PWD=/
TZ=EST5EDT
A__z=! LOGNAME
LD_LIBRARY_PATH=/home/dsadm/Ascential/DataStage/PXEngine/lib:/usr/bin:/usr/lib:/usr/ccs/lib:.
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat

still it was not working..

ArndW · Post by **ArndW** » Thu Feb 22, 2007 7:15 am

Go into your Administrator for a project, click on Environment and look at the compiler options you have set. Look at APT_COMPILER

vkoppala · Post by **vkoppala** » Thu Feb 22, 2007 12:09 pm

usr/bin:/usr/lib:/usr/ccs/lib:
.

still it was not working

ray.wurlod · Post by **ray.wurlod** » Thu Feb 22, 2007 1:48 pm

That looks more like LD_LIBRARY_PATH than APT_COMPILER. If it's really APT_COMPILER (which should be the pathname of a CC compiler executable followed by some command line executables) then your system is severly horked, to borrow one of Craig's words.