Table MONI is locked.

[former_member249185]

Hi All,

The job SAP_COLLECTOR_FOR_PERFMONITOR is getting failed because of table MONI is locked. The error message is like below.

Job started

Step 001 started (program RSCOLL00, variant , user name XCHAKHA

Table MONI is locked by user XCHAKHA

Job cancelled after system exception ERROR_MESSAGE

Please do needful.

Thanks & Regards,

Charanjit.

[Former Member]

Hi Charanjit,

First Unlock the Table which is locked by using the below code.Then rerun your process again after running this code in SE38.

REPORT ZUNLOCKTABLE.

data:

varkey like rstable-varkey.

varkey = sy-mandt.

call function 'DEQUEUE_E_TABLE'

exporting

• MODE_RSTABLE = 'E'

tabname = 'MONI'

varkey = varkey

• X_TABNAME = ' '

• X_VARKEY = ' '

• _SCOPE = '3'

• _SYNCHRON = ' '

• _COLLECT = ' '

.

case sy-subrc.

when 0.

message i398(00) with 'success'.

when others.

endcase.

Thanks & Regards,

Sudheer.

[former_member249185]

Hi Sudheer,

Thanks for your support, but how can i unlock my MONI table ? what is the transaction for the same ?

Thanks & Regards,

Charanjit.

[Former Member]

Hi Charanjit,

I have already mentioned the Function Module which is used to unlock the Tables.

In the next post I have given you a program which uses that function module.

In this Program I have entered the table MONI, whcih will be unlocked after to run the program.

Go to TXCode SE38.

Enter the program name as ZUNLOCKTABLE.

Create.Select AS Executable Program.

Save as Local Object.

And copy my code and add in that program.

After that press F8 to execute the program.

Your table will be unlocked by getting a message Success.

Let me know if u have any problem.

Thanks,

Sudheer.

[Former Member]

Hi,

it is kind of strange. Just check as some one else stated earlier if some other instance of SAP_COLLECTOR_FOR_PERFMONITOR is running in parallel. This might be an old job. At the same time look for the last successful and first unsuccessful run of the job. It might give you some hint. Check if some old process related to this job is hung at the OS level.

Regards.

Ruchit Khushu.

[Former Member]

Hai,

ZUNLOCKTABLE is a customized table...

Regards,

Yoganand.V

[Former Member]

Hi Yoganand,

This is not a customized table.

This is just name of the report program which I have created to unlock a table which is Locked.

Thanks,

Sudheer.

Edited by: sudheer chowdhary on Jan 15, 2009 8:01 PM

[Former Member]

Hai,

I mistyped it as table instead of report..

Anyway you have create your own report using the function module defining which table is locked and so on..

Regards,

Yoganand.V

[Former Member]

You are right Yoganand.

Thanks,

Sudheer.

[Former Member]

Hi,

You should unlock the table MONI by using this Function Module 'DEQUEUE_E_TABLE'

Thanks & Regards,

Sudheer.

[former_member249185]

Hi,

It's not related to lock entries. My table MONI is locked & there is no single entry in SM12 transaction.

Thanks & Regards,

Charanjit.

[Former Member]

Log off the sap sessions for user XCHAKHA who has locked the table and retry.

[former_member249185]

Hi,

XCHAKHA is my user id. There is no lock entry found in SM12 & 13.

Thanks & Regards,

Charanjit Singh.

[Former Member]

check if multiple SAP_COLLECTOR_FOR_PERFMONITOR job is running.

[Former Member]

Hai,

Please check SM21 logs, you might have the logs saying Lock table overflow.

Check the below links.....

http://sap.ittoolbox.com/groups/technical-functional/sap-basis/lock-table-overflow-1199105?cv=expand...

http://help.sap.com/saphelp_nw04/helpdata/en/f0/b57338788f4d72e10000009b38f8cf/content.htm

Regards,

Yoganand.V

[former_member249185]

Yoganand Sir,

Please help me. The error message is saying tabel MONI is locked by me.

Please do needful.

Thanks & Regards,

Charanjit Singh.

[mohammed_anish]

Just to check...in sm12, can you try without giving the client number...?

Regards,

Anish

[Former Member]

Hi,

Use the tcode SM12 and unlock the table entries.

Regards,

Vamshi.