SAP Knowledge Base Article - Preview

3089466 - Database Error

Symptom

  • A database error occurred. The database error text is: "[Microsoft] [ODBC SQL Server Driver] [SQL Server] Statement(s) could not be prepared.. (Error: WIS 10901)" is shown when refreshing the lists of values in Web Intelligence.
  • The source database connection is on Microsoft SQL Server, however in Universe Design Tool the generic ODBC has set.
  • When changing the generic driver to the dedicated SQL Server one, there is no error message anymore in Web Intelligence Rich Client only in BI Launchpad.
  • The data can be seen in Universe Design Tool as well.
  • Purging the WebI report or restarting the BI servers doesn't help.


Read more...

Environment

  • SAP BusinessObjects Business Intelligence platform 4.2 
  • Universe Design Tool
  • Microsoft SQL Server
  • ODBC

Product

SAP BusinessObjects Business Intelligence platform 4.2

Keywords

statements could not be prepared bi 4.2 webi launchpad sql server odbc , KBA , BI-RA-WBI , Web Intelligence , 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.