Article ID: 115879, created on Apr 1, 2013, last review on Dec 5, 2016

  • Applies to:
  • Operations Automation
  • Business Automation

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 and later: 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

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

upgrade osa

deadlock order

hanged order

AEvent clean pba database

order provisioning fails

caea8340e2d186a540518d08602aa065 198398b282069eaf2d94a6af87dcb3ff e12cea1d47a3125d335d68e6d4e15e07 5356b422f65bdad1c3e9edca5d74a1ae

Email subscription for changes to this article
Save as PDF