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 to [Release 10.1.2]
Information in this document applies to any platform.
***Checked for relevance on 26-Sep-2012***


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





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


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