Skip to Content

Hello SAP experts,

I want to describe a phenomen which can occur in newer Support Packages (with the new standard job SAP_BTC_TABLE_CONSISTENCY_CHECK or the SM65 check) and also how to use the new standard jobs and SM65.

New Standard Jobs

There are two new standard jobs (note 1440439 – New Standard Jobs (2)):

1. Job name: SAP_ADS_SPOOL_CONSISTENCY_CHECK

Report: RSPO1042

Description: Delete “orphaned” ADS spool files

Note: 1493058

2. Job name: SAP_BTC_TABLE_CONSISTENCY_CHECK

Report: RSBTCCNS

Description: Check batch table consistency

Note: 1549293 Other terms

Implemented with the following SPs:

  • SAPKB70029
  • SAPKB70113
  • SAPKB70213
  • SAPKB71016
  • SAPKB71111
  • SAPKB73009
  • SAPKB73107
  • SAPKB74001

So all of you who have implemented ERP EhP6 SP07 for SEPA are concerned! (SAPKB73107)

To activate the new jobs go to SM36, click on standard jobs (SHIFT+F4) and click on default scheduling (please delete unnecessary Jobs like SAP_COLLECTOR_FOR_NONE_R3_STAT in a ABAP only system) or schedule it with your third party job tool (like Control-M, UC4 etc.).

If you have scheduled the standard jobs, which you definitively should (notes 1411877 and 16083 to avoid growth of you basis tables), you will have the table consistency check and automatically fix for the batch tables.

You can see the output in the SM37 job log or in SM21 system log (produced with SM65 other messages look exactly):

sm21_inconsitencies.JPG

SM65

At first implement note 1549293 (SM65: Consistency check improvements), because during normal operation time it locks the TBTCO completely which effects the whole jobs in your system!!!

Start TA SM65, Goto Additional test and select like in this picture and execute:

SM65.JPG

If you have every day such error messages, you have to change the scheduled time for the standard jobs

Because these can occur every time when the 2 jobs SAP_REORG_JOBS and SAP_BTC_TABLE_CONSISTENCY_CHECK run at the same time! Please run first SAP_REORG_JOBS and then the other one.

If you still have such messages after you scheduled the reorg jobs:

Inconsistency detected in tables TBTCO and TBTCP

Inconsistency detected in tables TBT*

Please follow the instructions below:

  • check note 924198 if table TBTCCNTXT is affected
  • implement note 1381629 and run report ZDELBADCONTEXT to check and then fix the inconsistencies

SM65 is also a good tool for checking the server after an upgrade/migration like TA SICK. I think this transaction is not so widespread, but pretty cool to get an overview.

I hope I could tell something new about the BTC tables and the standard jobs.

If you have any further questions, don’t hestate to comment the blog or contact me or one of my colleagues at Q-Partners ( info_at_qpcm_dot_de )

Best Regards,

Jens Gleichmann

Technology Consultant at QPCM (www.qpcm.eu)

######

Edit 1.1

Format adjustments after migration of the blog

######

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. Former Member

    Hi Jens,

    I have checked that the entries are not getting deleted for ‘ADSP’ file format of table –┬áTSP01.

    Is there any way to delete this kind of file types?

    (0) 
    1. Jens Gleichmann Post author

      Hi Sabarna,

      without details about your release or what exactly you have executed it is pretty hard to help you. At first check some notes like 1493058 or 2304431 which containing details of reports like RSPO1042.

      Regards,

      Jens

      (0) 

Leave a Reply