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.

KBA , BI-RA-WBI-DSL , Obsolete, use : BI-RA-WBI-BE-DP , BI-RA-WBI , Web Intelligence , Problem