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.  

Oracle Database Backup using Brtools on a Disk

Hi All,

This blog contains steps with screenshot which shows you the steps to take Oracle DB backup on Disk.

Please stop your SAP application server before you proceed with your DB backup activities and take a backup of initSID.sap file before you modify it manually.

Step1: Modify the initSID.sap file present in the location :\oracle\SID\11202\database (windows) or /oracle/SID/112_64/dbs(Linux).

 

Change the entries as shown in the figure above(Change "backup_dev_type = disk" and "backup_root_dir = :\location" and save and quit.

Step2: Start Brtools utility from the command prompt by logging in as SIDadm on windows and oraSID  in Linux.

 

Enter "4" (Press Enter Key)

Enter "1" (Press Enter Key)

 

Enter "c" (Press Enter Key)

Enter "c" (Press Enter Key)

Enter "c" (Press Enter Key)

It will show you the summary of all the files which it will copy during this backup activity, Press "c" and continue.

You can see the progress of your backup as shown in the screen above.

Finally once your backup is over, you can see the return code 0 on the screen which shows that your backup was successfull.