Skip to Content
1

BOC - Change Max Rows Supported

Feb 24, 2017 at 01:02 AM

144

avatar image
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

10 |10000 characters needed characters left characters exceeded

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.

1
Former Member
John Leggio

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

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Henry Banks
Feb 24, 2017 at 10:44 AM
0

Hi,

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


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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

1