We have a significant number of scheduled Tableau Prep flows that run in Tableau Cloud nightly. For quite a while, everything was going smoothly. But in the last month or so, we've been seeing at least one flow fail nearly every night with a similar error:
This job failed on Nov 6, 2024, 2:35 AM after running for 30.3 min because of: Flow run ID: {12112559} failed on output step: {a99778cb-f072-4719-a01a-f6ccff7bd9d6}. The output step failure message: System error: Unable to publish the datasource. Verify the project exists on your server and you have permission to access it, or select a different project. Flow run ID: {12112559} failed on output step: {a99778cb-f072-4719-a01a-f6ccff7bd9d6}. The output step failure message: Unable to publish the datasource. Verify the project exists on your server and you have permission to access it, or select a different project. com.tableausoftware.server.status.reporting.TableauRuntimeException: Unable to publish the datasource. Verify the project exists on your server and you have permission to access it, or select a different project.
These errors began prior to our Tableau Cloud being upgraded to 2024.3, and our pod (prod-useast-a) hasn't been moved to hyperforce yet.
It's not always the same flow that fails, either. The failures jump around to different flows, so I cannot exactly identify a pattern. But the error message is always about being unable to publish the datasource.
In the past, we've had issues like this when we've approached our allotted data for our site, but we're using 80 GB of our 1 TB max storage space.
Any ideas of what might be causing this?
Hi, I am not completely sure. However, I always recommend to use the Tableau Prep Builder that matches the tableau prep conductor release you obtained from getting the info using a browser (e.g. https://yourserver.com/api/3.10/serverinfo)
This solves a lot of incompatibility problems between the flow in Prep Builder and the flow published in Tableau Server.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador