SAP Knowledge Base Article - Preview

2426423 - "Error [Data Federator Driver] [Server] Encountered 'WITH'..." occurs when setting END_SQL parameter to HANA hints on multi-source universe to HANA DB

Symptom

  • SAP HANA hints are typically used in order to optimize SAP HANA performance or memory consumption per KBA 2142945 - FAQ: SAP HANA Hints
  • Set parameter END_SQL in multi-source universe to HANA DB and then the following error occurs when refreshing Web Intelligence report and also executing query/showing table values in Information Design Tool
    Error:
    [Data Federator Driver] [Server] Encountered "WITH" at line <line number>, column <Column number>.
    Was expecting one of:
        <EOF>
        "where" ...
        "group" ...
        "order" ...
        "having" ...
        "union" ...
        "intersect" ...
        "except" ...
        "natural" ...
        "join" ...
        "cross" ...
        "inner" ...
        "left" ...
        "right" ...
        "full" ...
        "/*+" ...
        ";" ...
        "," ...


Read more...

Environment

  • SAP BusinessObjects Business Intelligence Platform 4.X
  • SAP HANA Database 1.0
  • Information Design Tool (IDT)
  • Web Intelligence (WebI)

Product

SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2 ; SAP HANA 1.0, platform edition

Keywords

BI4, BI4.0, BI4.1, BI4.2, 4.x, BI4.x, IDT, UNX, .UNX, .BLX, .DFC, universe, MSU, multi-source universe, IDT, WebI, END_SQL, END SQL, With Hint, Hint,BiSL, Data Federator, "With", with , KBA , BI-BIP-SL , Semantic Layer , BI-RA-WBI , Web Intelligence , 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.