Form Version not found %_ALIAS_GLOBAL_%:db9ed8e0-bf0f-454c-

Post any question regarding setting up, running or configuring Verj.io Workflow

Moderators: Jon, Steve, Ian, Dave

xren
Ebase User
Posts: 272
Joined: Fri Dec 14, 2012 2:55 pm
Location: Ottawa

Form Version not found %_ALIAS_GLOBAL_%:db9ed8e0-bf0f-454c-

#1

Postby xren » Tue Nov 15, 2016 6:00 pm

Hi,

my server always report the following error and it seems it cannot enact node because of this:

Failed while enacting node: unknown: Form Version not found %_ALIAS_GLOBAL_%:db9ed8e0-bf0f-454c-bd4f-b2bf1df5459a

I figured if I cancel all jobs, this will stop, then I can test my new process.

I cancelled most of the jobs, but there are still a couple of them cannot be cancelled due to node status

Can anyone help to solve this problem?

Thanks
0 x

Jon
Moderator
Moderator
Posts: 1342
Joined: Wed Sep 12, 2007 12:49 pm

#2

Postby Jon » Wed Nov 16, 2016 1:26 pm

I think this might be because you have an old job that refers to something in the workspace that no longer exists. Probably the best solution is to remove all the current jobs - as you suggest. If you have problems with this you can always empty the corresponding tables i.e. delete all records from the following tables:

workflow_job
workflow_history
workflow_attribute_values
workflow_table_attr_values
workflow_enactment_future_cfg
workflow_nodeenactment
workflow_workstream

It's probably best to stop the server, then restart it after you have done this.

Do you have any more information on the failure - are there any other error messages?
0 x

ericb
Ebase User
Posts: 82
Joined: Fri Jan 15, 2016 2:34 pm

Re: Form Version not found %_ALIAS_GLOBAL_%:db9ed8e0-bf0f-454c-

#3

Postby ericb » Thu Feb 22, 2018 7:59 pm

I've encountered this issue with a job as well, in our production environment. The error occurs when a user tries to open the task associated to the job, and also when I try to re-assign the task to someone else (using system.workflow.api.forceAssign()).

The exact error message when I try to reassign the task:

Code: Select all

com.ebasetech.ufs.runtime.events.rhinojavascript.RhinoScriptException: Wrapped com.ebasetech.xi.exceptions.FormNotFoundException: Form Version not found %_ALIAS_GLOBAL_%:db6f3a53-7118-4ead-be68-199a3de50171
In checking the workflow database, and looking at the WORKFLOW_JOB table, I find that for the vast majority (848 out of 851, to be exact) of forms, the runtime_ID column looks something like

Code: Select all

