Clicking on the approval link in the email shows an error

Description description

Environment

Issues/Symptoms

You may see the following error when clicking on the approval link in the email.

A technical error has occured:

WDB-200001 SQL statement ‘SELECT   W0.iWorkflowId, W0.sInternalName, W0.sLabel, W0.sDesc, W0.iCreatedById, W0.iModifiedById, W0.tsCreated, W0.tsLastModified, W0.iSupervisorId, W0.sTimezone, W0.iInProcess, W0.iHistory, W0.iOnError, W0.iErrorLimit, W0.iBuiltIn, W0.iIsModel, W0.sForm, W0.iFolderId, W0.iFolderProcessId, W0.tsLastStart, W0.tsNextProcessing, W0.sNextProcessingAfn, W0.sNextProcessingHost, W0.iStatus, W0.iProduction, W0.iFailed, W0.iUnlockedCount, W0.iState, W0.tsProcess, W0.iProcessId, W0.sHostname, W0.iPort, W0.iOperationId, W0.iStartState, case when W0.iStartState = 1 and W0.iForecasted = 0 and (W0.iState = 0 or W0.iState = 20) then 1 else case when W0.iStartState = 1 and W0.iForecasted = 1 and (W0.iState = 0 or W0.iState = 20) then 2 else W0.iState end end, W0.iPriority, W0.iForecasted, W0.sLogin, W0.iRoutingOperationId, W0.iAggregateId, W0.iOrder, W0.tsExpiration, W0.iRecurrentMdl, W0.iCurrentOrderId, W0.mData, W0.mVisualState FROM XtkWorkflow W0 WHERE ((W0.iFolderId IN (SELECT xr.iFolderId FROM XtkRights xr WHERE xr.iOperatorId IN (XXXX, XXXX, XXXX, XXXX)) OR W0.iFolderId=0)) AND (((W0.iFolderId IN (SELECT xr.iFolderId FROM XtkRights xr WHERE xr.iOperatorId IN (XXXX, XXXX, XXXX, XXXX)) OR W0.iFolderId=0)) AND ((W0.iWorkflowId = :#(1)#)))’ could not be executed.

Param(0)=50302570

WDB-200011 The requested database record does not exist.

Cannot load document of type ‘xtk:workflow’ satisfying condition ‘([ /@id] = XXXXXX)’.

Error while calling SOAP method ‘GetValidationParameters’ of service ‘xtk:workflow’):‘SOP-330011 Error while executing the method ‘GetValidationParameters’ of service ‘xtk:workflow’.’

Code: ‘SOAP-ENV:Server’

com.neolane.fwk.core.NlException: Error while calling SOAP method ‘GetValidationParameters’ of service ‘xtk:workflow’):'SOP-330011 Error while executing the method ‘GetValidationParameters’ of service ‘xtk:workflow’.

Code: ‘SOAP-ENV:Server’

at com.neolane.fwk.soap.SoapMethodCall.execute(SoapMethodCall.java:840)

at com.neolane.fwk.xtk.JSPContext.executeSOAPCall(JSPContext.java:820)

at org.apache.jsp.validateTask_jsp._jspService(validateTask_jsp.java:176)

at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439)

at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)

at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:731)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at com.neolane.jssp.HttpHeaderFilter.doFilter(HttpHeaderFilter.java:102)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)

at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)

at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:445)

at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)

at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)

at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1152)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:622)

at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

at java.lang.Thread.run(Thread.java:748)

Resolution resolution

The operators need to have access to the Campaign workflows folder under Administration - Production - Objects.