Job Compilation Error for Transformer

Soma123 · Post by **Soma123** » Thu Mar 19, 2009 4:13 am

Hi I have a simple job containing one source DRS Stage, a Transformer Stage and a Target Sequential File.

<main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 15:27:04(002) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 15:27:04(003) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 15:27:04(006) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E IIS-DSEE-TBLD-00076 15:27:04(008) <main_program> Error when checking composite operator: Subprocess command failed with exit status 256.
##E IIS-DSEE-TFSR-00019 15:27:04(009) <main_program> Could not check all operators because of previous error(s)
##W IIS-DSEE-TFTM-00012 15:27:04(010) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
##W IIS-DSEE-TBLD-00000 15:27:04(011) <main_program> Error when checking composite operator: Output from subprocess: C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 108: cannot open "C:/WINDOWS/TEMP/sh10BC.aab" for output: Access is denied.

##W IIS-DSEE-TBLD-00000 15:27:04(012) <main_program> Error when checking composite operator: Output from subprocess: C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 108: C:/WINDOWS/TEMP/sh10BC.aab: The system cannot find the file specified.
cannot open "C:/WINDOWS/TEMP/sh10BC.aad" for output: Access is denied.
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 125: C:/WINDOWS/TEMP/sh10BC.aad: The system cannot find the file specified.
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 157: cannot open "C:/WINDOWS/TEMP/sh10BC.aaf" for output: Access is denied.

##I IIS-DSEE-TBLD-00079 15:27:04(013) <transform> Error when checking composite operator: cxx -O -IC:/IBM/InformationServer/Server/PXEngine/include C:/IBM/InformationServer/Server/Projects/Dsx_Proj/RT_BP1.O/V0S1_Test_Job1_Transformer_1.C -o C:/IBM/InformationServer/Server/Projects/Dsx_Proj/RT_BP1.O/V0S1_Test_Job1_Transformer_1.tmp.o.
##W IIS-DSEE-TBLD-00000 15:27:04(014) <main_program> Error when checking composite operator: Output from subprocess: C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 157: C:/WINDOWS/TEMP/sh10BC.aaf: The system cannot find the file specified.
cannot open "C:/WINDOWS/TEMP/sh10BC.aah" for output: Access is denied.
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 157: C:/WINDOWS/TEMP/sh10BC.aah: The system cannot find the file specified.
cannot open "C:/WINDOWS/TEMP/sh10BC.aaj" for output: Access is denied.
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 157: C:/WINDOWS/TEMP/sh10BC.aaj: The
##W IIS-DSEE-TBLD-00000 15:27:04(015) <main_program> Error when checking composite operator: Output from subprocess: system cannot find the file specified.
cannot open "C:/WINDOWS/TEMP/sh10BC.aal" for output: Access is denied.
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 173: C:/WINDOWS/TEMP/sh10BC.aal: The system cannot find the file specified.
cannot open "C:/WINDOWS/TEMP/sh10BC.aan" for output: Access is denied.
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 202: C:/WINDOWS/TEMP/sh10BC.aan: The system cannot find the file specified.
##W IIS-DSEE-TBLD-00000 15:27:04(016) <main_program> Error when checking composite operator: Output from subprocess: cxx: file '/etc/cxx.ccg': The system cannot find the path specified.

##E IIS-DSEE-TCOS-00029 15:27:04(017) <main_program> Creation of a step finished with status = FAILED. (T[/color]est_Job1.Transformer_1)[/color]
********************

It seems soem problem with C++ Compiler setup as this Compilation Error is only Coming for Jobs haveing Transformer and not for Other Jobs.

Prior to Loading DS 8.0.1 I had installaed Visual Studio 2005 which had SDK with it so I assume both Compiler & SDK is present in my system.
But I don't know whether all required files are present in the respective directory where DataStage will Search? Some one please tell me which location DataStage checks for Compiler?

Do these have anything to do with APT_COMPILER OPT & APT_LINKER OPT Setup?

Please help.

Thanks,
Soma

sima79 · Post by **sima79** » Thu Mar 19, 2009 4:52 am

Have a look at the system requirements at this link http://www-01.ibm.com/support/docview.w ... eswwindows

APT_COMPILEOPT and APT_LINKOPT only need to be modified when using Visual Studio .NET 2003 compiler.

Soma123 · Post by **Soma123** » Thu Mar 19, 2009 5:45 am

yes it has been mentioned for 2003 Compiler only change APT_COMPILEOPT & APT_LINKEROPT Option, in my case it's 2005 Professional Edition, for which it says being the defaut compiler no settings required. But for my case it's throwing error during Compilation of Jobs having Transformer Only..So puzzled what all other setups do I need to cross-Check...Please show me any pointers for this issue..

