ePolicy Orchestrator Db table orionscheduletasklog
I checked in my epo db that table with large space used:
OrionSchedulerTaskLogDetail 60427819 6 47951752 KB
OrionSchedulerTaskLog 13265306 11 3134000 KB
OrionAuditLog 4249677 14 908592 KB
SCOR_BINARY_REPUTATION 1234932 28 828232 KB
I tried to delete the row with task purge but the task still run for many time and crash.
I tried with query but i found this error:
he DELETE statement conflicted with the SAME TABLE REFERENCE constraint "FK_OrionSchedulerTaskLog_OrionSchedulerTaskLog". The conflict occurred in database "ePO_GTTSRV102", table "dbo.OrionSchedulerTaskLog", column 'ParentId'.
The statement has been terminated.
Could you send me the query to clear this tables ?
OrionSchedulerTaskLog and OrionSchedulerTaskLogDetail
Re: ePolicy Orchestrator Db table orionscheduletasklog
Please log a McAfee support case so this can be assessed in more detail. As you've spotted there are constraints that will prevent direct deletion. This is because there are dependencies on other tables that would be affected adversely by such action, so it must be done with care.
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?
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.
Community Help Hub
New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.