My Oracle Support Banner

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

Last updated on AUGUST 29, 2019

Applies to:

Oracle Application Server Single Sign-On - Version and later
Information in this document applies to 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_SCHEMA_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

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