My Oracle Support Banner

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 06, 2023

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.


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 : _admin/057E4A161268305E061206BC960CE15D
...Name/ID : /30A9233749D24BF486E165AA677D1376
...Name/ID : /3BDDE8567057AD3D863F53C6C7E2CFF6
...Name/ID : /47E41D6226FED8552E0BACC1895B97BE
...Name/ID : My.Oracle.Com/5DB61843A26CE17F6E6571DED06284AD
...Name/ID :  [Session 2]/612814FBBFDFCD75DF47E5AA567F090C
...Name/ID : /71DDD375F4C3D88770EF2A288125CDB2
...Name/ID :  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.





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.