SAP Knowledge Base Article - Preview

1759002 - BI40:Tables created in SP02 after modification in SP04 gives error "Error Executing Query"

Symptom

  • Error Executing Query encountered "." at line <number>, column <number>. Was expecting one of:    "from" ...     "as" ...     "and" ...     "or" ...      "in" ...    "between" ...      <COMPARISON_OPERATOR> ...    "like" ...    "not" ...    "is" ...     <DELIMITED_IDENTIFIER> ...      <IDENTIFIER> ...      "," ...     "." <IDENTIFIER> ...      "." <DELIMITED_IDENTIFIER> ...     "." "*" ...     "+" ...    "-" ...    "*" ...    "/" ...    "**" ...     "//" ...     "%" ...     "(" ...
  • Problem only exist for existing Data foundation
  • Recreating the table in the data foundation doesn't give the error
  • Refreshing structure generate the error
  • Editing derived table and clicking OK without modification generate the error


Read more...

Environment

  • Information Design Tool BI 4.0 SP04
  • Windows
  • SAP HANA

Product

SAP BusinessObjects Business Intelligence platform 4.0

Keywords

ADAPT01659853 01659853 5000450162 upgrade universe IDT data foundation HANA jdbc derive table error executing query work doesn't SP04 field name beginning number , KBA , BI-BIP-SL , Semantic Layer , 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.