Soma123 · Post by **Soma123** » Thu Mar 19, 2009 6:22 am

one additional input to this issue..when I checked the Configuration File (which is the default one cretaed during installtion having 1 Node) it gave me same set of error that are coming for the Transformer Job Compilation.

C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 108: cannot open "C:/WINDOWS/TEMP/sh050C.aab" for output: Access is denied.
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 108: C:/WINDOWS/TEMP/sh050C.aab: The system cannot find the file specified.
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 131: cannot open "C:/WINDOWS/TEMP/sh050C.aad" for output: Access is denied.
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 131: C:/WINDOWS/TEMP/sh050C.aad: The system cannot find the file specified.
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 157: cannot open "C:/WINDOWS/TEMP/sh050C.aaf" for output: Access is denied.
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 157: C:/WINDOWS/TEMP/sh050C.aaf: The system cannot find the file specified.
cannot open "C:/WINDOWS/TEMP/sh050C.aah" for output: Access is denied.
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 157: C:/WINDOWS/TEMP/sh050C.aah: The system cannot find the file specified.
cannot open "C:/WINDOWS/TEMP/sh050C.aaj" for output: Access is denied.
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 157: C:/WINDOWS/TEMP/sh050C.aaj: The system cannot find the file specified.
cannot open "C:/WINDOWS/TEMP/sh050C.aal" for output: Access is denied.
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 173: C:/WINDOWS/TEMP/sh050C.aal: The system cannot find the file specified.
cannot open "C:/WINDOWS/TEMP/sh050C.aan" for output: Access is denied.
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 202: C:/WINDOWS/TEMP/sh050C.aan: The system cannot find the file specified.
##I IIS-DSEE-TFCN-00001 17:44:46(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.0.1.4458
Copyright (c) 2001, 2005-2007 IBM Corporation. All rights reserved

