topic Re: St05 SQl Trace Analysis in Application Development and Automation Discussions

St05 SQl Trace Analysis

Former Member — Mon, 11 Mar 2013 15:34:44 GMT

Hello All,

We have background jobs those run with user ID MAESTRO. I want to analyse the SQL trace for these jobs, however from ST05 I see we can enable the jobs for different user using the option activate Trace with Filter. I have activated using this option for user MAESTRO but after the finish of jobs, I have deactivated the trace and tried to list the trace for user MAESTRO.When ever I do this it always says Trace doesn't exist.Could you kindly let me know how can I enable the sql trace for the jobs running on different user.

Regards,

Sai

Re: St05 SQl Trace Analysis

JL23 — Mon, 11 Mar 2013 15:49:36 GMT

moved to ABAP Testing and Troubleshooting

Re: St05 SQl Trace Analysis

HermannGahm — Mon, 11 Mar 2013 21:00:32 GMT

Hi,

are you sure you activated the SQL trace on the same application server where the job was running?

(ST05 is application server dependent)

Another hint: the user that scheduled a job is not necessarily the user that executes a step in the job.

Make sure to trace the right user on the right server.

Kind regards,

Hermann

Re: St05 SQl Trace Analysis

adam_krawczyk1 — Tue, 12 Mar 2013 07:42:12 GMT

Hi Sandeep,

You have already good suggestions from Hermann what is probably the root cause.

Message that you are getting means that no action was registered for tracing. To check on which server and what user is running the job, start the batch job, go to SM51 and choose server to see list of jobs in progress with user name. In general you can switch between application server with SM51.

The easiest thing to do is to assign batch job run to specific server and run ST05 from same server. Then you are sure that logs will be collected, assuming you know the right user.

Regards,

Adam

Re: St05 SQl Trace Analysis

Former Member — Tue, 12 Mar 2013 13:17:22 GMT

Thank you Hermann and Adam. The issue is solved.