2562792 - SQL error -20010 ORA-06512 in MAIN_SHDIMP/UPDATE_DBSTATS_NEWSHD | SAP Knowledge Base Article

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 , 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.