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 for Me (Login required).

Search for additional results

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