Some MySQL queries are failing with the timeout error in the OnCommand WFA server

Applies to

OnCommand Workflow Automation (WFA) 4.2

Issue

The server.log located in <installation drive>\Program Files\Netapp\WFA\jboss\standalone\deployments\log\ may contain:

2020-03-19 06:35:21,261 ERROR [org.jboss.as.ejb3.invocation] (default task-150) <>: EJB Invocation failed on component TesterFacadeImpl for method public abstract com.netapp.wfa.ui.domain.TestQueryResultsWithColumnsInfo com.netapp.wfa.ui.TesterFacade.calculateUserInputValues(java.lang.String,java.lang.String,boolean,boolean,boolean): javax.ejb.EJBException: WfaException{Message: Temporary timeout failure, please retry, Cause: null}