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
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.