SAP Knowledge Base Article - Preview

2591534 - Unable to retrieve tables from remote source due to error: Cannot get remote source objects: Could not get tables - SAP HANA 1.0 smart data integration

Symptom

Following the creation of the remote source, while trying to retrieve tables the following error is seen

InternalError: dberror(CallableStatement.execute): 403 - internal error: Cannot get remote source objects: Could not get tables

The DP Agent trace shows:

A collation conflict between 'SQL_Latin1_General_CP1_CI_AS' and 'Latin1_General_BIN' in the INTERSECT operation
can not be resolved. Context: com.microsoft.sqlserver.jdbc.SQLServerException:

A collation conflict between 'SQL_Latin1_General_CP1_CI_AS' and 'Latin1_General_BIN' in the INTERSECT process
can not be resolved. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError (SQLServerException.java:197)


Read more...

Environment

  • DP Agent build version 1.3.13
  • MSSQL LogReader
  • All supported platforms

Product

SAP HANA 1.0 smart data integration

Keywords

KBA , HAN-DP-SDI , SAP HANA smart data integration (SDI) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.