SAP Knowledge Base Article - Preview

2562792 - SQL error -20010 ORA-06512 in MAIN_SHDIMP/UPDATE_DBSTATS_NEWSHD

Symptom

You are updating SAP systems running on Oracle database via SUM. You can see error messages like the following in the two files:

  1. UPSTNEWSHD.LOG

    4 ETQ291 Database operation "TABLE-EXISTANCE-TEST" completed successfully
    4 ETQ399 Running update statistics for imported tables...
    3 ETQ121 20171028075836: PID 34144276 execute '~/exe/brconnect -u -p ~/tmp/OPTSTAT.LST -c -f stats -f allsel,collect -p 8 -RDB' in background, output written to '/swdir/SUM/abap/log/ORA_UPDATESTAT.LOG'.
    3WETQ122 20171028080540: PID 34144276 exited with status 5 (time:   424.0/   11.0/    2.7/0MB real/usr/sys/maxmem)
    4 ETQ399 20171028080540: WAITED for 1 processes to finish, 0 aborted.
    1EETQ399 Last error code set is: brconnect exited with 5
    1EETQ204 Upgrade phase "UPDATE_DBSTATS_NEWSHD" aborted with severe errors ("20171028080540")

  2. ORA_UPDATESTAT.LOG

    BR0301E SQL error -20010 in thread 5 at location stats_tab_collect-66, SQL statement:
    'EXECUTE stmt_1a'
    'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"/BOFU/CFBIAP_FD"', ESTIMATE_PERCENT => NULL, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, CASCADE => TRUE, NO_INVALIDATE => FALSE); END;'
    ORA-20010: DBMS_STATS INTERNAL ERROR in raise_col_part_not_exist : can not find non existent table partition
    ORA-06512: at "SYS.DBMS_STATS", line 34841
    ORA-06512: at line 1
    BR0886E Collecting statistics failed for table SAPSR3./BOFU/CFBIAP_FD
    BR0280I BRCONNECT thread 5 time stamp: 2017-10-28 07:59:26
    BR0881I Collecting statistics for table SAPSR3./BOFU/CFBIAP_RAV with method/sample C ..."Updating statistics for table "SAPSR3./OSP/T_AUDIT_USR~"
    [..]
    BR0280I BRCONNECT time stamp: 2017-10-28 08:05:40
    BR0879I Statistics checked for 0 tables
    BR0878I Number of tables selected to collect statistics after check: 0
    BR0880I Statistics collected for 36791/0 tables/indexes
    BR1308E Collection of statistics failed for 9/0 tables/indexes


Read more...

Environment

  •  Upgrade SAP System with Software Update Manager (SUM) tool and Oracle database

Keywords

MAIN_SHDIMP, UPDATE_DBSTATS_NEWSHD, , KBA , BC-UPG-TLS-TLA , Upgrade tools for ABAP , 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 for Me (Login required).

Search for additional results

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