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

Oracle

 

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

Web Hosting by Yahoo!