DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
atul9806
Participant



Joined: 06 Mar 2012
Posts: 43
Location: Pune
Points: 396

Post Posted: Fri Jun 22, 2012 10:53 am Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Windows
Hi All
I know this is a repeat question for this forum but guys believe me I am posting here this question after doing all the things whatever I found on google.

My problem is "My transformer job is not compiled"

Error:
Quote:
Output from transformer compilation follows:

##I IIS-DSEE-TFCN-00001 22:13:10(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.5.0.5746
Copyright (c) 2001, 2005-2008 IBM Corporation. All rights reserved



##I IIS-DSEE-TFCN-00006 22:13:10(001) <main_program> conductor uname: -s=Windows_NT; -r=1; -v=6; -n=ROHIT-PC; -m=Pentium
##I IIS-DSEE-TOSH-00002 22:13:10(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 22:13:10(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 22:13:10(004) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 22:13:10(007) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E IIS-DSEE-TBLD-00076 22:13:11(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 256.
##E IIS-DSEE-TFSR-00019 22:13:11(001) <main_program> Could not check all operators because of previous error(s)
##W IIS-DSEE-TFTM-00012 22:13:11(002) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
##I IIS-DSEE-TBLD-00079 22:13:11(003) <transform> Error when checking composite operator: cxx -O -IC:/IBM/InformationServer/Server/PXEngine/include -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c C:/IBM/InformationServer/Server/Projects/dstage1/RT_BP14.O/V0S8_TransEmployee_Transformer_8.C -o C:/IBM/InformationServer/Server/Projects/dstage1/RT_BP14.O/V0S8_TransEmployee_Transformer_8.tmp.o.
##I IIS-DSEE-TBLD-00000 22:13:11(004) <main_program> Error when checking composite operator: Output from subprocess: Compiler "cl" not found.

##E IIS-DSEE-TCOS-00029 22:13:11(005) <main_program> Creation of a step finished with status = FAILED. (TransEmployee.Transformer_8)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S8_TransEmployee_Transformer_8 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 DSLink3;
0007: outputname 0 DSLink11;
0008:
0009: initialize {
0010: // define our control variables
0011: int8 RowRejected0;
0012: int8 NullSetVar0;
0013:
0014: }
0015:
0016: mainloop {
0017:
0018: // initialise the rejected row variable
0019: RowRejected0 = 1;
0020:
0021: // evaluate columns (no constraints) for link: DSLink11
0022: writerecord 0;
0023: RowRejected0 = 0;
0024: }
0025:
0026: finish {
0027: }
0028:
*** End of Internal Generated Transformer Code



I have installed Microsoft Visual Studio 2010 for the C++ compiler and added the path in INCLUDE and LIB env variable.

My current settings are :
Quote:

APT_COMPILEROPT -W/TP -W/EHa -DAPT_USE_ANSI_IOSTREAMS -c
APT_COMPILER cxx
APT_LINKER cxx
APR_LINKOPT -s -W/dll -W/base:0x50000000


please suggest

_________________
Thanks
Atul Singh
http://datastgae4you.blogspot.com/
zulfi123786



Group memberships:
Premium Members

Joined: 04 Nov 2008
Posts: 640
Location: Bangalore
Points: 4917

Post Posted: Fri Jun 22, 2012 10:57 am Reply with quote    Back to top    

disable operator combination for the transformer stage and recompile and post the result

_________________
- Zulfi
Rate this response:  
Not yet rated
atul9806
Participant



Joined: 06 Mar 2012
Posts: 43
Location: Pune
Points: 396

Post Posted: Fri Jun 22, 2012 11:19 am Reply with quote    Back to top    

that is already set to FALSE

_________________
Thanks
Atul Singh
http://datastgae4you.blogspot.com/
Rate this response:  
Not yet rated
nagarjuna



Group memberships:
Premium Members

Joined: 27 Jun 2008
Posts: 531
Location: Chicago
Points: 2886

Post Posted: Fri Jun 22, 2012 1:07 pm Reply with quote    Back to top    

Is it a new project ? Are you able to compile job without a transformer ?

Please note that APT_COMPILER* & APT_LINKER* variables depends on OS & the path in which you have installed C++ or gcc or XLC compilers.

