BOC - Change Max Rows Supported

[Former Member]

Hello Experts,

We are developing BOC reports having SAP BW as a source but unable to retrieve more than 5k rows... how can we change that stuff?

Please help me out.

Kind regards,

Bernardo

[JohnL]

Hi Bernardo,

Also check your BW system to see if there are ST22 dumps or errors in SLG1 that might point to a reason why its maxing out at 5000 records.

[Former Member]

Thanks John,

I haven't find nothing in ST22 or SLG1 which tells me something about this issue.

I have provided more details with regards to the issue in the BOC Monitor in response to H's post bellow.

Best regards,

Bernardo

[Henry_Banks · Accepted solution]

Hi,

according to this help page here: https://uacp2.hana.ondemand.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/11b4e5ff76eb4747b...

it should be possible to do: Data Acquisition Maximums:

•Columns: 100
•Rows: 800,000
•Dimension members: 250,000
•Dimension members with attributes: 150,000
•Dimension members in hierarchy: 150,000
•Hierarchy depth: 1,000

what does the query return in a bw-side test with the same input variable responses?

is this the first fetch when building a model from the bw connection / query, or are you trying to schedule a new full load into BOC?

Regards,
H

[Former Member · Accepted solution]

Hello H,

Sorry for my delays in the response. This issue still remains and we don't know what/where to change for it to work.

It is not necessarilly the 1st time fetching data into the model having the BW connection as the source, and this happens either manual or scheduled fashion.

So far I can tell you that in the BOC System/Monitor/Trace options we found the following error:

Component: sap.fpa.services.resource.dm

Message: An error occurred in the BW service: Result set is too large; data retrieval restricted by configuration

And the stack shows something like this:

Exception@/sap/fpa/services/core/system/Exception.xsjslib:105
ExceptionBWAgent@/sap/fpa/services/dm/agent/bw/BWAgent.xsjslib:14
BWAgent.prototype.doDestRequest@/sap/fpa/services/dm/agent/bw/BWAgent.xsjslib:102
BWAgent.prototype.readQueryData@/sap/fpa/services/dm/agent/bw/BWAgent.xsjslib:266
BWAgent.prototype.getDataStructure@/sap/fpa/services/dm/agent/bw/BWAgent.xsjslib:272
DataAcquisition.prototype._startQueryData@/sap/fpa/services/dm/DataAcquisition.xsjslib:111
DataAcquisition.prototype.startQueryDataJob@/sap/fpa/services/dm/DataAcquisition.xsjslib:93
RestDataIntegration.prototype.doPost@/sap/fpa/services/dm/RestDataIntegration.xsjslib:175
handleRequest@/sap/fpa/services/GetResponse.xsjs:306
@/sap/fpa/services/GetResponse.xsjs:346

I hope this helps. Thanks for your help.

Cheers,

Bernardo