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

This issue is currently under investigation by Development.

Resolution

This issue is currently under investigation by Development.

Workaround

Create a query with freehand SQL option.

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