Symptoms
The following error is shown in CCP when trying to filter users by any status:
An unforeseen error occurred. Please contact clientsupport@apptix.com.
Error ID: 1414070230163
The following error is shown in poa.debug.log at the same time:
Oct 23 07:43:57 AUSP01MPAR04 : DBG [UI:376b38d8:1414068236884 1:13020:2610 Kernel]: [Plesk::DBS::checkSQLError] Diagnostic info about SQL error: sqlreturn=0 state=42000, nativeCode=4104, description=[Microsoft][SQL Server Native Client 10.0][SQL Server]The multi-part identifier "u.user_id" could not be bound.
Oct 23 07:43:57 AUSP01MPAR04 : DBG [UI:376b38d8:1414068236884 1:13020:2610 lib]: [Plesk::DBS::Statement::execQuery] {module_id="db_service"; code="1"} '[Microsoft][SQL Server Native Client 10.0][SQL Server]The multi-part identifier "u.user_id" could not be bound.' while 'SELECT COUNT(*) FROM accounts a INNER JOIN users u ON u.scope_id = a.account_id INNER JOIN identities i ON i.identity_id = u.auth_identity_id INNER JOIN contacts c ON c.contact_id = u.contact_id WHERE u.scope_id = ? AND u.type = 'service user' AND (u.sub_id = ? OR u.sub_id IS NULL) AND (u.sub_id IS NULL OR NOT EXISTS (SELECT 1 FROM subscriptions_acl sa WHERE sa.user_id = ? AND sa.sub_id IS NOT NULL ) OR u.sub_id IN (SELECT sa.sub_id FROM subscriptions_acl sa WHERE sa.user_id = ? )) (SELECT 1 FROM hs_user_services hss WHERE hss.user_id = u.user_id AND hss.hs_service_status != ? ) '
POA Management Node is installed on a Windows server.
Cause
Incorrect query is used in this case.
Resolution
The issue has been reported to the maintenance as a bug POA-88885. It will be fixed in one of future versions. Please contact your Account Manager to trace the status of this issue.