db%_ALIAS_GLOBAL_% - SSA_GeneralForm - null - a1e7bcef-c336-4478-949c-c6e513b86f15
The 3 others, including the one giving the error above, look like this (it's exactly the same code as in the error above, but without the ALIAS_GLOBAL part at the beginning):

Code: Select all

db6f3a53-7118-4ead-be68-199a3de50171
The previous 2 forms that have this format of runtime_id have completed without issue though, so I'm not sure why this one is giving us trouble all of a sudden.

I'd really like to avoid having to delete this job and have the users start over. If there's anything that can be changed in the workflow database tables to get the job working again, I would much prefer that.
0 x

Jon
Moderator
Moderator
Posts: 1342
Joined: Wed Sep 12, 2007 12:49 pm

Re: Form Version not found %_ALIAS_GLOBAL_%:db9ed8e0-bf0f-454c-

#4

Postby Jon » Fri Feb 23, 2018 1:07 pm

You are correct in your assumption that the runtime id of the workflow_jobs table should begin with:

Code: Select all

db%_ALIAS_GLOBAL_% - process name - null -
And in the runtime_versions table you should see the same thing but missing the "db" at the front.

I tried running some tests changing the runtime id in workflow_jobs at different times and it didn't make any difference - everything carried on working. So I'm not sure whether just changing this will fix your problem.

Before you change anything could you check what you have in the current_versions table for this process. Also do you have a stack trace at the point of failure. Final question: which Ebase version are you running?
0 x

ericb
Ebase User
Posts: 82
Joined: Fri Jan 15, 2016 2:34 pm

Re: Form Version not found %_ALIAS_GLOBAL_%:db9ed8e0-bf0f-454c-

#5

Postby ericb » Fri Feb 23, 2018 2:27 pm

We are running Ebase 5.2.0.

In the current_versions table, I have the following for this process:

Code: Select all

%_ALIAS_GLOBAL_% - SSA_GeneralForm - null - 33e1b1e5-55c8-4be5-8c52-803e0344dbb8
I can't find it at all in the runtime_versions table however. If it's missing from this table, could that explain the issue?

Here's the trace for one occurrence of the error:

Code: Select all

Thu Feb 22 14:27:31: ERROR Wrapped com.ebasetech.xi.exceptions.FormNotFoundException: Form Version not found %_ALIAS_GLOBAL_%:db6f3a53-7118-4ead-be68-199a3de50171 (WF_OPEN_TASK_JS#12)
com.ebasetech.ufs.runtime.events.rhinojavascript.RhinoScriptException: Wrapped com.ebasetech.xi.exceptions.FormNotFoundException: Form Version not found %_ALIAS_GLOBAL_%:db6f3a53-7118-4ead-be68-199a3de50171 (WF_OPEN_TASK_JS#12)
	at com.ebasetech.ufs.runtime.events.rhinojavascript.JavascriptExecutionHandler.handleExecutionErrors(JavascriptExecutionHandler.java:355)
	at com.ebasetech.ufs.runtime.events.rhinojavascript.JavascriptExecutionHandler.execute(JavascriptExecutionHandler.java:280)
	at com.ebasetech.ufs.runtime.events.JVMScriptNode.execute_(JVMScriptNode.java:133)
	at com.ebasetech.ufs.runtime.events.JVMScriptNode.execute(JVMScriptNode.java:99)
	at com.ebasetech.ufs.runtime.events.RunnableContext.execute(RunnableContext.java:69)
	at com.ebasetech.ufs.runtime.events.SuspendableExecutable.execute(SuspendableExecutable.java:47)
	at com.ebasetech.ufs.runtime.events.SuspendableContainerExecutable.execute(SuspendableContainerExecutable.java:26)
	at com.ebasetech.ufs.runtime.events.BaseEventNode.execute(BaseEventNode.java:32)
	at com.ebasetech.ufs.runtime.events.RunnableContext.execute(RunnableContext.java:69)
	at com.ebasetech.ufs.runtime.events.SuspendableExecutable.execute(SuspendableExecutable.java:47)
	at com.ebasetech.ufs.runtime.events.SuspendableContainerExecutable.execute(SuspendableContainerExecutable.java:26)
	at com.ebasetech.ufs.runtime.events.RunnableContext.execute(RunnableContext.java:69)
	at com.ebasetech.ufs.runtime.events.SuspendableExecutable.execute(SuspendableExecutable.java:47)
	at com.ebasetech.ufs.runtime.events.SuspendableContainerExecutable.execute(SuspendableContainerExecutable.java:26)
	at com.ebasetech.ufs.runtime.events.RunnableContext.execute(RunnableContext.java:69)
	at com.ebasetech.ufs.runtime.Request.execute(Request.java:448)
	at com.ebasetech.ufs.runtime.Request.execute(Request.java:417)
	at com.ebasetech.ufs.runtime.Request._execute(Request.java:352)
	at com.ebasetech.ufs.runtime.Request.execute(Request.java:317)
	at formservlets.FormProcessingUtil.executeRequest(FormProcessingUtil.java:503)
	at formservlets.EbaseAjaxServlet.process(EbaseAjaxServlet.java:73)
	at formservlets.EbaseAjaxServlet.doPost(EbaseAjaxServlet.java:40)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at formservlets.EbaseFilter.processRequest(EbaseFilter.java:253)
	at formservlets.EbaseFilter.performFilter(EbaseFilter.java:180)
	at formservlets.EbaseFilter.doFilter(EbaseFilter.java:100)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:198)
	at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:176)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2503)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2492)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
