ODATA Datawarehouse table extract issue after Tableau upgrade

book

Article ID: 225655

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

We are trying to connect to Clarity Datawarehouse tables through ODATA connection and we are not able to extract data from few tables. There is a server error that pops up as below.

The tables differ from region to region. For example the DWH_INV_INVESTMENT table is not accessible in Dev region but works fine in PROD, where as the DWH_INV_STATUS_REPORT is not accessible in PROD but accessible in Dev.

Tableau failed to create an extract. This data source requires an extract before you can start your analysis.

DataSource.Error: OData: Request failed: The remote server returned an error: (500) Internal Server Error. (Internal Server Error)

 

 

Environment

Release : 15.9.3

Component : CLARITY DATA WAREHOUSE

Resolution

Tableau 2021.1.3

This URL contains some OData specific strings, and research on the '$skiptoken' value led to an SAP thread on OData pagination:
https://answers.sap.com/questions/206008/how-to-get-more-than-10000-records-while-querying-.html
The pertinent information comes from the bottom post:
You can use the recent snapshot based pagination and loop over $skiptoken to get all the remaining pages

"ts":"2021-09-08T13:15:07.907"
"e":{"excp-error-code":"0x7C19CF64"
"excp-source":"DataSource"
"excp-status-code":"UNAVAILABLE"}
"v":{"class":"odata"
"dse-type":"UnableToConnect"
"excp-msg":"Unable to access OData

Workaround: filter upfront or do excel first and load to Tableau.

Attachments