脚本调用定时任务出错

【myApps/OBPM版本号】：v4.4- sp XX
【浏览器类型】：Chrome/其他
【联系方式-QQ】：774777387
【联系电话】:    18079141110
【问题描述】：
由于后台任务因不明原因会不定期停止，需要手工开启，于是打算在前台做个手工开启的按钮，当出现任务停止时手工重启：

【代码示例】：
(function(){
var taskid="__m4SyGvPTgRSBrLZYlrG";//需要启动的任务id

var taskprocess = Packages.cn.myapps.core.task.ejb.TaskProcessBean();
var taskVO = taskprocess.doView(taskid);
var runningTime = taskVO.getRunningTime();
println("taskVO---->"+taskVO);
var rdate = format(runningTime,"yyyy-MM-dd");
var rtime =  format(runningTime,"HH:mm:ss");
taskprocess.doStart(rdate,rtime,taskVO);
})()

【报错信息】：

org.mozilla.javascript.EcmaError: TypeError: TaskProcessBean is not a function, it is org.mozilla.javascript.NativeJavaPackage. (__MTmN0aQZEBrS5woAUoi).重启人脸同步.actionScript#4)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3350)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3340)
at org.mozilla.javascript.ScriptRuntime.typeError(ScriptRuntime.java:3356)
at org.mozilla.javascript.ScriptRuntime.typeError2(ScriptRuntime.java:3375)
at org.mozilla.javascript.ScriptRuntime.notFunctionError(ScriptRuntime.java:3430)
at org.mozilla.javascript.ScriptRuntime.getPropFunctionAndThis(ScriptRuntime.java:2052)
at org.mozilla.javascript.optimizer.OptRuntime.callProp0(OptRuntime.java:117)
at org.mozilla.javascript.gen.c524381._c1(Activity(__MTmN0aQZEBrS5woAUoi).重启人脸同步.actionScript:4)
at org.mozilla.javascript.gen.c524381.call(Activity(__MTmN0aQZEBrS5woAUoi).重启人脸同步.actionScript)
at org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:57)
at org.mozilla.javascript.gen.c524381._c0(Activity(__MTmN0aQZEBrS5woAUoi).重启人脸同步.actionScript:1)
at org.mozilla.javascript.gen.c524381.call(Activity(__MTmN0aQZEBrS5woAUoi).重启人脸同步.actionScript)
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)
at org.mozilla.javascript.gen.c524381.call(Activity(__MTmN0aQZEBrS5woAUoi).重启人脸同步.actionScript)
at org.mozilla.javascript.gen.c524381.exec(Activity(__MTmN0aQZEBrS5woAUoi).重启人脸同步.actionScript)
at cn.myapps.runtime.macro.runner.JavaScriptRunner.run(JavaScriptRunner.java:169)
at cn.myapps.runtime.activity.service.ActivityRunTimeServiceImpl.execute(ActivityRunTimeServiceImpl.java:378)
at cn.myapps.runtime.activity.controller.ActivityController.execute(ActivityController.java:355)
at cn.myapps.runtime.activity.controller.ActivityController$$FastClassBySpringCGLIB$$beafbc81.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)

好的，我先验证一下

你第二行脚本写错了 要加new
var taskprocess =  new Packages.cn.myapps.core.task.ejb.TaskProcessBean();

