Skip to Content
avatar image
Former Member

Truncate Tables TRBAT and TRJOB on DB level

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 30, 2008 at 03:31 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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