SAP Knowledge Base Article - Preview

2926836 - Cannot load the entityset A_ProductBasicText of the OData service API_PRODUCT_SRV

Symptom

  • While trying to load the entityset A_ProductBasicText of the OData service API_PRODUCT_SRV in excel, you get the following error message:

Data could not be retrieved from the database.

Check the database server or contact your database administrator. Make sure the external database is available, and then try the operation again.

  • The following request fails

URI: /sap/opu/odata/sap/API_PRODUCT_SRV/A_ProductBasicText

Found error messages on the system:

The range of the statement to be passed to the database is too wide

An exception with the type CX_SY_OPEN_SQL_DB was raised, but was not handled locally or declared in a RAISING clause.


Read more...

Environment

SAP S/4HANA Cloud Public Edition

Excel

Product

SAP S/4HANA Cloud 2002 ; SAP S/4HANA Cloud 2005

Keywords

READ_STXH_COMPLEX, CL_RSTX_TABLE_VIEW, CL_API_PRODUCT_MPC_EXT, SQL, A_ProductBasicText, A_ProductInspectionText, A_ProductPurchaseText, A_ProductPlantText, A_ProductSalesText , KBA , LO-MD-MM , Material Master , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.