Article ID: 115879, created on Apr 1, 2013, last review on Feb 6, 2017

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

Symptoms

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 - 7.0: 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

or

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"

Cause

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.

Resolution

Contact the Odin 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

canceling statement due to statement timeout

database

Bug OA (OBA/OOA)

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

canceling timeout statement

e

upgrade osa

deadlock order

Upgrade hot fixes

hanged order

AEvent clean pba database

order provisioning fails

eRROR PROVISIONING

AEvent

198398b282069eaf2d94a6af87dcb3ff caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 c0f836394088a28cc30dd0e5fe8b600e b2c3b33425dfc50c7d41a2efaa7f84f3 210d017ddc3a076d22f0f865b1cf0730 92711db0799e8aefe8e51f12dace0496 801221f8cd76fba7300d1e6817c8e08b 3627d36199b8ff577605df76e2fa222b bb7e9177fb03488961a3ea554120f328

Email subscription for changes to this article
Save as PDF