Skip to Content
avatar image
Former Member

tpclearreports showing now 20h while installing downtime minimized / spam

Hi

can anybody tell me how I can see if there is still anything running:

I see "tpclearreports" now for 20 h after installing servicepacks in downtime minimized mode in transaction SPAM.

Can I interrupt this step and clear the queue to continue with other servicepacks?

Thanks in advance!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 23, 2009 at 09:56 PM

    Hi,

    Check for the slog and ulog files and also the log files in tmp dir.. If your SAP Application is running on UNIX then execute ps -ef | grep tp or on win check in the task manager for tp is running.

    Please mention the what is OS, DB your using,,,

    Thanks,

    Mahesh

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi

      It is Win2003 Server x64 with MaxDB 7.6.3

      there is one tp-process running but it seems to do not much.. (no trans or r3trans)

      ULOG last entries:

      APServiceP01 20090123012819 RFC: tp SHOWPARAMS P01 pf=
      sipa1\sapmnt\trans\bin\TP_DOMAIN_P01.PFL -Dtransdir=
      sipa1\sapmnt\trans (pid=4144)

      APServiceP01 20090123012819 RFC: tp CONNECT P01 pf=
      sipa1\sapmnt\trans\bin\TP_DOMAIN_P01.PFL -Dtransdir=
      sipa1\sapmnt\trans (pid=4144)

      APServiceP01 20090123012825 RFC: tp XPA ALL P01 pf=
      sipa1\sapmnt\trans\bin\TP_DOMAIN_P01.PFL -Dclientcascade=yes -Dstoponerror=8 -Drepeatonerror=8 -Dsourcesystems= -Dbuffreset=yes -Dbatch_proc=1 tag=spam -Dtransdir=
      sipa1\sapmnt\trans (pid=4144)

      APServiceP01 20090123024001 RFC: tp SHOWPARAMS P01 pf=
      sipa1\sapmnt\trans\bin\TP_DOMAIN_P01.PFL -Dtransdir=
      sipa1\sapmnt\trans (pid=5472)

      APServiceP01 20090123024001 RFC: tp CONNECT P01 pf=
      sipa1\sapmnt\trans\bin\TP_DOMAIN_P01.PFL -Dtransdir=
      sipa1\sapmnt\trans (pid=5472)

      APServiceP01 20090123024037 RFC: tp SHOWPARAMS P01 pf=
      sipa1\sapmnt\trans\bin\TP_DOMAIN_P01.PFL -Dtransdir=
      sipa1\sapmnt\trans (pid=5472)

      APServiceP01 20090123024037 RFC: tp CONNECT P01 pf=
      sipa1\sapmnt\trans\bin\TP_DOMAIN_P01.PFL -Dtransdir=
      sipa1\sapmnt\trans (pid=5472)

      APServiceP01 20090123024038 RFC: tp CLEARREPORTS P01 pf=
      sipa1\sapmnt\trans\bin\TP_DOMAIN_P01.PFL -Dstoponerror=8 -Drepeatonerror=8 -Dbuffreset=yes tag=spam -Dtransdir=
      sipa1\sapmnt\trans (pid=5472)

      SLOG last entries:

      START tp_getprots P01 P 20090122230903 HEGEWALD sipa1 20090122230631

      STOP tp_getprots P01 P 20090122231859 HEGEWALD sipa1 20090122230631

      STOP MOVE NAMETABS P01 6 20090122231859 HEGEWALD sipa1 20090122230631

      START tpmvinactreports P01 B 20090122231859 HEGEWALD sipa1 20090122230631

      STOP tpmvinactreports P01 B 20090123000134 HEGEWALD sipa1 20090122230631

      WARNING:
      sipa1\sapmnt\trans\tmp\PZ090123.P01 : cant open

      WARNING: : cant open

      START MAIN IMPORT P01 I 20090123000138 HEGEWALD sipa1 20090122230631

      STOP MAIN IMPORT P01 I 20090123011509 HEGEWALD sipa1 20090122230631

      INFO: stoponerror changed from 9 to 8

      WARNING:
      sipa1\sapmnt\trans\tmp\N090123.P01 : cant open

      WARNING:
      sipa1\sapmnt\trans\tmp\N090122.P01 : cant open

      WARNING: : cant open

      WARNING: : cant open

      START TBATG CREATION OF EN P01 n 20090123011510 HEGEWALD sipa1 20090122230631

      START tp_getprots P01 Y 20090123011510 HEGEWALD sipa1 20090122230631

      WARNING: : cant open

      WARNING: : cant open

      WARNING: : cant open

      WARNING: : cant open

      STOP tp_getprots P01 Y 20090123011907 HEGEWALD sipa1 20090122230631

      STOP TBATG CREATION OF EN P01 n 20090123011907 HEGEWALD sipa1 20090122230631

      INFO: event SAP_IMPORT_STOP triggered successfully

      STOP imp all P01 0004 20090123011908 HEGEWALD sipa1 20090122230631

      START tpunlock_eu P01 20090123012037 HEGEWALD sipa1

      STOP tpunlock_eu P01 20090123012038 HEGEWALD sipa1

      START EXECUTION OF REPORTS P01 R 20090123012135 HEGEWALD sipa1

      START tp_getprots P01 R 20090123012135 HEGEWALD sipa1

      START tp_getprots P01 R 20090123012825 HEGEWALD sipa1

      STOP tp_getprots P01 R 20090123020514 HEGEWALD sipa1

      STOP tp_getprots P01 R 20090123020524 HEGEWALD sipa1

      STOP EXECUTION OF REPORTS P01 R 20090123020524 HEGEWALD sipa1

      START tpclearreports P01 B 20090123024038 HEGEWALD sipa1

      TPCLEARREPORTS is the message that is now on screen since 2.40 pm after step 2 and main import was "successfully" finished and I started the next step.

      Main import was interrupted by sap-front-end breakdown after dump of message-type-x but seemed to be recoveredafter restart of spam from another station.

      System is now running regularly.

      Thanks!

  • avatar image
    Former Member
    Jan 24, 2009 at 02:05 PM

    Found sapnote to create index on reposrc...

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Note 822379 - Known problems with Support Packages in SAP NW 7.0x AS ABAP

      Search term; CLEAR_OLD_REPORTS.

      Stop SPAM run. Create index on table REPOSRC with therm R3STATE PROGNAME. Ensure index is created in the database. Restart SPAM import