ORA-21780 Maximum number of object durations exceeded during Oracle Portal Export (Doc ID 1268475.1)

Last updated on AUGUST 29, 2016

Applies to:

Portal - Version 10.1.2.0.2 and later
Information in this document applies to any platform.
Checked for currency on 26-MAR-2015

Symptoms

Can not export a specific page group (large one) as it fails when exporting items with a database error:

ORA-21780: Maximum number of object durations exceeded


Errors seen in export log:

Exporting Perspectives ...
Exporting Styles ...
Exporting Pages ...
Exporting Regions ...
Exporting Items ...

[12-JUL-10 12:05:50][Error: ] context = NULL user = PORTAL
WWUTL_API_EXPORT_PAGEGROUP.extract_itemORA-21780: Maximum number of object
durations exceeded.

[12-JUL-10 12:05:50][Error: ] context = NULL user = PORTAL
WWUTL_API_EXPORT_PAGEGROUP.extract_pageORA-06510: PL/SQL: unhandled
user-defined exception ORA-06512: at "PORTAL.WWUTL_API_EXPORT_PAGEGROUP",
line 204 ORA-06512: at "PORTAL.WWUTL_API_EXPORT_PAGEGROUP", line 1844
ORA-21780: Maximum number of object durations exceeded.


[12-JUL-10 12:05:50][Error: ] context = NULL user = PORTAL
WWUTL_API_EXPORT_PAGEGROUP.start_exportORA-06510: PL/SQL: unhandled
user-defined exception ORA-06512: at "PORTAL.WWUTL_API_EXPORT_PAGEGROUP",
line 204 ORA-06512: at "PORTAL.WWUTL_API_EXPORT_PAGEGROUP", line 2604
ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at
"PORTAL.WWUTL_API_EXPORT_PAGEGROUP", line 204 ORA-06512: at
"PORTAL.WWUTL_API_EXPORT_PAGEGROUP", line 1844 ORA-21780: Maximum number of
object durations exceeded.

Completed On: 12-JUL-10 12:05:50

[12-JUL-10 12:05:50][Error: ] context = NULL user = PORTAL ORA-06510:
PL/SQL: unhandled user-defined exception ORA-06512: at
"PORTAL.WWUTL_API_EXPORT_PAGEGROUP", line 204 ORA-06512: at
"PORTAL.WWUTL_API_EXPORT_PAGEGROUP", line 3616 ORA-06510: PL/SQL: unhandled
user-defined exception ORA-06512: at "PORTAL.WWUTL_API_EXPORT_PAGEGROUP",
line 204 ORA-06512: at "PORTAL.WWUTL_API_EXPORT_PAGEGROUP", line 2604
ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at
"PORTAL.WWUTL_API_EXPORT_PAGEGROUP", line 204 ORA-06512: at
"PORTAL.WWUTL_API_EXPORT_PAGEGROUP", line 1844 ORA-21780: Maximum number of
object durations exceeded.


Enabled event in database to capture the trace file:

*** SERVICE NAME:(SYS$USERS) 2010-07-14 15:40:34.268
*** SESSION ID:(1944.15089) 2010-07-14 15:40:34.268
*** 2010-07-14 15:40:34.268
ksedmp: internal or fatal error
ORA-21780: Maximum number of object durations exceeded.
Current SQL statement for this session:
INSERT INTO WWUTL_SBR_TX_TEXT$ ( EXPORT_ID ,TEXT ,ID ,SITEID ) SELECT :B3
,TEXT ,ID ,SITEID FROM WWV_TEXT WHERE ID = :B2 AND SITEID = :B1
----- PL/SQL Call Stack -----
object line object
handle number name
c0000001b9809358 1816 package body PORTAL.WWUTL_API_EXPORT_PAGEGROUP
c0000001b9809358 2596 package body PORTAL.WWUTL_API_EXPORT_PAGEGROUP
c0000001b9809358 3603 package body PORTAL.WWUTL_API_EXPORT_PAGEGROUP
c0000001c2ffda88 712 package body PORTAL.WWUTL_APP_EXPORT_IMPORT
c0000001c2ffda88 2884 package body PORTAL.WWUTL_APP_EXPORT_IMPORT
c0000001ba4c7ec8 1 anonymous block
c0000001bacbe6e8 2 anonymous block
----- Call Stack Trace -----
calling call entry argument values in hex

location type point (? means dubious value)

-------------------- -------- --------------------
----------------------------
ksedst()+64 call ksedst1() 000000000 ? 000000001 ?
ksedmp()+2176 call ksedst() 000000000 ?
C000000000000C9F ?
4000000003FEDA00 ?
000000000 ? 000000000 ?
000000000 ?

 

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