1 Reply Latest reply on Feb 14, 2019 12:40 AM by sajad.bhat

    Extract Refresh Failed

    User Test

      Dear All,

       

      I having a extract refresh job running daily in my tableau server, and this job will failed some day for example 4 failed per week. Previously, I suspect the job is crash with other job, so I change the extraction job from 3am to 6am and I did to increase the session timeout to 6 hours as well, however, the job still failed for someday. And I go thru the backgrounder log, the log listed following details:

       

      2019-02-12 15:54:29.787 +0800 (MyTask,,,,749273,:refresh_extracts) scheduled-background-job-runner-1 : 
      ERROR com.tableausoftware.backgrounder.runner.BackgroundJobRunner - Error executing backgroundjob: :refresh_extracts
      java.util.concurrent.ExecutionException: com.tableausoftware.nativeapi.dll.TableauCancelException: Operation cancelled.
      [Microsoft][SQL Server Native Client 11.0]Operation canceled
      
      
      at java.util.concurrent.FutureTask.report(FutureTask.java:122)
      at java.util.concurrent.FutureTask.get(FutureTask.java:206)
      at com.tableausoftware.backgrounder.runner.BackgroundJobRunner.executeNextJob_aroundBody2(BackgroundJobRunner.java:271)
      at com.tableausoftware.backgrounder.runner.BackgroundJobRunner$AjcClosure3.run(BackgroundJobRunner.java:1)
      at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149)
      at com.tableausoftware.instrumentation.InstrumentedMethod.instrumentInvocation(InstrumentedMethod.java:66)
      at com.tableausoftware.instrumentation.InstrumentationAspect.aroundAnnotatedMethod(InstrumentationAspect.java:57)
      at com.tableausoftware.backgrounder.runner.BackgroundJobRunner.executeNextJob(BackgroundJobRunner.java:219)
      at com.tableausoftware.backgrounder.runner.BackgroundJobRunner.executeJobs_aroundBody0(BackgroundJobRunner.java:208)
      at com.tableausoftware.backgrounder.runner.BackgroundJobRunner$AjcClosure1.run(BackgroundJobRunner.java:1)
      at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149)
      at com.tableausoftware.instrumentation.InstrumentedMethod.instrumentInvocation(InstrumentedMethod.java:66)
      at com.tableausoftware.instrumentation.InstrumentationAspect.aroundAnnotatedMethod(InstrumentationAspect.java:57)
      at com.tableausoftware.backgrounder.runner.BackgroundJobRunner.executeJobs(BackgroundJobRunner.java:184)
      at com.tableausoftware.backgrounder.config.BackgroundJobRunnerSchedulingConfig.lambda$scheduleTask$0(BackgroundJobRunnerSchedulingConfig.java:42)
      at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
      at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
      at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:308)
      at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$301(ScheduledThreadPoolExecutor.java:180)
      at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:294)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      at java.lang.Thread.run(Thread.java:748)
      Caused by: com.tableausoftware.nativeapi.dll.TableauCancelException: Operation cancelled.
      [Microsoft][SQL Server Native Client 11.0]Operation canceled
      
      
      at com.tableausoftware.nativeapi.dll.TableauCancelException.getTableauCancelException(TableauCancelException.java:39)
      at com.tableausoftware.nativeapi.dll.NativeApiJNI.VQLSessionDelegate_ExecuteCommandForSessionInternal(Native Method)
      at com.tableausoftware.nativeapi.dll.VQLSessionDelegate.ExecuteCommandForSessionInternal(VQLSessionDelegate.java:55)
      at com.tableausoftware.nativeapi.commands.CommandHandler.executeForSession(CommandHandler.java:40)
      at com.tableausoftware.nativeapi.commands.CommandHandler.doCommand(CommandHandler.java:62)
      at com.tableausoftware.nativeapi.commands.ExtractsCommands.refreshWorkbookExtracts(ExtractsCommands.java:343)
      at com.tableausoftware.model.workgroup.service.DataEngineWrapper.refreshExtracts(DataEngineWrapper.java:173)
      at com.tableausoftware.model.workgroup.service.VqlSessionService$VqlSessionAction.doNativeApiWorkbookExtractAction(VqlSessionService.java:2375)
      at com.tableausoftware.model.workgroup.service.VqlSessionService$VqlSessionAction.access$2000(VqlSessionService.java:1408)
      at com.tableausoftware.model.workgroup.service.VqlSessionService.refreshExtractsForWorkbook(VqlSessionService.java:900)
      at com.tableausoftware.model.workgroup.workers.ExtractsWorker.refreshWorkbook(ExtractsWorker.java:536)
      at com.tableausoftware.model.workgroup.workers.ExtractsWorker.executeWithDataengine(ExtractsWorker.java:333)
      at com.tableausoftware.model.workgroup.workers.RefreshExtractsWorker.executeWithDataengine_aroundBody0(RefreshExtractsWorker.java:94)
      at com.tableausoftware.model.workgroup.workers.RefreshExtractsWorker$AjcClosure1.run(RefreshExtractsWorker.java:1)
      at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149)
      at com.tableausoftware.instrumentation.InstrumentedMethod.instrumentInvocation(InstrumentedMethod.java:66)
      at com.tableausoftware.instrumentation.InstrumentationAspect.aroundAnnotatedMethod(InstrumentationAspect.java:57)
      at com.tableausoftware.model.workgroup.workers.RefreshExtractsWorker.executeWithDataengine(RefreshExtractsWorker.java:94)
      at com.tableausoftware.model.workgroup.workers.DataengineDependentWorker.execute(DataengineDependentWorker.java:65)
      at com.tableausoftware.backgrounder.runner.BackgroundJobRunner$ExecuteJobImplCallable.call_aroundBody0(BackgroundJobRunner.java:412)
      at com.tableausoftware.backgrounder.runner.BackgroundJobRunner$ExecuteJobImplCallable$AjcClosure1.run(BackgroundJobRunner.java:1)
      at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149)
      at com.tableausoftware.instrumentation.InstrumentedMethod.instrumentInvocation(InstrumentedMethod.java:66)
      at com.tableausoftware.instrumentation.InstrumentationAspect.aroundAnnotatedMethod(InstrumentationAspect.java:57)
      at com.tableausoftware.backgrounder.runner.BackgroundJobRunner$ExecuteJobImplCallable.call(BackgroundJobRunner.java:395)
      at com.tableausoftware.backgrounder.runner.BackgroundJobRunner$ExecuteJobImplCallable.call(BackgroundJobRunner.java:377)
      at java.util.concurrent.FutureTask.run(FutureTask.java:266)
      ... 3 more
      

       

      Can some expert to explain what is the reason and the way to solving this issue?

       

      Thanks.