Article ID: 115879, created on Apr 1, 2013, last review on Mar 27, 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.

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

Email subscription for changes to this article
Save as PDF