Caused by: com.ebasetech.xi.exceptions.FormNotFoundException: Form Version not found %_ALIAS_GLOBAL_%:db6f3a53-7118-4ead-be68-199a3de50171
	at com.ebasetech.ufs.runtime.rtLoaders.DBRuntimeLoader.loadRootComponent(DBRuntimeLoader.java:104)
	at com.ebasetech.ufs.runtime.AbstractRuntimeLoader.makeRuntimeHeadless(AbstractRuntimeLoader.java:57)
	at com.ebasetech.ufs.runtime.rtLoaders.DBRuntimeLoader.getRuntimeHeadless(DBRuntimeLoader.java:42)
	at com.ebasetech.ufs.kernel.workspace.ServerRuntimeLoader.makeRuntime(ServerRuntimeLoader.java:187)
	at com.ebasetech.ufs.runtime.rtLoaders.ServerCachingRuntimeLoader.makeRuntimeHeadless(ServerCachingRuntimeLoader.java:269)
	at com.ebasetech.ufs.runtime.rtLoaders.CachingRuntimeLoader.getRuntime(CachingRuntimeLoader.java:101)
	at com.ebasetech.ufs.kernel.workspace.ServerRuntimeLoader.getRuntime(ServerRuntimeLoader.java:151)
	at com.ebasetech.ufs.runtime.FormEngine.getRuntimeHeadless(FormEngine.java:447)
	at com.ebasetech.ufs.runtime.FormEngine.getRuntimeHeadless(FormEngine.java:422)
	at com.ebasetech.ufs.runtime.HeadlessUserState.hookupRuntime(HeadlessUserState.java:512)
	at com.ebasetech.ufs.runtime.FormEngineSession.setCurrentUserState(FormEngineSession.java:114)
	at com.ebasetech.ufs.runtime.FormEngine.startInNewSession(FormEngine.java:106)
	at com.ebasetech.ufs.workflow.server.enactment.Job.openExistingJob(Job.java:221)
	at com.ebasetech.ufs.workflow.server.dbpersist.WorkStreamDbPersist$PersistImpl.populate(WorkStreamDbPersist.java:198)
	at com.ebasetech.ufs.utility.PersistenceHelper.load(PersistenceHelper.java:122)
	at com.ebasetech.ufs.workflow.server.dbpersist.WorkStreamDbPersist.load(WorkStreamDbPersist.java:58)
	at com.ebasetech.ufs.workflow.server.enactment.WorkStream.<init>(WorkStream.java:60)
	at com.ebasetech.ufs.workflow.server.dbpersist.enactment.NodeEnactmentDbPersist.populate(NodeEnactmentDbPersist.java:330)
	at com.ebasetech.ufs.workflow.server.dbpersist.enactment.NodeEnactmentDbPersist.GetNodeEnactmentInstance(NodeEnactmentDbPersist.java:444)
	at com.ebasetech.ufs.workflow.server.dbpersist.enactment.NodeEnactmentDbPersist.GetNodeEnactmentInstance(NodeEnactmentDbPersist.java:400)
	at com.ebasetech.ufs.workflow.server.external.WorkflowManager$InteractiveTaskEnactmentAccessorImpl.ForName(WorkflowManager.java:463)
	at com.ebasetech.ufs.workflow.server.external.WorkflowManager$15.go(WorkflowManager.java:1527)
	at com.ebasetech.ufs.workflow.server.external.WorkflowManager.protect(WorkflowManager.java:928)
	at com.ebasetech.ufs.workflow.server.external.WorkflowManager.openTask(WorkflowManager.java:1519)
	at com.ebasetech.ufs.runtime.external.api.impl.WorkflowImpl.openTaskAndGotoForm(WorkflowImpl.java:58)
	at com.ebasetech.ufs.runtime.external.api.impl.WorkflowImpl.openTaskAndGotoForm(WorkflowImpl.java:44)
	at sun.reflect.GeneratedMethodAccessor416.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126)
	at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:225)
	at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1479)
	at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:815)
	at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:109)
	at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
	at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3280)
	at org.mozilla.javascript.Context.callFunctionWithContinuations(Context.java:1284)
	at org.mozilla.javascript.Context.executeScriptWithContinuations(Context.java:1251)
	at com.ebasetech.ufs.runtime.events.rhinojavascript.JavascriptExecutionHandler.execute(JavascriptExecutionHandler.java:270)
	... 52 more
