program gives dump before dequeue the table? how to set up the unlock if the the job gives the dump?

[Former Member]

i have executed a report as back ground job, in the report i have written a select quary between the en queue and de queue function modules. the select quary given the dump but in this case the deque function module is not got executed so the lock is not released the on the table, here how to set the unlock when select quary gives the dump.

Thanks.

[isaias_freitas]

Hi,

If the job ended in error (the dump), then the corresponding session (at the transaction SM04) should be deleted.

There would be an implicit "dequeue all" operation in such situation (session being deleted).

Are you able to simulate the issue at will?

If yes, can you please add to this thread:

1. The SAP kernel release and patch level of the system where the issue can be simulated;
2. A sample ABAP code that we could use to simulate the issue.

Regards,

Isaías

[Former Member]

ok but is there any way to release the lock from en queue function module if short dump happened.

[isaias_freitas]

Hello,

The lock should be released automatically...

Regards,

Isaías

[Former Member]

so how to set this 'releasing the lock automatically' when there is dump before de queue function module?

[isaias_freitas]

There is no setup required.

When a session is deleted because of an issue (like the dump), the SAP kernel would always perform a "dequeue all" implicitly and automatically.

This "dequeue all" means "delete all the locks for this session".