• In progress
  • Odata[0100]: "Contents of table ... not available"

    OData error message: Failure | Odata[0100] - The contents of table <table-name> are not available for this user. The remote server returned an error: (500) Internal Server Error.

    Causes

    May be due to a time-out condition on the OData server.

    Solutions

    1) Key+ key (ETL+ Design page).

    Assign a Key+ to the table on the ETL+ Design page.
    The presence of a Key+ key for the table in ETL+ seems to help OData “paginate” the query into smaller chunks of data.

    ETL+ Design page example. The AddressID column is designated as the Key+ key.

    2) Extraction pages and Pause settings.

    Adjust the Extraction pages and Pause settings on the page.


    Related Pages

    • – see the Extraction pages and Pause settings.