Expressing our Experience

Expressing our Experience
Performance
- SQL Statement Tuning - Part 1
- I/O Performance - MSS
- SQL Statement Tuning #4
- Preliminary Analysis - Expensive SQL Statement, ST05, ST04, SM50, ST03
- SQL Statement Tuning # 2, Unsuitable Access Path, DB05, ST05
- SQL Statement Tuning # 3, SolutionDB, Solution Database
Upgrades
- Important Points When You Plan for an Upgrade
Oracle
- Datafile Table Relation
- Dyanmic SGA
- DB02 doesn't seem to contain latest data, DB02_COLL_PLAN, SAP_COLLECT_FOR_PERFMONITOR, ORA_MON_DBCON
- Script to Monitor Oracle Tablespace
- R3trans could not connect to database after upgrading to oracle 11g, SEC_CASE_SENSITIVE_ LOGON, ORA-01017
MSS
- SNAP_NO_NEW_ENTRY
- QFE GDR
- Never Delete files from c:\windows\installer directory (sqlrun_run.msp, sqlrun_run.msi, sqlrun_tools.msp, Couldn’t find local patch)
- Script to monitor Transaction Log Space and Alert, DBCC SQLPERF(LOGSPACE)
- Configure Database Mail, sp_send_dbmail
- SQL Server Installation, an instance with the same name is already installed on this computer, msicuu2, 290301
- SQL SP Upgrade Issues, resrcmon, sqlsrvres, Do_sqlMofComp
- Script to Monitor Deadlock
Business Objects BI Platform
- Dashboard Connectivity BICS
- Business Objects Reports to Email Destination
- Dashboard Designer - Error 2032 - BW Connection
- Managed System Setup for BOE 4.0
Tips and Tricks
- ICONS in SM02
- SO36 Auto Forwarding
- SE38 Access
- Manually applying SQL Service Pack in Cluster Nodes
- Is your global directory growing?
- Program to Schedule SM02 message in Background - SM02_ADD_MESSAGE
- Avoid opening Microsoft Word while opening a text editor from Smartforms/SAPScripts, rscpseteditor
- Converting Spool Request Ouput into a PDF Format, RSTXPDFT4
- Freeze Transports, T_OFF, NOIMPORT
- Getting list of application servers attached to Message Server, msgserver, commands
- Do you want to Ping (LAN) any of your end user PC from SAPGUI?, ST06,
OS/DB Migration
- Creating Task File - System Copy
Run SAP
- CTS+ Error Scenario # 2 - Class java.rmi.RemoteException:Another Session = [Local port:0, Host:xxxxx, Port:5xx18, SessionID:3] is still valid – cannot create a new one
- CTS+ Error Scenarios # 1 java.rmi.RemoteException
- CTS+ Error Scenario # 3, “couldn’t find any of the known states in group”, java.lang.IllegalStateException
- Increase Heap Memory of Wily Introscope Enterprise Manager
- Deactivating HTTPs for Webdynpro pages
Data Archiving
- Arciving Intermediate Documents, IDOC, Archive Object, EDIDC, EDIDS, EDI40
- BALDAT SLG2 SBAL_DELETE
- Archiving SAPOffice, Business Workplace (Transactions SBWP, SO01, SO00, etc., and Tables SOFFCONT1, SOOD, SOC3, etc.,)
Business Objects Data Services
- Do you want to connect to Sharepoint/Any website using WebDAV from Business Objects Data Services Server (or from any server for that matter)?
AS ABAP
- Table Buffering - ST02
- Never Attempt to Add Support Pack Related Transport Requests into Buffer Manually @ OS Level, tp addtobuffer
- SAP Instance Not Coming up Due to Semaphore 50
- Transport/Support Pack Import Steps, RDDEXECL, RDDDIC03L, RDDVERSL, tp, R3trans
- An interesting issue on SMTP relaying from SAP servers, SMICM, ehlo
- TEST IMPORT, SPAM, SAINT, TP
- Interesting issue on DMS, nothing happens when a user tries to open a document from DMS, CV04N
AS JAVA
- How to Activate Gateway Service On SAP Java Application Server, gwrd,
- Monitoring SAP System using Wily Introscope
- Interesting issue around ADS - com.sap.engine.services.ejb.exceptions.BaseEJBException: Transaction system failure in method rpData
- How we resolved the issue of Frequent Full GC that was running every .03 seconds?, Verbose, system.gc()
- Steps to customize Portal Logon Screen, authschemes, com.sap.portal.runtime.logon.par
- SLD Association Error - Can't create association. com.sap.sld.api.wbem.exception.CIMException: CIM_ERR_FAILED: Invalid key value or reference
- Frequent User Locking Issue in SAP PI system, SLDAPICUST, SAPJSF
XI/PI
- Decentral Adapter Engine - Protecting Web Services - SystemCookiesDataProtection
- Transporting Integration Objects - Transport Target
- JVM Analysis - PI/XI, Memory Analyzer, JVM Leak
VMWare
- Facts on SAP Applications running on MS SQL Server with VMware software
TREX
- Alert Server Configuration
- xRPM system CFolders TREX Search Configuration
MDM
- Handling Repositories in SRM-MDM during system refresh, Archive Repository
- SLAVE repository and SYNCH scripts
- MDM 7.1 SP 07 - Issues and Whats New
SAP BW
- Deleting a Query from OLAP Cache, RSRT, RSRCACHE
- Handling “Warning concerning the BW extraction” during support pack/add-on installation/upgrades
- BEx history is missing
- BEx- Export to Excel – Results in xls file with huge size (i.e. 50 MB)
- Quick Tip to Enhance BW Query Performance
General
- SAP Architecture History and Evolution
- loader.LoaderError: [-25008] Logon failure; previous user's (SUPERDBA) connection was restored.
Whitepaper
- Whitepaper on Defining SAP Security Patch Strategy
- A Guide to Perform End-To-End SSL for SAP WebDispatcher
- Whitepaper on Defining Backup Strategy
- Guide to Perform Efficient System Copy
- Whitepaper on SAP Webdispatcher
Installation
- Difference in Multi-SID Installation between Windows 2003 and Windows 2008, linkd, Client Access Point
Scripts
- DiskSpace Monitoring Report - for Windows
About us
Ask a question

Scripts

Under this section, you will find useful scripts that can be used to automate the monitoring process in SAP environment.

Copyright 2012 SAP Basis Experts On Demand . All rights reserved.

Web Hosting by Yahoo!