Article ID: 129192, created on Aug 1, 2016, last review on Aug 1, 2016

  • Applies to:
  • Operations Automation 6.0

Symptoms

Operations Automation is running on Windows with Microsoft SQL as a database engine. Control Panel is loading for a long time or the following error appears when attempting to access all parts of the Control Panel:

Service Unavailable
HTTP Error 503. The service is unavailable.

The following stuck queries can be found in poa.log:

Feb 11 15:16:53 OSSCORE001 : DBG [UI:b09591e5:1845050:1455203812509 RequestProcessor-88059 pau 2123966006]: com.parallels.pa.service.db.ejb.DBServiceBean Executing update: ' UPDATE mlabs_protected_emails SET sync_status =  ? , was_updated =  ? WHERE recipient_id =  ? AND recipient_type =  ? AND sync_status !=  ? AND email NOT IN ( LOWER( ? ) ,  LOWER( ? )  ) ' Parameters: [d, y, 1924393, mbx, d, john.doe@domain.tld, john.doe@domain2.tld] [sqlpid: -1]

Cause

The issue is located in MessageLabs service controller, it is reported to the OA maintenance team as POA-100940: "Updating of recipient emails in Message Labs locks another update operations".

Resolution

Please contact your Account Manager or Pooled Technical Associates team (pta@odin.com) to trace the status of POA-100940. As a workaround please restart pem and pau services on the OA Management Node.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 956c448bddc7e1f3585373687602379f 6f1456866eed87488c0f02b298a741c0

Email subscription for changes to this article
Save as PDF