SAP Knowledge Base Article - Public

3644666 - Unknown error occurs when validating Google BigQuery or Microsoft SQL Server connection in SAP Datasphere

Symptom

Error is raised during validation of Google Big Query or Microsoft SQL Server connection created in SAP Datasphere:

Data Flows: Cause: Open request could not be performed due to error: Unknown error
Replication Flows: Cause: Open request could not be performed due to error: Unknown error 

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 

Environment

SAP Datasphere

Reproducing the Issue

Executing "Validate" in Connections in SAP Datasphere.

Cause

The issue is caused by the Datasphere synchronization problem.

Resolution

Re-sync the third-party drivers, even there are no third-party drivers uploaded in the Datasphere system:

In Datasphere tenant, go to System -> Configuration -> Data Integration -> Third-Party Drivers -> Click on "Sync".

    Keywords

    Datasphere, SAP integration, Connection validation error, Google Big Query, Microsoft SQL Server, data flow, replication flow, unknown error , KBA , DS-DI-CON , Connections , Problem

    Product

    SAP Datasphere all versions