Skip to Content
author's profile photo Former Member
Former Member

Call stored procedure in sap Hana

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!!

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2015 at 12:37 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 20, 2015 at 12:36 AM

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

    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.