Skip to content

SAP ST03n after System Copy/Refresh

After system refresh/copy i found that ST03 still showing the name of source in Workload Analysis menu.  Here is some work around to delete the source.

Go to ST03n-

Change to Expert mode -

Go to Collector and Performance DB — Performance Database — Workload Collector Data —Contents

Select all the right hand side value of source system & delete all.

Now your source system is removed from ST03 Workload menu.

After deleting the source system you got a popup with error “No System Load Data Available”.

Adding Present System in Workload Menu.

Schedule the SAP standard job “SAP_COLLECTOR_FOR_PERFMONITOR” from SM36 in hourly basis.

This job runs the ABAP report “RSCOLL00″ , Collect the data and update your Workload Menu.

Posted in SAP.

Tagged with , , , , , , , .

No comments

By adil – May 18, 2012

Increasing no of days for Workload Analysis in ST03n

I have got a call from one of my colleague saying that how to increase no of days for workload in st03n. This time is a new question for me so i find the solution for the same.

Go to ST03n

Present Value

How to Change:

1. Change to expert mode -   

2. Go to Collector & Performance DB

 

3. Open Control –

4. Change the value of:

Daily = 30 (as required)

Weekly = (as required)

Monthly  = (as require)

save the entry.

 

Now  you are Done..

Posted in SAP.

Tagged with , , , , , .

No comments

By adil – May 15, 2012

SAP License Installation error

We have found a strange error while installing new SAP license. my SAP license got expired. SAP* is only the user who is able to login into system and install the new sap license in slicense tcode.We are unable to install the new license. We have raised the issue to SAP, SAP suggests that first delete the old license then install new one, unfortunately SAP* also not able to delete the expired license. We gone through this SAP note 917936 to resolve the issue but this note is not applicable for us as we are on higher SP level as given.

Install the license through OS level. (saplicense)

Prerequisites

The database interface library is linked dynamically as of Release 4.5A. For saplicense to find this library, the following variables must be set in the environment of the user calling saplicense:

dbms_type = <database type> (for example, ora , inf , ada , mss , db2 , db4 , db6 )
DIR_LIBRARY = <path to dynamically linked database library> (for example, /usr/sap/SID/SYS/exe/run )

You must be logged on as the <sapsid>adm user. This ensures that all of the required environment variables are set correctly.

saplicense -show                      Display all SAP license.

if it’s not working then also check your database connectivity by R3trans -d.

saplicense – delete

First enter the SAP System ID. saplicense then asks you for the hardware key (11-character hardware key).
Enter the hardware key.

saplicense then asks you for the product ID (a name beginning with “R3_”) that indicates the database type (for example, R3_ORA).
Enter the relevant product ID for your SAP System.

The licenses are then deleted. This is confirmed by the message: saplicense: license deleted

saplicense -install   (This license can be provided manually or by file)

Please refer :

http://help.sap.com/saphelp_470/helpdata/en/a7/512c88407a11d1893b0000e8323c4f/content.htm

Source: help.sap.com

Posted in SAP.

Tagged with , , , , , , .

No comments

By adil – May 11, 2012

SAProuter Testing & Troubleshooting

The SAProuter is a program that acts as an intermediate location in the network between SAP systems where access is controlled before data is sent further along the communication path. Connections can also be established between SAP systems over several SAProuters. You can then secure connections between adjacent SAProuters using SNC.

Here are some basic commands to troubleshoot & checking the connectivity of SAP Router to SAP or others SAP routers.

Restart a router:
saprouter -r -V 2 -K “p:CN=<local saphost>, OU=<customer number>,  OU=SAProuter, O=SAP, C=DE“

2. Out put to below commands should be error free respectively enables you to verify certificate import to SAProuter local host reach on required port:

Output of the command ‘sapgenpse’
Output of the command ‘sapgenpse get_my_name -n all’
Output of the command ‘sapgenpse seclogin -l’
Output of the command ‘ping 194.39.131.34′ <localsaphost at your end>
Output of the command ‘telnet 194.39.131.34<localsaphost at your end> 3299

3. To verify internal firewall has been released to allow the access from your R/3 system(s) to your local saprouter server. You can verify the firewall rules and the connectivity to SAP using the following commands:

niping -c -O -S 3299 -H <localsaphost at your end>
niping -c -O -S 3299 -H /H/<localsaphost at your end>/H/194.39.131.34
niping -c -H /H/<localsaphost at your end>/H/194.39.131.34/H/194.39.131.34

All above command end with success or with connected message. if you find any error in any above niping command then you might have PORT opening issue in firewall or certificate issue.

