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



Group memberships:
Premium Members

Joined: 26 May 2004
Posts: 898
Location: Chicago
Points: 6765

Post Posted: Sun May 22, 2011 5:07 pm Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi

We are in process of migration from old Production server into New production server.

when I import from old server to new server I am getting folloeing error from Transformer stage.

New server with same Datastage version 8.1 and Fix pack level 2 that all.

Is this I need to setup anything like for this error.

//--------------------------------------------------------------


Error compiling parallel transformer
Output from transformer compilation follows:

##I XXXXXB 000001 <osh_conductor> Checking Authorization...
##I XXXXXE 000001 <osh_conductor> Using dynamic configuration script: /opt/IBM/Engine/InformationServer/Server/PXEngine/aaa.sh
##I XXXXXF 000001 <osh_conductor> Authorized to proceed.
##I IIS-DSEE-TFCN-00001 15:07:49(000) <main_program>
IBM WebSphere DataStage Enterprise Edition 8.1.0.5809
Copyright (c) 2001, 2005-2008 IBM Corporation. All rights reserved



##I IIS-DSEE-TFCN-00006 15:07:49(001) <main_program> conductor uname: -s=Linux; -r=2.6.18-194.17.4.el5xen; -v=#1 SMP Wed Oct 20 13:11:50 EDT 2010; -n=aaaaaaa; -m=x86_64
##I IIS-DSEE-TOSH-00002 15:07:49(002) <main_program> orchgeneral: loaded
##I IIS-DSEE-TOSH-00002 15:07:49(003) <main_program> orchsort: loaded
##I IIS-DSEE-TOSH-00002 15:07:49(004) <main_program> orchstats: loaded
##W IIS-DSEE-TOSH-00049 15:07:49(007) <main_program> Parameter specified but not used in flow: DSPXWorkingDir
##E IIS-DSEE-TBLD-00076 15:07:49(009) <main_program> Error when checking composite operator: Subprocess command failed with exit status 65,280.
##E IIS-DSEE-TFSR-00019 15:07:49(010) <main_program> Could not check all operators because of previous error(s)
##W IIS-DSEE-TFTM-00012 15:07:49(011) <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:07:49(012) <main_program> Error when checking composite operator: Output from subprocess: Couldn't change directory to /di/data/aaaa/temp: No such file or directory

##I IIS-DSEE-TBLD-00079 15:07:49(013) <transform> Error when checking composite operator: g++ -fPIC -O -I/opt/IBM/Engine/InformationServer/Server/PXEngine/include -O -fPIC -Wno-deprecated -c -m32 /di/UVProjects/svl_fdm/RT_BP1.O/V0S15_jb_ee_SL_001_AUD_EXT_CLOSE_BATCH_TRANS_CURRENT_TIME.C -o /di/Projects/aaaa/RT_BP1.O/V0S15_jb_SL_001_AUD_EXT_CLOSE_BATCH_TRANS_CURRENT_TIME.tmp.o.
##E IIS-DSEE-TCOS-00029 15:07:49(014) <main_program> Creation of a step finished with status = FAILED. (jb_ee_SL_001_AUD_EXT_CLOSE_BATCH.TRANS_CURRENT_TIME)

*** Internal Generated Transformer Code follows:
0001: //
0002: // Generated file to implement the V0S15_jb_ee_SL_001_AUD_EXT_CLOSE_BATCH_TRANS_CURRENT_TIME transform operator.
0003: //
0004:
0005: // define our input/output link names
0006: inputname 0 DSLink12;
0007: outputname 0 lnk_out_ETL_BATCH_RUN;
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: lnk_out_ETL_BATCH_RUN
0023: lnk_out_ETL_BATCH_RUN.BATCH_END_TM = current_timestamp();
0024: writerecord 0;
0025: RowRejected0 = 0;
0026: }
0027:
0028: finish {
0029: }
0030:
*** End of Internal Generated Transformer Code


Thanks
man
SURA



Group memberships:
Premium Members

Joined: 14 Jul 2007
Posts: 1229
Location: Sydney
Points: 9015

Post Posted: Sun May 22, 2011 5:26 pm Reply with quote    Back to top    

Hope this link might help you.

http://www.dsxchange.com/viewtopic.php?p=381676
Rate this response:  
chulett

Premium Poster


since January 2006

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

Joined: 12 Nov 2002
Posts: 43085
Location: Denver, CO
Points: 222463

Post Posted: Sun May 22, 2011 8:41 pm Reply with quote    Back to top    

SURA, please learn how to post properly here so I don't contantly need to clean up after you. There is a perfectly lovely Reply to topic link at the bottom of the page, use that instead of quoting everything every time you reply. And don't bury your reply in the middle of a quote where nobody can see it, I had to dig it out for you.

_________________
-craig

"You can never have too many knives" -- Logan Nine Fingers
Rate this response:  
Not yet rated
kalyhot
Participant



Joined: 02 Jun 2020
Posts: 7

Points: 56

Post Posted: Tue Jun 02, 2020 12:34 pm Reply with quote    Back to top    

SURA wrote:
Hope this link might help you.

http://www.dsxchange.com/viewtopic.php?p=381676


I faced the same issue, you have to install visual C++ 2010 express edition and be sure that this environement variable system is added

var VS100COMNTOOLS

value c:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\Tools\

for all the verifications must see this
https://www.ibm.com/support/pages/datastage-designer-parallel-job-transformer-stage-fails-compile-windows-2008

_________________
kalyhot DS certified 9 Developper
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: 54581
Location: Sydney, Australia
Points: 295981

Post Posted: Sat Jun 27, 2020 8:08 pm Reply with quote    Back to top    

The event about PXWorkingDir is only a warning (note that it has a W in its event ID). Errors have E in their event ID - it is these that you should be looking for and diagnosing.

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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