2487868 - A CDS Analytics Query hits Invalid Hint Error | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2487868 - A CDS Analytics Query hits Invalid Hint Error

Symptom

Run a trainsient query based on CDS view hits DB error:

Database returned the SQL code 468. Error text: hint error: invalid hint: incorrect syntax near "(": line x col xxx (at pos xxx)
RS_EXCEPTION 000

In the work process trace dev_w<nn> file you could see more details:

C SQLERRTEXT : hint error: invalid hint: incorrect syntax near "(": line 1 col xxx (at pos xxx)
....
C SELECT .....
......

C ..... FROM /* Entity name: xxxxx */ "xxxx" ... WHERE ....
C .... WITH HINT(RESULT_LAG ('hana_long'));
B ***LOG BY4=> sql error 468 performing PRE on table xxxx  [dbdbslst 4799]
B ***LOG BY0=> hint error: invalid hint: incorrect syntax near "(": line 1 col xxx (at pos xxx) [dbdbslst 4799]

Read more...

Environment

BW 7.5 above

Product

SAP BW/4HANA 1.0 ; SAP NetWeaver 7.5

Keywords

KBA , BW-BEX-OT-ODP , Query Runtime for Operational Data Provisioning , HAN-DB-ENG-BW , SAP HANA BW Engine , How To

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.