Symptom
You are updating SAP systems running on Oracle database via SUM. You can see error messages like the following in the two files:
- 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") -
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.