SAP Knowledge Base Article - Public

2693169 - Case sensitive SQL database returns Connection Server error in SAP Analyitcs Cloud (SAC)

Symptom

  • Following error is shown when adding a table by drag and drop into the query:
    • "An error occurred in Connection Server service: Invalid object name '<table_name>.information_schema.table_constraints' "
  • Freehand SQL does not bring any error when defining the case sensitive SQL query.
  • Error happens only on case sensitive database.

Environment

  • SAP Analytics Cloud 2018.15.3

Reproducing the Issue

  1. Create a query to a case sensitive database.
  2. Drag and drop tables you would like to consume in SAC.
  3. Observe the error

Cause

Defect in Data Acquisition Agent when using collation insensitivity in the database.

Resolution

This issue is planned to be fixed by releasing the next SAP Analytics Cloud Agent version mid. November.

Workaround

Changing the collation of the SQL Database fixes the problem.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, sql, Invalid object name, freehand, table, Connection Server , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0