Article ID: 115879, created on Apr 1, 2013, last review on Oct 18, 2016

  • Applies to:
  • Operations Automation 7.0
  • Operations Automation 6.0
  • Operations Automation 5.5
  • Business Automation 7.0
  • Business Automation 5.5
  • Business Automation 5.4
  • Business Automation 6.0


1. Cannot open Event Manager screens: "canceling statement due to statement timeout"

A Provider cannot open the list of events in the Business Automation Event Manager:

  • BA 5.4: Home > Configuration Director > Event Manager

  • BA 5.5: Home > Operations > Tasks

One of the following errors is displayed:

ODBC error #57014: ERROR: canceling statement due to statement timeout;
Error while executing the query


error returned: Data packet type error. Type: 6 Index: 1

The problem may affect any screen in the Event Manager, including Active Tasks, Critical Failures, Minor Faults, or Event Log.

2. Product precheck fails

Product Precheck reported: "AEvent table size exceeds critical value and could cause significant growth of upgrade time"


Too many events are stored in the BA database. The size of the corresponding tables is too large, and the database server cannot fetch the required data within the configured timeout period.

The problem SQL query may be located in the log of the database server. For example, in the case of PostgreSQL, the following entries may be found in the log when the problem occurs in the PBA Provider Control Panel:

ERROR:  canceling statement due to statement timeout

STATEMENT:  SELECT "T846593864"."TaskID", "T846593864"."EID", "T846271280"."EKID", "T846530600"."ObjName", "T846530600"."MethodName", "T846593864"."TaskStat", "T846593864"."StartTime", "T846593864"."DateArc" FROM "AEvent" "T846271280" CROSS JOIN "TaskHandler" "T846530600" CROSS JOIN "Task" "T846593864"  WHERE ((((("T846593864"."EID") = ("T846271280"."EID")) AND (("T846593864"."EHID") = ("T846530600"."EHID"))) AND (("T846593864"."TaskStat") = (5))) AND (("T846530600"."Severity") <> (o))) AND ((1) = (1))

In the current version, BA does not allow you to configure data retention for event logs. This will be implemented in future versions of the product in the scope of the requests PBA-451 and PBA-3629.


Contact the Parallels Support Team to resolve the problem.

Search Words

Proxy Error - Error reading from remote server

Event Manager in PBA doesn't work

Falha na alteração do plano de serviço: Não disponível. Os serviços ainda não foram fornecidos.

task manager times out

archive events



Number of Events stored in BA database exceeds critical value

ODBC code #HY000

Error Code: 0xd5d92af2

task manager timed out

cannot open PBA tasks tab - recurring issue

APS resource for '/aps/2/application/dns-record-a' with id '288558' hasn't been registered

ODBC error #57014: ERROR: canceling statement due to statement timeout; Error while executing the query

deadlock order

hanged order

AEvent clean pba database

order provisioning fails

92711db0799e8aefe8e51f12dace0496 caea8340e2d186a540518d08602aa065 198398b282069eaf2d94a6af87dcb3ff 210d017ddc3a076d22f0f865b1cf0730 801221f8cd76fba7300d1e6817c8e08b e12cea1d47a3125d335d68e6d4e15e07 3627d36199b8ff577605df76e2fa222b bb7e9177fb03488961a3ea554120f328 5356b422f65bdad1c3e9edca5d74a1ae 5b048d9bddf8048a00aba7e0bdadef37 2554725ed606193dd9bbce21365bed4e 956c448bddc7e1f3585373687602379f 6f1456866eed87488c0f02b298a741c0 c0f836394088a28cc30dd0e5fe8b600e b2c3b33425dfc50c7d41a2efaa7f84f3 0871c0b47b3b86ae3b1af4c2942cd0ce 1941880841f714e458ae4dc3d9f3062d

Email subscription for changes to this article
Save as PDF