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.
|