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.