An Agent Wakeup call or Agent Push server task does not expire if the client computer can't be reached

Technical Articles ID: KB84114
Last Modified: 6/25/2020

Environment

McAfee ePolicy Orchestrator (ePO) 5.x

Problem

When you try to push the agent to a client computer, the server task does not expire.

The issue is seen when the computer can't be reached.

Problem

You might also notice that the EPODataChannelDataMT table in the ePO database is increasing in size without shrinking.

Cause

The DBCleanUp task is missing a hidden server task.

Solution

If this solution or workaround does not resolve your issue, log on to the ServicePortal and create a Service Request at https://support.mcafee.com/ServicePortal/faces/serviceRequests/createSR. Include this article number in the Problem Description field.

Workaround

Restore the DBCleanUp task:

Take a backup of the ePO database before making any changes. For instructions to back up the SQL database, see one of the following articles:
- See KB52126 for details about backing up the ePO database using SQL Server Management Studio.
- See KB67591 for details about backing up the ePO database using OSQL commands.
Confirm that you are experiencing the issue described in this article.
1. Log on to the Microsoft SQL Server Management Studio.
2. Expand Databases.
3. Right-click the ePO database (where the default name is ePO_) and select New Query.
4. Paste the following SQL statements into the query window, depending on which ePO version you are using:
  
  For ePO 5.10:
  SELECT Id, name, UniqueKey, Enabled FROM OrionSchedulerTaskMT WHERE name like '%dc db clean%'
  SELECT * FROM OrionTaskQueueMT WHERE TaskDescription LIKE '%DC DB Clean%'
  
  For ePO 5.9.x:
  SELECT Id, name, UniqueKey, Enabled FROM OrionSchedulerTaskMT WHERE name like '%db clean%'
  SELECT * FROM OrionTaskQueueMT WHERE TaskDescription LIKE '%DBClean%'
5. Click Execute.
6. Note the ID of the task as returned by the first statement. The second statement is not expected to return a result. If it does, you are experiencing a different problem. Stop here.
Run the following command using a web browser:

https://<ePO_server_name>:8443/remote/scheduler.updateServerTask?taskId=<ID_from_step_2g>&status=disabled&isHidden=true
When prompted for credentials, type in an ePO user with Global Administrator permissions (for example, the original administrator user).
If there is any reply other than the following, provide the full error message with the current orion.log files to Technical Support and stop here.

OK:
True
Run the SQL statements from step 2 again. The first statement shows that the task is disabled now (Enabled =0). The second statement is not expected to return a result.
Delete records in OrionSchedulerTaskQueueEntryMT with the SchedulerTaskID from step 2g above using the command below:

DELETE FROM OrionScheduledTaskQueueEntryMT WHERE SchedulerTaskID = <ID_from_step_2g>
Run the following command using a web browser:

https://<ePO_server_name>:8443/remote/scheduler.updateServerTask?taskId=<ID_from_step_2g>&status=enabled&isHidden=true
If there is any reply other than the following, provide the full error message with the current orion.log files to Technical Support and stop here.

OK:
True
Run the SQL statements from step 2 again. The first statement shows that the task is enabled again (Enabled =1). The second statement now returns a result. Note the RunTime (next time to run the task).
Wait one minute.
Run the following statement:

ePO 5.10:
SELECT * FROM OrionTaskQueueMT WHERE TaskDescription LIKE '%DC DB Clean%'

ePO 5.9:
SELECT * FROM OrionTaskQueueMT WHERE TaskDescription LIKE '%DBClean%'

The RunTime field is updated.

Affected Products

ePolicy Orchestrator 5.9
ePolicy Orchestrator 5.10.x
Known Issue/Product Defect

Languages:

This article is available in the following languages:

German
English United States
Spanish Spain
French
Italian
Japanese
Portuguese Brasileiro
Chinese Simplified

Glossary of Technical Terms

Highlight Glossary Terms

Please take a moment to browse our Glossary of Technical Terms.

Knowledge Center

An Agent Wakeup call or Agent Push server task does not expire if the client computer can't be reached

Environment

Problem

Problem

Cause

Solution

Workaround

Affected Products

Languages:

Glossary of Technical Terms

Title

Title

Knowledge Center

An Agent Wakeup call or Agent Push server task does not expire if the client computer can't be reached

Environment

Problem

Problem

Cause

Solution

Workaround

Affected Products

Languages:

Glossary of Technical Terms

Choose your region

Title

Title