on 10-11-2013 3:32 PM
Hello,
This is a SAP distributed system with one SAP dialog instance.
We are facing some problems when we add/run an activity (job) in DB13 tcode.
When we run a Check and update optimizer statistics activity in DB13, it show the following error (the same for other type of activity, like CheckDB):
Job started
Step 001 started (program RSDBAJOB, variant &0000000000006, user ID ADMINSAP)
Execução do comando lógico BRCONNECT No host liszgpora001
Parâmetros: -jid STATS20130320200000 -u / -c -f stats -t ALL
SXPG_STEP_XPG_START: is_local_host: rc = 403
SXPG_STEP_XPG_START: host = liszgpora001
SXPG_STEP_XPG_START: is_local_r3_host: rc = 802
SXPG_STEP_XPG_START: RFC_TCPIP_CONNECTION_OPEN: rc = 1003
SXPG_STEP_COMMAND_START: SXPG_STEP_XPG_START returned: 1.003
SXPG_COMMAND_EXECUTE(LONG)
<timestamp> = 20131009200121
COMMANDNAME = BRCONNECT
ADDITIONAL_PARAMETERS = -jid STATS20130320200000 -u / -c -f stats -t ALL
LONG_PARAMS
OPERATINGSYSTEM = ANYOS
TARGETSYSTEM = liszgpora001
DESTINATION
SY-SUBRC = 1003
SXPG_COMMAND_EXECUTE failed for BRCONNECT - Reason: program_start_error: For More Information, See SYS
I checked the SM37 for DB job (DBA:UPDATESTATS_____@121311/5000) and I see in there an error... the same error.
I searched for a solution and I found the following SAP notes:
1914589 - SXPG_COMMAND_EXECUTE failed when start job from DB13/DBACOCKPIT
446172 - SXPG_COMMAND_EXECUTE (program_start_error) in DB13
I read them, but sincerely I didn't understand some of the instructions/information described in that sap notes. I also found some threads in SDN forums:
http://scn.sap.com/thread/2155624
http://scn.sap.com/thread/2129398
For instance: I see in central instance if there exist the RFC --> SAPXPG_DBDEST_<SAPDBHOST> - and yes, there is the RFC SAPXPG_DBDEST_LISZGPORA001, I made a conection test and everything is OK! I also checked the same RFC but in dialog instance, there is the same RFC - SAPXPG_DBDEST_LISZGPORA001 but when I done a connection test it show me an error:
Connection Error
Error when opening an RFC connection (CPIC-CALL: 'ThSAPOCMINIT' : cmRc=27 thRc=2
ERROR: timeout during allocate
LOCATION: SAP-Gateway on host liszgpsap003.zagope.pt / sapgw01
DETAIL: no connect of TP /usr/sap/AZP/DVEBMGS00/exe/sapxpg from host liszgpsap
COMPONENT: SAP-Gateway
COUNTER: 18059
MODULE: gwr3cpic.c
LINE: 2025
RETURN CODE: 242
SUBRC: 0
RELEASE: 720
TIME: Fri Oct 11 15:32:37 2013
VERSION: 2
I don´t know if this is the cause for this error... and if this RFC in dialog instance is suppose to be work for this can run the jobs for DB!
I don´t know...
Please, can you help me!?
Kind regards,
samid
As you have distributed set up then read this SAP note
Note 1025707 - DBA Cockpit: Planning calendar and remote Oracle databases
Either you set up a standalone gateway on the DB node or with the help of remote shell.
You can easily fix this problem with the help of these threads.
http://scn.sap.com/thread/3323179
https://scn.sap.com/thread/1642168
http://scn.sap.com/thread/1937412
http://scn.sap.com/thread/2101286
Also check this SAP note
Note 34219 - DB13: CPIC error CM_RESOURCE_FAILURE_RETRY
Good Luck
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
They are in different hosts! So, in this case, I need a Gateway installed on this databse host, am I right?
I will only consider this as a valid point in the whole post as the rest are irrelevant.
I already answered your question in my first reply. Here it is once more.
Either you set up a standalone gateway on the DB node or with the help of remote shell.
Regards
RB
Hi Reagan,
Yes... sorry!
Let me to put here some information about the RFC SAPXPG_DBDEST__<SAPDBHOST>
In central and dialog instance, in SM59, I change the settings of that RFC, I put the information about database host (liszgpora001😞
The connection test show me the following error:
Connection Error
Error when opening an RFC connection (CPIC-CALL: 'ThSAPOCMINIT' : cmRc=17 thRc=2
ERROR: Estruturação conexão à porta conv.SAP fracassou (porta conv.SAP inciad
LOCATION: SAP-Server liszgpsap003_AZP_00 on host liszgpsap003 (wp 3)
COMPONENT: CPIC
COUNTER: 615
MODULE:
LINE:
RETURN CODE: 236
SUBRC: 0
RELEASE: 720
TIME: Sun Oct 13 14:34:48 2013
VERSION:
regards,
samid
Hello
LOCATION: SAP-Server liszgpsap003_AZP_00 on host liszgpsap003 (wp 3)
Let me clarify this.
liszgpsap003 = CI host with system number 00
liszgpora001 = Oracle DB host
Right ?
I see you are providing gateway host as liszgpora001 and gateway service as sapgw00
Is there a gateway running on host liszgpora001 ?
Regards
RB
Hello Reagan,
Let me clarify this.
liszgpsap003 = CI host with system number 00
liszgpora001 = Oracle DB host
Yes, you are right!
I see you are providing gateway host as liszgpora001 and gateway service as sapgw00
Is there a gateway running on host liszgpora001 ?
That´s the point here! 🙂
I believe that I must follow the instructions in sap note 1025707 (DBA Cockpit: Planning calendar and remote Oracle databases) the section "3. Connection through SAP gateway", am I right?
And also check the information in sap note 980266 (RFC destination SAPXPG_DBDEST_<DB-HOST> does not work), right?
Thank you Reagan for your patience 🙂
regards,
samid
I believe that I must follow the instructions in sap note 1025707 (DBA Cockpit: Planning calendar and remote Oracle databases) the section "3. Connection through SAP gateway", am I right?
And also check the information in sap note 980266 (RFC destination SAPXPG_DBDEST_<DB-HOST> does not work), right?
You are in the right track now.
Good Luck
RB
Hello,
For this, first I need to install a standalone gateway on DB host server. For this activity, I´m reading the following installation guide:
-> service.sap.com/instguides
-> SAP NetWeaver
-> SAP NetWeaver 7.4
-> Installation
-> 3 - Installation - Standalone Engines
-> Installing Gateway for SAP NetWeaver 7.1 or Higher
But now I´m with a doubt regarding which version of SAP Software Provisioning Manager I need to download/run for this installation. My ERP systems are in release ERP 6.0 EHP5 (with NW EHP2 - which means that SAP_BASIS and SAP_ABA components are in 7.02 version).
This is important, because for instance, as you know I need to download the software provisioning manager 1.0 (http://service.sap.com/sltoolset -> Software Logistics Toolset 1.0 -> Software Provisioning Manager) here there are two SWPM types:
SWPM10SP02_4-20009707.SAR Software Provisioning Manager1.0 SP2 for
NW higher than 7.0x 4 Info 267126 12.07.2013
SAR SWPM10SP03_7-20009707.SAR SW Prov. Mgr. 1.0 SP03 for systems based
on NW7.1x or higher
Which you think is the indicated file for my case? I guess it is the first (SWPM10SP02_4-20009707.SAR) because it says that is for NW higher that 7.0x and as I said before our NW release in our ERP systems is 7.02!
Can you clarify me please this point?
regards,
samid
Which you think is the indicated file for my case?
Read this article
http://scn.sap.com/community/netweaver-administrator/blog/2013/08/21/swpm-variants-70swpm-or-swpm
Regards
RB
yes, you are correct.
Note 1680045 - Release Note for Software Provisioning Manager 1.0
Ok, thank you for the link and the information... but even so
As I said, my system is a SAP ERP 6.0 EHP5 with SAP NW EHP2 (SAP_BASIS and SAP_ABA components are 7.02 version)
Therefore I believe the installation guide that I need to follow is not that I mentioned ("Installing Gateway for SAP NetWeaver 7.1 or Higher"), I think the installation guide that fits my release is the "Installing Gateway for SAP NetWeaver 7.0 / 7.0 EHPs":
-> service.sap.com/instguides
-> SAP NetWeaver
-> SAP NetWeaver 7.0 (2004s)
-> Installation
-> 3 - Installation - Standalone Engines
-> Installing Gateway for SAP NetWeaver 7.0 / 7.0 EHPs
Please, can you confirm if this is the correct thought!
Am I correct or not?
___
I have one more question...
Regarding the following options:
-> service.sap.com/instguides
-> SAP NetWeaver
-> SAP NetWeaver Gateway 2.0
What´s this? Is the sap product that SAP Gateway that I need to install?
Kind regards,
samid
Hello,
I installed a SAP Gateway in DB host and now the RFC SAPXPG_DBDEST_LISZGPORA001 (SAPXPG_DBDEST_<DB-HOST>) is work but when I schedule in DB13, for instance, the "Check and update optimizer statistics" it show the following information:
Job started
Step 001 started (program RSDBAJOB, variant &0000000000024, user ID ADMINSAP)
Execução do comando lógico BRCONNECT No host liszgpora001
Parâmetros: -jid STATS20131020181756 -u / -c -f stats -t ALL
Can't exec external program (No such file or directory)
External program terminated with exit code 1
BRCONNECT returned error status E
Job finished
The RFC SAPXPG_DBDEST_LISZGPORA001 in Central instance (liszgpsap003) and also in Dialog instance (liszgpsap004) is configured like this (the LISZGPORA001 is the DB host) and like I said above, now the connection is good:
Any tips? Can you help me to understand what is the problem now?!
Best regards,
samid
I created a specific thread for this new issue in the following url:
http://scn.sap.com/thread/3441054
Thank you,
samid
I created a specific thread for this new issue in the following url:
http://scn.sap.com/thread/3441054
Thank you,
samid
Hi,
Have you checked this SAP Note 446172 - SXPG_COMMAND_EXECUTE (program_start_error) in DB13. It seems your RFC is not working.
And also, check sxpg rfc is pointing towards phyical host instead of virtual host.
BR,
Prabhakar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
In dialog instance, please check the hosts & Services file at Operating system level and make sure that entries of the target server are maintained as same as in Central instance.
Regards,
Mudasir H Syed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
Check the note 980266 and change the settings of your RFC as it has been mentioned in the note.
Note 980266 - RFC destination SAPXPG_DBDEST_<DB-HOST> does not work
Another crude work around is ( Temporary ) ,
As you are able to access the RFC from Central instance then try to run the job on Central instance only. You can remove the Dialog instance from the 'background processing group' ( SM61 ) and then execute the job. It will run on central instance only.
Regards,
Mudasir H Syed.
Hello,
I´m reading that sap note 980266.
Tell me one thing, and correct me please if I am wrong...
As I said before this is a distributed SAP system with a dialog instance, so we have three servers, the server A (central instance), server B (dialog instance) and server C (database instance/host).
Regarding that RFC SAPXPG_DBDEST__<SAPDBHOST>, in central instance the settings of this RFC has the program field with server A host.
In dialog instance the settings of this RFC has the program field with server A host.
So... my question is, the value of that Program the value of thisfieldshould not be for both RFC´s (in central and dialog instance) the server C host, this is, the database host? I think so, but can you tell me if I am right, please?
Kind regards,
samid
Hello Ankit Mishra,
I did what you suggested and yes, it corrects the RFC SAPXPG_DBDEST__<SAPDBHOST> in dialog instance.
I run again in DB13 the activity Check and update optimizer statistics and again it stops with an error... not the initial error, it´s a new error!
Job started
Step 001 started (program RSDBAJOB, variant &0000000000023, user ID ADMINSAP)
Execute logical command BRCONNECT On host liszgpora001
Parameters: -jid CHECK20131011180519 -u / -c -f check
BR0801I BRCONNECT 7.20 (1)
BR0252E Function fopen() failed for './dbs/initAZP.sap' at location BrInitSapRead-1
BR0253E errno 2: No such file or directory
BR0159E Error reading BR*Tools profile ./dbs/initAZP.sap
BR0280I BRCONNECT time stamp: 2013-10-11 18.05.20
BR0301E SQL error -12545 at location db_connect-2, SQL statement:
'CONNECT /'
Error while trying to retrieve text for error ORA-12545
BR0310E Connect to database instance AZP failed
BR0806I End of BRCONNECT processing: cemhednc.log2013-10-11 18.05.20
BR0280I BRCONNECT time stamp: 2013-10-11 18.05.20
BR0804I BRCONNECT terminated with errors
External program terminated with exit code 3
BRCONNECT returned error status E
Job finished
Can you help me please?!
Thanks,
samid
Hello Ankit,
1. Grant 777 or 775 perimission to conn<SID>.log created under /oracle/<SID>/sapcheck
I didn´t found any sapcheck directory under /oracle/<SID>
All this checks is to be done in Database host or in central instance, dialog instance hosts?
I also check the permissions in /oracle/AZP/11202/dbs (in Database host) and also in the files under dbs and everything is OK, like you recommended
What I don´t understand is... when I read the sap note 980266 (RFC destination SAPXPG_DBDEST_<DB-HOST> does not work) I thought that RFC´s (in central instance and dialog instance) should has in the 'Program' field the path of sapxpg program in database instance/host and not to the central instance (gateway host and service of the Central instance)! What you think about that?
regards,
samid
Do you have Database host and central instance host different ?
- If this is same, in RFC you just need to update Gateway host & Gateway Service of Central Instance.
- If database host has no sap instance installed : you need a Gateway installed on this host.
BR0801I BRCONNECT 7.20 (1)
BR0252E Function fopen() failed for './dbs/initAZP.sap' at location BrInitSapRead-1
BR0253E errno 2: No such file or directory
BR0159E Error reading BR*Tools profile ./dbs/initAZP.sap
>> what is your ORACLE_HOME for sidadm & orasid on database host ?
Also verify permissions of brtools with Note 113747 - Owners and authorizations for BR*Tools
/oracle/SID/sapcheck is a standard default directory on database host for storing BRCONNECT logs. If it is not there, please create it. Permission can be 775 for orasid:dba
make sure you have permissions for dbs & initSID.sap like below :
dbs > drwxr-xr-x oraSID:dba
initSID.sap > -rw-r--r-- oraSID:dba
best regards
ashish
Hello ashish,
Do you have Database host and central instance host different ?
They are in different hosts! So, in this case, I need a Gateway installed on this databse host, am I right?
>> what is your ORACLE_HOME for sidadm & orasid on database host ?
For azpadm and oraazp the ORACLE_HOME is the same: /oracle/AZP/112_64
/oracle/SID/sapcheck is a standard default directory on database host for storing BRCONNECT logs. If it is not there, please create it. Permission can be 775 for orasid:dba
The location of sapcheck directory is not, in my case, in /oracle/<SID>/sapcheck, instead it is in the following directory: /oracle/AZP/sapdata/sapcheck
It has the following permissions:
drwxr-xr-x 2 oraazp dba 12 Aug 12 13:13 sapcheck
make sure you have permissions for dbs & initSID.sap like below :
dbs > drwxr-xr-x oraSID:dba
initSID.sap > -rw-r--r-- oraSID:dba
I checked the permissions in /oracle/AZP/11202/dbs and also in the files under dbs and everything is OK, like you recommended:
drwxr-xr-x 2 oraazp dba 27 Oct 13 02:47 dbs
-rwxr-xr-x 1 oraazp dba 6996 Feb 25 2013 initAZP.sap
Any tips?
Kind regards,
samid
you are right.. you should installed a standalone gateway on database host.
Nicholas Chang has explained it very well in http://scn.sap.com/thread/1937412
So just follow all steps and let us know in case of further problems.
best regards
ashish
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.