_________________
Nag
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 36589
Location: Denver, CO
Points: 186517

Post Posted: Fri Jun 22, 2012 1:42 pm Reply with quote    Back to top    

zulfi123786 wrote:
disable operator combination for the transformer stage and recompile and post the result

Just as an FYI, this only needs to be suggested when the error is from the "combined operator" and it is unclear what stage is actually generating the error. We know who the culprit is here. Wink

Out of curiousity, is Microsoft Visual Studio 2010 a supported compiler for your release?

_________________
-craig

It's a scheme of devices to get at low prices all goods from cough mixtures to cables
Which tickled the sailors by treating retailers as though they were all veg-e-tables
Rate this response:  
Not yet rated
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 49944
Location: Canberra, Australia
Points: 271435

Post Posted: Fri Jun 22, 2012 3:36 pm Reply with quote    Back to top    

What are the values of the system environment variables INCLUDE, LIB and LIBPATH ? Have you installed the Platform SDK as per the installation instructions?

_________________
RXP Services Ltd
Melbourne | Canberra | Sydney | Hong Kong
Delivering Outcomes Together
Rate this response:  
Not yet rated
atul9806
Participant



Joined: 06 Mar 2012
Posts: 43
Location: Pune
Points: 396

Post Posted: Sat Jun 23, 2012 2:59 am Reply with quote    Back to top    

The System Requirement said these compilers are supoorted by DS8.5


Microsoft Visual C++ .Net 2003
Microsoft Visual Studio 2005 Professional Edition C++
Microsoft Visual Studio .NET 2005 Express Edition C++
Microsoft Visual Studio 2008 Professional Edition C++
Microsoft Visual Studio .NET 2008 Express Edition C++


I have to installed the whole tool ? is it not possible to get the C++ compiler only ?

_________________
Thanks
Atul Singh
http://datastgae4you.blogspot.com/
Rate this response:  
Not yet rated
atul9806
Participant



Joined: 06 Mar 2012
Posts: 43
Location: Pune
Points: 396

Post Posted: Sat Jun 23, 2012 5:23 am Reply with quote    Back to top    

Hi Guys..
My mistake, VS2010 is not supported. I went through the documentation and I've installed VS 2008 which is supported by DS8.5

I have set these values in INCLUDE, LIB and PATH dir

Quote:

CLASS PATH C:\Program Files\Microsoft Visual Studio 9.0\VC\bin;
LIB C:\Program Files\Microsoft Visual Studio 9.0\VC\lib;
INCLUDE C:\Program Files\Microsoft Visual Studio 9.0\VC\include;


I compiled the job and got another error which is looks like
Quote:

Output from transformer compilation follows:

##I IIS-DSEE-TFCN-00001 16:23:12(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.5.0.5746
Copyright (c) 2001, 2005-2008 IBM Corporation. All rights reserved



##I IIS-DSEE-TFCN-00006 16:23:12(001) <main_program> conductor uname: -s=Windows_NT; -r=1; -v=6; -n=ROHIT-PC; -m=Pentium
##I IIS-DSEE-TOSH-00002 16:23:12(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 16:23:12(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 16:23:12(004) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 16:23:12(007) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E IIS-DSEE-TBLD-00076 16:23:18(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 40,192.
##E IIS-DSEE-TFSR-00019 16:23:18(001) <main_program> Could not check all operators because of previous error(s)
##W IIS-DSEE-TFTM-00012 16:23:18(002) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
##I IIS-DSEE-TBLD-00000 16:23:18(003) <main_program> Error when checking composite operator: Output from subprocess: C:\IBM\InformationServer\Server\PXEngine\include\apt_util/ints.h(83) : fatal error C1083: Cannot open include file: 'strstream': No such file or directory

