Symptom
-
Unable to refresh Desktop Intelligence documents based on Stored Procedures from InfoView and in 3-tier mode Deski.
- The error message is "Connection or SQL sentence error: (DA0005) Exception:DBD, [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.State:01000" in 3-tier mode.
-
The error message in InfoView is "SetPrompts failed - Connection or SQL sentence error: (DA0005) Exception:DBD, [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.State:01000] The following data providers has not been successfully refreshed."
Read more...
Environment
- Business Objects Enterprise : XI 3.x
- Database : Microsoft SQL Server 2005
- Operating System : Windows Server 2008
Product
SAP BusinessObjects Enterprise XI 3.1
Keywords
State 01000, statement has been terminated, SetPrompts failed, DA0005, 3-tier mode , KBA , BI-RA-DKI , Obsolete - Desktop Intelligence , 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.