1680812 - Error message "Request Processing Failed (XLS 000009) The specified DSN contains an architecture mismatch between the driver and the application" in Dashboard Designer 4.0

SAP Knowledge Base Article - Public

1680812 - Error message "Request Processing Failed (XLS 000009) The specified DSN contains an architecture mismatch between the driver and the application" in Dashboard Designer 4.0

Symptom

Error message "Request Processing Failed (XLS 000009) The specified DSN contains an architecture mismatch between the driver and the application" is received in Dashboard Designer 4.0 when .Unx based on SQL server 2008 is refreshed in Query Browser.

Environment

  • SAP BusinessObjects BI 4.0 SP02
  • Dashboard Designer 4.0 SP02
  • SQL Server 2008 64 bit

Reproducing the Issue

  1. Convert a .Unv universe based on SQL server 2008(64 bit) into .Unx in Information Designer Tool.
  2. Open Dashboard Designer 4.0 client and select the Query Browser option.
  3. Select the Converted .Unx universe from the list of Universes.
  4. Drag an object to the result objects pane and click Next. Error Message appears. 

Cause

Connection of the converted universe is based on a 32 bit DSN  SQL driver causing the architectural mismatch between driver and applications.

For Refreshing the universe content and fetching the data from the Data source a 64 bit DSN driver connection is required.

Resolution

Create a new DSN using 64 bit SQL Server Native Client driver on the same machine having name similar to a 32 bit connection.

Keywords

Query Browser,SQL server,DSN,XLS000009 , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Dashboards software 4.0