Call stored procedure in sap Hana

[Former Member]

I have some layouts that are designed using a stored procedure in SAP Hana.  The run for the majority of layouts however on some i get the message 'Failed to retrieve data from the database'-

if i call the stored procedure in Hana with the posting in question i.e. docentry param and object id i get the following message:

Call "iis_epc_eml_mdoc" (739,17)

Could not execute 'CALL "NCC_LIVE"."IIS_EPC_EML_MDOC_NCC_SO" (539,17)' in 222 ms 602 µs .

SAP DBTech JDBC: [7]: feature not supported:  [7] "NCC_LIVE"."IIS_EPC_EML_MDOC_NCC_SO": line 431 col 4 (at pos 20819): [7] (range 3): feature not supported: invalid unicode string (support only CESU-8) at function __cs_field_HybridNCLob__()

The error seems to be intermittent i.e. it will work on a posted document and then stop working or vice versa - a document wont work and then will start working again!!

any help greatly appreciated!!

[Former Member]

Change your index server.ini, your Smart_data_Access to column, thats it

[Former Member]

Any solution?

I have the same problem, I have been analyzing and reached the following conclusions:

1. SAP9 for HANA not the case that when they were created in the fields of type memo in SAP9 creates the fields as CS_MEMORY_LOB and 9.1 is creating as LOB. This change in the type of data that suddenly fails in my queries.

2. If I do a LEFT JOIN the main table to table that has this column and there is no data gives error, but if there is no data gives error.

My conclusion is that the error is the same is the LEFT JOIN when the table does not have data, because if I do SELECT direct the table does not have any kind of problem.