Truncate Tables TRBAT and TRJOB on DB level

[Former Member]

Hi!

I am facing with hanging SPAM patch of SAPKB 13 -16.

I am on windows with SAP DB.

Now It is not possible to log onto SAP system

The error is: syntaxerror in program SAPLSFES.

To solve this problem I would like to truncate the both tables TRBAT and TRJOB on DB level.

I connected to SAP DB via "dbmcli commando" and can see the both tables with commando:

>sql_execute select * from tables where TABLENAME='TRBAT'

Can some one please tell me the right procedure/DB-command to truncate both tables?

Thank you very much!

Holger

[markus_doehr2]

Can some one please tell me the right procedure/DB-command to truncate both tables?

Do not do that - it won´t help you.

The new programs are already imported, if you truncate those tables, you will set the status back but the error will remain.

Open an OSS call, the support will give you a command to proceed with the import.

Markus

[Former Member]

Hi Markus!

Many thanks for quick help.

Could you give me please the appropriate TP commandos in order to proceed (e.g.)

(e.g. tp clearbuffer, addtobuffer, etc.)?

>tp r3i SAPKB70013 ERB pf=D:\usr\sap\trans\bin\TP_DOMAIN_ERB.PFL tag=SPAM -Dclientcascade=yes -Drepeatonerror=8

I will definetely open an OSS call, but will try to solve this problem on my own.

Thank you very much!

regards

Thom

[Former Member]

Hi Thom,

The system is inconsistent, as the main import is canceled.

At the end of the import logs / usr/sap/trans/log/SAPKB70013.ERB. at the end of this as SPAM is haging you might have tablespace issue . check your log file and increase tablespace.

Then do the following:-

start main import at OS level will the follwowing command:-

"tp r3i SAPKB79913 ERB tag = SPAM

Let us know the results.

Regards,

Atil

[Former Member]

Hi!

I guess I don't have the problem with tablespaces.

When I try to start tpimport from CMD-console (>tp import all ERB ...) the output of SLOG-file looks as follows:

Backgroud job RDDIMPDP could not bes started or terminated abnormally.

Any ideas how to proceed?

Thank you!

[lbreddemann]

Hi Holger,

of course you don't have a tablespace problem - MaxDB does not have something like tablespaces.

The problem you face is not a database problem at all. Somehow there is a syntax error in one of the newly loaded ABAP programs.

Maybe it would be more efficient to continue analyzing this issue in the support message or in the appropriate forum (maybe this one: ).

And please mark the double postings as 'answered' as well...

regards,

Lars

[Former Member]

Hi Thom,

Please re-schedule backgroud job RDDIMPDP in client 000/user DDIC as

per Note 11677, and other clients as pet this note.

Please make sure this job runs on R/3 level when you start import.

You can excute the program RDDIMPPUTPP also to make this program as event driver.

Good Luck,

Atil