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.