ORA-20011 and ORA-06512

Last Year
JorgeR
BIZAGI STUDIO

Summary

When the user tries to create a Bizagi project using an Oracle database, the creation fails and the Summary of Problems displays the error code ORA-20011 and several errors with code ORA-06512.

Applies to

Bizagi Engine 10.x using Oracle Database 11g Release 11.2.0.1.0 

Symptoms

The following errors are displayed when a user tries to create a Bizagi project using an Oracle database:


ORA-20011: Approximate NDV failed: ORA-00439: feature not enabled: Data Guard Broker
ORA-06512: at “SYS.DBMS_STATS”, line 20508
ORA-06512: at “SYS.DBMS_STATS”, line 20951
ORA-06512: at “SYS.DBMS_STATS”, line 21498
ORA-06512: at “BIZAGIADMON.SPBA_ORA_GATHER_STATS”, line 35
ORA-06512: at line 1

Cause

During the creation of the project, Bizagi executes a stored procedure (dbms_stats.gather_fixed_objects_stats) to collect statistics from Oracle database. For Oracle Database 11g Release 11.2.0.1.0, Oracle has identified a known issue with this procedure and had release a patch in order to resolve this.
The bug is found on Standard Edition databases, but should also apply to Enterprise Edition.

Solution

Download and apply the Patch 9056912 available for your platform, you can find it login into your Oracle Support. Once this patch has been applied, the problem is fixed.


Details

Last Modified:Last Year
Last Modified By: AndresM
Type: ERROR
Level: Advanced
Rated 4 stars based on 1 vote
Article has been viewed 7.9K times.

Options