Clicking on the approval link in the email shows an error

Last update: Tue Apr 07 2026 00:00:00 GMT+0000 (Coordinated Universal Time)

Fix the error where clicking on the approval link in the email shows an error in Adobe Campaign Classic.

Description description

Environment

Campaign Classic
Campaign Classic v7

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

Ensure that the Campaign Managers operator group has access to the Campaign workflows folder under Administration → Production → Objects.

In the Adobe Campaign client console, navigate to Administration → Production → Objects.
Right-click the Campaign Workflows folder and select Properties.
On the Security tab, verify that the Campaign Managers operator group is listed with the appropriate access rights.
If the group is missing, click Add, select the Campaign Managers group, assign the required rights, and save the changes.

Note: Users who need to interact with approval links must be members of the Campaign Managers operator group. Granting access to individual operators without Campaign Manager rights is not recommended, as it may not resolve the underlying permissions issue.

recommendation-more-help

3d58f420-19b5-47a0-a122-5c9dab55ec7f