topic Ending a transaction programmatically in Application Development and Automation Discussions

Ending a transaction programmatically

Former Member — Wed, 14 Sep 2005 15:14:43 GMT

I'd like to determine if a particular transaction is running and then terminate it.

The functionality I'm looking for is similar to transaction SM04 where you can terminate a transaction by user.

Re: Ending a transaction programmatically

ChristianFi — Wed, 14 Sep 2005 15:26:24 GMT

Search for function starting with TH* (like TH_DELETE_MODE) but I am not sure if I would trust that every transaction exits gracefully - especially concerning update processes.

Christian

Re: Ending a transaction programmatically

RichHeilman — Wed, 14 Sep 2005 15:27:00 GMT

I don't know if you can end the transaction remotely, but maybe you could end the session all together.

Regards,

Rich Heilman

Re: Ending a transaction programmatically

Former Member — Wed, 14 Sep 2005 15:33:27 GMT

Agreed. We'll certainly check for that.

The exact problem that we have is that we don't want a particular transaction to be active/available when a certain batch job is running.

Making the transaction unavailable for start-up seems pretty straight forward. It's finding the active occurances and terminating them that seems to be more difficult.

As of now, I don't know if terminating the transaction will be graceful or not. But, I'd like to try it.

Re: Ending a transaction programmatically

Former Member — Wed, 14 Sep 2005 15:47:12 GMT

Look at this thread. I have posted a program there. But please be carefule about the pitfalls in that.

Instead, how about locking the transaction before the batch job and unlocking it after, instead of trying to terminate it? Also, you need to consider other ways that would hinder your job. If the transaction is VA01, even if you stop it from executing, how will you monitor all those other ways that will create a sales order like via EDI or via RFCs or through custom programs etc?

Regards,

Srinivas

Re: Ending a transaction programmatically

Former Member — Wed, 14 Sep 2005 15:52:13 GMT

You cannot catch a tcode but with Function TH_WPINFO you can catch if a program related to tcode is running.

You can cancel the program . See the code in subroutine

PROG_EXIT in program RSMON000_ALV .

Otherwise you can use tcode SM50.

Cheers

Re: Ending a transaction programmatically

Former Member — Wed, 14 Sep 2005 16:03:25 GMT

Thanks. I've discovered how to prevent new startups of the transaction.

What I need to do is end any active sessions before the batch job starts.

Re: Ending a transaction programmatically

Former Member — Wed, 14 Sep 2005 16:08:26 GMT

Instead of ending, may be you should just wait until the transaction is completed and then start the job.

Let us say you have a program that monitors if the transaction is running. If it is running, then it just goes into a loop until the transaction has ended. Since you are stopping any new ones becoming active, you only will wait until the active ones are done. Once done, the execution of this program ends. Your batch job, should have this program as a predecessor step.

Srinivas

Re: Ending a transaction programmatically

guillaume-hrc — Wed, 14 Sep 2005 16:32:09 GMT

Yes, the SM04 transaction seems to use the 'TH_DELETE_USER' function.

Or maybe you could try to directly call the routine <b>DELETE_USER</b> in the RSM04000_ALV ?

Re: Ending a transaction programmatically

Former Member — Thu, 15 Sep 2005 05:07:29 GMT

Active programs can be cancelled from SM50 Program/Mode -> Program -> Cancel. you can leverage the code here .

If answers were helpful reward and close the thread.

Cheers

Re: Ending a transaction programmatically

ChristianFi — Thu, 15 Sep 2005 12:02:26 GMT

You could use EXIT_SAPLSABE_010 to avoid that a user can start a report (of type 1). In this exit you could check if your batch program is running.

I am sure there is something similar for modul pools as well.

Christian

Re: Ending a transaction programmatically

Former Member — Thu, 15 Sep 2005 22:39:10 GMT

If these answers helped you, please reward and close the post.

Thanks,

Srinivas