My Oracle Support Banner

SSOMIG Import Fails Copy_subscriber_prefs Failed Ora-01422 (Doc ID 463428.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle9iAS Single Sign-On - Version: 10.1.4.0.1
This problem can occur on any platform.

Symptoms

Imported the SSO data from 9.0.4 SSO into SSO 10.1.4.0.1. From the log file found the following errors:

 "Error: copy_subscriber_prefs failed" and "Error in copying data: Ora-01422: exact fetch returns more than requested number of rows".

Steps to Reproduce Problem:
=====================
1) export SSO (9.0.4) data using using the following commands:
ssomig -export -s orasso -p orasso_password -c asdb -log_d $ORACLE_HOME/sso/log

2) import SSO data into SSO 10.1.4.0.1 using the following commands:
ssomig -import -overwrite -s orasso -p orasso_password -c destination_sso_db -log_d
/path_of_ssoimp -d ssoimp.dmp -log_f imp.log

3) The imp (10.1.4.0.1) log was uploaded as "ssomig.log",and the source (9.0.4) exp log was uploaded as "source_ssomig.log".

-We are importing SSO data into SSO (10.1.4.0.1). The metadata repository is 10.1.4.0.1, but the
database version is 10.2.0.3.
-We installed the Oracle Identity Management in a Distribute Style, ie., Single Sign-on middle
tier, OID middle tier, and metadata repository database in separated servers.
- Our source sso data was from an export of 9iAS 9.0.4. In the source instance we do have
Discoverer.
-Our source SSO was 9iAS 9.0.4, and it was upgraded from 9.0.2 two years ago.

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
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

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