SAPXPG* RFC is failing

[Former Member]

Hi All,

Have a good day.

Recently, we have migrated our production system to new hardware setup.

After that , DB13 jobs and RFC SAPXPG_DBDEST_<DB_HOST> are getting failed  due to "SXPG_COMMAND_EXECUTE failed " as SAP and DB are running in different host.

As per note  446172, the below command was executed.

rsh <DB host> -l <sid>adm sapxpg

we got result as "Permission denied"

we have maintained .rhosts file under user directory as per note 10403.

again ,above command has been executed. now,we are getting error as below

rsh <DB HOST> -l <sid>adm sapxpg

Insufficient credentials.

Also we can see the same error in trace dev_rd file.

dev_rd trace:

Wed Jun 22 13:14:42 2016

child (pid=28321) exited with exit code 1

permission denied

Wed Jun 22 13:22:30 2016

child (pid=7715) exited with exit code 1

Insufficient credentials.

Insufficient credentials.

Insufficient credentials.

Insufficient credentials.

Insufficient credentials.

Insufficient credentials.

Insufficient credentials.

Insufficient credentials.

Insufficient credentials.

Insufficient credentials.

Kindly guide me how to proceed further.

Thank in advance for your support.

Best Regards,

Gopukrish

[karthikeyan_natarajan4 · Accepted solution]

Hi Gopukrish,

Did you see these below sap notes

http://service.sap.com/sap/support/notes/2145145

http://service.sap.com/sap/support/notes/1974030

http://service.sap.com/sap/support/notes/2137321

http://service.sap.com/sap/support/notes/1914589

Regards,

kartik

[Former Member · Accepted solution]

Dear Kartik,

Have a good day.

Thank you for suggesting the SAP notes.

standalone gateway is not installed as we are connecting through 'rsh' shell.

existing system was fine without standalone gateway.

I have just removed .rhosts which was created yesterday as per note 10403.

Now, i am getting error as "Permission denied".

Thanks.

Best Regards,

Gopikrishnan J

[karthikeyan_natarajan4 · Accepted solution]

Hi Gopi,

Please paste the error log of DB13 and SM59 connection test.

Regards,

kartik

[Former Member]

Dear All,

Thank you very much for your kind reply.

Issue has been resolved.

OS team has added parameters in  pam.conf files and maintained .rhosts file under home directory.

After that ,RFC is  working fine. Now, we can able to scheduled the jobs in DB13.

Thank you once again for your support and help.

Best Regards,

gopukrish

[former_member185239]

This message was moderated.

[feng_shi]

Hi,

I believe you are using remote shell to execute the external commands on DB server.

(there is no gateway option defined in RFC SAPXPG_DBDEST_<DB_HOST> )

Since you have migrated our production system to new hardware setup,

the rsh between application server and DB server did not set up successfully, therefore, the RFC is not working.

As you mentioned, the following error also indicates that the rsh did not configured correctly.

rsh <DB HOST> -l <sid>adm sapxpg

Insufficient credentials.

this is not a SAP system issue at all,  instead, you should ask you OS admin to make sure that rsh has been configured correctly.

by the way, if the rsh has been configured successfully, the following should return nothing.

rsh <DB host> -l <sid>adm sapxpg

At last, I've summrized some technical points and typical issues into following wiki,

I believe you will get benefit from it.

https://wiki.scn.sap.com/wiki/x/9gpmG

thanks and best regards,

Shi