cyb 发表于 2021-10-25 18:53
你第二行脚本写错了 要加new
var taskprocess =  new Packages.cn.myapps.core.task.ejb.TaskProcessBean( ...

还是报错：
【脚本代码】：
关闭任务脚本
(function(){
var taskid="__m4SyGvPTgRSBrLZYlrG";//需要关闭的任务id

var taskprocess = new Packages.cn.myapps.core.scheduler.ejb.TriggerProcessBean();

taskprocess.doRemove(taskid);
})()

重启任务脚本
(function(){
var taskid="__m4SyGvPTgRSBrLZYlrG";//需要启动的任务id

var taskprocess =  new Packages.cn.myapps.core.task.ejb.TaskProcessBean();
var taskVO = taskprocess.doView(taskid);
var runningTime = taskVO.getRunningTime();
println("taskVO---->"+taskVO);
var rdate = format(runningTime,"yyyy-MM-dd");
var rtime =  format(runningTime,"HH:mm:ss");
taskprocess.doStart(rdate,rtime,taskVO);
})()

【报错代码】
org.mozilla.javascript.EcmaError: TypeError: [JavaPackage cn.myapps.core.scheduler.ejb.TriggerProcessBean] is not a function, it is org.mozilla.javascript.NativeJavaPackage. (__MTmN0aQZEBrS5woAUoi).重启人脸同步.beforeActionScript#4)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3350)
at org.mozilla.javascript.ScriptRuntime.constructError(ScriptRuntime.java:3340)
at org.mozilla.javascript.ScriptRuntime.typeError(ScriptRuntime.java:3356)
at org.mozilla.javascript.ScriptRuntime.typeError2(ScriptRuntime.java:3375)
at org.mozilla.javascript.ScriptRuntime.notFunctionError(ScriptRuntime.java:3430)
at org.mozilla.javascript.ScriptRuntime.notFunctionError(ScriptRuntime.java:3418)
at org.mozilla.javascript.ScriptRuntime.newObject(ScriptRuntime.java:2129)
at org.mozilla.javascript.gen.c541762._c1(FormName:教务教学管理/手动开启人脸同步/手动重启人脸同步 Activity(__MTmN0aQZEBrS5woAUoi).重启人脸同步.beforeActionScript:4)
at org.mozilla.javascript.gen.c541762.call(FormName:教务教学管理/手动开启人脸同步/手动重启人脸同步 Activity(__MTmN0aQZEBrS5woAUoi).重启人脸同步.beforeActionScript)
at org.mozilla.javascript.optimizer.OptRuntime.call0(OptRuntime.java:57)
at org.mozilla.javascript.gen.c541762._c0(FormName:教务教学管理/手动开启人脸同步/手动重启人脸同步 Activity(__MTmN0aQZEBrS5woAUoi).重启人脸同步.beforeActionScript:1)
at org.mozilla.javascript.gen.c541762.call(FormName:教务教学管理/手动开启人脸同步/手动重启人脸同步 Activity(__MTmN0aQZEBrS5woAUoi).重启人脸同步.beforeActionScript)
at org.mozilla.javascript.ContextFactory.doTopCall(ContextFactory.java:393)
at org.mozilla.javascript.ScriptRuntime.doTopCall(ScriptRuntime.java:2834)
at org.mozilla.javascript.gen.c541762.call(FormName:教务教学管理/手动开启人脸同步/手动重启人脸同步 Activity(__MTmN0aQZEBrS5woAUoi).重启人脸同步.beforeActionScript)
at org.mozilla.javascript.gen.c541762.exec(FormName:教务教学管理/手动开启人脸同步/手动重启人脸同步 Activity(__MTmN0aQZEBrS5woAUoi).重启人脸同步.beforeActionScript)
at cn.myapps.runtime.macro.runner.JavaScriptRunner.run(JavaScriptRunner.java:169)
at cn.myapps.common.model.activity.Activity.runBeforeActionScript(Activity.java:1577)
at cn.myapps.runtime.activity.service.ActivityRunTimeServiceImpl.runbeforeactionscript(ActivityRunTimeServiceImpl.java:138)
at cn.myapps.runtime.activity.controller.ActivityController.runBeforeActionScript(ActivityController.java:166)
at cn.myapps.runtime.activity.controller.ActivityController$$FastClassBySpringCGLIB$$beafbc81.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:746)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.aop.aspectj.AspectJAfterAdvice.invoke(AspectJAfterAdvice.java:47)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:688)
at cn.myapps.runtime.activity.controller.ActivityController$$EnhancerBySpringCGLIB$$fb119a3.runBeforeActionScript()
at sun.reflect.GeneratedMethodAccessor1441.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:497)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:891)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:974)
at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:877)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:851)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at cn.myapps.runtime.common.filter.MultiLanguageFilter.doFilter(MultiLanguageFilter.java:57)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at cn.myapps.base.web.filter.SecurityFilter.doFilter(SecurityFilter.java:337)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at cn.myapps.base.web.filter.PersistenceFilter.doFilter(PersistenceFilter.java:34)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:130)
at org.springframework.boot.web.servlet.support.ErrorPageFilter.access$000(ErrorPageFilter.java:66)
at org.springframework.boot.web.servlet.support.ErrorPageFilter$1.doFilterInternal(ErrorPageFilter.java:105)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:528)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at oorg.mozilla.javascript.EcmaError: TypeError: [JavaPackage cn.myapps.core.task.ejb.TaskProcessBean] is not a function, it is org.mozilla.javascript.NativeJavaPackage. (__MTmN0aQZEBrS5woAUoi).重启人脸同步.actionScript#4)

您看一下数据库，按图去查看数据库的status这个值，看看他在运行和启动的时候的不同值，在你需要的状态把值附上去

cyb 发表于 2021-10-28 16:47
您看一下数据库，按图去查看数据库的status这个值，看看他在运行和启动的时候的不同值，在你需要的状态把值 ...

具体代码有么，已经查到了状态。。。不知道值附到哪里？

没有  
你自己写吧！
差不多就是用queryBySQL(sql)更新表的值  类似于这个语句UPDATE T_TRIGGER SET STATE='' WHERE ID=''