1 Reply Latest reply on Apr 24, 2017 12:32 PM by Dan Becker Branched from an earlier discussion.

    Error when refreshing published extract

    ravindra babu

      Hai all,

       

      while refreshing extract i am getting the below error. recently we upgraded version 9.3 to 10.0

       

      Error: "java.lang.nullpointerexception" When Refreshing Extract Published to Tableau Server

       

      can any one give proper solution for this??

       

      ERROR::

      2017-04-18 02:01:40.151 -0500 (D Group,,,) pool-3-thread-1 : INFO com.tableausoftware.core.service.DependentServiceChecker - Starting server dependency checks

      2017-04-18 02:01:40.167 -0500 (D Group,,,) pool-3-thread-1 : INFO com.tableausoftware.instrumentation.InstrumentationUtil - Instrumenting 'public transient void com.tableausoftware.model.workgroup.workers.RefreshExtractsWorker.executeWithDataengine(java.lang.Object[])' as 'com.tableausoftware.instrumentation:00=worker,01=refreshExtracts,name=execute'.

      2017-04-18 02:01:40.182 -0500 (D Group,,,) pool-3-thread-1 : INFO com.tableausoftware.model.workgroup.workers.RefreshExtractsWorker - Whitelisting: Workbook 'HGT Payroll Dashboard' with repo URL 'HGTPayrollDashboard' has 1 datasources and 1 were allowed after applying the whitelists.

      2017-04-18 02:01:40.182 -0500 (D Group,,,) pool-3-thread-1 : INFO com.tableausoftware.model.workgroup.workers.RefreshExtractsWorker - Retrieving secondary whitelist data for workbook id 2737

      2017-04-18 02:01:40.182 -0500 (D Group,,,) pool-3-thread-1 : INFO com.tableausoftware.model.workgroup.workers.RefreshExtractsWorker - Retrieving secondary whitelist data for datasource id 1132

      2017-04-18 02:01:40.260 -0500 (D Group,,,) pool-3-thread-1 : INFO com.tableausoftware.model.workgroup.service.VqlSessionService - Created session id:3C433E8695E54F1E8D5AE67D743F68A8

      2017-04-18 02:01:40.385 -0500 (,,,) scheduled-background-job-runner-1 : ERROR com.tableausoftware.backgrounder.runner.BackgroundJobRunner - Error executing backgroundjob: :refresh_extracts

      1. java.util.concurrent.ExecutionException: java.lang.NullPointerException

                      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:353)

                      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:67)

                      at com.tableausoftware.instrumentation.InstrumentationAspect.aroundAnnotatedMethod(InstrumentationAspect.java:57)

                      at com.tableausoftware.backgrounder.runner.BackgroundJobRunner.executeNextJob(BackgroundJobRunner.java:302)

                      at com.tableausoftware.backgrounder.runner.BackgroundJobRunner.executeJobs(BackgroundJobRunner.java:293)

                      at com.tableausoftware.backgrounder.config.BackgroundJobRunnerSchedulingConfig$1.run(BackgroundJobRunnerSchedulingConfig.java:46)

                      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:745)

      Caused by: java.lang.NullPointerException

                      at com.tableausoftware.domain.user.service.UserService.getFullyQualifiedName(UserService.java:1135)

                      at com.tableausoftware.model.workgroup.service.VqlSessionService$VqlSessionAction.createSession(VqlSessionService.java:2803)

                      at com.tableausoftware.model.workgroup.service.VqlSessionService$VqlSessionAction.setupSessionForWorkbook(VqlSessionService.java:2595)

                      at com.tableausoftware.model.workgroup.service.VqlSessionService$VqlSessionAction.access$20(VqlSessionService.java:2587)

                      at com.tableausoftware.model.workgroup.service.VqlSessionService.refreshExtractsForWorkbook(VqlSessionService.java:1007)

                      at com.tableausoftware.model.workgroup.workers.ExtractsWorker.refreshWorkbook(ExtractsWorker.java:341)

                      at com.tableausoftware.model.workgroup.workers.ExtractsWorker.executeWithDataengine(ExtractsWorker.java:264)

                      at com.tableausoftware.model.workgroup.workers.RefreshExtractsWorker.executeWithDataengine_aroundBody0(RefreshExtractsWorker.java:82)

                      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:67)

                      at com.tableausoftware.instrumentation.InstrumentationAspect.aroundAnnotatedMethod(InstrumentationAspect.java:57)

                      at com.tableausoftware.model.workgroup.workers.RefreshExtractsWorker.executeWithDataengine(RefreshExtractsWorker.java:81)

                      at com.tableausoftware.model.workgroup.workers.DataengineDependentWorker.execute(DataengineDependentWorker.java:67)

                      at com.tableausoftware.backgrounder.runner.BackgroundJobRunner$ExecuteJobImplCallable.call_aroundBody0(BackgroundJobRunner.java:462)

                      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:67)

                      at com.tableausoftware.instrumentation.InstrumentationAspect.aroundAnnotatedMethod(InstrumentationAspect.java:57)

                      at com.tableausoftware.backgrounder.runner.BackgroundJobRunner$ExecuteJobImplCallable.call(BackgroundJobRunner.java:447)

                      at com.tableausoftware.backgrounder.runner.BackgroundJobRunner$ExecuteJobImplCallable.call(BackgroundJobRunner.java:1)

                      at java.util.concurrent.FutureTask.run(FutureTask.java:266)

                      ... 3 more

      2017-04-18 02:01:40.416 -0500 (,,,) scheduled-background-job-runner-1 : INFO com.tableausoftware.instrumentation.InstrumentationUtil - Instrumenting 'private void com.tableausoftware.backgrounder.runner.BackgroundJobRunner.onExecutionFailure(com.tableausoftware.model.workgroup.workers.AbstractWorker, com.tableausoftware.model.workgroup.BackgroundJob)' as 'com.tableausoftware.instrumentation:00=jobRunner,name=executionFailure'.

      2017-04-18 02:01:40.572 -0500 (,,,) scheduled-background-job-runner-1 : INFO com.tableausoftware.model.workgroup.util.EmailHelper - Sending email from donotreplyTableau@Dgroup.com to null from server smtpmail.Dgroup.com

      2017-04-18 02:01:40.572 -0500 (,,,) scheduled-background-job-runner-1 : ERROR com.tableausoftware.model.workgroup.workers.RefreshExtractsWorker - Failed to send email notification upon refresh failure.

      1. java.lang.IllegalArgumentException: null email address

                      at com.tableausoftware.core.util.SMTPClient.setupToAddresses(SMTPClient.java:243)

                      at com.tableausoftware.core.util.SMTPClient.send(SMTPClient.java:178)

                      at com.tableausoftware.model.workgroup.util.EmailHelper.sendEmail(EmailHelper.java:131)

                      at com.tableausoftware.model.workgroup.util.EmailHelper.sendNotificationEmail(EmailHelper.java:114)

                      at com.tableausoftware.model.workgroup.util.EmailHelper.sendNotificationEmail(EmailHelper.java:94)

                      at com.tableausoftware.model.workgroup.workers.ExtractsWorker.sendNotificationOnFailure(ExtractsWorker.java:211)

                      at com.tableausoftware.backgrounder.runner.BackgroundJobRunner.onExecutionFailure_aroundBody4(BackgroundJobRunner.java:424)

                      at com.tableausoftware.backgrounder.runner.BackgroundJobRunner$AjcClosure5.run(BackgroundJobRunner.java:1)

                      at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149)

                      at com.tableausoftware.instrumentation.InstrumentedMethod.instrumentInvocation(InstrumentedMethod.java:67)

                      at com.tableausoftware.instrumentation.InstrumentationAspect.aroundAnnotatedMethod(InstrumentationAspect.java:57)

                      at com.tableausoftware.backgrounder.runner.BackgroundJobRunner.onExecutionFailure(BackgroundJobRunner.java:422)

                      at com.tableausoftware.backgrounder.runner.BackgroundJobRunner.executeNextJob_aroundBody2(BackgroundJobRunner.java:413)

                      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:67)

                      at com.tableausoftware.instrumentation.InstrumentationAspect.aroundAnnotatedMethod(InstrumentationAspect.java:57)

                      at com.tableausoftware.backgrounder.runner.BackgroundJobRunner.executeNextJob(BackgroundJobRunner.java:302)

                      at com.tableausoftware.backgrounder.runner.BackgroundJobRunner.executeJobs(BackgroundJobRunner.java:293)

                      at com.tableausoftware.backgrounder.config.BackgroundJobRunnerSchedulingConfig$1.run(BackgroundJobRunnerSchedulingConfig.java:46)

                      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:745)