3718571 - Error in Replication Flow without any further information

Error occurs when attempting to import source table from Microsoft Azure SQL Database connection as source for replication flow in Datasphere.

SAP Datasphere

Below details are shown in the network trace - Response - while reproducing the issue:

{
    "code": "getMetadataReplicationFlowFailed",
    "details": {
        "stack": "See correlation id ...
        "message": "ReplicationFlowRequestError: [ReplicationFlow] Failed to fetch the data from server. Error in getCSNDefininitionFromCFW. Get Metadata Failed: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve collation conflict between \"SQL_Latin1_General_CP1_CI_AS\" and \"SQL_Latin1_General_CP1_CI_AI\" in UNION ALL operator occurring in ORDER BY statement column 3. "
    }
}

• The issue seems originating from the Database side and MSSQL experts should be able to address it accordingly.
• Request Microsoft SQL Server team to review this issue using the following documentation:
   https://learn.microsoft.com/en-us/sql/relational-databases/collations/set-or-change-the-database-collation?view=sql-server-2017&tabs=ssms

"Cannot resolve collation conflict", sql, azure, replication flow , KBA , DS-DI-RF-UI , Replication Flow editor, monitoring and deployment , Problem