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,