Unforeseen error when clicking on Users tab in CCP : CloudBlue Technical Support

Symptoms

Unforeseen error is shown when one logs in to CCP and click on Users tab. The following errors are shown in POA UI log:

2014-05-03 09:02:30,597 f3e5647cf8 -6013 DEBUG  ModuleFinder         Entry: screens service_users.LongServiceUserListScreen:build
2014-05-03 09:02:30,597 f3e5647cf8 -6013 DEBUG  OUT                  SCREEN: com.plesk.p2.cp.ext.service_users.modules.screens.LongServiceUserListScreen@859666.buildList
2014-05-03 09:02:30,598 f3e5647cf8 -6013 DEBUG  CORBA                #3022454: Plesk.HostedServices._HostedServiceManagementStub.isHSUserWithUnknownPasswordPresent(user_id=36 (su_user_id=1)) >>> entry
2014-05-03 09:02:30,651 f3e5647cf8 -6013 DEBUG  CORBA                #3022454: Plesk.HostedServices._HostedServiceManagementStub.isHSUserWithUnknownPasswordPresent(user_id=36 (su_user_id=1)) <<< exit [53]
2014-05-03 09:02:30,651 f3e5647cf8 -6013 DEBUG  CORBA                #3022456: com.parallels.psa._ResourceStub.getAccountResourceActivationParameters(user_id=36 (su_user_id=1)) >>> entry
2014-05-03 09:02:30,690 f3e5647cf8 -6013 DEBUG  CORBA                #3022456: com.parallels.psa._ResourceStub.getAccountResourceActivationParameters(user_id=36 (su_user_id=1)) <<< exit [39]
2014-05-03 09:02:30,690 f3e5647cf8 -6013 DEBUG  CORBA                #3022458: Plesk.APS._APSManagerStub.getApplications(user_id=36 (su_user_id=1)) >>> entry
2014-05-03 09:02:30,694 f3e5647cf8 -6013 DEBUG  CORBA                #3022458: Plesk.APS._APSManagerStub.getApplications(user_id=36 (su_user_id=1)) <<< exit [4]
2014-05-03 09:02:30,694 f3e5647cf8 -6013 DEBUG  CORBA                #3022460: Plesk.APS._APSManagerStub.getApplications(user_id=36 (su_user_id=1)) >>> entry
2014-05-03 09:02:30,697 f3e5647cf8 -6013 DEBUG  CORBA                #3022460: Plesk.APS._APSManagerStub.getApplications(user_id=36 (su_user_id=1)) <<< exit [3]
2014-05-03 09:02:30,697 f3e5647cf8 -6013 DEBUG  CORBA                #3022462: Plesk.APS._APSManagerStub.getApplications(user_id=36 (su_user_id=1)) >>> entry
2014-05-03 09:02:30,700 f3e5647cf8 -6013 DEBUG  CORBA                #3022462: Plesk.APS._APSManagerStub.getApplications(user_id=36 (su_user_id=1)) <<< exit [3]
2014-05-03 09:02:30,700 f3e5647cf8 -6013 DEBUG  CORBA                #3022464: Plesk.APS._APSManagerStub.getApplications(user_id=36 (su_user_id=1)) >>> entry
2014-05-03 09:02:30,703 f3e5647cf8 -6013 DEBUG  CORBA                #3022464: Plesk.APS._APSManagerStub.getApplications(user_id=36 (su_user_id=1)) <<< exit [3]
2014-05-03 09:02:30,703 f3e5647cf8 -6013 DEBUG  CORBA                #3022466: Plesk.APS._APSManagerStub.getApplicationXMLMetadata(user_id=36 (su_user_id=1)) >>> entry
2014-05-03 09:02:30,707 f3e5647cf8 -6013 DEBUG  CORBA                #3022466: Plesk.APS._APSManagerStub.getApplicationXMLMetadata(user_id=36 (su_user_id=1)) <<< exit [4]
2014-05-03 09:02:30,707 f3e5647cf8 -6013 DEBUG  ModuleFinder         Exit: screens service_users.LongServiceUserListScreen:build by exception:java.lang.reflect.InvocationTargetException
2014-05-03 09:02:30,707 f3e5647cf8 -6013 DEBUG  OUT                  NAVIGATION ERROR:java.lang.reflect.InvocationTargetException
2014-05-03 09:02:30,707 f3e5647cf8 -6013 DEBUG  OUT                  java.lang.reflect.InvocationTargetException
2014-05-03 09:02:30,708 f3e5647cf8 -6013 DEBUG  OUT                     at sun.reflect.GeneratedMethodAccessor1292.invoke(Unknown Source)
..........
..........
2014-05-03 09:02:30,709 f3e5647cf8 -6013 DEBUG  OUT                  Caused by: java.lang.NullPointerException
2014-05-03 09:02:30,709 f3e5647cf8 -6013 DEBUG  ModuleFinder         Exit: navigations pcp.ObjectNav:build by exception:java.lang.reflect.InvocationTargetException
2014-05-03 09:02:30,709 f3e5647cf8 -6013 DEBUG  ModuleFinder         Exit: layouts pcp.PDefaultLayout:build by exception:java.lang.reflect.InvocationTargetException
2014-05-03 09:02:30,710 f3e5647cf8 -6013 WARN   PDefaultPage         Exception during screen execution
java.lang.reflect.InvocationTargetException