##I IIS-DSEE-TCOA-00067 17:44:46(001) <main_program> OS charset: windows-1252.
##I IIS-DSEE-TCOA-00068 17:44:46(002) <main_program> Input charset: UTF-8.
##I IIS-DSEE-TFSC-00001 17:44:46(003) <main_program> APT configuration file: C:/IBM/InformationServer/Server/Configurations/default.apt
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 108: C:/IBM/InformationServer/Server/PXEngine/etc/standalone.sh: cannot open "C:/WINDOWS/TEMP/sh1048.aab" for output: Access is denied.
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 108: C:/IBM/InformationServer/Server/PXEngine/etc/standalone.sh: C:/WINDOWS/TEMP/sh1048.aab: The system cannot find the file specified.
cannot open "C:/WINDOWS/TEMP/sh1048.aad" for output: Access is denied.
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 125: C:/IBM/InformationServer/Server/PXEngine/etc/standalone.sh: C:/WINDOWS/TEMP/sh1048.aad: The system cannot find the file specified.
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 157: C:/IBM/InformationServer/Server/PXEngine/etc/standalone.sh: cannot open "C:/WINDOWS/TEMP/sh1048.aaf" for output: Access is denied.
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 157: C:/IBM/InformationServer/Server/PXEngine/etc/standalone.sh: C:/WINDOWS/TEMP/sh1048.aaf: The system cannot find the file specified.
cannot open "C:/WINDOWS/TEMP/sh1048.aah" for output: Access is denied.
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 157: C:/IBM/InformationServer/Server/PXEngine/etc/standalone.sh: C:/WINDOWS/TEMP/sh1048.aah: The system cannot find the file specified.
cannot open "C:/WINDOWS/TEMP/sh1048.aaj" for output: Access is denied.
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 157: C:/IBM/InformationServer/Server/PXEngine/etc/standalone.sh: C:/WINDOWS/TEMP/sh1048.aaj: The system cannot find the file specified.
cannot open "C:/WINDOWS/TEMP/sh1048.aal" for output: Access is denied.
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 173: C:/IBM/InformationServer/Server/PXEngine/etc/standalone.sh: C:/WINDOWS/TEMP/sh1048.aal: The system cannot find the file specified.
cannot open "C:/WINDOWS/TEMP/sh1048.aan" for output: Access is denied.
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 202: C:/IBM/InformationServer/Server/PXEngine/etc/standalone.sh: C:/WINDOWS/TEMP/sh1048.aan: The system cannot find the file specified.
cannot open "C:/WINDOWS/TEMP/sh1048.aap" for output: Access is denied.
C:/IBM/InformationServer/Server/PXEngine/etc/standalone.sh 28: C:/WINDOWS/TEMP/sh1048.aap: The system cannot find the file specified.
[: C:/IBM/InformationServer/Server/PXEngine/etc/standalone.sh 75: expression syntax error
[: C:/IBM/InformationServer/Server/PXEngine/etc/standalone.sh 75: expression syntax error
[: C:/IBM/InformationServer/Server/PXEngine/etc/standalone.sh 75: expression syntax error
[: C:/IBM/InformationServer/Server/PXEngine/etc/standalone.sh 75: expression syntax error
standalone.sh: The operating system [] is not supported
##W IIS-DSEE-TFPM-00152 17:45:16(000) <main_program> Accept timed out retries = 4
##E IIS-DSEE-TFPM-00153 17:45:16(001) <main_program> The section leader on MACHINE1 died
##E IIS-DSEE-TFPM-00356 17:45:16(002) <main_program>

**** Parallel startup failed ****

This is usually due to a configuration error, such as
not having the Orchestrate install directory properly
mounted on all nodes, rsh permissions not correctly
set (via /etc/hosts.equiv or .rhosts), or running from
a directory that is not mounted on all nodes. Look for
error messages in the preceding output.

##I IIS-DSEE-TFPM-00177 17:45:16(003) <main_program> Step started on node MACHINE1; it uses 1 nodes.
The program running the step is /C=/IBM/InformationServer/Server/PXEngine/bin/orchadmin.exe.

##I IIS-DSEE-TFPM-00178 17:45:16(004) <main_program> The ORCHESTRATE startup program in /C=/IBM/InformationServer/Server/PXEngine/etc/standalone.sh is being used.

##I IIS-DSEE-TFPM-00181 17:45:16(005) <main_program> A startup script is not being used.

##I IIS-DSEE-TFPM-00183 17:45:16(006) <main_program> The TCP port being used for startup is 10,000; the associated socket number is 3.

##I IIS-DSEE-TFPM-00184 17:45:16(007) <main_program>
Node status:

##I IIS-DSEE-TFPM-00185 17:45:16(008) <main_program> MACHINE1 -
##I IIS-DSEE-TFPM-00187 17:45:16(009) <main_program> rsh issued, no response received

##E IIS-DSEE-TFPM-00247 17:45:16(010) <main_program> Unable to contact one or more Section Leaders.
Probable configuration problem; contact Orchestrate system administrator.

##E IIS-DSEE-TFSC-00011 17:45:16(011) <main_program> Step execution finished with status = FAILED.
##E IIS-DSEE-TCOA-00069 17:45:16(012) <main_program> ERROR: check configuration file failed.

*************
Someone please tell me what installation set up I am basically missing !
Also the IBM Installation Guide mentions about configuring MPP in Windows environment but nothing about SMP as for my case it would be simply one Node Server ? in that scenario what set up I should do!

if amy one has done it ...please clarify a bit in understanding the Installation setups.

Soma123 · Post by **Soma123** » Fri Mar 20, 2009 12:09 am

Hi,
Can any one suggest me, Why I am getting so many Access Denied errors, like....
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 108: cannot open "C:/WINDOWS/TEMP/sh050C.aab" for output: Access is denied.
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 108: C:/WINDOWS/TEMP/sh050C.aab: The system cannot find the file specified.
C:/IBM/InformationServer/Server/PXEngine/etc/vsvars32.ksh 131: cannot open "C:/WINDOWS/TEMP/sh050C.aad" for output: Access is denied.

Does this mean the DataStage User that 's checking the Configuration File
does not have the access?

Please advise.

Thanks in advance,

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Mar 20, 2009 3:18 am

Is this the first job or was DataStage working before in the PC?

Soma123 · Post by **Soma123** » Fri Mar 20, 2009 3:29 am

Server Job is working fine, but for parallel job it's throwing this kind of Compilation Error. I have not done any set up as far as Environment Variable Settings are concerned. The Compiler is .NET 2005 and the SDK is already loaded.

ray.wurlod · Post by **ray.wurlod** » Fri Mar 20, 2009 4:01 pm

And your values for the four "Compiler" environment variables are ...?

Soma123 · Post by **Soma123** » Sun Mar 22, 2009 11:47 pm

Four Compilation variable values are :
APT_COMPILEOPT
-W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c -W/Zc:wchar_t-
APT_COMPILER
cxx
APT_LINKER
cxx
APT_LINKOPT
-s -W/dll -W/base:0x50000000 -W/Zc:wchar_t-