Unable to set up multiple approval | Community
Skip to main content
S
Sanjana12
Level 6
January 27, 2023
Solved

Unable to set up multiple approval

  • January 27, 2023
  • 2 replies
  • 987 views

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)
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by ParthaSarathy

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

 

2 replies

akshaaga
Adobe Employee
akshaagaAdobe Employee
Adobe Employee
January 28, 2023

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?

 

    S
    Sanjana12Author
    Level 6
    February 9, 2023

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

    ParthaSarathy
    Community Advisor
    ParthaSarathyCommunity AdvisorAccepted solution
    Community Advisor
    February 9, 2023

    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~  Click here to join ADOBE CAMPAIGN USER GROUP for Quarterly In-person | Hybrid | Virtual Meetups
      Sukrity_Wadhwa
      Community Manager
      Sukrity_WadhwaCommunity Manager
      Community Manager
      February 9, 2023

      Hi @sanjana12,

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

      Thanks!

      Sukrity Wadhwa
      Terms & ConditionsAccessibility statement

      Loading footer...