SAP Knowledge Base Article - Preview

1363557 - Error: “Connection or SQL sentence error: (DA0005) Exception: DBD, [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.State: 42000” while parsing the object on tables having space in table name.

Symptom

  • When Business Objects generates a query on a table with a space in the name an error is shown: "Connection or SQL sentence error: (DA0005) Exception: DBD, [Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared.State: 42000"
  • The query generated is for example: SELECT vwudorder."order number", vwudorder."order date", Table__13.uvalue FROM "dbo.order amount" Table__13 RIGHT OUTER JOIN vwudorder ON (vwudorder.id_order=Table__13.id_order)
  • If this query is executed in SQL server management studio following error occurs  "Msg 208, Level 16, State 1, Line 1 Invalid object name 'dbo.order amount'"
  • When the syntax is changed from "dbo.order amount" to "order amount" the query will run.
  • The issue is with the universes which are migrated from Business Objects XI R2 to Business Objects XI 3.1


Read more...

Product

SAP BusinessObjects Enterprise XI 3.1

Keywords

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.