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:
This problem can occur on any platform.


Imported the SSO data from 9.0.4 SSO into SSO 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 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 ( 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 ( The metadata repository is, but the
database version is
-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
-Our source SSO was 9iAS 9.0.4, and it was upgraded from 9.0.2 two years ago.


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

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.