Skip to main content
Level 6
ene 27, 2023 7:11 p. m. UTC
Resuelto

Unable to set up multiple approval

Hello, I'm getting error while setting up multiple approval. When I'm logging in as the second user to respond to the approval, I'm getting this below error. Please help

 

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.mData, W0.mVisualState FROM XtkWorkflow W0 WHERE ((W0.iFolderId IN (SELECT xr.iFolderId FROM XtkRights xr WHERE xr.iOperatorId IN (2188843, 1589, 2191364)) OR W0.iFolderId=0)) AND (((W0.iFolderId IN (SELECT xr.iFolderId FROM XtkRights xr WHERE xr.iOperatorId IN (2188843, 1589, 2191364)) OR W0.iFolderId=0)) AND ((W0.iWorkflowId = :#(1)#)))' could not be executed.
  Param(0)=2188841
WDB-200011 The requested database record does not exist.
Cannot load document of type 'Workflows (xtk:workflow)' satisfying condition '([/@id] = 2188841)'.
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:827)
	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:472)
	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.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
	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:1137)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:319)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:750)
Este tema ha sido cerrado para respuestas.
ParthaSarathy
ParthaSarathyRespuesta
Community Advisor
feb 9, 2023 9:21 a. m. UTC

Hi @sanjana12 ,

If you had created multiple approvals (assigning person-1, person-2, person-3 as approvers), Have you tried approving as person-1 and it worked, and then when you try to approve from person-2, you got error?

 

I think this might be because, since person-1 had approved already, the process began, and thus person-2 approval is not required. So when person-2 tries to approve the same, this error might happened.

Then, for testing, when you made person-2 as administrator, and repeated the process, did you approved it as person-2 first and it worked? Might be now you will get same error, when you try to approve it again as person-1, as it is already approved by person-2

 

~  ParthaSarathy S

4 respuestas

akshaaga
Adobe Employee
Adobe Employee
ene 28, 2023 7:32 p. m. UTC

Hi @sanjana12 ,

Can see the following error here - 

WDB-200011 The requested database record does not exist.

Can you check if you have a record with [/@id] = 2188841) in your database?

 

Traducir
Level 6
feb 9, 2023 9:10 a. m. UTC

Sorry for the late response, I checked when I made the second user an administrator, it worked! Any idea why/

Traducir
ParthaSarathy
Community Advisor
ParthaSarathyCommunity AdvisorRespuesta
Community Advisor
feb 9, 2023 9:21 a. m. UTC

Hi @sanjana12 ,

If you had created multiple approvals (assigning person-1, person-2, person-3 as approvers), Have you tried approving as person-1 and it worked, and then when you try to approve from person-2, you got error?

 

I think this might be because, since person-1 had approved already, the process began, and thus person-2 approval is not required. So when person-2 tries to approve the same, this error might happened.

Then, for testing, when you made person-2 as administrator, and repeated the process, did you approved it as person-2 first and it worked? Might be now you will get same error, when you try to approve it again as person-1, as it is already approved by person-2

 

Traducir
~  ParthaSarathy S
Sukrity_Wadhwa
Level 4
feb 9, 2023 8:57 a. m. UTC

Hi @sanjana12,

Was the given suggestion helpful to resolve your query or do you still need more help here? Do let us know.

Thanks!

Traducir
Sukrity Wadhwa