Odata Query length issue in SAP CPI

[pushpap]

Hi All,

We are having a production issue while fetching Employee data from SuccessFactors. Getting below error:

com.sap.gateway.core.ip.component.odata.exception.OsciException: Request-URI Too Long : 414 : HTTP/1.1

As read in some blogs, this error is due to exceeded length of the query.

Could anyone help us with possible options to avoid these kind of errors?

This iFlow was running perfectly till yesterday evening in production and throwing this error since today morning, we have not made any changes in the iFlow.

The same iFlow is running fine in dev tenant as well.

Unable to find out the reason...Awaiting your responses.

Thanks,

Pushpa

[former_member76828]

Hi Pushpalatha,

How did you resolve this issue? Even I am facing the same.

[former_member724290]

Hello Pushpa,

use GET in batch

Blog

[kc_kristris]

Hello Pushpa,

Solution would be to break your queries into two calls (request-reply).

Regards,

Kris

[pushpap]

Hi,

any solutions/ suggestions in reducing the length of the Odata query to successfactors?

present query length is 8497 characters which is exceeding max length of 8192 characters.

We are still stuck with this production issue.

your help is greatly appreciated.

Pushpa

[rafaeljimenez]

segment the query, you can use content enricher for foundation opbjects and this will reduce the size of main query

[abegum]

Could you please suggest ,what could be the solution for such cases ? Appreciate your help ..