Skip to Content
author's profile photo Former Member
Former Member

How to unlock a Z table ?

Hi , I have cleared the key field check for some fields and tried to ADJUST AND ACTIVATE the table using data base utility (SE14 ) . But some problem occured in activating that . So I tried to chnage it again , But I could not open the table in chnage mode. error message is as follows

ZSCORECARD_EXP is locked because a restart log exists

Diagnosis

Table is locked against changes because a database operation has not yet been completed (a restart log still exists).

Procedure

Wait a few minutes or check the table using the database utility (function Utilities -> Database utility) - please look at the information on the table in the database utility.

ERROR FROM step 2 onwards IN DATABASE UTILITY

Seq of steps

1 Initialization

2 Dropping of indexes, renaming of original table

3 No action

4 Activation of transparent table

5 Conversion of data to new table, deletion of renamed table

6 Creation of sec. indexes

Please help me . Thanks In advance .

Dharma.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2008 at 09:23 AM

    Hi Dharma,

    You can use transaction SM12 to lock or Unlock objects but you should be authorised for using this transaction.

    For Authorization you will have to contact SAP Basis people (They can also unlock your table).

    Regards.

    Amit Bisht.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2008 at 09:38 AM

    Hi

    primary key fields should be the first field of the ztable.

    so change the new primary key field to first column of the ztable.then place the other fields.

    after that choose Utilities menu button->Data Base Object->Data Base Utility

    in the new screen click on Acitvate and Adjust the database button.

    then the table get activated and duplicate entries with respectivwe to new primary key get deleterd.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2008 at 11:26 AM

    Dear,

    GO throught sm12 t-code and select your se11 or ur ztable and unlock it.

    Thanks,

    jaten

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 11, 2008 at 12:59 PM

    Hi Dharma,

    As you have already tried to adjust & activate the table using database utility but you are still getting the same issue so just go to SM12 & delete the lock entry for your table & after that again try to adjust & activate your table..

    This might resolve your issue..

    Best of luck,

    Bhumika

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Matthew Billingham

      Hi All ,

      Yes , This has nothing to do with the SM12 lock . This is realated to DATABASE UTILITY . While I activating and adjusting the changes using data base utiliy .. job got terminated .It seems Data base utility performce a series of steps .. It failed at from second step on wards .

      1) Initialization --Success

      2)Dropping of indexes, renaming of original table

      3)No action

      4) Activation of table

      5) transparent Conversion of data to new table, deletion of renamed table

      6) Creation of sec. indexes

      Currently it is inactive . Please help me how to delete the reset log and activate the table . Thank you .

      Dharma .

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.