IBM Support

"Could not execute TI process:Dim1_ExtDimProcess ... [ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application" when publishing FAP

Troubleshooting


Problem

Customer has installed and configured FAP. All of the connections work, and user can connect to, launch, and configure FAP. However, when user tries to publish data to TM1, user receives an error.

Symptom

IBM Cognos Controller Financial Analytics Publisher - 'Logs' section

    Description: Could not execute TI process:Dim1_ExtDimProcess

tm1server.log (located on the TM1 server)
    2000 [3] INFO 2012-01-23 15:37:20.203 TM1.Process Process "Dim1_ExtDimProcess" executed by user "Admin"
    2000 [3] ERROR 2012-01-23 15:37:20.203 TM1.SQLAPI IM014[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
    2000 [3] ERROR 2012-01-23 15:37:20.203 TM1.SQLAPI E16) Cannot connect to ODBC data source "FAP" IM014[Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application.
    2000 [3] ERROR 2012-01-23 15:37:20.203 TM1.SQLAPI 08003[Microsoft][ODBC Driver Manager] Connection not open
    2000 [3] ERROR 2012-01-23 15:37:20.203 TM1.Process Process "Dim1_ExtDimProcess": : Execution was aborted. Error file: <TM1ProcessError_20120123153720_Dim1_ExtDimProcess.log>

TM1ProcessError_<date>_Dim1_ExtDimProcess
    Error: Prolog procedure line (0): Unable to open data source "FAP".

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"8.5.1;8.5;10.1","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
08 May 2025

UID

swg21578925

Page Feedback