DSXchange

Hi Ray - One more question, When the same job was converted to use the "connector" stage it was running fine from the script without the variable in REMOTE_DB_INSTALL_LOC in the dsenv file.

So this variable, is it something specific to the Enterprise stage?

Thanks,
Prasanna

I missed to export the variable REMOTE_DB_INSTALL_LOC in the dsenv file, including this variable in the dsenv resolved the issue.

But i dont understand how did the job run from client

Thanks,
prasanna

Hi Chulett,Andy and Ray We are sourcing/executing $DSHOME/dsenv in our shell script before calling the datstage Job. I've verified that again. The issue happens only with the Enterprise stage called from a Shell script, When the same job is converted to use Connector Stage it is running fine from th...

Hi - We are facing the same issue in our project ,We are setting up 8.7 . The Job is executing fine when i run from designer, but when i run the job from Unix using a script, i'm getting the error DW_SEL_Classification,0: Fatal Error: Caught ORCHESTRATE exception in parallel process: APT_Archive::Ba...

It is a "Parallel" Job Ray..

My bad, i posted it under the server Edition. Not sure how to change it to parallel

Hi - I'm getting the below error when i try to delete/open a job. Error: =========== Unable to delete the item(s). Unable to load RID - c2e76d84.43058877.2a63bb5f.13cd98d3cd7.74677ae0.2b6ed7 In the sametime I see the below entry in the sysout log [3/11/13 14:33:54:976 EDT] 0000003b SystemOut O [org....

Thanks & Apologies for not responding for long time..The issue was resolved.

The installation in the DB2 nodes were wrong, Once the installation in DB2 nodes were corrected , the DB2 EE stage is working fine and also the "Orchadmin Check"

Thanks,
Prasanna

Host Name:dwapp2w129m3 APT_CONFIG_FILE: { node "node1" { fastname "dwapp2w129m3" pools "" resource disk "/etrade/IBM/prd/InformationServer/Server/Datasets" {pools ""} resource scratchdisk "/etrade/IBM/prd/InformationServer/Server/Scratch" {...

Hi - We are migrating our Jobs from 8.0 to 8.7 in Linux. After installation and configuring the dsenv file, When we run the Orchadmin check we are getting the below error ##I IIS-DSEE-TFCN-00001 15:25:19(000) <main_program> IBM InfoSphere DataStage Enterprise Edition 8.7.0.6419 Copyright (c) 2001, 2...

My Job Structure: Dataset -> copy stage -> DB2 Enterprise Stage in Write(Append) Mode Error: DB2_WRT_ETF_PROGRAM_ASSETS,0: Error Idx = 12; DB2Driver Embedded SQL message: SQL0804N The application program parameters for the current request are not valid. Reason code "106". If a host variabl...

Hi ray, to my understanding the PX engine is searching for the Transformer generated object file in DS project directory (and on the LD_LIBRARY_PATH directories) on DB2 server. But the transformer object files is present (and generated) only in project directory on the application server. So it shou...

We are getting the following warning message in all our jobs which is using Transformer stage. We have IBM InfoServer 8.0 in our application server which is a SMP system and configured DB2 cluster server to make use of DS "Enterprise DB2 stage". We have 4 config file for 1x, 2x and 4x para...

All, When i tries to open the designer from the director i'm getting an erro saying "(40509)unable to create object manager" But i am able to open the same job separately through logging in designer directly Can some one help me in this. what should i do to avoid this error. Thanks Prasanna

what are the new features added to the DataSatge Version 7.5.2 compared to DataSatge Version 7.0. What are the major differences...

Thanks a lot HTH.

is it possiblt to Set the checkpoints in Server job?? Please advice me for the same.

Thanks in advance.

Cheers,
Pras