SAP Missing Excel Templates while exporting

Recently we are facing issue while exporting in excel format.

It’s throwing below error.

Solution – Run Report in SA38 – BCALV_BDS_IMPORT_SAP_TEMPLATE in DIALOG mode.

The above report will not ask any input & complete in seconds.

Then try again to export the same contents in excel, you will receive an error first time but next time it will solve & export the contents in excel successfully.

SAP Java Portal change password through Telnet

I am working on SAP Java Portal upgrade from NW 7.3 to 7.4. While SUM enter in execution phase, security team changed the credentials of “Administrator”. due to this upgrade got stuck & i am not able to change password back to same in Portal.

I performed the same through telnet by following below method. before performing this i change UME parameter in config tool & restart the cluster.

Change minimum length of password – 4
Keep password history – 3

telnet localhost 50008

Enter user name
enter current password

Type – add user
enter current password — click Enter

enter user – Administrator
enter new password
confirm new password

Now you can set same password what you have given during Configuration Phase in SUM & continue to upgrade.

Let me know if this works for you.

Z programs behaving like SAP Program after changing the domain controller

After changing the Domain Controller, if your Customize Programs (z) behave like SAP Program, please follow below steps to change the same.

Z programs behaving like SAP Program after changing the domain controller
( ED1 –> EX1)

Need to switch off the Assistant

SA38 – Program – Edit – Modification Operations – Switch off Assistant


Recently we have configured HTTPS in our SAP system. After configuring the same our NWBC portal is not working with HTTP, whenever we open portal, it tries forwarding HTTP to HTTPS & give us error. We don’t have self certificate installed for HTTPS as we are using HTTPS for third party communication. All other traffic on https are blocked. No user is able to open NWBC.

for permanent solution of NWBC to use only HTTP, change as below:

SICF — Search for NWBC

Double click on NWBC

Go to Error Pages Tab

Click on Configuration

Change – Action During Logon

Select Protocol – Do No Switch

Click on Save – It will ask for transport. You can forward the same settings to further systems.

Now when you open again NWBC, it will not switch from HTTP to HTTPS.

Unlock TMSADM user automatically in SAP

While working on STMS, mostly users faced issue that TMSADM user lock continuously in 000 client. Due to this RFC’s stop working & STMS_IMPORT screen is also asking password multiple time.

for coming out from this situation we have developed 1 customise report for unlocking TMSADM automatically.

1. Create 1 report in SE38 (paste the below content) & save it as executable program.
2. Schedule 1 job in SM36 to run every 5 min in 000 client.

Let me know if you face any difficulty or share you comments.


TABLES: usr02.

l_t_usr02 TYPE TABLE OF usr02,
l_s_usr02 TYPE usr02.

CLEAR: l_t_usr02.
bname = ‘TMSADM’ and
uflag in (’64’, ‘128’).

IF l_t_usr02 IS INITIAL.
MESSAGE s306(rsec).

UFLAG = ‘0’
bname = ‘TMSADM’ AND
uflag in (’64’, ‘128’).



Verification of HTTPS connection during upgrade.

Recently we are upgrading our JAVA Portal which is running on DMZ with https protocol enabled.

While starting SUM SP16, it’s started by default http but if SUM detect system is running on https, it’s get converted to https automatically.

We are facing issue while it’s asking for adm credentials. it’s not accepting the credentials & in log file it’s throwing SSLERR_PEER_CERT_UNTRUSTED error. we have checked multiple log files & found that it’s trying to access the system via https protocol.

How to check https connections are working or not before running SUM

SAPCONTROL give you the facility to check the same.

sapcontrol -nr -host -prot NI_HTTPS -function AccessCheck Stop

sapcontrol -nr -host -prot NI_HTTPS -function ParameterValue

Give instance no. & hostname in above fields & run the commands.

The above both commands should return “Access Check” “OK”. if it’s failing with SSLERR_PEER_CERT_UNTRUSTED issue, then SUM will never work. in my case i have tested the above command on my second application server & it works there, i ran the SUM from there & upgrade my portal successfully without any single error.

SAP STMS – Buffer Cleanup automatically while adding transport

If the STMS buffer cleanup automatically after adding transport & you cannot see any TR in STMS_IMPORT screen and the buffer file shows :

#1/_TASK CLITRELESAPUSER EXL W H A I r0 C r1 0 V R G < K T t r5 umodes ASCL20130828182513000 00000PROJECT P033 A # buffer cleaned on 20160824182513

    You can also find the same thing in TP log. it shows cleanup run in last.


    Please cross check that all systems in STMS Path should be on same transport group – (GROUP_SID). Change the same & redistribute it.

SAP Table TRBAT contains lock entry: LOCKMARK

Yesterday i found that my auto import job in BW system got hanging & continuously running since half an hour. truck icon was there & in “Import Monitor” status is running. There is no other option for me rather then cancelling the import from Import Monitor – Right Click – Delete Entry.

I did some troubleshooting & found that “RDDIMPDP” job is running & finishing with below warning “Table TRBAT contains lock entry: LOCKMARK“.

While checking the both tables in SE16 “TRBAT” & “TRJOB”. i see old entries are exists over there. This need to be delete for overcome this issue. Entries from these tables can be delete from SM30. I did the same & run again “RDDNEWPP” in Client 000 & Productive Client by DDIC or respective user. This will schedule a new “RDDIMPDP” job.

These steps help me to resolve the issue & auto import job is running fine.

Leave comments if this helps you.