##I IIS-DSEE-TBLD-00079 16:23:18(004) <transform> Error when checking composite operator: cxx -LC:/IBM/InformationServer/Server/Projects/dstage1/RT_BP14.O/ -LC:/IBM/InformationServer/Server/PXEngine/lib -LC:/IBM/InformationServer/Server/PXEngine/user_lib -s -W/dll -W/base:0x50000000 -W/Zc:wchar_t- -lliborchnt -lliborchcorent -lliborchbuildopnt C:/IBM/InformationServer/Server/Projects/dstage1/RT_BP14.O/V0S8_TransEmployee_Transformer_8.tmp.o -o C:/IBM/InformationServer/Server/Projects/dstage1/RT_BP14.O/V0S8_TransEmployee_Transformer_8.dll.
##I IIS-DSEE-TBLD-00000 16:23:18(005) <main_program> Error when checking composite operator: Output from subprocess: LINK : fatal error LNK1181: cannot open input file 'C:\IBM\InformationServer\Server\Projects\dstage1\RT_BP14.O\V0S8_TransEmployee_Transformer_8.tmp.o'

##E IIS-DSEE-TCOS-00029 16:23:18(006) <main_program> Creation of a step finished with status = FAILED. (TransEmployee.Transformer_8)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S8_TransEmployee_Transformer_8 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 DSLink3;
0007: outputname 0 DSLink11;
0008:
0009: initialize {
0010: // define our control variables
0011: int8 RowRejected0;
0012: int8 NullSetVar0;
0013:
0014: }
0015:
0016: mainloop {
0017:
0018: // initialise the rejected row variable
0019: RowRejected0 = 1;
0020:
0021: // evaluate columns (no constraints) for link: DSLink11
0022: writerecord 0;
0023: RowRejected0 = 0;
0024: }
0025:
0026: finish {
0027: }
0028:
*** End of Internal Generated Transformer Code




I go through the log and found this line
Quote:

##I IIS-DSEE-TBLD-00000 16:23:18(003) <main_program> Error when checking composite operator: Output from subprocess: C:\IBM\InformationServer\Server\PXEngine\include\apt_util/ints.h(83) : fatal error C1083: Cannot open include file: 'strstream': No such file or directory


I have searched this include file but I didn't find it in INCLUDE in path
one more thing,
As I am not working on VS, I have installed VS2008 but I found VS2009 as directory in program files ??

please suggest.

_________________
Thanks
Atul Singh
http://datastgae4you.blogspot.com/
Rate this response:  
Not yet rated
rosecity
Participant



Joined: 04 Apr 2012
Posts: 17

Points: 120

Post Posted: Mon Jun 25, 2012 7:57 am Reply with quote    Back to top    

Do you have a folder called Microsoft SDKs anywhere in your Program Files directory?
Rate this response:  
Not yet rated
atul9806
Participant



Joined: 06 Mar 2012
Posts: 43
Location: Pune
Points: 396

Post Posted: Tue Jun 26, 2012 10:37 pm Reply with quote    Back to top    

yes, I have this folder

_________________
Thanks
Atul Singh
http://datastgae4you.blogspot.com/
Rate this response:  
Not yet rated
rosecity
Participant



Joined: 04 Apr 2012
Posts: 17

Points: 120

Post Posted: Wed Jun 27, 2012 8:11 am Reply with quote    Back to top    

Try using the Lib and Include path which is in your Microsoft SDKs directory.

For example:

Lib: C:\Program Files\Microsoft SDKs\Windows\v6.0A\Lib

Include: C:\Program Files\Microsoft SDKs\Windows\v6.0A\Include
Rate this response:  
Not yet rated
atul9806
Participant



Joined: 06 Mar 2012
Posts: 43
Location: Pune
Points: 396

Post Posted: Thu Jun 28, 2012 1:07 am Reply with quote    Back to top    

I'll try and update soon the outcome.

update

I added these 2 dir in the LIB and INCLUDE.

CLASSPATH : .;C:\Program Files\QuickTime\QTSystem\QTJava.zip;C:\PROGRA~1\IBM\SQLLIB\java\db2java.zip;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc.jar;C:\PROGRA~1\IBM\SQLLIB\java\sqlj.zip;C:\PROGRA~1\IBM\SQLLIB\java\db2jcc_license_cu.jar;C:\PROGRA~1\IBM\SQLLIB\bin;C:\PROGRA~1\IBM\SQLLIB\java\common.jar;C:\IBM\SQLLIB\java\db2java.zip;C:\IBM\SQLLIB\java\db2jcc.jar;C:\IBM\SQLLIB\java\sqlj.zip;C:\IBM\SQLLIB\java\db2jcc_license_cu.jar;C:\IBM\SQLLIB\bin;C:\IBM\SQLLIB\java\common.jar;C:\Program Files\Java\jdk1.7.0_02\bin;C:\Program Files\Java\jdk1.7.0_02\lib\jxl.jar;C:\Program Files\Microsoft Visual Studio 9.0\VC\bin;

