Home > SAP software/management Tips > SAP Basis administration tips > Local data 'watch-outs'
SAP Tips:
EMAIL THIS
 TIPS & NEWSLETTERS TOPICS 

SAP BASIS ADMINISTRATION TIPS

Local data 'watch-outs'


Kevin Towert
08.20.2003
Rating: -3.60- (out of 5)


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   


As an add-on to a previous tip about having users Local Data switched on, there are a coupe of 'watch-outs' to consider.
When you switch on the Local Data, this creates an MS Access dB called SAPLocal<User ID>Data.mdb.
This file is located in the directory you specify when switching on the Local Data, it is also copied back to the NT Server where the users profile is held when they log off from NT (the file can be found under the SAPWORKDIR folder). Sometimes, users will find that SAP 'hangs' when they try something, and they will end the session through Task Mgr, log back on and the same thing happens. This is due to the database being corrupt. When you end all of the users SAP sessions and close the GUI down, check the database on the C-drive and you will see that the associated .LDB file is still there. This file is a register of who is using the data base. Both the LDB & MDB files will need to be deleted on the C-drive and the users home server. It is also worth finding out which other PCs the user has logged onto, and deleting them from those locations as well so that another corrupt version is not written back to the server. These corruptions are usually caused when the network is having problems or the users logged on more than once and one session times out and the data does not get written back to the dB correctly.

Rate this Tip
To rate tips, you must be a member of SearchSAP.com.
Register now to start rating these tips. Log in if you are already a member.


Submit a Tip




Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us   



RELATED CONTENT
SAP Basis administration tips
Converting from MDMP to Unicode
Can SAP developer include authority check for S_TCODE in a called transaction?
How to fix Smart Forms printing double purchase orders
Deriving the name of a Smart Style from a Smart Form
SAP FI/CO consultant's role during upgrade from R/3 to ECC 6.0
Alternatives to downloading a trial version of SAP IDES ERP software
Verifying data consistency in production SAP FI/CO system when restoring a backup
How to upgrade DB2 on SAP R/3 4.7
How to create a snapshot from NAS and SAN of Oracle database
How to clone an SAP ECC 6.0 instance

SAP Basis administration and NetWeaver administration
Seven tips for simplifying SAP data archiving administration
Using up-to-date SAP ABAP codes in SAP ECC 6.0
Migrating SAP Solution Manager system between Unix platforms
SAP talent management FAQ: Fresh answers to frequently asked questions
Collaboration a must for SAP hardware teams and software teams
How to establish communication between SAP Unicode and non-Unicode systems
Mission-critical SAP software demands a mission-critical hardware infrastructure
In an upgrade to SAP ECC 6.0, when do integrated apps get upgraded?
NetWeaver PI 7.1 easier to implement than earlier versions, SAP says
SAP Software Deployment Manager vs. Java Support Package Manager
SAP Basis administration and NetWeaver administration Research

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
Basis  (SearchSAP.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.



NetWeaver SAP White Papers
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2000 - 2009, TechTarget | Read our Privacy Policy
SearchSAP.com is a search service provided by TechTarget and is completely
independent of and not affiliated with SAP AG.
  TechTarget - The IT Media ROI Experts