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.

Create Dummy Project for local transport

We have CHARM implemented in our landscape & all the local creation of TR’s are prohibited as per policy. During upgrade of Solution Manager 7.2 it’s asking for perform some change in Shadow System. Change is Shadow System asking TR & which we are not able to save as LOCAL due to CTS enabled.

Alternative Solution for the same is.

Create dummy project in system directly via SA38 – RSWBO_AUX_PROJECT

This new dummy project will visible in system & you can save the local TR & continue with the change or upgrade.

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
administrator
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

SAP SMQ2 Mass Queue Deletion

In some scenario or as per customer requirement, you need to delete all the Q from SMQ2. Manual deletion of Q is pain & it takes lot of time.

You can follow below method to truncate the table in safe method.

Table Name – TRFCQIN (SMQ2)

For Oracle

SQL>select count(*) from sapsr3.TRFCQIN;

COUNT(*)
———-
2517434

Cross verify the count from SMQ2 with Oracle Result.

SQL>truncate table SAPSR3.TRFCQIN;

From SAP

SE14 – TRFCQIN

Delete Data – Activate & Adjust Database.

Now your SMQ2 is empty.

SAP ITSM Text Determination Procedure & Copy Control

Recently while working on Charm Project, there is a requirement from client where we need to add some extra Text fields in “Request for Change” screen. We have added some Z fields & these all fields need to display in “Urgent Change” as Text Log while following up from the same screen.

Request for Change Extra Text Determination Z fields:
Request for Change Text Determination

After filling up all the entries you want to display these details in Urgent Change as Text Log. I have created 1 more Text field(Requirement) in Urgent Change & copy all text from RFC under that.

Below is the procedure:
SPRO
spro

Choose Define Text Objects & Text Types
sapscript

Click Change

Double click on CRM_ORDERH

crm_order

Create New Field

z08

Below are the Text ID (creation of Text ID’s are common & you can assign as per your requirement)

text_id

save the same & capture in TR.

    Text ID is created & now assigning in Urgent Connection transaction.

SPRO

text_det

Select CRM_ORDERH & Dobule click on “Definition of Procedure”

procedure

now enter manually by selecting ZMHF0001 (Urgent Change Connection)

zmhf

below screen will appear
crmh

Add new entry “Requirement” & set sequence as per your requirement.

requirment

req1

save & capture in TR.

Also verify the same in CRM UI. (Urgent for Change)

ui

Now configuring copy all text values of “request for change” to “Urgent Change”. All values will be copied in requirement tab only.

SPRO
spro

Select below ZMCR – ZMHF (Maintenance Project) & double click on “Text ID Mapping”

mapp_proj

click on New Entries
text_map

now add values here (Source to Target)
Z08(Requirement) — Target
zvalue

save in TR.

Now create New request for change in UI & insert scope Urgent Change. Fill all the entries & & check all values should be visible in Urgent Change.

result

Share your comments & feedback.

ITSM: How to block unwanted Transaction Type

if you are getting below screen in ITSM while clicking on Create Incident / Service Request & you want to block unwanted transaction type (SMIN).

ZMIN

ZMIN

You can go To SPRO – SAP Solution Manager – Capabilities – IT Service Management – Transactions – Define Transaction Type

Find the SMIN & make it inactive. while saving it will ask you TR number, you can also forward the same to further systems.

smin

Can’t connect to X11 window server using ‘hostname:2’

If you are getting this below error in while opening SAPINST GUI in linux machine then run below command.

May 8, 2015 6:38:04 AM [Info]: GUI started.
May 8, 2015 6:38:04 AM [Info]: >> No protocol specified
May 8, 2015 6:38:04 AM [Info]: >> Closed input stream
May 8, 2015 6:38:04 AM [Error]: GUI terminated with return code 4
May 8, 2015 6:38:05 AM [Info]: >> Invocation target exception: Can’t connect to X11 window server using ‘hostname:2’ as the value of the DISPLAY variable; you may consider checking your DISPLAY environment variable.

xhost +

on base machine where we start vnc.

then ssh the host and start GUI.

SAP NWBC changing HTTPS to HTTP

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.