DSXchange

They differ by 129 Rows, It's not possible to see the input data as we are having million of records to be processed at any point of time. this Difference also is not constant, In some Job, there is not any difference at all while in other Jobs it somewhere around 1000 records.

Hi Ray,

This is Ok,but even if the Datastage is using null or zero value in those places where it is expecting numeric values, then also the number of records in the input file and the number of records in output file should match.

If i am wrong then please correct me.....

Hi All, I have a server job which does the transformation and creates Dat File for loading Using Orabulk Stage. Some Records are being rejected for some Jobs randomly. The Transformation Job Finishes with Warning. The Warning is : "DataStage Job 126 Phantom 736 Program "ORABULK.RUN": ...

I have all the rights, I have checked the entries.

I need some suggestions.

Hi Girish, Make a Copy of ur old Job and then change the Metadata in the Job. Select all the derivations from the copy of the Job and Press Ctl C, then in the New Job go to the transformation and right click there and select paste derivations. In this manner u don't need to code again and again. Any...

Hi All, I have installed DataStage Version 6 on solaris. The log file is not showing any error. I am getting this error when trying to connect to server - "The connection was refused or the RPC Daemon is not running". I checked out and found that dsrpc is running. The problem which i point...

hi Ray,

i am getting this error now,

RPCPID=2259 - 18:08:23 - uvrpc_debugflag=9 (Debugging level)
RPCPID=2259 - 18:08:23 - In rpc_init()
RPCPID=2259 - 18:08:23 - get service by name bombed errno=0
RPCPID=2259 - 18:08:23 - listen failed

Hi Ray,

Sorry for replying you so late, There is only one listener and that is dsrpc only. The socket is available to datastage only.

please suggest wht shud i do to solve this problem. I am unable to diagnose the problem till now. i rebooted the server but the problem still exists.

Ray,

The dsrpcd.log under tmp shows

RPCPID=7512 - 10:35:53 - uvrpc_debugflag=9 (Debugging level)
RPCPID=7512 - 10:35:53 - In rpc_init()
RPCPID=7512 - 10:35:53 - bind bombed errno=125
RPCPID=7512 - 10:35:53 - listen failed

Please suggest.

Hi T.J,

Yes, dsrpcd is running under root.

Ray,

I have executed this command
"nohup bin/dsrpcd -d9 > /tmp/dsrpcd.log 2>&1 &"
and the output of this is
[1] 13527

Now i am not able to understand what shud i conclude from this.

Ray, It does not give me any information. I am not able to conclude anything. The output keep on varying when i execute the command nohup bin/dsrpcd > /dev/null 2>&1 & 1. Output [1] 3901 2. Output [2] 4012 [1] Done nohup bin/dsrpcd >/dev/null 2>&1 3. Output [3] 4065 [2] Done nohup bin/ds...

Hi go to ur project directory execute these commands 1) . `cat /.dshome`/dsenv 2) `cat /.dshome`/bin/uv then DataStage Command Language 6.0 (c) Copyright 2002 Ascential Software, Inc. - All Rights Reserved DSEngine logged on: Mon Dec 1 16:19:10 2003 will come 3) DS.TOOLS Then choose option 5 another...

Hi All, I have installed DataStage Version 6 on solaris. The log file is not showing any error. I am getting this error when trying to connect to server - "The connection was refused or the RPC Daemon is not running". The dsrpc - 31538/tcp entry is there in /etc/services. I have rebooted t...

Ray,

At line B0:
01E Call "$DSP.GetNext" _T0000 Pin%%VOS42PI.REJECTEDCODE

I am unable to understand what this means,

Please suggest...