Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Problem with PO and HANA xsodata with input parameters

Hi,

We have a HANA view which uses input parameters, and this is exposed as an xsodata service, which also uses input parameters. The URL looks like this. For a single value the following syntax would be used:

http://hana:8000/data/view.xsodata/InputParams(i_var='1')/Results?$format=json

If there are multiple values for the variable, the following syntax is used.

http://hana:8000/data/view.xsodata/InputParams(i_var='1'',''2'',''3'',''4'',''5')/Results?$format=json

The PO OData adapter works with a single value but fails with multiple values, with the following:

Error org.apache.olingo.odata2.api.edm.EdmSimpleTypeException: The metadata constraints [Nullable=false, DefaultValue=1, MaxLength=8] do not match the literal 1,2,3,4,5.

So PO is complaining that it thinks that the actual variable value is '1,2,3,4,5' rather than 5 separate values. Is this a PO bug, or is HANA breaking the OData format? Or just an integration issue between the two products? I'd sure appreciate any ideas on what to do.

Thanks!

John

Tags:
Not what you were looking for? View more on this topic or Ask a question