Ssomig Import Into a 10.2.0.x Metadata Repository Database Fails Ora-06510: Pl/Sql Unhandled User-Defined Exception (Doc ID 455709.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Application Server Single Sign-On - Version 10.1.2 to 10.1.4 [Release 10gR2 to 10gR3]
Information in this document applies to any platform.

Symptoms

The ssomig tool import fails, then exits with the following error:

ORA-06510: PL/SQL: unhandled user-defined exception
SSO-80000: Operation was unsuccessful.
Please see the log file.



From the log file...

Copying External Applications ...
...Name/ID : Landman_admin/057E4A161268305E061206BC960CE15D
...Name/ID : Landman/30A9233749D24BF486E165AA677D1376
...Name/ID : enVision/3BDDE8567057AD3D863F53C6C7E2CFF6
...Name/ID : Envision2/47E41D6226FED8552E0BACC1895B97BE
...Name/ID : My.Oracle.Com/5DB61843A26CE17F6E6571DED06284AD
...Name/ID : Envision 2.1 [Session 2]/612814FBBFDFCD75DF47E5AA567F090C
...Name/ID : Triangle/71DDD375F4C3D88770EF2A288125CDB2
...Name/ID : Envision 2.1 [Session 1]/7975DE88ABF79E2951ACCEF7BBD45E62
...Name/ID : Secure Database Tunnel/9A11B560C6953500EF79311D42C2E0BD
...Name/ID : Timesheets/B66CC1EC013FCC92E299A63BAFD925F2
...Name/ID : Reporting/E0BC2415196BA0BD0FFAFFCBC8FCB696
Copying External Application user information...
Error in copying data: User-Defined Exception
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "ORASSO.WWSSO_UTL", line 546
ORA-06502: PL/SQL: numeric or value error

----- PL/SQL Call Stack -----
object line object
handle number name
39336cfe0 895 package body ORASSO.WWSSO_UPGM_IMPORT
394604078 1 anonymous block


PL/SQL procedure successfully completed.

.

Cause

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