Some server tasks are stuck indefinitely showing 'in progress' and the EPODataChannelDataMT database table is excessively large

Technical Articles ID: KB90920
Last Modified: 2023-07-26 07:28:11 Etc/GMT

Environment

ePolicy Orchestrator (ePO) 5.10.x

Problem 1

Certain server tasks that use the data channel still display in progress after the expire time for the task is reached. The problem only occurs if the data channel action is unsuccessful in contacting one or more clients.

Example tasks include the following:

Any task that does a push agent install.
A task that performs an Agent wake-up call.

To confirm the problem, run the following SQL query:

select count (AutoID) as CountExpiredTasks
from EPOAgentHandlerDataChannelWQMT with (nolock)
where ExpireTime < DateAdd (DD, -2, GetDate())

NOTES:

The query returns a count of all rows in the data channel work queue table, where the expiry time is two or more days in the past.
On an ePO server functioning properly, the query returns zero results.

Problem 2

The EPODataChannelDataMT table grows over time and never reduces in size.

To confirm the problem, run the following SQL query:

select count(DCD.AutoId) as DCDRowCount
from EPODataChannelDataMT DCD with (nolock)
left join EPOAgentHandlerDataChannelWQMT DCWQ with (nolock)
on DCD.AutoId = DCWQ.DataId
where DCWQ.DataID is NULL

NOTES:

On a working ePO server, the row count on that query is low, depending on how busy the data channel is in the environment.
The issue is confirmed when the row count returns hundreds of rows.

Cause

By design, an internal maintenance task runs every 60 seconds to purge expired data channel requests from the EPOAgentHandlerDataChannelWQMT table. It also deletes rows from the EPODataChannelDataMT table that don't have corresponding rows in the EPOAgentHandlerDataChannelWQMT table.

In ePO 5.10.0.2428 and earlier, the maintenance task is not properly loaded into the scheduler, so it's never invoked.

Solution

ePolicy Orchestrator 5.10.0 Update 1 was released to support to resolve this issue. This release has now been superseded by a later cumulative ePO 5.10 update release.

The latest ePO 5.10.0 Update is available from the Product Downloads site.

NOTE: You need a valid Grant Number for access.

To find the latest release, see KB51569 - Supported platforms for ePolicy Orchestrator.

To view other ePO 5.10.x known and resolved issues, see KB90382 - ePolicy Orchestrator 5.10.x Known Issues.

Affected Products

Languages:

This article is available in the following languages:

Knowledge Center

Some server tasks are stuck indefinitely showing 'in progress' and the EPODataChannelDataMT database table is excessively large

Environment

Problem 1

Problem 2

Cause

Solution

Affected Products

Languages:

Title

Title

Knowledge Center

Some server tasks are stuck indefinitely showing 'in progress' and the EPODataChannelDataMT database table is excessively large

Environment

Problem 1

Problem 2

Cause

Solution

Affected Products

Languages:

Choose your region

Title

Title