Skip to Content
avatar image
Former Member

BOC - Change Max Rows Supported

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

Add comment
10|10000 characters needed 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.

  • 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

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 24, 2017 at 10:44 AM

    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

    Add comment
    10|10000 characters needed 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