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 for Me (Login required).

Search for additional results

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