SAP Knowledge Base Article - Preview

1603399 - Deski report based on Stored Procedure gives the error "Exception:DBD, [Microsoft][ODBC SQL Server Driver][SQL Server]The statment has been terminated.State:01000" when refreshed in 3-tier mode and in InfoView.

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.