At the same time the following information can be found in POA debug log:

May  3 09:02:30 osscore : DBG [UI:ce8b7b1b:1399100550703 1:29296:ad1ffba0 lib]: CORBA_OTHER <0> IDL:Plesk/APS/APSManager_private:1.0::getApplicationXMLMetadata
May  3 09:02:30 osscore : DBG [UI:ce8b7b1b:1399100550703 1:29296:ad1ffba0 SAAS]: [APS::getApplicationXMLMetadata] ===> ENTRY
May  3 09:02:30 osscore : DBG [UI:ce8b7b1b:1399100550703 1:28953:ad5ffba0 Kernel]: STMT [Con: 616, 0xb30f0538] ' SELECT app_ver FROM aps_packages WHERE app_id =  ?  AND ( status =  ?  OR status =  ?  OR status =  ? ) ORDER BY version_order'($0 = 101, $1 = 'r', $2 = 'c', $3 = 'z')
May  3 09:02:30 osscore : DBG [UI:ce8b7b1b:1399100550703 1:29296:ad1ffba0 SAAS]: [APS::getApplicationXMLMetadata] <=== EXIT [0.002515]
May  3 09:02:30 osscore : DBG [UI:ce8b7b1b:1399100550703 1:29296:ad1ffba0 lib]: CORBA_OTHER </0> OK

The application ID mentioned in the log indeed cannot be found in POA database:

plesk=> SELECT * from aps_packages where app_id = 101;
 pkg_id | app_id | app_ver | version_order | aps_ver | repo_file_name | url | task_id | disabled | status | uuid
--------+--------+---------+---------------+---------+----------------+-----+---------+----------+--------+------
(0 rows)

plesk=> SELECT * from aps_applications where app_id = 101;
 app_id | name | summary_key_id | categories | icon_name | prov_type | app_uid | master_app_id |     default_conf_id | master_app_uid | images_root_path
 | owner_id
--------+------+----------------+------------+-----------+-----------+---------+---------------+    -----------------+----------------+-----------------
-+----------
(0 rows)

Cause

There are resources that have activation parameters pointing to non-existent APS applications. Another possibility is that UI process memory has cached information about APS application that was already removed from system. Both scenarios will be fixed in scope of bug APS-17012.

Resolution

Restart POA UI on the UI server - in most cases it helps to fix the issue:

[root@ui ~]# /etc/init.d/pemui stop
Stopping pemui:                                            [  OK  ]
[root@ui ~]# /etc/init.d/pemui start
Starting pemui:                                            [  OK  ]

If it does not help, check if there are resources pointing to non-existent applications:
```
SELECT * FROM rt_act_params where name = 'app_id' AND NOT EXISTS (SELECT 1 FROM aps_applications WHERE aps_applications.app_id = CAST(rt_act_params.value AS int));
```
If such resources are found, remove them via POA Provider Panel > Products > Resources (use the IDs obtained from the query above to find out what resources should be removed).