We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-basis] SAP Client 600 Has Been Locked (sap*.ddic,basis)

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Reply from navneet013 on Oct 8 at 4:04 PM
1. Did you try with d07.D07.USR02?
2. If no try and share the result for below
SELECT BNAME, MANDT from d07.D07.USR02 where BNAME='SAP*';
3. If query in Step 2 runs without any issue that means schema name is correct and you can then proceed to step 7.
4. If query in step 2 gives same error again i.e. invalid object name then your search for correct schema continues.
5. Login to command prompt from appropriate user (guess d07adm?) and fire below command
set | find "MSSQL"
Look out value of parameter MSSQL_SCHEMA and MSSQL_DBNAME to verify your database and schema name.
6. Again try query from step 2 but with new discovered schema name. If it works fine then go to next step but use correct schema name.
7. delete from d07.D07.USR02 where BNAME='SAP*' and MANDT=600;
Another method to get schema name for your MSSQL database:
1. Login to SQL Server Management Studio.
2. Expand your relevant database (might be D07 in your case).
3. Expand Tables (might take some time to populate the list).
4. Look out for your table USR02 should be at very bottom of the list.
5. Schema name would be prefix to your table like
d07.USR02 or
D07.USR02 or
d07.D07.USR02

---------------Original Message---------------
From: sapbasis25
Sent: Wednesday, September 24, 2014 3:10 AM
Subject: SAP Client 600 Has Been Locked (sap*.ddic,basis)

Hi,

sap dev client 600 client has been locked in all user ids. Kindly guide me in this.

I am not able to find the answer for this please guide.

Thanks
sap basis

 
Reply to this email to post your response.
 
__.____._
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
  
Copyright © 2014 Ziff Davis, LLC. and message author.
Ziff Davis, LLC. 28 E 28th Street New York, NY 10016
navneet013  
 
Mark as helpful
View this online
Ask a new question
 
In the Spotlight
Become a blogger at Toolbox.com and share your expertise with the community. Start today.

_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language