Thu Feb 22 14:27:31: ERROR com.ebasetech.xi.exceptions.FormRuntimeException: com.ebasetech.ufs.runtime.events.rhinojavascript.RhinoScriptException: Wrapped com.ebasetech.xi.exceptions.FormNotFoundException: Form Version not found %_ALIAS_GLOBAL_%:db6f3a53-7118-4ead-be68-199a3de50171 (WF_OPEN_TASK_JS#12)
Thu Feb 22 14:27:31:  Unexpected error occurred - see server log
Thu Feb 22 14:27:31: ERROR Unexpected error occurred
com.ebasetech.xi.exceptions.FormRuntimeException: com.ebasetech.ufs.runtime.events.rhinojavascript.RhinoScriptException: Wrapped com.ebasetech.xi.exceptions.FormNotFoundException: Form Version not found %_ALIAS_GLOBAL_%:db6f3a53-7118-4ead-be68-199a3de50171 (WF_OPEN_TASK_JS#12)
	at com.ebasetech.ufs.runtime.events.JVMScriptNode.handleExecutionErrors(JVMScriptNode.java:213)
	at com.ebasetech.ufs.runtime.events.JVMScriptNode.execute(JVMScriptNode.java:114)
	at com.ebasetech.ufs.runtime.events.RunnableContext.execute(RunnableContext.java:69)
	at com.ebasetech.ufs.runtime.events.SuspendableExecutable.execute(SuspendableExecutable.java:47)
	at com.ebasetech.ufs.runtime.events.SuspendableContainerExecutable.execute(SuspendableContainerExecutable.java:26)
	at com.ebasetech.ufs.runtime.events.BaseEventNode.execute(BaseEventNode.java:32)
	at com.ebasetech.ufs.runtime.events.RunnableContext.execute(RunnableContext.java:69)
	at com.ebasetech.ufs.runtime.events.SuspendableExecutable.execute(SuspendableExecutable.java:47)
	at com.ebasetech.ufs.runtime.events.SuspendableContainerExecutable.execute(SuspendableContainerExecutable.java:26)
	at com.ebasetech.ufs.runtime.events.RunnableContext.execute(RunnableContext.java:69)
	at com.ebasetech.ufs.runtime.events.SuspendableExecutable.execute(SuspendableExecutable.java:47)
	at com.ebasetech.ufs.runtime.events.SuspendableContainerExecutable.execute(SuspendableContainerExecutable.java:26)
	at com.ebasetech.ufs.runtime.events.RunnableContext.execute(RunnableContext.java:69)
	at com.ebasetech.ufs.runtime.Request.execute(Request.java:448)
	at com.ebasetech.ufs.runtime.Request.execute(Request.java:417)
	at com.ebasetech.ufs.runtime.Request._execute(Request.java:352)
	at com.ebasetech.ufs.runtime.Request.execute(Request.java:317)
	at formservlets.FormProcessingUtil.executeRequest(FormProcessingUtil.java:503)
	at formservlets.EbaseAjaxServlet.process(EbaseAjaxServlet.java:73)
	at formservlets.EbaseAjaxServlet.doPost(EbaseAjaxServlet.java:40)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at formservlets.EbaseFilter.processRequest(EbaseFilter.java:253)
	at formservlets.EbaseFilter.performFilter(EbaseFilter.java:180)
	at formservlets.EbaseFilter.doFilter(EbaseFilter.java:100)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:198)
	at net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:176)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:142)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:518)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1091)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:673)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.doRun(AprEndpoint.java:2503)
	at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:2492)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
