SAP Knowledge Base Article - Preview

2848653 - BRCONNECT - ORA-01000 for table function

Symptom

When gathering statistics with BRCONNECT, the following error message is displayed:

BR0280I BRCONNECT time stamp: 2019-10-10 04:02:28
BR1863I Updating statistics of table functions...
BR0280I BRCONNECT time stamp: 2019-10-10 04:02:30
BR0301E SQL error -1000 at location stats_tfun_update-1, SQL statement:
'BEGIN "<OWNER>"."<TABLE_NAME>#F" (0, 1); END;'
ORA-01000: maximum open cursors exceeded
ORA-06512: at "<OWNER>.<TABLE_NAME>#G", line 1
ORA-06512: at line 1
BR1867E Updating statistics failed for table function <OWNER>.<TABLE_NAME>

Read more...

Environment

  • BR*Tools
  • Oracle Database as of 12.1

Product

SAP NetWeaver all versions

Keywords

brconnect brtools br*tools statistics stats gather collect , KBA , BC-DB-ORA-DBA , Database Administration , 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.