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

SLAVE repository CREATION and SLAVE SYNCHRONIZATIOn

You would like to know what are the steps to create a Slave repository once you have a Master Repository

 

Once you have the Master Repository, you would like to know how to create a SLAVE repository and also on how to keep it in SYNCH with the Master repository.

The steps are detailed below

  1. Once you are connected to the master repositoy, right click on the master repository and go till the option of create slave.You will be asked if the repository has to be verified before the slave is created. Choose No and conitnue
  2. Select the DBMS Server and give the user credentials for that DBMS server ( Normally it would be user "sa"' and its password credentials.
  3. Here you can select a new repository name , ex. if you have the master as TST_MASTER, you can give the name as TST_SLAVE
    • Note: Please choose the approriate name as if you select from the pull down menu, you could overwrite an existing repository.  

1

 

2

4. Now click on finish.When you click on finish, you can see in the MDM console that the Master would be duplicating meaning that it is creating the SLAVE

5. Once the SLAVE creation is completed, you can see the change of icon in the Master repository ( pink couloring on the icon ) and you will get the message that the respository was successfully duplicated.Once the SLAVE has been created, it will still not be displayed in the MDM console until it is mounted.

6. Righ click on the server and click on mount respositoy.Connect to the DB with the "sa" credentials and give the repository name ( example TST_SLAVE) and give the port number on which it has to be mounted.

  •      Make sure you give a port which is not used already else you will not be able to mount the repository.

Double click the SLAVE repository and conenct to it with the required credentials.Right click on the repository and do a load repository ->Immediate. Wait until it is fully loaded, and you can the respository will come to status Loaded Running.

 

Now your SLAVE repository has been created and loaded.

 

 

 

SYNCH SLAVE

 Once you have the MASTER and SLAVE, you need to have a Synch script to keep the Master and Slave in synch once or twice a day.

When ever you need to do a snchronization of the SLAVE manually,you can right click on the Master repository and click on Synchronize SLAVE.

To automate this, get this to be done by a script and put it in a scheduler ( for Windows ) or in crontab ( Unix)

p.s - We got the script from SAP which we changed according to our environment and have put it in the scheduler to run twice a day.

 

 Regards

Bharathwaj V

            

 

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

Web Hosting by Yahoo!