| Author |
Message |
atul9806
Participant
Joined: 06 Mar 2012
Posts: 43
Location: Pune
Points: 396
|
|
| 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
|
|
|
|
|
|
|
disable operator combination for the transformer stage and recompile and post the result
|
_________________ - Zulfi |
|
|
|
 |
atul9806
Participant
Joined: 06 Mar 2012
Posts: 43
Location: Pune
Points: 396
|
|
|
|
 |
nagarjuna

Group memberships: Premium Members
Joined: 27 Jun 2008
Posts: 531
Location: Chicago
Points: 2886
|
|
|
|
|
|
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 |
|
|
|
 |
chulett
 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
|
|
|
|
|
|
| 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.
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
|
|
|
|
 |
ray.wurlod
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
|
|
|
|
|
|
|
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 |
|
|
|
 |
atul9806
Participant
Joined: 06 Mar 2012
Posts: 43
Location: Pune
Points: 396
|
|
|
|
|
|
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/ |
|
|
|
 |
atul9806
Participant
Joined: 06 Mar 2012
Posts: 43
Location: Pune
Points: 396
|
|
|
|
|
|
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/ |
|
|
|
 |
rosecity
Participant
Joined: 04 Apr 2012
Posts: 17
Points: 120
|
|
|
|
|
|
|
Do you have a folder called Microsoft SDKs anywhere in your Program Files directory?
|
|
|
|
|
 |
atul9806
Participant
Joined: 06 Mar 2012
Posts: 43
Location: Pune
Points: 396
|
|
|
|
 |
rosecity
Participant
Joined: 04 Apr 2012
Posts: 17
Points: 120
|
|
|
|
|
|
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
|
|
|
|
|
 |
atul9806
Participant
Joined: 06 Mar 2012
Posts: 43
Location: Pune
Points: 396
|
|
|
|
|
|
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/ |
|
|
|
 |
|
|