topic Re: Fm SO_DOCUMENT_SEND_API1 locking table ADR6 in Application Development and Automation Discussions

Fm SO_DOCUMENT_SEND_API1 locking table ADR6

Former Member — Wed, 20 Jan 2010 14:12:05 GMT

Hi All,

FM SO_DOCUMENT_SEND_API1 is locking table ADR6 while sending emails.I dont want this to happen.

PLease help how can i avoid this.

Thanks and regards,

Rajeev

david_escofettrenado — Wed, 20 Jan 2010 14:25:31 GMT

Does you have set the field COMMIT_WORK ?

Former Member — Wed, 20 Jan 2010 14:30:59 GMT

Hi David,

Yes I am using this commit work .

Actually the FM was called inside a loop.

In production environment as large amount of data was being processed.

So the process was taking tiime so instead of commiting the work inside the FM , i used commit work outside

the loop.

How can i unlock this database table .?

Thanks and regards,

Rajeev

prasenjit_sharma — Wed, 20 Jan 2010 22:21:28 GMT

Hi,

What all are you using in your code? Is there anything else that can enqueue the table?

Regards

Prasenjit

Former Member — Mon, 25 Jan 2010 04:22:44 GMT

Hi Prasenjit,

If i dont use the sender address parameter in function module.

The person who runs the program , his name will be sent out as the sender address.

But i dont want that to happen , so to avoid this i am using the sender address parameter ,

it will make an entry in the database table ADR6.,which is locking the table .

I dont want this to locking to happen at the same time sender address should be sent

How cani achieve this , Please help me.

Thanks and regards,

Rajeev