SAP Knowledge Base Article - Preview

3053535 - catsbp failed with error "The history of path <xyz> in the database is in a stat that this script cannot process"

Symptom

Executing catsbp fails with below error:

Prerequisite check failed:
 Cause: The history of patch 32218454/24018797 in the database is in a
        state that this script cannot process.
Action: Open an SAP incident using component BC-DB-ORA and provide
        the log file generated by this script.

catsbp completed with errors, post-installation of this SAP Bundle
Patch is INCOMPLETE.

Further upwards in the logfile, we see RU and 'Interim Patch' got applied at once (INSTA = <the same number for all affected entries>). While the actual timestamp of the OS is still before the  ACTION_TIME

Dumping registry$sqlpatch...
select install_id, patch_id, patch_uid, patch_type, action, action_time, status, source_version, target_version, nvl( description, 'NONE' ), logfile from registry$sqlpatch order by action_time;
INSTA   PATCH_ID  PATCH_UID PATCH_TYPE ACTION     ACTION_TIME          STATUS          SOURCE_VERSI TARGET_VERSI DESCRIPTION                                        LOGFILE
    1   32218454   24018797 RU         APPLY      05-MAY-2021 04:15:46 SUCCESS         19.1.0.0.0   19.10.0.0.0  Database Release Update : 19.10.0.0.210119 (322184 /oracle/BM0/cfgtoollogs/sqlpatch/32218454/24018797/32218454_apply_BM0_2021May05_04_10_37.log
    1   32308618   24027550 INTERIM    APPLY      05-MAY-2021 04:15:47 SUCCESS         19.1.0.0.0   19.1.0.0.0   MERGE ON DATABASE RU 19.10.0.0.0 OF 28357349 28555 /oracle/BM0/cfgtoollogs/sqlpatch/32308618/24027550/32308618_apply_BM0_2021May05_04_11_39.log
    1   32395634   24023078 INTERIM    APPLY      05-MAY-2021 04:15:47 SUCCESS         19.1.0.0.0   19.1.0.0.0   MERGE ON DATABASE RU 19.10.0.0.0 OF 27957963 28052 /oracle/BM0/cfgtoollogs/sqlpatch/32395634/24023078/32395634_apply_BM0_2021May05_04_15_41.log
3 rows selected.

If you would have used catsbp instead as documented in the SBP readme, not calling datapatch directly, catsbp would have called datapatch multiple times to always execute only one action at a time, thus being able to vaildate if the datapatch action was successful or not for this particular datapatch action.

catsbp would stop if the return code isn't SUCCESS and won't continue with the next datapatch call.
With catsbp being used, you'd see only one action listed per install_id  .


in the database is in a stat that this script cannot process""> Read more...

Environment

  • Linux / UNIX Operating System
  • as of Oracle RDBMS 19c
  • SAP Netweaver
  • SAP Solution Manager

Product

SAP NetWeaver all versions ; SAP Solution Manager 7.2

Keywords

catsbp, datapatch, SGR, SBP, oracle, opatch, mopatch, bundle patch, error, 19c, 19, The history of path in the database is in a stat that this script cannot process , KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.