on 10-03-2013 3:00 PM
Hi Experts,
We have a issue with the 124002 ID request for the ODS ZSDOD005 (request number REQU_6ROBVFEQ9SSOIJY5MDF2W9BTX).
It has green status, but if you open the monitor, the status is red.
If you search for more detail, you can see the following message:
“Lock in lock manager could not be set -> long text”
The error refers to a lock in lock manager
Lock in lock manager could not be set -> long text
Message no. RSENQ009
Diagnosis
The lock in the lock manager could not be set.
An attempt is being made to set the lock in include LRSENQF00 in the form set_enqueue.
The lock table is table RSENQ_PROT_ENQ.
An attempt was made to lock the following object:
User/Object = BWREMOTE/ZSDOD005
Object_typ/Action = ODS/UPD_ODS
Subobject = REQU_6ROBVFEQ9SSOIJY5MDF2W9BTX
SubSubObject = 000001
This problem affects subsequent loads.
The InfoPackage ZPAK_6K641H103XV0MTRBAV9Q788IS loads data to three ODS ZSDOD001, ZSDOD003 and ZSDOD005.
None of the other ODS generated InfoPackage for 09.25.2013.
Our BASIS support team couldn’t see locks that impact in the procedure.
The InfoPackage ZPAK_6K641H103XV0MTRBAV9Q788IS is part of the Process Chain ZCP01 - Ventas (SD) Transaccional
If we tried to repeat the step we had obtained the following message:
This issue prevents subsequent loads of data.
It is abnormal that there is a green external status and a red one internal.
Could you, please check why are we having this lock error?
What are the steps to follow to avoid losing information or having it duplicated in this case?
Thanks,
Kiran
Hi Kiran ,
You can monitor Sm12 for this issue , Just check If it reached max no. of entries , if any lock overflow is there . It will also appear in Sm21 system logs .
It is also possible some other jobs is consuming most of lock entries during that time ,causing this problem .
http://help.sap.com/saphelp_nw70ehp2/helpdata/en/47/ea5e27e97f486ee10000000a42189d/content.htm
Thanks
Manas Behra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.