Posted in SAP.

Tagged with , , , , , .

No comments

By adil – May 6, 2012

Trick: Approve download basket via Solution Manager

SAP Basis Administrator responsibility is to approve the basket and download the objects in Download Manager. For easiness and without creating any Maintenance Transaction in solution_manager, you can do the same via SE37.

Logon to Solman and run SE37.

Then —- /TMWFLOW/MO_UI_BASKET_AUTHORIZ

Insert the value I_OSS_RFC = SAP-OSS

Then Click on Execute Button

Here we can see T_APPROVED_OBJECTS is one  which we were approved.

Run SAP Download Manager –> Download the selected and approved packages.

viagra

Posted in SAP.

Tagged with , , , .

No comments

By adil – April 22, 2012

Setting email alert in SUM / SAPup & EHPi

While upgrading SAP system through EHPi / SUM & SAPup, we always keep our session alive to check where our tool got stuck or where it’s required user input. if you close the session and tool get stuck so your upgrade time will increase & you didn’t meet up with your deadline, we also faced the same issue. Later on we have read the SUM guide that you can set the alerting so you will get an email/sms during stuck or requires user input.

This is something tricky, however i will try to explain this in easy words.

1. Create a notepad file and save this file as .vbs ext.(example: email.vbs) and save the below contents. However you require Email address, SMTP port & SMTP server address.

Set objMessage = CreateObject(“CDO.Message”)

objMessage.Subject = “SUM Upgrade Update”

objMessage.From = “from@from.com”

objMessage.To = “to@to.com”

objMessage.TextBody = “SUM tool requires user inputs”

objMessage.AddAttachment “e:\usr\sap\EC5\SUM\abap\tmp\upalert.log”

‘==This section provides the configuration information for the remote SMTP server.

‘==Normally you will only change the server name or IP.

objMessage.Configuration.Fields.Item _

