search cancel

Phoenix Theme not Fully Rendering Classic UI Page

book

Article ID: 203074

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

Users are unable to login to Clarity if the UI theme is set to the Phoenix UI. The page spins but never renders. The new UX loads without an issue. 

This issue is similar to the one described on User Not Able to Access Phoenix UI - Blank Page (KB145045). However, the resolution on KB145045 does not apply. The corresponding record exists in the cmn_menu_items table and is not hidden. 

When using another UI theme, the Overview page renders, but the Favorites menu is unresponsive when hovered over. 

Environment

Release : 15.8.1

Component : CA PPM SAAS USERS, GROUPS, OBS ADMINISTRATION

Cause

This is due to missing records in the CMN_CAPTIONS_NLS table for both 'My Links' and 'Favorites Menu' for the affected user(s). 

Resolution

The missing records will need to be added to the CMN_CAPTIONS_NLS table. This can be done using the cmn_captions_nls_upd_sp stored procedure. 

In GCP, the commands to run would be the following: 

Note: 

v_portletid will need to be replaced with the result from the following query: 

select id from cmn_portlets 
where portlet_code like '%union.favLeftNav' 
and principal_id =<internal user id>

v_actionid will need to be replaced with the result from the following query: 

select id from cmn_actions 
where action_code = <internal user id>||'.My Links'

call cmn_captions_nls_upd_sp('CMN_PORTLETS',v_portletid, 'Nabídka Oblíbené', 'Nabídka Oblíbené', 1, null, null, null, null, null,'cs');                        
call cmn_captions_nls_upd_sp('CMN_PORTLETS',v_portletid, 'Menuen Favoritter', 'Menuen Favoritter', 1, null, null, null, null, null,'da');                      
call cmn_captions_nls_upd_sp('CMN_PORTLETS',v_portletid, 'Favoritenmenü', 'Favoritenmenü', 1, null, null, null, null, null,'de');                              
call cmn_captions_nls_upd_sp('CMN_PORTLETS',v_portletid, 'Favorites Menu', 'Favorites Menu', 1, null, null, null, null, null,'en');                            
call cmn_captions_nls_upd_sp('CMN_PORTLETS',v_portletid, 'Menú de favoritos', 'Menú de favoritos', 1, null, null, null, null, null,'es');                      
call cmn_captions_nls_upd_sp('CMN_PORTLETS',v_portletid, 'Suosikit-valikko', 'Suosikit-valikko', 1, null, null, null, null, null,'fi');                        
call cmn_captions_nls_upd_sp('CMN_PORTLETS',v_portletid, 'Menu Favoris', 'Menu Favoris', 1, null, null, null, null, null,'fr');                                
call cmn_captions_nls_upd_sp('CMN_PORTLETS',v_portletid, 'Kedvencek menü', 'Kedvencek menü', 1, null, null, null, null, null,'hu');                            
call cmn_captions_nls_upd_sp('CMN_PORTLETS',v_portletid, 'Menu Preferiti', 'Menu Preferiti', 1, null, null, null, null, null,'it');                            
call cmn_captions_nls_upd_sp('CMN_PORTLETS',v_portletid, 'お気に入りメニュー', 'お気に入りメニュー', 1, null, null, null, null, null,'ja');                                      
call cmn_captions_nls_upd_sp('CMN_PORTLETS',v_portletid, '즐겨찾기 메뉴', '즐겨찾기 메뉴', 1, null, null, null, null, null,'ko');                                          
call cmn_captions_nls_upd_sp('CMN_PORTLETS',v_portletid, 'Menu Favorieten', 'Menu Favorieten', 1, null, null, null, null, null,'nl');                          
call cmn_captions_nls_upd_sp('CMN_PORTLETS',v_portletid, 'Favoritter-meny', 'Favoritter-meny', 1, null, null, null, null, null,'no');                          
call cmn_captions_nls_upd_sp('CMN_PORTLETS',v_portletid, 'Menu ulubionych', 'Menu ulubionych', 1, null, null, null, null, null,'pl');                          
call cmn_captions_nls_upd_sp('CMN_PORTLETS',v_portletid, 'Menu Favoritos', 'Menu Favoritos', 1, null, null, null, null, null,'pt');                            
call cmn_captions_nls_upd_sp('CMN_PORTLETS',v_portletid, 'Меню избранного', 'Меню избранного', 1, null, null, null, null, null,'ru');                          
call cmn_captions_nls_upd_sp('CMN_PORTLETS',v_portletid, 'Favoriter-meny', 'Favoriter-meny', 1, null, null, null, null, null,'sv');                            
call cmn_captions_nls_upd_sp('CMN_PORTLETS',v_portletid, 'Sık Kullanılanlar Menüsü', 'Sık Kullanılanlar Menüsü', 1, null, null, null, null, null,'tr');        
call cmn_captions_nls_upd_sp('CMN_PORTLETS',v_portletid, '收藏夹菜单', '收藏夹菜单', 1, null, null, null, null, null,'zh');                                              
call cmn_captions_nls_upd_sp('CMN_PORTLETS',v_portletid, '我的最愛功能表', '我的最愛功能表', 1, null, null, null, null, null,'zh_TW');  

