Creating A Public/Private Connection With Oracle BI Discoverer 10g (10.1.2) Fails With "unable to save the connection" and ORA-06510,ORA-06512,ORA-06502 (Doc ID 394011.1)

Last updated on OCTOBER 14, 2016

Applies to:

Oracle Discoverer - Version 10.1.2.0.2 to 10.1.2.3 [Release 10.1.2]
Information in this document applies to any platform.
***Checked for relevance on 26-Sep-2012***

Symptoms

When trying to create a public or private connection with Discoverer 10g (10.1.2) Plus or Viewer, the following error is encountered:

 

A connection error has occurred.
- OracleBI Discoverer Viewer was unable to save the connection. Please check
for other errors.
- ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at
"ORASSO.WWSSO_API_PRIVATE", line 244 ORA-06510: PL/SQL: unhandled user-defined
exception ORA-06512: at "ORASSO.WWSSO_UTL", line 546 ORA-06502: PL/SQL: numeric
or value error ORA-06512: at line 1


You may also see:

 

The connection list is currently unavailable.
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "ORASSO.WWSSO_API_PRIVATE," line 258
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "ORASSO.WWSSO_UTL" line 728
ORA-28231: no data passed to obfuscation toolkit
ORA-06512: at line 1 Unable to retrieve connection list

 

 

 

Changes

The metadata repository (MR) database may have been upgraded to database version 10.1.x or 10.2.x

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms