Skip to Content
Author's profile photo Former Member
Former Member
September 5, 2016 Less than a 1 minute read

Error in Update Statistics – SQL error -20003 at location stats_tab_collect

Hello,

I just want to share a solution for the error SQL error -20003 at location stats_tab_collect. The issue occurs on DB13 update statistics.

It began occur after a BW system refresh done through Oracle database backup from PRD.

Symptom

/wp-content/uploads/2016/09/error_1_1029911.jpg

/wp-content/uploads/2016/09/error_db13_1029912.jpg

BR0301E SQL error -20003 at location stats_tab_collect-78, SQL statement

BR0886E Collecting statistics failed for table SAPSR3./BIC/B0000100000

I tried to find something on SAP Support, but no lucky.

Then, I found the solution below in Oracle Support Doc ID 1180514.1:

Cause

Problems with validity of the dictionary objects upon which DBMS_STATS package depends.


Solution


Log on as ora<SID> user on the OS, and then recreate DBMS_STATS package by running the following scripts with SQLPLUS:

  @?/rdbms/admin/dbmsstat.sql

  @?/rdbms/admin/prvtstas.plb

  @?/rdbms/admin/prvtstat.plb



Regards,

Richard W. L. Brehmer
rbrehmer.com

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.