Search Engine: Elastic

Article ID: 124171, created on Jan 9, 2015, last review on Jan 9, 2015

  • Applies to:
  • Operations Automation 5.5

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.

5b048d9bddf8048a00aba7e0bdadef37 caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 5356b422f65bdad1c3e9edca5d74a1ae 2554725ed606193dd9bbce21365bed4e

Email subscription for changes to this article
Save as PDF