search cancel

Error "[Exception: DBD [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specifiedState:IM002] A connection required to refresh this document is unavailable(DA0004)" when refreshing the reports after changing the date.


Article ID: 53344


Updated On:


SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service CA Service Desk Manager CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager


Business Query cannot refresh a query because the universe has been moved to a different repository or domain, without a change in name. Business Query can no longer find this universe or the associated connection. As changing source is not possible with Business Query, you must do the following:

  1. Open the .bqy file.
  2. Edit the query, and press Run (don't just refresh the data provider).
  3. Save the query as a .bqy file using the same name as before.

The Business Query then points to the correct universe and connection.

Also, this error may occur if you may be attempting to refresh a document based on an outdated or invalid universe in the repository. The designer of the universe should export a new version of the universe to the repository. Try refreshing the document once again.


Component: SDBOXI