DATASTAGE 7.5.1 A SAP R/3 , ORACLE CONNECTIONS

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
sendmk
Charter Member
Charter Member
Posts: 136
Joined: Mon Oct 03, 2005 5:02 am

DATASTAGE 7.5.1 A SAP R/3 , ORACLE CONNECTIONS

Post by sendmk »

Hi

We are using SAP R/3 Pack ABAP 5.2.1 Realese with Parallel Job WITH DS 7.5.1 A we are getting the following error message when we connect DS Server from INDIA and run the SAP R/3 related Jobs and job fails.

DataStage server and SAP Application Server are in Onsite we are connecting from Offshore and running the jobs.even if we run the jobs from Onsite also same error message.

Here SAP is the Source Stage.

APT_CombinedOperatorController,0: Fatal Error: Fatal: R/3 Logon failed : Connect to SAP gateway failed Connect_PM GWHOST=xxx.xxx.xxx.xx, GWSERV=sapgw05, ASHOST=xxx.xxx.xxx.xx, SYSNR=05 LOCATION CPIC (TCP/IP) on local host ERROR connection to host xxx.xxx.xxx.xx, service 3305 timed out TIME Tue May 2 02:43:13 2006 RELEASE 620 COMPONENT NI (network interface) VERSION 36 RC -12 MODULE nixxi_r_mt.c LINE 821 DETAIL NiPConnect COUNTER 1 [dscapiop.C:1882]


We are getting a similar error for Oracle as the Source in the Job instead of SAP.

DataStage server and Oracle Server are in Onsite we are connecting from Offshore and running the jobs.even if we run the jobs from Onsite also same error message

RETURN_REQ_CAUSAL_PARTS_TAB: connect failed for env: DEVOTD, user: GWM, password: *****
Oracle error: -2127
[orautils.C:413]

RETURN_REQ_CAUSAL_PARTS_TAB: APT_OraReadOperator: connect failed. [orareadop.C:269]

For both of these Jobs we have some Connections Issues can any body help on this.

Regards
Sendmk
Sreenivasulu
Premium Member
Premium Member
Posts: 892
Joined: Thu Oct 16, 2003 5:18 am

Post by Sreenivasulu »

The error message shows that it is a LOGON error and GATEWAY error.

Both are related to network issues.

Try connecting to SAP and ORACLE from outside of Datastage environment in offshore. If you get the same problem then its a network issue not a datastage issue.

Regards
Sreeni
sendmk
Charter Member
Charter Member
Posts: 136
Joined: Mon Oct 03, 2005 5:02 am

DATASTAGE SAP R/3 ORACLE

Post by sendmk »

Sreenivasulu wrote:The error message shows that it is a LOGON error and GATEWAY error.

Both are related to network issues.

Try connecting to SAP and ORACLE from outside of Datastage environment in offshore. If you get the same problem then its a network issue not a datastage issue.

Regards
Sreeni
THANX Sreeni


I am able to Connect from offshore to SAP and Oracle outside DS ENV

but from connecting Onsite DS from Offshore and from there connecting SAP and Oracle iam facing issue

Regards
sendmk
Post Reply