Some tables are not available in Tableau via Odata

Products

• Clarity PPM SaaS

Issue/Introduction

We are trying to connect to few tables in Tableau that were available before and see this error message:

2019-11-21 03:30:27.937 -0500 (Default,,,,1428629,:refresh_extracts,984d5f38-4fba-4f70-86c5-9472fdcc2928) pool-25-thread-1 backgrounder: WARN  com.tableausoftware.model.workgroup.workers.RefreshExtractsWorker - |status=ExtractTimingFailure|jobId=1428629|jobLuid=984d5f38-4fba-4f70-86c5-9472fdcc2928|siteName="Default"|datasourceName=" DWH_INV_INVESTMENT"|refreshedAt="2019-11-18T08:31:27.224Z"|scheduleName="Daily at 3:30 AM EST"|scheduleType="FullRefresh"|jobName="Refresh Extracts"|jobType="RefreshExtracts"|totalTimeSeconds=10|runTimeSeconds=1|queuedTime="2019-11-21T08:30:17.121Z"|startedTime="2019-11-21T08:30:25.989Z"|endTime="2019-11-21T08:30:27.935Z"|correlationId=69|priority=50|serialId=null|extractsSizeBytes=0|jobNotes="An unknown error related to remote content was detected (500)

com.tableausoftware.nativeapi.exceptions.DataSourceException: An unknown error related to remote content was detected (500)

Some other tables are showing correctly, what could be causing this?

Environment

Release : All SAAS releases with OData

Resolution

 

Please ensure you run the OOTB Refresh Data Warehouse Odata Model job to update all tables. Then schedule the job to run on regular basis.