Why does the SAP adapter not retrieve all the available resources while introspecting in TIBCO Data Virtualization?

Why does the SAP adapter not retrieve all the available resources while introspecting in TIBCO Data Virtualization?

book

Article ID: KB0070102

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization All Supported Versions

Description

The issue arises when the SAP adapter while introspecting in TIBCO Data Virtualization, fails to retrieve all available resources, particularly when dealing with a large number of tables. The default configuration settings restrict the maximum number of tables that can be retrieved, leading to incomplete data retrieval operations.

Issue/Introduction

This article will summarize the steps to fix the issue of SAP adapter not able to retrieve all the resource under it.

Environment

All Supported Environments

Resolution

To address this issue, navigate to the Advance tab of the SAP data source in TDV Studio. Then locate the parameter named "Table maximum options" and adjust the value to accommodate the large volume of tables present in the SAP. The default value of this parameter is 500 and it can be adjusted according to the requirement. By making this configuration change, the SAP adapter can now successfully retrieve all available resources in TDV while introspecting,