(“http://schemas.microsoft.com/cdo/configuration/sendusing”) = 2

‘Name or IP of Remote SMTP Server

objMessage.Configuration.Fields.Item _

(“http://schemas.microsoft.com/cdo/configuration/smtpserver”) = “Your mail server IP address”

‘Server port (typically 25)

objMessage.Configuration.Fields.Item _

(“http://schemas.microsoft.com/cdo/configuration/smtpserverport”) = 25

objMessage.Configuration.Fields.Update

‘==End remote SMTP server configuration section==

objMessage.Send

—————————————————————————————————————————————

MAKE SURE THAT SMTP SERVICE IS RUNNING ON YOUR HOST WHERE YOU ARE GIVING THIS SCRIPT.

You can write multiple recipients in “objMessage.To = “to@to.com” this file separating by commas.

NO NEED TO CHANGE THIS LINE

 “objMessage.AddAttachment  e:\usr\sap\EC5\SUM\abap\tmp\upalert.log”

AS TOOL  AUTOMATICALLY CREATES A FILE WITH REQUIRED DETAIL & MAIL TO YOU AS ATTACHMENT.

2. Create a notepad file with .bat ext.(email.bat) and call this vbs script(email.vbs) through this file. (as upgrade tool only recognize batch file)

 

3. Setting in upgrade tool & Test the settings.

 

4. You will received email like this.

If  you find any difficulty while configuring alert setting, you can reach me at adil(at)adilfahim.com.

Posted in SAP.

Tagged with , , , , , , , , , .

No comments

By adil – April 21, 2012

Generating Stack For EHP Upgrade

I have found a good article for creating EHP upgrade Stack through Solution Manager.

Please refer this link

 

Posted in SAP.

Tagged with , , .

No comments

By adil – April 20, 2012

SAP ECC 6.0 EHp 4.0 to EHp 5.0 Upgrade in Windows

Recently we have patched our SAP ECC system EHp 4.0 to EHp 5.0. EHP 5.0 requires Netweaver 7.0 EHP 2.0. As this is not a release upgrade but it still requires lot of efforts & time to complete, that’s why it’s call upgrade. We have calculated our STACK.xml file from SOLMAN 7.0 EHP 1 SP 23 (EHP 5.0 requires minimal level SP23). we stuck in lot of errors and it takes time to resolve it.

Before starting EHP upgrade always prepare a download directory and keep your all downloaded SAR & stack.xml  files in same directory. During upgrade sometimes EHPi got hangs & you feel it’s not working so please check abap/log or abap/tmp for any log or errors.

Below is the quick glance of errors which i faced during upgrade.

Go through this below SAP note before starting EHP upgrade.

1302772 General Installation Note

1.  Extraction Phase – Missing Notes – It will show you some missing notes. you have to import SAP notes in your ECC 6.0 EHP 4.0 system via SNOTE to continue. (some notes can only be applied in client 000 & can also requires functional people so make sure during note implementation you get confirmation from functional team)

2. Configuration Phase – SPAM Version Check -  To avoid this error update your SPAM to latest before starting upgrade.

3. Configuration Phase – Include Change Request – if you want to include any change request to be imported during upgrade to give details otherwise continue to skip this option.

4. Configuration Phase – Errors -  Download latest R3trans, tp & libdbsl(dbsoralib.dll) from Marketplace and extracts it to EHPI/abap/exenew & EHPI/abap/exe dir. This is the place where your new/extracted kernel resides, recheck that you are downloading the right R3trans & tp for your new kernel & also check R3trans -d( it should finish with 000) from your new kernel dir( i. e. abap/exe or abap/exenew)

5. Check Phase – Errors – Create Tablespace PSAPSR3702 with <given space>. This is the manual activity. you have to complete this activity via BRtools. You also get one file with name “ORATBSXT.LST“  in abap/log, in this file you will find how to create tablespace with recommended size.

6. Pre processing Phase -  Open repairs found – If your system is development system or any unreleased requests are there so release it or before proceed.

7. Pre processing Phase – MAIN_INIT/JOB_RSVBCHCK2 were Negative- Check log file and find the errors. this error occurs if you have any update request pending in SM13 or any outbound queue pending in SMQ1. Delete all the request from SM13 & SMQ1 and proceed. if it’s still giving error also run report RMCEX_SETUP_ENTRIES and delete the structural data or call transaction LBWG to delete the contents of the setup table  for all clients. Also check this SCN post http://scn.sap.com/thread/903136

8. Pre processing Phase – Lock development – This option will lock your development system for future development till upgrade.

9. Pre processing Phase – MAIN_SHADOW/START_SHDI_FIRST – failed to start shadow instance, check log file STARTFSI.log & DEVTRACE.log. usually this error occurs where there is short memory. in our case we check that if we down our main instance then shadow instance get up. both are not working simultaneously. we insert the parameter in shadow instance profile. (abap/heap_area_total = 2000000000) and also set the recommend page file size and restart the shadow instance. also check this SCN post – http://scn.sap.com/thread/1876639

10. Pre processing Phase – ACT_UPG – in our case ACT_UPG phase takes more then 12 hours to complete.

11.  Take full backup before downtime starts.

12. Downtime Phase – MAIN_SWITCH/KX_SWITCH_1 -  check log files, in our case EHPi fails to copy to 2 kernel files from exenew dir to /usr/sap/<SID>/…. we manually copy that 2 files and proceed.

13. Downtime Phase – MAIN_NEWBAS/STARTSAP_NBAS! -  check log files, in our case SAP error reading our instance profile from /usr/sap/<SID>/sys/profile. There was junk character in the profile but after removing that character EHPi again not able to read the profile so we copy the contents of our instance profile and create a new instance profile and then proceed.

14.  No more Errors in Downtime & Post Processing Phase.

We have completed our ECC 6.0 EHp 4.0 to EHp 5.0 successfully after these efforts. i was not able to note down the exact time for every phase.

Manual Post steps – in our case after logging to EHp 5.0 SAP system, we found that our Updates are deactivated, we activate the updates in SM13 & also create structure of financial. ( i forgot the exact thing as this is done by my colleague.)

Posted in IT, SAP.

Tagged with , , , , , , , , .

No comments

By adil – March 30, 2012

Oracle upgrade 10.2.0.4 to 11.2.0.2 in windows

Few days back i did my Oracle Upgrade from 10.2.0.1 to 11.2.0.2  in Windows 2003/ multiple Oracle homes environment. I did it successfully with the help of upgrade guide from SMP.

Oracle upgrade 11.2.0.2 requires 10.2.0.4 version. first we upgrade 10.2.0.1 to 10.2.0.4 then 11.2.0.2.

I have also prepare the notes for the same. if any one requires or stuck on any phase, do let me know.

 

Posted in General, SAP.

Tagged with , , , , , , .

No comments

By adil – March 4, 2012

ECC 5.0 Homogenous System Copy via SAPinst

Recetly we have done ECC 5.0 Homogenous System Copy(ABAP only) via SAPinst method. we have completed it successfully.

However it’s gives me some error while importing the Database Content.

if anyone need any assistance for ECC 5.0 System Copy, drop me an email adil(at)adilfahim.com

Posted in SAP.

Tagged with , , , , , .

2 comments

By adil – March 2, 2012