SAP Knowledge Base Article - Preview

1636854 - "Statement(s) could not be prepared.. (IES 10901)" error when viewing or scheduling a Webi report with cascading LOVs.

Symptom

  • You create a Webi report based on a MSSQL database that contains a cascading List of Values which includes a time period range (start date and end date for example).
  • When refreshing this report in the Web viewer within BI Launchpad, or when scheduling the report and selecting a start date or start date and end date, the following error is returned:

"Database error: [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.. (IES 10901)"

  • The same workflow via a JCO connection to a BW cube (using the Data Federator driver) results in the following error:

"Database error: [Data Federator Driver] [Server] com.businessobjects.datafederator.server.engine.parsers.dml.TokenMgrError: Lexical error at line 6, column 47.  Encountered: "@" (64), after : "". (IES 10901)"


Read more...

Environment

  • SAP BusinessObjects BI4.0
  • Support Pack 02

Product

SAP BusinessObjects Business Intelligence platform 4.0

Keywords

BI4, Webi, Web, Intelligence, WebIntelligence, LOV, list, values, refresh, cascading, statement(s), prepared, IES, 10901, IES 10901, error, ADAPT01583733, 01583733 , KBA , BI-RA-WBI , Web Intelligence , Bug Filed

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.