SXPG_COMMAND_EXECUTE failed for BRCONNECT

Hi All,

While running certain jobs in from TX DB13, it was failing in our landscape as our CI and DB are on different host.

After checking the log, I found the below logs:

+++++++++++++++++++++++++++++++++++++++++++

SXPG_COMMAND_EXECUTE failed for BRCONNECT - Reason: program_start_error: For More Information, See SYS
Message no. Q2233

Diagnosis
This message includes variables. No additional information can be specified.
+++++++++++++++++++++++++++++++++++++++++++

Googled this and found many confusing solutions. Also, for your information, our servers were on AIX and I am sure the solution will work on all linux flavors.

Solution:
Follow SAP note number, Note 446172 - SXPG_COMMAND_EXECUTE (program_start_error) in DB13 section 8.

Login to system as root user and execute the command which is shown below in your SAP primary application Server(CI):

rsh -l adm sapxpg 

Ex: rsh -l SIDadm sapxpg
where hostname name is the hostname of the DB Server.

In my case it failed with permission denied error("Permission denied", "Can't establish connection" or a password query). Now, follow the procedure to fix this error.

Open file /etc/hosts.equiv and make an entry about the other host and the user which should be allowed to execute the command in Db server.

Ex:
hostname sidadm
hostname orasid

Where hostname is the hostname of your SAP Primary application Server and "sid" is the SID of your SAP Server.

Cheers,
Sharib Tasneem