RSBOLAP018: Java system error

Problem: When you running a Process Chain in BW system, you saw an error RSBOLAP018: Java system error, as shown below.

Investigate: Check log as shown in the error description. You will find this line on files defaultTrace.xx.log :
ERROR RSBOLAP (018): Java system error: An Unknown Error Occured During Portal Communication
MSGV1: An Unknown [...]

Important Log Files for Portal Application

If you run a Portal application based on SAP Web AS, you may find an error on your running process. Mostly the errors are logged into a log files of Java server process. A Portal application usually identified by prefix http://<hostname>:<port>/irj/… Here’s the important log files location :

<drive>:\usr\sap\<SID>\DVEBMGS<inst_no>\j2ee\
cluster\serverX\log\defaultTrace.xx.trc
<drive>:\usr\sap\<SID>\DVEBMGS<inst_no>\j2ee\
cluster\serverX\log\applications.x.log

X: server process number, start from 0,1,2 .. [...]

DB02 statistics blank

If I’m not mistaken, display for DB02 is changed from SAP Netweaver 7.0  SP12 into a kind of DB Cockpit which also can be accessed from tx code ST04, DB13, DB14, and some DB transactions. After a Support Package upgrade or refresh sometimes it’s not displayed properly or blank as displayed below :

In my case, [...]

ORA-20000:Index or partition of such index is in unusable state

Problem: In SAP BW system when you run update statistics you find an error below,
BR0301E SQL error -20000 at location stats_tab_collect-20, SQL statement:
‘BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => ‘”SAPBWP”‘, TABNAME => ‘”/BIC/B0001595000″‘, ESTIMATE_PERCENT
ORA-20000: index “SAPBWP”.”/BIC/B0001595000KE”  or partition of such index is in unusable state
ORA-06512: at “SYS.DBMS_STATS”, line 13267
ORA-06512: at “SYS.DBMS_STATS”, line 13287
ORA-06512: at line 1
BR0886E Checking/collecting statistics [...]

Analysing Memory Using sappfpar command in SAP

SAP provides a tools to analyse memory consumption for Web AS ABAP called sappfpar. With this command you can estimate a memory consumption in a detail based on parameter setting in instance profile. Command will be like this :
>sappfpar check pf=<Instance Profile>
and the example result:

From the picture above you can see a lot of parameter [...]

Reset Password itsadmin in ITS 6.20

Due to incorrect logon or forgot the password user itsadmin in SAP ITS 6.20 is locked. Incorrect password can be occured after upgrading ITS or just after installation. Here’s the procedure how to reset the password:

Make a backup of ItsRegistryADM.xml in configuration folder, so you can revert it back if needed.
Search “itsadmin” in ItsRegistryADM.xml file.
Password [...]

Notes in updating clustered SAP system Kernel

This is a little note when you upgrading the SAP Kernel in clustered system on Windows OS: Dont forget to copy the Kernel folder /usr/sap/<SID>/<instance>/SYS/exe/run to C:/Windows/sapcluster folder. I got an error when I didn’t copy the Kernel folder to cluster directory. And this has to be done in both cluster nodes which I think [...]

Procedure to unlock J2EE Admin using SAP*

Open ConfigTool which is located in <drive>:\usr\sap\SID\JC05\j2ee\configtool\configtool.bat, for Unix you can run ./configtool.sh
Switch to configuration editor mode.

Go to cluster_data -> server -> cfg -> services.

Switch to edit mode by pressing pencil button.
Click on Propertysheet com.sap.security.core.ume.service
Change ume.superadmin.activate to TRUE.
Define the SAP* password in ume.superadmin.password.

Restart Web AS Java.
Login to visual admin.
Go to service -> security provider. Open [...]

J2EE Start-Up Issue Troubleshooting Guide

Well just wanna share to you, I just got a good link from my friend’s website. It’s about troubleshooting guide when you start up Java Web AS application. You can find the pdf document here. This guide was created by Kenny Tully. Cheers,

Unlock Java Administrator using SAP*

Java Engine UME (User Management Engine) can be stored in Data Source which are located either in SAP System data source, UME Database or Directory Service Data Source. They have different scenario of user administration, those are :

J2EE_ADMIN for SAP Web AS with ABAP and Java
J2EE_ADM_<SID> for SAP Web AS Java (UME uses ABAP user [...]