Solved: Regarding sm37

Former Member · ‎02-22-2005

Each time i enter sm37 transaction, I get 5times the job

executing like this,Status X is 'COMPLETED'.

ZGLT0_SHINTANI003_V1 X

when i check in joblog it says job completed normally.

But whenever i enter sm37, 5 times job gets increased in list.

what would be the reason how can i debug.

ambichan.

Former Member · ‎02-22-2005

Hello Ambichan,

Obviously, the program is getting scheduled multiple number of times due to some error you have made somewhere.

Otherwise why would that happen only with this particular program ? In this program, you have done some batch input processing, am I correct? and you have executed the program in Background ? Just try these options:

1. Use only the Session Method and see if you are getting it 5 times.

2. Then, write another test program where you have only the Call Transaction method and execute it. See if you are still egtting it 5 times.

3. If you are getting correct results for both 1 and 2, then we shall think of combining the two options in the same program based on some condition.

Regards,

Anand Mandalika.

Former Member · ‎02-22-2005

Hello Ambichan,

Obviously, the program is getting scheduled multiple number of times due to some error you have made somewhere.

Otherwise why would that happen only with this particular program ? In this program, you have done some batch input processing, am I correct? and you have executed the program in Background ? Just try these options:

1. Use only the Session Method and see if you are getting it 5 times.

2. Then, write another test program where you have only the Call Transaction method and execute it. See if you are still egtting it 5 times.

3. If you are getting correct results for both 1 and 2, then we shall think of combining the two options in the same program based on some condition.

Regards,

Anand Mandalika.

Former Member · ‎02-22-2005

hai anand,

Thanks for your reply.

Actually now problem is not with executing this program.

already i executed this program and i guess somewhere error went off. and so now its still generating jobs in SM37.

Because now i am not at all executing this program.But

when i getinto sm37 screen it list 5times increasing(even though i have not executed this time in background or foreground.)

could you pls understand my situation.

shall i explain u more..

ambichan.

Former Member · ‎02-22-2005

Hi Ambichan,

The jobs cannot keep on getting increased in number just like that. When you go to SM37, On the initial screen, select all the checkboxes (including the option Scheduled ). then go and monitor the jobs. There will only be a fixed number of jobs.

Regards,

Anand Mandalika.

Former Member · ‎02-22-2005

hai anand,

Its true,by default jobs wont get increased in number.but

it happens in my case.

In fact i tried with selecting all checkboxes, but

still it increased by 5 times each time.

But i am sure this situation happens only after i execute

this batch input and call transaction program.

I am using GUI40B..till yesterday it was fine.

I am just struck how to continue in this case..pls give some suggestions to debug.

u mean monitor job is SM50?

ambichan.

Message was edited by: ambi chan

Former Member · ‎02-22-2005

Hello Ambichan,

I think we have come a bit too deep into this problem. Just do one thing. since you are in the development stage anyways, Go to SM37 and

1. Delete all the jobs in the scheduled status.

2. Cancel all the jobs in the active status.

After you do this, then you split the program you have mentioned in the other post into two other programs. In one of these programs use only the Session Method. In the other one, use only the Call Transaction Method. As I have suggested in the other thread, please use the messages option for the Call Transaction method. and also check out the value of sy-subrc.

Get back with your results. But be sure that there are no jobs in SM37 at all. Delete all the jobs, whatever the status. That will help you avoid some confusion.

Regards,

Anand Mandalika.

Former Member · ‎02-22-2005

Hey anand,

Sorry to disturb u again and again.

I already checked this by deleting all jobs first,and then

i executed old program(which is already executing fine in background). but the same scenario exists.

ZFIPR_GL_OUTPUT Status - "X" Cancelled

ZGLT0_SHINTANI003_V1 Status "X" finished.(5 times)

ZGLT0_SHINTANI003_V1 X

very interesting and irritating.

i checked st22, where i found few short dump 'SYSTEM CANCELLED' and CONVT_OVERFLOW.

if uw ant i will send u that also.

First my problem is,i want to stop generating 5times jobs

in sm37 then i thaught of going to program seperation.

but i cant recover from this itself.

note: I think in background this program is continously executing..how about finding the background work process and delete it. and check....but i dont know how to do this..

ambichan

Former Member · ‎02-22-2005

Hello Ambichan,

To understand the effects, it is always the cause that we shoudl try to identify. I'm slmost sure that the BDC internal table with the data is the culprit, thoug I cannot say that affirmatively. So please try to separate the two approaches.

Secondly, on the selection-screen, are you hitting F9 or F8?

Now, killing the background work process is not a very difficult thing to do. Just go to SM50 and select the BGD work process whioch is executing the job and choose from the menu Process-->Cancel with core.

Regards,

Anand Mandalika.

Former Member · ‎02-22-2005

yes ur right.

I am not sure at what situation this problem rises.

but i saw this problem only recently.

Hope you know, actually i was trying to execute program

with Background proces at click of "F8 clock Exe button".

while trying that, i have tried like this with your code. i guess at this point of time this problem rises.(but i am not sure of this.)

if sscrfields-ucomm = 'ONLI'.

sscrfields-ucomm = 'SJOB'

endif.

Bytheby, Sorry, in sm50 i tried to stop the BTC process also i tried PRocess-Restart after error-yes button.

now it gives me No 1- in Err colum.

is it prob? how to avoid this.

ambichan

Former Member · ‎02-22-2005

Hi Ambichan,

I guess that is all that you can do with SM50 :-). If it gives you -1 in the error column, is the line changing to red color? I think it should. And try out the option Restart after error-->No. Anyways, this is not the way to solve the problem. You cannot expect theusers to do that, right?

Forget about SM50 for sometime. The session method is intrinsically batch-oriented (or background based). That is why it is called BDC - Batch Data Communication. Why do you again have to execute the program in background?

Regards,

Anand Mandalika.

Former Member · ‎02-22-2005

hai,

I solved this problem thankyou.

i closed all BTC process in SM50.now

i dont get repeated times in SM37.

THankyou.

i will get back to you for Call transaction process later

thank you somuch for ur assistance.

ambichan.

Former Member · ‎02-22-2005

Hi Ambichan,

Nice to know that you have solved the problem. Could you please close this thread? That way the others will not have to look at it with the intent to provide you an answer.

Regards,

Anand Mandalika.