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

Loading of 'SAPNTAB' import package is interrupted with R3load error

Hi All,

While Installing Netweaver 7.31 on HANA DB using SWPM 1.0, I encountered the error below while it went to the ABAP IMPORT stage and it failed while starting the first import.

I checked the Log and found this error below in the import logs in sapinst directory.

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

Loading of 'SAPNTAB' import package is started.

TRACE: 2012-12-05 15:16:16 com.sap.inst.migmon.LoadTask processPackage
Task file generation for 'SAPNTAB' import package:
/usr/sap/PBH/SYS/exe/uc/hpia64/R3load -ctf I /software/51042348/DATA_UNITS/EXP3/DATA/SAPNTAB.STR /tmp/sapinst_instdir/NW731/HDB/INSTALL/NW731/HDB/STD/ABAP/DDLHDB.TPL SAPNTAB.TSK HDB -l SAPNTAB.log

ERROR: 2012-12-05 15:16:16 com.sap.inst.migmon.LoadTask run
Loading of 'SAPNTAB' import package is interrupted with R3load error.
Process '/usr/sap/PBH/SYS/exe/uc/hpia64/R3load -ctf I /software/51042348/DATA_UNITS/EXP3/DATA/SAPNTAB.STR /tmp/sapinst_instdir/NW731/HDB/INSTALL/NW731/HDB/STD/ABAP/DDLHDB.TPL SAPNTAB.TSK HDB -l SAPNTAB.log' exited with return code 2.
For mode details see 'SAPNTAB.log' file.

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

Soln: I Found a solution in SAP note number 1702177 which was relevant to SUM 1.0, but to take in chance I took a backup of file SAPNTAB.STR and tried with the one which is attached to this note and it worked.

Please try it at your Risk.

Thanks,
Sharib Tasneem

Changing SAPSR3 password using BRTOOLS

Hi All,

There are times when it becomes compulsory to change the password of SAP Schema User. The older technique involves sql query which is not allowed in SAP enviroment.

The best practice to change SAPSR3 or SAP password is through BRTOOLS utility.

Step1: Login to Server as ORASID user.

Step2: brconnect -u / -f chpass -o -p

Ex: brconnect -u / -f chpass -o SAPSR3 -p new_password

In the above example,

-u / -- option means that authorization will be done from OS level user

SAPSR3 -- Represents Schema user in Normal SR3 system

-p --  New Password

Hope this will help many novice consultants.

Cheers,
Sharib Tasneem

How to change Oracle database parameter using BRTOOLS

Hi All,

You can use BRTOOLS to change Oracle DB parameter.

brspace -u / -f dbparam

Cheers,
Sharib Tasneem

RSORAISQN - Report for improving index Quality in Oracle DB

Hi All,

In this post, I will show users to use SAP report RSORAISQN to improve the index quality of table in Oracle DB. Here we are taking an example of MSEG Table. You can similarly check the index quality of any SAP table.

Note: Please use this report during Off-Peak business hours.

Login to SAP System with appropriate user rights to execute reports.

TX : Se38 - RSORAISQN - Execute.

Step 1: Analysis

You will find a screen as shown below:

Enter the detail as shown in the above example.
Finally Click on execute button and it will ask for a confirmation popup, click "Ok" on that screen.

Step2 : Checking Quality

Once step 1 is done, it will bring you to the main screen as shown above.

Now Enter the detail as shown below to check the index quality of the MSEG table.

And Click on "Execute" button.


The below screen shows, the index quality to of MSEG Table(Example)

If you find index quality to be below 60%, please follow the Step 4 to rebuild it.

Step 3: Improving Index Quality

You can enter the detail as shown below. Please make sure that your ID should be same during analysis.
And click on execute button.

Once, you rebuild the index, you can check to it using Step1 and Step2.

Thanks,
Sharib Tasneem

Error in Phase PREP_INPUT/TOOLVERSION_INI of SUM Tool During EHP5 Upgrade

Error in PREP_INPUT/TOOLVERSION_INI phase while EHP5 Upgrade while using SUM Tool.

