topic Re: Problems in Enqueue in Application Development and Automation Discussions

Problems in Enqueue

former_member343107 — Wed, 19 Mar 2008 07:26:59 GMT

Hi All,

I created two programs to lock different records. But only one of them can be executed successfully. Can you help to indicate possible reason? The lock object uses 'E' lock. It has one primary table and a couple of secondary tables. But in these programs only the mode parameter corresponding to the primary table is used.

Program 1:

DATA: lv_reqkey TYPE KEYXXXXX VALUE '9998'.

CALL FUNCTION 'ENQUEUE_XXXXXX'

EXPORTING

MODE_PRIMARY_TAB = 'E'

REQKEY = lv_reqkey

X_REQKEY = ' '

_SCOPE = '2'

_WAIT = ' '

_COLLECT = ' '

EXCEPTIONS

FOREIGN_LOCK = 1

SYSTEM_FAILURE = 2

OTHERS = 3

BREAK-POINT.

Program 1:

DATA: lv_reqkey TYPE KEYXXXXX VALUE '9999'.

CALL FUNCTION 'ENQUEUE_XXXXXX'

EXPORTING

MODE_PRIMARY_TAB = 'E'

REQKEY = lv_reqkey

X_REQKEY = ' '

_SCOPE = '2'

_WAIT = ' '

_COLLECT = ' '

EXCEPTIONS

FOREIGN_LOCK = 1

SYSTEM_FAILURE = 2

OTHERS = 3

BREAK-POINT.

Thanks + Best Regards

Jerome

Re: Problems in Enqueue

Former Member — Wed, 19 Mar 2008 07:35:58 GMT

Check in "Lock Parameters" tab of the Lock Object definition, whether you have selected the key fields. If not, it will lock the entire table.

Hope this helps.

Thanks,

Balaji

Re: Problems in Enqueue

Former Member — Wed, 19 Mar 2008 07:37:03 GMT

Hi,

it is possible because of due to one of the parameters in :

_WAIT = ' '

_COLLECT = ' '

please try to put some value 'X' in one of these 2 or both and try checking whether it worked or not.

Thanks,

Vishnu.

Re: Problems in Enqueue

former_member343107 — Wed, 19 Mar 2008 09:22:20 GMT

Hi Balaji,

In the "Lock Parameters" tab I selected the key of the document header table. But I didn't select the key of the document item tables. (item table also has the document header key as its own key.) Is that correct?

Thanks, Jerome

Re: Problems in Enqueue

former_member343107 — Wed, 19 Mar 2008 11:37:31 GMT

Sovled by myself. The foreign key was not correctly set.