cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
savidudu
Level 10
Report Inappropriate Content
Message 1 of 2

Database Deadlock and Error Conflict

Hello All,

Could you please assist me why this is happening ?

2021-12-18T04:02:07,421 ERROR [scheduler-TaskQueueEngine-thread-10] service.ScheduledTaskManagerImpl - execution of task Protection Workspace Data Collection failed
com.mcafee.orion.core.cmd.CommandException: 1 subtask had an error:
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_PWS_ComplianceDrillDownMT_LeafNodeID". The conflict occurred in database "ePO_Database", table "dbo.EPOLeafNodeMT", column 'AutoID'

2021-12-18T04:01:57,921 ERROR [scheduler-TaskQueueEngine-thread-10] tasks.MasterDataCollectionServerTask - Task class com.mcafee.protectionworkspace.tasks.ProductCoverageTaskCommand threw execption
java.sql.SQLException: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_PWS_ComplianceDrillDownMT_LeafNodeID". The conflict occurred in database "ePO_Database", table "dbo.EPOLeafNodeMT", column 'AutoID'.

2021-12-18T10:00:49,075 ERROR [scheduler-TaskQueueEngine-thread-5] propertytranslator.FCFWClientRuleProcessor - Failed to cleanup rules for tenant: 1.
java.sql.SQLException: Transaction (Process ID 249) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.


Thanks

1 Reply
aguevara
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 2 of 2

Re: Database Deadlock and Error Conflict

If the deadlock issue can be reproduced by running the Firewall Property translator server task then please collect the data from the below article and open a Service request with support:

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

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?

You Deserve an Award
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.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community