4 Replies Latest reply on Aug 31, 2018 2:20 PM by Alexander V

    Extract can not create with PostgreSQL on Tableau Linux Server 10.5.4

    Alexander V

      Dear community.

       

      I have created a project connected to the PostgreSQL database and published the project on a Tableau Linux Server v.10.5.4.

      The credentials are embedded and the Tableau Server connects to the datasource succesfully.

      The problem is the extracts can not to be created due to Sign Up Failed. The credentials are ok.

      The full error description is in the attachment. The problem is 'Unable to connect to the file /var/opt/tableau/tableau_server/temp/backgrounder_... '

       

      WhatsApp Image 2018-08-30 at 00.16.03.jpeg

        • 1. Re: Extract can not create with PostgreSQL on Tableau Linux Server 10.5.4
          Jeff Strauss

          Is this specific to this extract?  Are any extracts successful?

          • 2. Re: Extract can not create with PostgreSQL on Tableau Linux Server 10.5.4
            Alexander V

            Jeff the similar extracts work correctly on another version of Tableau Server (2018.1).

             

            I found a resolved issue in Tableau Server 10.5.6:

            780472

            In some cases, scheduled extract refreshes could not run due to Backgrounder processes being tied up with other internal tasks.

             

            Now I will be updating the Tableau Server to the last version. Probably it will fix it.

            • 3. Re: Extract can not create with PostgreSQL on Tableau Linux Server 10.5.4
              Paulo Dantas

              Hi Alexander,

               

              could be a size that can fit on the folder that the extract try to create the information or just a bug.

               

              You can check the log file on data -> tabsvc -> logs or data -> tabsvc.

               

              Best regards.

              • 4. Re: Extract can not create with PostgreSQL on Tableau Linux Server 10.5.4
                Alexander V

                The errors in log:

                 

                2018-09-01 00:03:51.607 +0300 (Default,,,BF979E5178AA45338A0CFC6564E92970,247409,:refresh_extracts,-) pool-4-thread-1 : INFO  com.tableausoftware.sos.Access.extract - using cacheDest for workingDest /var/

                opt/tableau/tableau_server/data/tabsvc/temp/backgrounder_0.10500.18.0801.2224/noopTemporary3631363211890797983/extract_{03CA086F-C491-4E0A-9DF1-6E0EB47EE6EB}_C4J9RQvLqK

                2018-09-01 00:03:51.607 +0300 (Default,,,BF979E5178AA45338A0CFC6564E92970,247409,:refresh_extracts,-) pool-4-thread-1 : INFO  com.tableausoftware.sos.Access.extract - inject folder /var/opt/tableau/tableau_server/data/tabsvc/dataengine/extract/c4/81/{03CA086F-C491-4E0A-9DF1-6E0EB47EE6EB} into {03CA086F-C491-4E0A-9DF1-6E0EB47EE6EB}

                2018-09-01 00:03:57.454 +0300 (Default,,,BF979E5178AA45338A0CFC6564E92970,247409,:refresh_extracts,-) pending-index-queue-proc-33 : INFO  com.tableausoftware.model.workgroup.jpa.MostRecentRefreshDaoJpa - Attempting to find datasource refresh all success events for failed 1 events

                2018-09-01 00:03:57.472 +0300 (Default,,,BF979E5178AA45338A0CFC6564E92970,247409,:refresh_extracts,-) pending-index-queue-proc-33 : INFO  com.tableausoftware.domain.solr.SolrPendingQueueProcessor - Search index update sent. UpdateId [9998] Index [WORKBOOK] Op [UPDATE] ObjectId [20].

                2018-09-01 00:03:57.511 +0300 (Default,,,,247409,:refresh_extracts,-) scheduled-background-job-runner-1 : ERROR com.tableausoftware.backgrounder.runner.BackgroundJobRunner - Error executing backgroundjob: RefreshExtracts

                java.util.concurrent.ExecutionException: com.tableausoftware.nativeapi.dll.DataSourceException: Unable to connect to the file "/var/opt/tableau/tableau_server/data/tabsvc/temp/backgrounder_0.10500.18.0801.2224/tableau-temp/0tq0p6w0cc8j1s1879qes0e26uuc". Check that the file exists and that you have sufficient access privileges for it.

                 

                 

                 

                 

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

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

                        at com.tableausoftware.backgrounder.runner.BackgroundJobRunner.executeJobs_aroundBody0(BackgroundJobRunner.java:237)

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

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

                        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

                        at java.lang.Thread.run(Thread.java:748)

                Caused by: com.tableausoftware.nativeapi.dll.DataSourceException: Unable to connect to the file "/var/opt/tableau/tableau_server/data/tabsvc/temp/backgrounder_0.10500.18.0801.2224/tableau-temp/0tq0p6w0cc8j1s1879qes0e26uuc". Check that the file exists and that you have sufficient access privileges for it.