SAP Knowledge Base Article - Preview

1627322 - Statement(s) could not be prepared error while parsing custom sql in derived table

Symptom

  • 'Exception: DBD, [Microsoft] [SQL Server Native Client 10.0] SQL Server Statement(s) could not be prepared. State: 42000' error while parsing the SQL in a derived table in universe designer when an ODBC connection is used
  • 'Microsoft] [SQL Server Native Client 10.0]: The column 'Name' was specified multiple times for 'Derived_table333'.State:42000.' error while parsing the SQL in a derived table in universe designer when an OLEDB connection is used


Read more...

Environment

  • Business Objects XI 3.1 Service Pack 2
  • Reporting Database: SQL  Server 2008
  • Operating System: Windows Server Release 2003 Service Pack 2

Product

SAP BusinessObjects Business Intelligence platform R2

Keywords

statement(s) could not be prepared, same column names in a derived table , KBA , BI-BIP-SL , Semantic Layer , How To

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.