Caused by: com.ebasetech.ufs.runtime.events.rhinojavascript.RhinoScriptException: Wrapped com.ebasetech.xi.exceptions.FormNotFoundException: Form Version not found %_ALIAS_GLOBAL_%:db6f3a53-7118-4ead-be68-199a3de50171 (WF_OPEN_TASK_JS#12)
	at com.ebasetech.ufs.runtime.events.rhinojavascript.JavascriptExecutionHandler.handleExecutionErrors(JavascriptExecutionHandler.java:355)
	at com.ebasetech.ufs.runtime.events.rhinojavascript.JavascriptExecutionHandler.execute(JavascriptExecutionHandler.java:280)
	at com.ebasetech.ufs.runtime.events.JVMScriptNode.execute_(JVMScriptNode.java:133)
	at com.ebasetech.ufs.runtime.events.JVMScriptNode.execute(JVMScriptNode.java:99)
	... 50 more
Caused by: com.ebasetech.xi.exceptions.FormNotFoundException: Form Version not found %_ALIAS_GLOBAL_%:db6f3a53-7118-4ead-be68-199a3de50171
	at com.ebasetech.ufs.runtime.rtLoaders.DBRuntimeLoader.loadRootComponent(DBRuntimeLoader.java:104)
	at com.ebasetech.ufs.runtime.AbstractRuntimeLoader.makeRuntimeHeadless(AbstractRuntimeLoader.java:57)
	at com.ebasetech.ufs.runtime.rtLoaders.DBRuntimeLoader.getRuntimeHeadless(DBRuntimeLoader.java:42)
	at com.ebasetech.ufs.kernel.workspace.ServerRuntimeLoader.makeRuntime(ServerRuntimeLoader.java:187)
	at com.ebasetech.ufs.runtime.rtLoaders.ServerCachingRuntimeLoader.makeRuntimeHeadless(ServerCachingRuntimeLoader.java:269)
	at com.ebasetech.ufs.runtime.rtLoaders.CachingRuntimeLoader.getRuntime(CachingRuntimeLoader.java:101)
	at com.ebasetech.ufs.kernel.workspace.ServerRuntimeLoader.getRuntime(ServerRuntimeLoader.java:151)
	at com.ebasetech.ufs.runtime.FormEngine.getRuntimeHeadless(FormEngine.java:447)
	at com.ebasetech.ufs.runtime.FormEngine.getRuntimeHeadless(FormEngine.java:422)
	at com.ebasetech.ufs.runtime.HeadlessUserState.hookupRuntime(HeadlessUserState.java:512)
	at com.ebasetech.ufs.runtime.FormEngineSession.setCurrentUserState(FormEngineSession.java:114)
	at com.ebasetech.ufs.runtime.FormEngine.startInNewSession(FormEngine.java:106)
	at com.ebasetech.ufs.workflow.server.enactment.Job.openExistingJob(Job.java:221)
	at com.ebasetech.ufs.workflow.server.dbpersist.WorkStreamDbPersist$PersistImpl.populate(WorkStreamDbPersist.java:198)
	at com.ebasetech.ufs.utility.PersistenceHelper.load(PersistenceHelper.java:122)
	at com.ebasetech.ufs.workflow.server.dbpersist.WorkStreamDbPersist.load(WorkStreamDbPersist.java:58)
	at com.ebasetech.ufs.workflow.server.enactment.WorkStream.<init>(WorkStream.java:60)
	at com.ebasetech.ufs.workflow.server.dbpersist.enactment.NodeEnactmentDbPersist.populate(NodeEnactmentDbPersist.java:330)
	at com.ebasetech.ufs.workflow.server.dbpersist.enactment.NodeEnactmentDbPersist.GetNodeEnactmentInstance(NodeEnactmentDbPersist.java:444)
	at com.ebasetech.ufs.workflow.server.dbpersist.enactment.NodeEnactmentDbPersist.GetNodeEnactmentInstance(NodeEnactmentDbPersist.java:400)
	at com.ebasetech.ufs.workflow.server.external.WorkflowManager$InteractiveTaskEnactmentAccessorImpl.ForName(WorkflowManager.java:463)
	at com.ebasetech.ufs.workflow.server.external.WorkflowManager$15.go(WorkflowManager.java:1527)
	at com.ebasetech.ufs.workflow.server.external.WorkflowManager.protect(WorkflowManager.java:928)
	at com.ebasetech.ufs.workflow.server.external.WorkflowManager.openTask(WorkflowManager.java:1519)
	at com.ebasetech.ufs.runtime.external.api.impl.WorkflowImpl.openTaskAndGotoForm(WorkflowImpl.java:58)
	at com.ebasetech.ufs.runtime.external.api.impl.WorkflowImpl.openTaskAndGotoForm(WorkflowImpl.java:44)
	at sun.reflect.GeneratedMethodAccessor416.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.mozilla.javascript.MemberBox.invoke(MemberBox.java:126)
	at org.mozilla.javascript.NativeJavaMethod.call(NativeJavaMethod.java:225)
	at org.mozilla.javascript.Interpreter.interpretLoop(Interpreter.java:1479)
	at org.mozilla.javascript.Interpreter.interpret(Interpreter.java:815)
	at org.mozilla.javascript.InterpretedFunction.call(InterpretedFunction.java:109)
	at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
	at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:3280)
	at org.mozilla.javascript.Context.callFunctionWithContinuations(Context.java:1284)
	at org.mozilla.javascript.Context.executeScriptWithContinuations(Context.java:1251)
	at com.ebasetech.ufs.runtime.events.rhinojavascript.JavascriptExecutionHandler.execute(JavascriptExecutionHandler.java:270)
	... 52 more
	
0 x

Jon
Moderator
Moderator
Posts: 1342
Joined: Wed Sep 12, 2007 12:49 pm

