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