Se fai clic sul collegamento di approvazione nell’e-mail, viene visualizzato un errore
Descrizione description
Ambiente
- Campaign Classic
- Campaign Classic v7
Problemi/Sintomi
Quando fai clic sul collegamento di approvazione nell’e-mail, potresti visualizzare il seguente errore.
Si è verificato un errore tecnico:
Istruzione SQL WDB-200001 '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, .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.iHostname, W0.iPort, W0.iOperationId, W0.iiStart Stato, caso in cui W0.iStartState = 1 e W0.iForecasts = 0 e (W0.iState = 0 o W0.iState = 20) allora 1 altro caso in cui W0.iStartState = 1 e W0.iForecasts = 1 e (W0.iState = 0 o W0.iState = 20) poi 2 altro fine W0.iState, W0.iPriority, W0.iForecast, W0.sLogin, W0.iRoutingOperationId, W0.iAggregast ateId, 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)) OR W0.iFolderId=0) AND (((W0.iFolderId IN Impossibile eseguire xr.iFolderId FROM XtkRights xr WHERE xr.iOperatorId IN (XXXX, XXXX, XXXX, XXXX)) OR W0.iFolderId=0)) AND ((W0.iWorkflowId = :#(1)#))'.
Param(0)=50302570
WDB-200011 Il record di database richiesto non esiste.
Impossibile caricare un documento di tipo 'xtk:workflow' che soddisfa la condizione '([
/@id]
= XXXXXX)'.
Errore durante la chiamata al metodo SOAP 'GetValidationParameters' del servizio 'xtk:workflow'):'SOP-330011 Errore durante l'esecuzione del metodo 'GetValidationParameters' del servizio 'xtk:workflow'.'
Codice: 'SOAP-ENV:Server'
com.neolane.fwk.core.NlException: Errore durante la chiamata al metodo SOAP 'GetValidationParameters' del servizio 'xtk:workflow'):'Errore SOP-330011 durante l'esecuzione del metodo 'GetValidationParameters' del servizio 'xtk:workflow'.
Codice: 'SOAP-ENV:Server'
at com.neolane.fwk.soap.SoapMethodCall.execute(SoapMethodCall.java:840)
at com.neolane.fwk.xtk.JSPContext.executeSOAPCall(JSPContext.java:820)
in org.apache.jsp.validateTask_jsp._jspService(validateTask_jsp.java:176)
in org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
in javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
in org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439)
in org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
in org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
in 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)
in 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)
in org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1115)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
in 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)
in org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Risoluzione resolution
Gli operatori devono avere accesso alla cartella Flussi di lavoro di Campaign in Amministrazione - Produzione - Oggetti.