sm59 SAPXPG_DBDEST_<sid> failed

[Former Member]

Hi expert:

I meet a problem that the DB13 database job can not excute successfully.Our central instance and DB installed on two seperate server.I have searched some subject about this,and found the rfc connection SAPXPG_DBDEST_<SID> is related ,but when I test the connection ,it show this error

Logon Connection Error

Error Details Error when opening an RFC connection

Error Details ERROR: timeout during allocate

Error Details LOCATION: SAP-Gateway on host chxsci / sapgw07

Error Details DETAIL: no connect of TP sapxpg from host prddbsvc after 20 sec

Error Details COMPONENT: SAP-Gateway

Error Details COUNTER: 190375

Error Details MODULE: gwr3cpic.c

Error Details LINE: 1973

Error Details RETURN CODE: 242

Error Details SUBRC: 0

Error Details RELEASE: 700

Error Details TIME: Tue Apr 28 17:26:45 2009

Error Details VERSION: 2

Could anyone can give me some help?

below is db job log

2009.04.25 19:00:03 Job started

2009.04.25 19:00:03 Step 001 started (program RSDBAJOB, variant &0000000000019, user ID YUANWEI)

2009.04.25 19:00:03 No application server found on database host - rsh/gateway will be used

2009.04.25 19:00:03 Execute logical command BRCONNECT On host prddbsvc

2009.04.25 19:00:03 Parameters: -u / -jid STATS20090321190000 -c -f stats -t ALL

2009.04.25 19:00:24 SXPG_COMMAND_EXECUTE failed for BRCONNECT - Reason: x_error

2009.04.25 19:00:24 Job cancelled after system exception ERROR_MESSAGE

Edited by: wei yuan on Apr 28, 2009 11:39 AM

If I connect to the DB server to use brtools to run the database job,it run well,but when I logon the CI server to use brtools,it failed like the message said

Edited by: wei yuan on Apr 28, 2009 11:43 AM

[Former Member · Accepted solution]

check out

[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=446172]

[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=34219]

[Former Member]

Hi,

You should have to check the gateway started. If not installed you have to install the standalone gateway server to overcome this problem. If your server farm is only one then this is not needed. if it is having more they you may need the standalone gateway server.

Note 657999 - Installing a Standalone Gateway in an MSCS Environment is for Windows MSCS, but process is same.

Regards

D.Mukundan

[leonorelena_diezquiroz2]

Hello,

Please tells us if his case was already resolved and achievement the solution. We have the same problem and have not been able to fix it.

Thank you very much for your reply.

[Former Member]

Hi Wei Yuan

Is the gateway started?

You can execute this command to start the gateway and then test the connection again (from sm59)

gwrd -force pf=<profile> &

example : gwrd -force pf=/usr/sap/<SID>/SYS/profile/<SID>_DVEBMGS32_<dbname> &

Hope that helps you

Regards,

Della

[Former Member]

Hi Michael:

you said"In the db file put in the CI host name sidadm ie wsaptst03 rq1adm in the ci rhost file put in the opposite ci host name then sidadm."

You mean that's I have to add an entry to the file /home/<sid>adm/.rhosts as "CIhostname <sid>adm" on DB host?and do the same on CI?But I already tvied this,it couldn't resolve my issue.Below are the coversation in the message

Dear support:

Refer to Note 446172 ,34219 and 10403 ,I test the command on app

server

1. rsh prddbsvc -l dhpadm sapxpg

rshd: 0826-813 Permission is denied.

But I have modified the .rhosts file in the home directory of

<sid>adm,and it includ the * <sid>adm entry.

I can execute the rsh prddbsvc date,it can execute successfully.

So Could you give me some help?

Hi, Dear Customer

Thanks for your additional information. I checked with this issue with

our next level support again.

We want to know have you checked the permissions on the sapxpg program?

On the DB host, it must be executable for <sid>adm.

Best Regards

Cherry,Tian

SAP Global Support

Dear Cherry:

below is the auth of sapxpg on our DB server

1. pwd

/usr/sap/DHP/SYS/exe/run

1. ls -ltr sapxpg

-rwxr-xr-x 1 dhpadm sapsys 6411808 Apr 28 16:59 sapxpg

How can I test if the sapxpg can execute uuder <sid>adm?

Best Regards

Yuanwei

So this is what I meet now.I havn't get response till now

Could you pls give some more prompt to me?

[JPReyes]

How can I test if the sapxpg can execute uuder <sid>adm?

You can create and execute external commands via SM49 and SM69. This way you can test sapxpg.

Regards

Juan

[Former Member]

Hi Juan:

Yes,I have tested used these t-code,it shown the same error message as rsh command.

Could you give me some more suggestion?

Best Regrads

Yuan

[Former Member]

try to give 777 to sapxpg and then try

[Former Member]

Hi,

Please refer the SAPNOTE "Note 446172 - SXPG_COMMAND_EXECUTE (program_start_error) in DB13". This should be helpful for you.

With Regards,

Saurabh

[Former Member]

Hi we had the same problem we had RSH set up between our DB and CI make sure you can connect then add the servers to the /root/.rhosts file. then make a .rhosts file in the /home/<sid>adm direstory of the DB and CI In the db file put in the CI host name sidadm ie wsaptst03 rq1adm in the ci rhost file put in the opposite ci host name then sidadm. hope this helps

[Former Member]

Please be informed that our next level support has checked again and

the '/' folder is home of root user but <sid>adm, and in this case,

please try to put another '.rhosts' file under <sid>adm's home directory

Please kindly let us know if there is still any problem after this.

Thank you!

this is the solution givend by SAP

but we already have the .rhosts file under "/" folder and the two server can rlogin each other so I doubt this can work

[Former Member]

they are asking to put '.rhosts' file under /home/sidadm too

[Former Member]

Thanks for your patience! Please be informed that our next level supporthas checked this issue, and it seems the setting of at os level is

missing.

First please check the job detail to see the Executing Server of the

failure job. Then do following:

- check the content of /etc/hosts of Executing Server, and find the

official name of this server

- go to DB server, modify/add following line into .rhosts file under

home directory of

<sid>adm:

<hostname> <sid>adm

See if this works.

If not, please provide us followings:

- job detail of the failer job

- dev trace of the job

- log on to server prdcisvc_DHP_07, go to sm69 and define a new externalcommand which uses br*tools to check the db. (You can copy the command

line output from the brconnect log files) Then provide us the output of

the execution of the external command as well as the dev trace for this

test.

Alternatively, you can also start a standalone gateway for this

case according to note 446172. Thank you! Please let us know the

results.

Today I have add the .rhosts file under /home/<sid>adm,but it can not resolve my issue

[Former Member]

446172 standalone gateway would be better

[JPReyes]

Seems like you have a problem to execute external programs from your application server, check dev_cp and dev_xpg for more details and post them here.

Regards

Juan