SAP Knowledge Base Article - Preview

2712640 - Error - hint error: invalid hint: incorrect syntax near "hana_sr" - during CDS view activation

Symptom

As per HANA requirements, the RESULT_LAG DB Hint added in the ABAP CDS  view (using the annotation '@AbapCatalog.dbHints') should have the syntax as follows:

@AbapCatalog.dbHints: [{dbSystem: #HDB, hint: 'RESULT_LAG('hana_sr',1000)'}]

But the above syntax throws the following syntax error during the CDS view activation:

---------------------
Database returned the SQL code 468. Error text: hint error: invalid hint: incorrect syntax near "hana_sr":line <n> col<nn> (at pos <nn>)
---------------

Once the above DB Hint is changed such that "hana_sr" in double quotes instead of single quote('hana_sr'), the CDS view gets activated successfully. But when trying to access this cube from AO, it throws the following error:

--------------------------
SQL code 468. Error text: hint error: invalid hint: incorrect syntax near """: line 1 col 591 (at pos 590) RS_EXCEPTION 000
--------------------------               


Read more...

Environment

  • HANA 2.0
  • S/4HANA

Product

SAP S/4HANA 1709

Keywords

RESULT_LAG('hana_sr'), RESULT_LAG, hana_sr, @AbapCatalog.dbHints , KBA , BC-ESI-ESF-BSA , Business Service Adaptation , 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.