Product specifications

6.2.4 ERP limitations

• The JCo API does not support array fetch. This means the result data is returned all at once. To

restrict the number of resulting rows and to avoid an out-of-memory issue, the application user has

to filter data appropriately. Regardless of this limitation, Connection Server still applies array fetch.

Note:

The application user can also set a value to Max Rows in the Query Panel of the information design

tool. However, the SAP ERP system does not take Max Rows into account if the universe defined

is multisource or if the query requires computations after data is fetched (SELECT DISTINCT,

ORDER BY, and GROUP BY).

• The ERP Max Rows parameter of the jco.sbo configuration file allows the application user to

query without filter an InfoSet or a SAP Query table that only contains numerical data type columns.

The user can also query a table containing numerical and DATS data type columns. This parameter

is also used when Max Rows is not passed to the SAP ERP system. ERP Max Rows can be used

with single-source and multisource universes.

Note:

Set ERP Max Rows to an appropriate value to avoid out-of-memory issues.

In the case of a multisource universe, you can also set a value to the Max Rows parameter of the

Query Panel of the data federation administration tool. See the

Data Federator Administration Tool

Guide

for more information.