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 sapbasis25 on Oct 8 at 9:40 PM
Hi,

Please find the error

delete from d07.D07.USR02 where BNAME='SAP*' and MANDT=600;


Msg 208, Level 16, State 1, Line 1
Invalid object name 'd07.D07.USR02'.

i have not found any usro2 name in the tables at sql
*d07*.USR02 or
*D07*.USR02 or
*d07.D07*.USR02 klike this i have not found any files in the data base'


my login user_automatic is ==1 when iam doing all this activites
after successfull excute only in sql query
I have to make the value to 0 is it right

Kindly guide me for the next

---------------Original Message---------------
From: Navneet Kumar Vivek
Sent: Wednesday, October 08, 2014 4:04 PM
Subject: SAP Client 600 Has Been Locked (sap*.ddic,basis)

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

 
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
sapbasis25  

achievements
 
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