My Oracle Support Banner

Ssoreg.sh Script Fails With ORA-01403: No Data Found (Doc ID 1593251.1)

Last updated on APRIL 03, 2017

Applies to:

Oracle Application Server Single Sign-On - Version 10.1.4.2 to 10.1.4.3 [Release 10gR3]
Information in this document applies to any platform.
***Checked for relevance on 03-APR-2017***

Symptoms

Running ssoreg.sh script to register new SSO partner application generates following message in ssoServer.log:

Mon Sep 23 15:14:28 EDT 2013 Exception while accessing database: java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "ORASSO.WWSSO_API_PRIVATE", line 210
ORA-01403: no data found
ORA-06512: at line 1

 

Changes

The ORASSO.WWSEC_ENABLER_CONFIG_INFO$ table was most likely manually updated.

This is not supported and this action corrupted data.

Here is table description to show table structure. This table has only 1 record inserted inserted during the installation process:

 

SQL> desc orasso.wwsec_enabler_config_info$
Name                                                Null?      Type
----------------------------------------- ------------ ----------------------------
LSNR_TOKEN                                    NOT NULL   VARCHAR2(255)
SITE_TOKEN                                                     VARCHAR2(255)
SITE_ID                                                           VARCHAR2(255)
LS_LOGIN_URL                                 NOT NULL   VARCHAR2(1000)
URLCOOKIE_VERSION                        NOT NULL  VARCHAR2(80)
ENCRYPTION_KEY                              NOT NULL  VARCHAR2(1000)
ENCRYPTION_MASK_PRE                     NOT NULL  VARCHAR2(1000)
ENCRYPTION_MASK_POST                   NOT NULL  VARCHAR2(1000)
URL_COOKIE_IP_CHECK                                     VARCHAR2(1)

 

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.