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.

Search Words

POA Windows Management Node

The multi-part identifier "u.user_id" could not be bound.

status updating

Users status updating

Error ID: 1414031102860

5b048d9bddf8048a00aba7e0bdadef37 caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 5356b422f65bdad1c3e9edca5d74a1ae 2554725ed606193dd9bbce21365bed4e

Email subscription for changes to this article
Save as PDF