Why the task on EPO has not been running

[Frank83]

Dear Mcafee,

please help check, I created one task on the EPO Server, and it should be running every day. but according to the display on the WEB, the lastest running time is 6th Feb. 2022, please see the attached picture.

[aguevara]

Is there a task waiting or pending on the server task log? could you please run the query on the ePO DB?

-------------------------------------------

SELECT
SUBSTRING(TaskDescription, LEN(LEFT(TaskDescription, CHARINDEX ('<name>', TaskDescription))) + 6, LEN(TaskDescription) - LEN(LEFT(TaskDescription, CHARINDEX ('<name>', TaskDescription))) - LEN(RIGHT(TaskDescription, LEN(TaskDescription) - CHARINDEX ('</name>', TaskDescription))) - 6) as 'Task Name',
CONVERT(datetime, SWITCHOFFSET(CONVERT(datetimeoffset, OrionTaskQueueMT.RunTime), DATENAME(TzOffset, SYSDATETIMEOFFSET()))) AS 'Local Start Time',
CONVERT(datetime, SWITCHOFFSET(CONVERT(datetimeoffset, OrionTaskQueueMT.EnqueuedTime), DATENAME(TzOffset, SYSDATETIMEOFFSET()))) AS 'Local Queued Time',
CASE WHEN State=0 THEN 'Queued' WHEN State=1 THEN 'INVALID' WHEN State=2 THEN 'Pending/Waiting' WHEN State=3 THEN 'Running' ELSE 'Unknown' END as 'State'
FROM OrionTaskQueueMT
where taskdescription like '%db clean%'

-------------------------------------------

Regards

Alejandro

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

[Frank83]

Hi Alejandro，

where do I run this query? Because the EPO has not installed by me.

Thanks.

[aguevara]

the query will identify if there the internal clean up task are working as expected on your ePO server, we have internal task which are in ccharge of starting and stopping such task and the query will identify if those internal task exist and if they are working as expected

[Frank83]

Hi Alejandro，

Do you have any other checking solution(not use the command, because I do not know how to run these command)?

Thanks.

[aguevara]

for now no, but here is an article explaining how to run such queries:

https://kc.mcafee.com/corporate/index?page=content&id=KB67591

[Frank83]

I do not know why I cannot open this link according to the manual.

Regardless of the method used to run the script, you need to know how to connect to the SQL Server hosting the ePO database. This section gives you guidance on how you can pull this information from ePO assuming ePO can successfully connect to the SQL Server.

Use the URL syntax below to access the Database Configuration page on your ePO server:

• https://:/core/config-auth
• https://:/core/config-auth

NOTES:

• The Default SecureHttpPort is 8443.
• Do not include the chevrons (< >) when typing the URL.

1. Start Internet Explorer.
2. Type the appropriate URL and log on.
   
   Example URL: https://ePOServer:8443/core/config-auth

[aguevara]

im not sure what's on that message but you need to access that URL directly on the ePO server and not remotely but this is just the page where you can test the connection to your DB, it wont help on this issue 

[Frank83]

Hi aguevara,

Yes, I've remoted to the EPO Server, on that server I use web and try to follow the steps which you send to me the link. but it show me can not find the resouces

so on EPO if one task is hanging up, it will affect the other task? 

[aguevara]

Understood, you could see the same details from your Database on the configuration file called db.properties located at C:\Program Files (x86)\McAfee\ePolicy Orchestrator\Server\conf\orion

If you know your details already from your DB then you can log into the DB using any of the other methods.

this issue can certainly impact other task