Expand my Community achievements bar.

SOLVED

Unable to set up multiple approval

Avatar

Level 7

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)
1 Accepted Solution

Avatar

Correct answer by
Community Advisor

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

 

View solution in original post

4 Replies

Avatar

Employee Advisor

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?

 

Avatar

Level 7

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

Avatar

Correct answer by
Community Advisor

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

 

Avatar

Administrator

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