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
Upgrades
We will be discussing upgrade topics ranging from preparations till the cut-over.