cancel
Showing results for 
Search instead for 
Did you mean: 

tpclearreports showing now 20h while installing downtime minimized / spam

Former Member
0 Kudos

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!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

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!

Answers (1)

Answers (1)

Former Member
0 Kudos

Found sapnote to create index on reposrc...

Former Member
0 Kudos

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