call cmn_captions_nls_upd_sp('CMN_ACTIONS',v_actionid, 'Moje odkazy', 'Moje odkazy', 1, null, null, null, null, null,'cs');                                  
call cmn_captions_nls_upd_sp('CMN_ACTIONS',v_actionid, 'Mine links', 'Mine links', 1, null, null, null, null, null,'da');                                    
call cmn_captions_nls_upd_sp('CMN_ACTIONS',v_actionid, 'Eigene Verknüpfungen', 'Eigene Verknüpfungen', 1, null, null, null, null, null,'de');                
call cmn_captions_nls_upd_sp('CMN_ACTIONS',v_actionid, 'My Links', 'My Links', 1, null, null, null, null, null,'en');                                        
call cmn_captions_nls_upd_sp('CMN_ACTIONS',v_actionid, 'Mis vínculos', 'Mis vínculos', 1, null, null, null, null, null,'es');                                
call cmn_captions_nls_upd_sp('CMN_ACTIONS',v_actionid, 'Omat linkit', 'Omat linkit', 1, null, null, null, null, null,'fi');                                  
call cmn_captions_nls_upd_sp('CMN_ACTIONS',v_actionid, 'Mes liens', 'Mes liens', 1, null, null, null, null, null,'fr');                                      
call cmn_captions_nls_upd_sp('CMN_ACTIONS',v_actionid, 'Hivatkozásaim', 'Hivatkozásaim', 1, null, null, null, null, null,'hu');                              
call cmn_captions_nls_upd_sp('CMN_ACTIONS',v_actionid, 'Collegamenti personali', 'Collegamenti personali', 1, null, null, null, null, null,'it');            
call cmn_captions_nls_upd_sp('CMN_ACTIONS',v_actionid, 'マイ リンク', 'マイ リンク', 1, null, null, null, null, null,'ja');                                            
call cmn_captions_nls_upd_sp('CMN_ACTIONS',v_actionid, '내 링크', '내 링크', 1, null, null, null, null, null,'ko');                                                
call cmn_captions_nls_upd_sp('CMN_ACTIONS',v_actionid, 'Mijn koppelingen', 'Mijn koppelingen', 1, null, null, null, null, null,'nl');                        
call cmn_captions_nls_upd_sp('CMN_ACTIONS',v_actionid, 'Mine koblinger', 'Mine koblinger', 1, null, null, null, null, null,'no');                            
call cmn_captions_nls_upd_sp('CMN_ACTIONS',v_actionid, 'Moje łącza', 'Moje łącza', 1, null, null, null, null, null,'pl');                                    
call cmn_captions_nls_upd_sp('CMN_ACTIONS',v_actionid, 'Meus links', 'Meus links', 1, null, null, null, null, null,'pt');                                    
call cmn_captions_nls_upd_sp('CMN_ACTIONS',v_actionid, 'Мои ссылки', 'Мои ссылки', 1, null, null, null, null, null,'ru');                                    
call cmn_captions_nls_upd_sp('CMN_ACTIONS',v_actionid, 'Mina länkar', 'Mina länkar', 1, null, null, null, null, null,'sv');                                  
call cmn_captions_nls_upd_sp('CMN_ACTIONS',v_actionid, 'Bağlantılarım', 'Bağlantılarım', 1, null, null, null, null, null,'tr');                              
call cmn_captions_nls_upd_sp('CMN_ACTIONS',v_actionid, '我的链接', '我的链接', 1, null, null, null, null, null,'zh');                                                
call cmn_captions_nls_upd_sp('CMN_ACTIONS',v_actionid, '我的連結', '我的連結', 1, null, null, null, null, null,'zh_TW'); 

----

The equivalent Oracle queries can be found on the text file attached. 

Additional Information

To find if there are any additional active users with the issue where the CMN_CAPTIONS_NLS table is missing records for either the 'My Links' action or 'Favorites Menu' portlet, the following queries can be used: 

For the 'Favorites Menu' portlet: 

   select  id, user_name, first_name, last_name from cmn_sec_users where user_name not in (SELECT
   distinct(cmn_sec_users.user_name)
FROM
    cmn_portlets
    INNER JOIN cmn_sec_users ON cmn_portlets.principal_id = cmn_sec_users.id
    INNER JOIN cmn_captions_nls ON cmn_captions_nls.pk_id = cmn_portlets.id
WHERE
    cmn_captions_nls.table_name = 'CMN_PORTLETS'
    AND cmn_portlets.portlet_type_code = 'FAVORITE')
    AND id not in (9,-99)
    AND user_status_id = 200
    

For the 'My Links' action: 

   select id, user_name, first_name, last_name from cmn_sec_users where user_name not in (SELECT
   distinct(cmn_sec_users.user_name)
FROM
    cmn_actions
    INNER JOIN cmn_sec_users ON cmn_actions.principal_id = cmn_sec_users.id
    INNER JOIN cmn_captions_nls ON cmn_captions_nls.pk_id = cmn_actions.id
WHERE
    cmn_captions_nls.table_name = 'CMN_ACTIONS'
    AND cmn_actions.action_code like '%My Links')
AND id not in (9,-99)
AND user_status_id = 200

Attachments

1612818726343__Oracle Queries.txt get_app