Skip to Content
author's profile photo
Former Member

Trace with Filter

Hi,

I have a report Z_MA_TEST including a simple sql statement (open sql).

I want to trace this to see what happends.

When I Activate Trace With Filter (OK)

  • Provide USERNAME = MYUSERNAME

When I Activate Trace With Filter (<b>Trace file empty??</b>)

  • Provide USERNAME = MYUSERNAME

  • Provide PROGRAMNAME = Z_MA_TEST

Why cant I trace with my program name ?

//Martin

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    Posted on Jan 19, 2005 at 03:39 PM

    Hi,

    there exists a transaction code to reset complete application server - that's to much (and don't ask).

    But each write access invalids buffer. But this invalidation might need some time to be recognized by all servers.

    Just flag buffer-trace, that's OK.

    Christian

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 14, 2005 at 10:13 AM

    After you activate trace.

    Run your program.

    When you are done; deactive trace.

    Push trace list.

    It will give the necessary output.

    -


    If it helps please give points.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hmmm... I only get a COMMIT.

      Maybe because this is a pooled table ?

      //MA

      REPORT Z_MA_TEST.

      data: vobjtest type A004-MATNR.

      select A004~MATNR

      into vobjtest

      from A004

      where A004~MATNR = '000000000000117777'.

      WRITE: / vobjtest.

      endselect.

  • Posted on Jan 14, 2005 at 10:38 AM

    Hi Martin,

    Pool or not - has nothing to do with the problem.

    Are you handling different logons? Direct trace (like Fuats explanation) only works between sessions of one login. Trace with filter can handle all sessions of one application server.

    Filtering behaves little bit strange - add some stars to get more valid entries:

    username = myusername

    progamname = z*

    TABN_INC = * (or A004)

    By the way: don't forget to check for KONP-LOEVM_KO = space.

    Regards,

    Christian

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Jan 18, 2005 at 01:57 PM

    Hi Martin,

    it's not the usual default, but A004 is fully buffered. So activate the flag buffer trace or change an entry immediately before running your example.

    Yellow lines will be actually executed via DB, blue lines will be handled by the application server out of buffer.

    Hope this is the solution,

    regards,

    Christian

    Add comment
    10|10000 characters needed characters exceeded