SAP Knowledge Base Article - Preview

1694933 - How to prevent hanging of on-demand Web Intelligence document refresh reporting off a multisource UNX Universe?


  • A Web Intelligence document is reporting off of a multisource UNX Universe.
  • The Web Intelligence document is refreshed on-demand in BI launchpad.
  • Watching the SQL query running in the Data Federation Administration tool, the total query takes 10 minutes or longer to complete.
  • The Web Intelligence Processing Server may resend the SQL query multiple times.
  • The Web Intelligence document appears to 'hang' in BI launchpad, until the HTTP Session times out.
  • Tracing the Web Intelligence Processing Server, there is an error message that appears 10 minutes after the query is sent to the Data Federator Service, with the message:

    **ERROR:C3_dacs:CS::Error (in cancel): (DBD) "[Data Federator Driver] [Server] Statement was canceled. | [Data Federator Driver] [Server] The query has been canceled" . [kc3cdbtbdacs.cpp;3395]
  • The Web Intelligence document may be refreshed successfully in the Web Intelligence Desktop tool.
  • The Web Intelligence document may be scheduled successfully.



SAP BusinessObjects Business Intelligence platform 4.0


KBA , BI-RA-WBI-DSL , Obsolete, use : BI-RA-WBI-BE-DP , BI-RA-WBI , Web Intelligence , 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.