Question surrounding automation services and windows task scheduler

Hello All,

Has anyone experienced any issues while running an automation services job via a windows task? When I run XML directly from the Spotfire Automation Services Job Builder, the job executes successfully. However, when scheduling this via the Windows task scheduler, I receive an error code of "(0x2)" which from what I've read is thrown due to an invalid argument or file location. 

In further testing I've found when I remove the steps to replace a data table using an information link, the windows task is able to successfully execute my job. When I run the job, leaving in the steps to perform the reload, I see the below error message in the Spotfire logs. The Spotfire application and automation services sits on the same machine where SQL server sits on its own machine. Could this be some sort of permission issue while trying to replace the information link? 

 

ERROR 2015-12-17T14:33:38,084-0500 [SpotfireAdmin, #5218] api.common.InformationModelServiceCommon: Failed to execute query: The query returned no result set
com.spotfire.ws.api.common.InformationModelWebServiceException: Failed to execute query: The query returned no result set
    at com.spotfire.ws.api.common.InformationModelServiceCommon.wrapException(InformationModelServiceCommon.java:135)
    at com.spotfire.ws.api.common.InformationModelServiceCommon.wrapException(InformationModelServiceCommon.java:69)
    at com.spotfire.ws.api.query.QueryManagerService.getDataBlockFromDAT(QueryManagerService.java:876)
    at com.spotfire.ws.api.query.QueryManagerService.getDataBlock(QueryManagerService.java:269)
    at sun.reflect.GeneratedMethodAccessor201.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:483)
    at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:188)
    at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:104)
    at org.apache.cxf.jaxws.AbstractJAXWSMethodInvoker.invoke(AbstractJAXWSMethodInvoker.java:237)
    at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:69)
    at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:75)
    at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)
    at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:107)
    at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:272)
    at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)
    at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:241)
    at org.apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:248)
    at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:222)
    at org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:153)
    at org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:171)
    at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:286)
    at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:206)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
    at org.apache.cxf.transport.servlet.AbstractHTTPServlet.service(AbstractHTTPServlet.java:262)
    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.spotfire.server.security.SecurityFilter.doFilter(SecurityFilter.java:251)
    at com.spotfire.server.security.SecurityFilter.doFilter(SecurityFilter.java:123)
    at com.spotfire.server.security.AbstractFilter.doFilter(AbstractFilter.java:121)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at com.spotfire.server.security.CustomAuthFilterWrapper.doFilter(CustomAuthFilterWrapper.java:71)
    at com.spotfire.server.security.AbstractFilter.doFilter(AbstractFilter.java:121)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at com.spotfire.server.security.HstsFilter.doFilter(HstsFilter.java:137)
    at com.spotfire.server.security.AbstractFilter.doFilter(AbstractFilter.java:121)
    at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237)
    at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at com.spotfire.server.security.CacheControlFilter.doFilter(CacheControlFilter.java:86)
    at com.spotfire.server.security.AbstractFilter.doFilter(AbstractFilter.java:121)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at com.spotfire.server.security.HttpMethodsFilter.doFilter(HttpMethodsFilter.java:203)
    at com.spotfire.server.security.HttpMethodsFilter.doFilter(HttpMethodsFilter.java:172)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at com.spotfire.server.security.AccessLogFilter.doFilter(AccessLogFilter.java:84)
    at com.spotfire.server.security.AbstractFilter.doFilter(AbstractFilter.java:121)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    at com.spotfire.server.security.RequestContextFilter.doFilter(RequestContextFilter.java:49)
    at com.spotfire.server.security.AbstractFilter.doFilter(AbstractFilter.java:121)
    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:220)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:503)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:421)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1070)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:611)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
    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.spotfire.ws.im.IMException: Failed to execute query: The query returned no result set
    at com.spotfire.ws.im.ds.sql.SQLDataSource.doStart(SQLDataSource.java:266)
    at com.spotfire.ws.dat.AbstractOperator.start(AbstractOperator.java:128)
    at com.spotfire.ws.dat.Pipe.doStart(Pipe.java:112)
    at com.spotfire.ws.dat.Pipe.doStart(Pipe.java:103)
    at com.spotfire.ws.dat.AbstractOperator.start(AbstractOperator.java:128)
    at com.spotfire.ws.im.QueryPipe.start(QueryPipe.java:191)
    at com.spotfire.ws.dat.Formatter.open(Formatter.java:370)
    at com.spotfire.ws.dat.Job$OpenTask.execute(Job.java:722)
    at com.spotfire.ws.dat.Job$Task.run(Job.java:661)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    ... 1 more
Caused by: java.sql.SQLException: The query returned no result set
    at com.spotfire.ws.im.ds.sql.SQLQuerySession.execute(SQLQuerySession.java:557)
    at com.spotfire.ws.im.ds.sql.SQLQuerySession.open(SQLQuerySession.java:108)
    at com.spotfire.ws.im.ds.sql.SQLDataSource.executeQuery(SQLDataSource.java:384)
    at com.spotfire.ws.im.ds.sql.SQLDataSource.doStart(SQLDataSource.java:264)
    ... 11 more

 

 

(1) Answer

Login