Skip to Content

SAP PO - SFSF Adapter - Lookup Dynamic Query Not respect selection fields

Hi experts,

I am doing a Lookup query using SF SF adapter oData, to select some fields of differents tables on SF.
The problem is, I want to select ONE field for example, and the result is ALL fields.
Because of that I am having a serious problem on PO:

com.sap.aii.adapter.lib.component.odata.exception.OsciException: The response size (30242644) is greater than the maximum message size (26214400).

Basically I am doing this select:

..link.../odata/v2/EmpJob?$select=seqNumber,startDate,userId,employmentNav/personIdExternal,position,positionNav/employeeClass,positionNav/employeeClassNav/label_defaultValue,positionNav/parentPosition/code,employeeClass,employeeClassNav/picklistLabels/locale,employeeClassNav/picklistLabels/label,managerId,event,eventReason,businessUnit,businessUnitNav/cust_ItOrgCode,businessUnitNav/name_defaultValue,company,companyNav/name_defaultValue,department,departmentNav/cust_ItDeptCode,departmentNav/name_defaultValue,division,divisionNav/cust_ItBuCode,divisionNav/name_defaultValue,positionNav/effectiveStatusNav/value,positionNav/effectiveStatusNav/key,positionNav/effectiveStatusNav/en_US&$expand=emplStatusNav,companyNav,businessUnitNav,departmentNav,divisionNav,employmentNav,positionNav/employeeClassNav,positionNav/parentPosition,positionNav/effectiveStatusNav,employeeClassNav/picklistLabels&$orderby=employmentNav/personIdExternal&$filter=userId in '901234','901235'

When I do the same select directly, (using Java for example), I get only the fields I wanted. But doing that using lookup in my Java Mapping, ALL fields came in the result...


There is something missing in my query?

ps.: the scenario works for a little amount of ids, but since I am processing all base, I got this error.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jul 02 at 05:18 PM

    2394984 - How to resolve PAYLOAD_SIZE_ERROR in PI SFSF adapter

    Resolution

    1. Go to NWA -> Configuration -> Infrastructure -> Applications -> com.sap.aii.adapter.sfsf.app
    2. Increase the value of this property "sfsf.maxMessageSize"

    Note that increasing the value too much can lead to memory issues in case a lot of messages are processed in the same time. Therefore, it is also recommended to control the message size and avoid too large messages sent from the sender Success factor system.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.