LIB : C:\IBM\SQLLIB\INCLUDE;C:\IBM\SQLLIB\LIB;C:\PROGRA~1\IBM\SQLLIB\INCLUDE;C:\PROGRA~1\IBM\SQLLIB\LIB;C:\Program Files\Microsoft Visual Studio 9.0\VC\include;C:\Program Files\Microsoft SDKs\Windows\v6.0A\Include;

INCLUDE : C:\PROGRA~1\IBM\SQLLIB\LIB;C:\IBM\SQLLIB\LIB;C:\Program Files\Microsoft Visual Studio 9.0\VC\lib;C:\Program Files\Microsoft SDKs\Windows\v6.0A\lib;


after compiling the job got this same error

Quote:

Output from transformer compilation follows:

##I IIS-DSEE-TFCN-00001 21:32:58(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.5.0.5746
Copyright (c) 2001, 2005-2008 IBM Corporation. All rights reserved



##I IIS-DSEE-TFCN-00006 21:32:58(001) <main_program> conductor uname: -s=Windows_NT; -r=1; -v=6; -n=ROHIT-PC; -m=Pentium
##I IIS-DSEE-TOSH-00002 21:32:58(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 21:32:58(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 21:32:59(000) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 21:32:59(003) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E IIS-DSEE-TBLD-00076 21:33:06(000) <main_program> Error when checking composite operator: Subprocess command failed with exit status 40,192.
##E IIS-DSEE-TFSR-00019 21:33:06(001) <main_program> Could not check all operators because of previous error(s)
##W IIS-DSEE-TFTM-00012 21:33:06(002) <transform> Error when checking composite operator: The number of reject datasets "0" is less than the number of input datasets "1".
##I IIS-DSEE-TBLD-00000 21:33:06(003) <main_program> Error when checking composite operator: Output from subprocess: C:\IBM\InformationServer\Server\PXEngine\include\apt_util/ints.h(83) : fatal error C1083: Cannot open include file: 'strstream': No such file or directory

##I IIS-DSEE-TBLD-00079 21:33:06(004) <transform> Error when checking composite operator: cxx -LC:/IBM/InformationServer/Server/Projects/dstage1/RT_BP14.O/ -LC:/IBM/InformationServer/Server/PXEngine/lib -LC:/IBM/InformationServer/Server/PXEngine/user_lib -s -W/dll -W/base:0x50000000 -W/Zc:wchar_t- -lliborchnt -lliborchcorent -lliborchbuildopnt C:/IBM/InformationServer/Server/Projects/dstage1/RT_BP14.O/V0S8_TransEmployee_Transformer_8.tmp.o -o C:/IBM/InformationServer/Server/Projects/dstage1/RT_BP14.O/V0S8_TransEmployee_Transformer_8.dll.
##I IIS-DSEE-TBLD-00000 21:33:06(005) <main_program> Error when checking composite operator: Output from subprocess: LINK : fatal error LNK1181: cannot open input file 'C:\IBM\InformationServer\Server\Projects\dstage1\RT_BP14.O\V0S8_TransEmployee_Transformer_8.tmp.o'

##E IIS-DSEE-TCOS-00029 21:33:06(006) <main_program> Creation of a step finished with status = FAILED. (TransEmployee.Transformer_8)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S8_TransEmployee_Transformer_8 transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 DSLink3;
0007: outputname 0 DSLink11;
0008:
0009: initialize {
0010: // define our control variables
0011: int8 RowRejected0;
0012: int8 NullSetVar0;
0013:
0014: }
0015:
0016: mainloop {
0017:
0018: // initialise the rejected row variable
0019: RowRejected0 = 1;
0020:
0021: // evaluate columns (no constraints) for link: DSLink11
0022: writerecord 0;
0023: RowRejected0 = 0;
0024: }
0025:
0026: finish {
0027: }
0028:
*** End of Internal Generated Transformer Code



please help

_________________
Thanks
Atul Singh
http://datastgae4you.blogspot.com/
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours