Unsupported parameter in object Error in XSODATA

[former_member210023]

Hi,

    I have built a calculation view in HCP with one input parameter ip_maktx. When I try to activate the XSOdata service for the view, I get an error saying

"Unsupported parameter "ip_maktx" in object "abcd.yyy.xxx.ARKA::ImportTesting"."

Any help is appreciated.

Please find below the XSODATA service details:

service {

"abcd.yyy.xxx.ARKA::ImportTesting" as "Param"

keys generate local "ID"

parameters via entity;  

}

Thanks

Arka

[pfefferf · Accepted solution]

Hello Arka,

is the parameter a multi-value parameter? If yes, then that is the reason. Multi-Value parameters are not supported in such a way.

Regards,

Florian

[former_member210023 · Accepted solution]

Hi Florian,

              I have not defined the parameter as multi value, it has been defined as mandatory and Direct Type.

Here is the SQL Script for the view.

BEGIN

  var_out = SELECT DISTINCT PRODUCT.PRODUCT_ID, PRODUCT.PRODUCT_NAME, SALES.REGION_ID, SALES.SALES_AMOUNT, REGION.REGION_NAME

       FROM "ARKA"."abcd.yyy.xxx.ARKA::ar2.PRODUCT3" AS PRODUCT INNER JOIN

       "ARKA"."abcd.yyy.xxx.ARKA::ar2.SALES3" AS SALES

       ON PRODUCT.PRODUCT_ID = SALES.PRODUCT_ID

       INNER JOIN

       "ARKA"."abcd.yyy.xxx.ARKA::ar2.REGION3" AS REGION

       ON REGION.REGION_ID = SALES.REGION_ID

       where PRODUCT.PRODUCT_NAME = :ip_maktx

       GROUP BY  PRODUCT.PRODUCT_ID, PRODUCT.PRODUCT_NAME, SALES.REGION_ID, REGION.REGION_NAME,SALES.SALES_AMOUNT

       ORDER BY PRODUCT.PRODUCT_ID;

END /********* End Procedure Script ************/

Thanks

Arka

[pfefferf · Accepted solution]

I assume that the type of the parameter is character based which makes no problems.

What editor did you use to create the view, HANA Studio/HANA Tools in Eclipse or the web-based dev workbench. With the web-based dev workbench it seems that not all properties for the view are set correctly, like described in post . Can you check in the XML respresentation of the view  that the selection tag is available like following for the parameter: <selection multiLine="false" type="SingleValue"/>

Regards,

Florian

[former_member210023 · Accepted solution]

Hi Florian,

               Thanks for your reply. I am using the HCP editor. Could you please let me know the process of checking the XML representation, I am unaware as I am new to this area.

Thanks

Arka

[pfefferf · Accepted solution]

Right click on the view to open the context menu and choose Open -> Open with Text Editor. This opens the XML of the view.

[former_member210023 · Accepted solution]

Hi Florian,

              Thanks for your support and guidance. The issue is now resolved, I added the following :

type="SingleValue"

Thanks

Arka