How to resolve the error : "Unable to cast COM object of type 'System._ComObject' to interface type 'SWL.SpcExtension.ExternalDatabaseConnection'. This operation failed because the QueryInterface call on the COM" encountered in Spotfire Statistica

How to resolve the error : "Unable to cast COM object of type 'System._ComObject' to interface type 'SWL.SpcExtension.ExternalDatabaseConnection'. This operation failed because the QueryInterface call on the COM" encountered in Spotfire Statistica

book

Article ID: KB0137496

calendar_today

Updated On:

Products Versions
Spotfire Statistica 14.x

Description

Cause of this error:

  1. This error occurs when an ADO.NET connection is created in the source database and set as the default connection for DES. Then, during the migration of a DC, the same error appears.

    image.png

  2. Default database connection in Data Entry section:

image.png

3. After this, when attempting to migrate the Data Configuration the following error occurs:  

image.png

Environment

Windows (OS)

Resolution

The resolution for the above error is as below:

  1. Change the default database from ADO .NET to an OLE DB, i.e. the connection to the Enterprise meta database should be OLE DB, and the Data Configuration will be migrated successfully.

    image.png

Issue/Introduction

While migrating the Data Configuration, if we encounter the error below, the following steps mentioned in resolution section resolves the error.

Error: An exception occured during the operation assigning data connection: Unable to cast COM object of type 'System._ComObject' to interface type 'SWL.SpcExtension.ExternalDatabaseConnection'.This operation failed because the QueryInterface call on the COM

image.png

Powered by Wolken Software