cancel
Showing results for 
Search instead for 
Did you mean: 

Upadete statistics failed in DB13

Former Member
0 Kudos

Hi,

During daily checks I found that Upadate statistics are failed in DB13. and displaying following error.

No application server found on database host - rsh/gateway will be used

Execute logical command BRCONNECT On host f1n2

Parameters:-u / -jid STATS20070213091036 -c -f stats -t PSAPSR3USR

SXPG_COMMAND_EXECUTE failed for BRCONNECT - Reason: x_error

Job cancelled after system exception ERROR_MESSAGE

Can anyone help to solve this problem?

Regarda,

Abhishek

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

Hi AR,

If it is distributed system, Please check if <SAPSID>ADM and ORA password was chnaged recently and was it synchronized to other systems as well.

Regards,

Priyank.

Former Member
0 Kudos

Hi All,

This is great. Everyone is helping each other. Keep up the love guys 😃 hehe.

MariaManuel
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hello,

is your system a distributed system? If it is and database is not on the same server as the CI, check if you can rsh from the CI to the DB with <SID>adm and ora<SID> . If you are using ssh, check that the exchanges keys are valid.

Hope it helps

Maria

Former Member
0 Kudos

Hello Maria,

Yes my system is distributed system. Iam working on the issue like what you said.

Thanking you.

Abhishek

Former Member
0 Kudos

what is the SAP & Database version that you are using.

Incase of Oracle, please update the brtools.

May be you could refer Note 12741 - Current versions of BR*Tools and SAPDBA.

Regards,

Prem

Former Member
0 Kudos

Hi Abhishek,

Pls check out Note 446172 - SXPG_COMMAND_EXECUTE (program_start_error) in DB13 which has a solution to your problem.

Award points if helpful

Regards

Umesh

Former Member
0 Kudos

Please check Note 446172 carefully.

1. Check if the gateway on the Batabase Server is running.If stopped, start it

2. Check the RFC SAPXPG_DBDEST_<SAPDBHOST>

Cheers!

Bidwan

Former Member
0 Kudos

Hi all,

Thanking you for your responses. Note- 446172 is helping me a lot on this issue. Iam working on that. I will come to you, if I get any problems in that .

Abhishek