Re: Form Version not found %_ALIAS_GLOBAL_%:db9ed8e0-bf0f-454c-

#6

Postby Jon » Mon Feb 26, 2018 10:49 am

The runtime_id in workflow_jobs is wrong and this is the basic reason for your failure. There are two concerns here:

How did it get in that state in the first place? Can you think of any unusual circumstance that might have caused this?
Can the database be changed to get it working again?

Do you think you could let us have some more information from the database - the output from the following queries:

select * from current_versions
select id from runtime_versions
select process_id, finished, runtime_id from workflow_job

And if you run the workflow maintenance scheduled task:
select id from runtime_versions_archive
select process_id, runtime_id from workflow_job_archive

Last question: do you know whether the workflow process has been changed since the failing job started? To put this question another way: if the runtime is reconstructed with the current versions of the process, system tasks, resources etc, would it work?

If the output from the database queries is too large then please email to support@ebasetech.com.
0 x

ericb
Ebase User
Posts: 82
Joined: Fri Jan 15, 2016 2:34 pm

Re: Form Version not found %_ALIAS_GLOBAL_%:db9ed8e0-bf0f-454c-

#7

Postby ericb » Mon Feb 26, 2018 2:19 pm

Hi Jon,

The output from the DB queries is indeed quite large, so I'll be sending the results via email.

I don't know what could cause this. As you'll see from the query results, the vast, vast majority of forms have the correct runtime_id, and even the two others that had the wrong one were able to complete. If it's doable then I should be able to make changes as needed to the DB to get the form working again, as long as I know what changes are needed.

The workflow process has had some minor changes since the job was started, however they are pretty minor and I would think that it would be able to continue running if the runtime were reconstructed from the current status of the process.
0 x

Jon
Moderator
Moderator
Posts: 1342
Joined: Wed Sep 12, 2007 12:49 pm

Re: Form Version not found %_ALIAS_GLOBAL_%:db9ed8e0-bf0f-454c-

#8

Postby Jon » Mon Feb 26, 2018 4:10 pm

OK in that case you can change the runtime_id in workflow jobs to be 'db' + the runtime_id from current versions (see below). You have three records in workflow_jobs with the bad runtime id of db6f3a53-7118-4ead-be68-199a3de50171:

SSA_GeneralForm
SSA_primApprovals
SSA_approvalSerial

I'm assuming SSA_GeneralForm is the main process and the other two are sub-processes. Based on this you can change the runtime_id of all 3 of these jobs to the current runtime_id for SSA_GeneralForm from current_versions, namely:

db%_ALIAS_GLOBAL_% - SSA_GeneralForm - null - 05963329-274f-4340-b196-3dcab0786076

The job should then continue exiting with the current version. I guess it's obvious but you should proceed with extreme caution doing this - at the very least, back up the database before starting, if possible try it first on a test system, and again if possible, shutdown the server while you're doing this (this would mean that you could restore from your backup in the worst case).
0 x

ericb
Ebase User
Posts: 82
Joined: Fri Jan 15, 2016 2:34 pm

Re: Form Version not found %_ALIAS_GLOBAL_%:db9ed8e0-bf0f-454c-

#9

Postby ericb » Mon Feb 26, 2018 5:43 pm

I've applied the changes as you instructed, and at first glance the job appears to be functioning properly now. I was able to re-assign the task to myself and open it, whereas previously both of those actions would bring about the error. I'll follow up if any new issues arise with this job.

Thanks for the help
0 x

ericb
Ebase User
Posts: 82
Joined: Fri Jan 15, 2016 2:34 pm

Re: Form Version not found %_ALIAS_GLOBAL_%:db9ed8e0-bf0f-454c-

#10

Postby ericb » Wed May 20, 2020 1:34 pm

So, ever since the solution given by Jon to manually fix this issue when it occurs, it has continued happening every once in a while. Today it happened again, however it appears to have evolved :shock:

The form in question this time is a Transfer Form, and as you'll see in the screenshot below, the runtime_id in the current_versions table is also invalid:
Capture.PNG
Capture.PNG (33.54 KiB) Viewed 6837 times
I've tried prepending "%_ALIAS_GLOBAL_% - SSA_Transfer - null - " to what is current there in both this table and the workflow_jobs rows that are affected, but this hasn't resolved the issue:
Capture2.PNG
Capture2.PNG (26.86 KiB) Viewed 6837 times
Jon (or someone else from Ebase), could you advise please?

