I'm unable to open a Project. When clicking the link, nothing opens, and Clarity shows it's loading and never progresses.
Logs may show error like this:
[Oracle] ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Related to this query
select action_code
from cmn_actions a, cmn_pages p, cmn_page_portlets pp
where a.page_id = p.id
and p.id = pp.page_id
and pp.principal_type = :"SYS_B_00"
and pp.principal_id = :v0
and pp.portlet_id in
(select iport.id
from cmn_portlets iport
where iport.portlet_code = :"SYS_B_01"
and :"SYS_B_02" = :v1
union
select id
from cmn_sec_chk_user_v0 sec, cmn_portlets iport
where :"SYS_B_03" = :v2
and iport.portlet_code = :"SYS_B_04"
and iport.id = sec.object_instance_id
and sec.permission_code = :v3
and sec.object_id = :v4
and sec.user_id = :v5 ) union
select action_code
from cmn_actions a, cmn_pages p, cmn_page_portlets pp
where a.page_id = p.id
and p.id = pp.page_id
and pp.principal_type = :"SYS_B_05"
and pp.portlet_id in
(select iport.id
from cmn_portlets iport
where iport.portlet_code = :"SYS_B_06"
and :"SYS_B_07" = :v6
union
select id
from cmn_sec_chk_user_v0 sec, cmn_portlets iport
where :"SYS_B_08" = :v7
and iport.portlet_code = :"SYS_B_09"
and iport.id = sec.object_instance_id
and sec.permission_code = :v8
and sec.object_id = :v9
and sec.user_id = :v10 )
and pp.page_id not in (
select page_id
from cmn_page_portlets
where principal_type = :"SYS_B_10"
and principal_id = :v11 )
and pp.page_id in
(select ipage.id
from cmn_pages ipage
where :"SYS_B_11" = :v12
union
select sec.object_instance_id
from cmn_sec_chk_user_v0 sec
where :"SYS_B_12" = :v13
and sec.permission_code = :v14
and sec.object_id = :v15
and sec.user_id = :v16 )
Release : 15.8.1
Component : CA PPM APPLICATION
After the DBA increased the Tablespace size for TEMP, the problem is resolved