Error Log:
++++++++++++++++++++++++++++++++++++++++++++++++++
EXECUTING /usr/sap/SID/SUM/abap/exe/disp+work (disp+work) -V
disp+work: /lib64/libuuid.so.1: no version information available
(required by disp+work)
disp+work: /lib64/libc.so.6: version `GLIBC_2.7' not found (required by
disp+work)
disp+work: /usr/lib64/libstdc++.so.6: version `CXXABI_1.3.3' not found
(required by /usr/sap/SID/SUM/abap/exe/dw_gui.so)
SAPup> Process with PID 19406 terminated with status 1 at
20121007182625!
++++++++++++++++++++++++++++++++++++++++++++++++++
Solution:

Please refer to SAP note 1563102 for its cause and solution

Error in Phase 'PREP_INIT/VALCHK_INI' during EHP5 Upgrade Using SUM Tool

Hi Guys,

We encountered some error during EHP5 Upgrade on our ECC 6.0 System while using SUM Tool.

The Error Log As Follows:
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
more VALCHK.LOG
1 ETQ201 Entering upgrade-phase "VALCHK_INI" ("20121008214727")
4 ETQ399 Set environment for standard connect:
2 ETQ367 Connect variables are set for standard instance access
4 ETQ399 System-nr = '00', GwService = 'sapgw00' Client = '000'
4 ETQ399 Environment variables:
4 ETQ399   dbs_ada_schema=SAPSID
4 ETQ399   auth_shadow_upgrade=0
1 ETQ200 Executing actual phase 'PREP_INIT/VALCHK_INI'.
1 ETQ399 Phase arguments:
2 ETQ399 Arg[0] = 'HARD-CHK'
1 ETQ359 RFC Login to: System="SID", AsHost="hostname" Nr="00", GwHost="hostname
", GwService="sapgw00"
2 ETQ232 RFC Login succeeded
4 ETQ010 Date & Time: 20121008214727
1 ETQ233 Calling function module "SUBST_HANDLE_UVERS" by RFC
2 ETQ373 parameter "IV_MODE" = "R"
2 ETQ373 parameter "IV_ALL" = " "
2 ETQ399 Table IT_UVERS (#5):
3 ETQ399 "SAP_ABA","700","","","","",""

,"","","","","",""
3 ETQ399 "SAP_APPL","600","","","","","","","","","","",""
3 ETQ399 "SAP_BASIS","700","","","","","","","","","","",""
3 ETQ399 "SAP_BW","700","","","","","","","","","","",""
3 ETQ399 "SAP_HR","600","","","","","","","","","","",""
1 ETQ234 Call of function module "SUBST_HANDLE_UVERS" by RFC succeeded
4 ETQ010 Date & Time: 20121008214727
2 ETQ374 parameter "EV_LEN" = "102"
2 ETQ399 Table IT_UVERS (#5):
3 ETQ399 "SAP_ABA","700","20121007","194751","20121007","194751","I","A","","700
","","",""
3 ETQ399 "SAP_APPL","600","20121007","194751","20121007","194751","I","A","","60
0","","",""
3 ETQ399 "SAP_BASIS","700","20121007","194751","20121007","194751","I","A","","7
00","","",""
3 ETQ399 "SAP_BW","700","20121007","194751","20121007","194751","I","A","","700"
,"","",""
3 ETQ399 "SAP_HR","600","20121007","194751","20121007","194751","I","A","","600"
,"","",""
1AETQ228 Detected invalid (temporary) start release "SAP_ABA"
1EETQ399 Last error code set is 'SAP_ABA is in an undefined state, that is not s
afe to be upgraded, reason Upgrade wasn't completed - Call the SAP Support'
1EETQ204 Upgrade phase "VALCHK_INI" aborted with severe errors ("20121008214727"

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
To fix this error, Please follow the step below:
Move to the location:
cd /usr/sap/SID/SUM/abap/bin

Execute the command: ./SAPup reset prepare

And then, once this command is executed successfully, delete SUM directory and extract fresh SUM files in the same location and continue.

Cheers,
Sharib

Note: Please refer to SAP notes for more detail.