This application is currently running on Ebase v5.5.1
0 x

Jon
Moderator
Moderator
Posts: 1342
Joined: Wed Sep 12, 2007 12:49 pm

Re: Form Version not found %_ALIAS_GLOBAL_%:db9ed8e0-bf0f-454c-

#11

Postby Jon » Fri May 22, 2020 10:24 am

Hi Eric,

Have you restarted the server after changing the database?
Do you have a stack trace for one of these failures?

Jon
0 x

ericb
Ebase User
Posts: 82
Joined: Fri Jan 15, 2016 2:34 pm

Re: Form Version not found %_ALIAS_GLOBAL_%:db9ed8e0-bf0f-454c-

#12

Postby ericb » Fri May 22, 2020 1:20 pm

Hi Jon,

Restarting the server did not help. Here is the stack trace I was able to find in the stderr log file.

Code: Select all

com.ebasetech.xi.exceptions.FormNotFoundException: Form Version not found %_ALIAS_GLOBAL_%:db%_ALIAS_GLOBAL_% - SSA_Transfer - null - 723b17-2905-43c6-ba01-fc9235775993
	at com.ebasetech.ufs.runtime.rtLoaders.DBRuntimeLoader.loadRootComponent(DBRuntimeLoader.java:117)
	at com.ebasetech.ufs.runtime.AbstractRuntimeLoader.makeRuntimeHeadless(AbstractRuntimeLoader.java:57)
	at com.ebasetech.ufs.runtime.rtLoaders.DBRuntimeLoader.getRuntimeHeadless(DBRuntimeLoader.java:50)
	at com.ebasetech.ufs.kernel.workspace.ServerRuntimeLoader.makeRuntime(ServerRuntimeLoader.java:199)
	at com.ebasetech.ufs.runtime.rtLoaders.ServerCachingRuntimeLoader.makeRuntimeHeadless(ServerCachingRuntimeLoader.java:269)
	at com.ebasetech.ufs.runtime.rtLoaders.CachingRuntimeLoader.getRuntime(CachingRuntimeLoader.java:101)
	at com.ebasetech.ufs.kernel.workspace.ServerRuntimeLoader.getRuntime(ServerRuntimeLoader.java:163)
	at com.ebasetech.ufs.runtime.FormEngine.getRuntimeHeadless(FormEngine.java:447)
	at com.ebasetech.ufs.runtime.FormEngine.getRuntimeHeadless(FormEngine.java:422)
	at com.ebasetech.ufs.runtime.HeadlessUserState.hookupRuntime(HeadlessUserState.java:518)
	at com.ebasetech.ufs.runtime.FormEngineSession.setCurrentUserState(FormEngineSession.java:114)
	at com.ebasetech.ufs.runtime.FormEngine.startInNewSession(FormEngine.java:107)
	at com.ebasetech.ufs.workflow.server.enactment.Job.openExistingJob(Job.java:221)
	at com.ebasetech.ufs.workflow.server.dbpersist.WorkStreamDbPersist$PersistImpl.populate(WorkStreamDbPersist.java:198)
	at com.ebasetech.ufs.utility.PersistenceHelper.load(PersistenceHelper.java:122)
	at com.ebasetech.ufs.workflow.server.dbpersist.WorkStreamDbPersist.load(WorkStreamDbPersist.java:58)
	at com.ebasetech.ufs.workflow.server.enactment.WorkStream.<init>(WorkStream.java:60)
	at com.ebasetech.ufs.workflow.server.dbpersist.enactment.NodeEnactmentDbPersist.populate(NodeEnactmentDbPersist.java:331)
	at com.ebasetech.ufs.workflow.server.dbpersist.enactment.NodeEnactmentDbPersist.GetNodeEnactmentInstance(NodeEnactmentDbPersist.java:444)
	at com.ebasetech.ufs.workflow.server.dbpersist.enactment.NodeEnactmentDbPersist.GetNodeEnactmentInstance(NodeEnactmentDbPersist.java:400)
	at com.ebasetech.ufs.workflow.server.WorkItem.getNodeEnactment(WorkItem.java:128)
	at com.ebasetech.ufs.workflow.server.enactment.WorkQueue$WorkThread.run(WorkQueue.java:470)
	
0 x


Who is online

Users browsing this forum: No registered users and 2 guests