SAP Knowledge Base Article - Preview

3059281 - HANA hint is not propagated with Procedure Sqlscript

Symptom

  • You have created a HANA procedure and attached a hint at the end of the sqlscript creation like the below example :

              CREATE PROCEDURE
              PRD22.TEST(
              in ...
              in ...
              ...
              )
              language sqlscript sql security invoker       as begin

              SELECT ...

              FROM "schema"."table"

              GROUP BY ..
              <other_clauses>
              WITH HINT(NO_CS_JOIN)

               END;


  • Calling the procedure directly in HANA Studio with input variables invokes the hint as expected

               CALL "PRD22"."TEST" ('', '', '', ?, ?)WITH HINT(NO_CS_JOIN)


  • However when the procedure is triggered and executed from a front end application tool or as part of a report, the hint is not invoked and dumps in an error.

               e.g "[9] Memory Allocation failed."




Read more...

Environment

  • SAP HANA PLATFORM EDITION 1.0
  • SAP HANA PLATFORM EDITION 2.0

Product

SAP HANA 1.0, platform edition ; SAP HANA, platform edition 2.0

Keywords

KBA , HAN-DB-ENG , SAP HANA DB Engines , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.