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.

Document ID : KB000053344
Last Modified Date : 14/02/2018
Show Technical Document Details

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.