SAP Knowledge Base Article - Preview

1527691 - Setprompt failed - Connection or SQL sentence error (DA0005) [Exception DBD [Microsoft][ODBC Microsoft] when refreshing report with prompt in Business Objects Release 3 Service Pack 2

Symptom

  • Impossible to refresh report after migrated from service pack 2 to service pack 3
  • Error : '"Setprompt failed - Connection or SQL sentence error (DA0005) [Exception DBD [Microsoft][ODBC Microsoft
    Access Driver] Syntax error (comma) in query expression '( sum(shop_facts.Amount_sold) >= 7,5)' State:42000] The
    following data providers have not been successfully refreshed: Query with (report name) (DMA0007)'
  • Error INF showing when trying to edit the report


Read more...

Environment

  • Windows 2003
  • Business objects XI 3.1 sp3 onwards

Product

SAP BusinessObjects Enterprise XI 3.1

Keywords

KBA , BI-RA-DKI , Obsolete - Desktop Intelligence , Bug Filed

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.