SAP Knowledge Base Article - Public

2458634 - SAP BusinessObjects Cloud gives "Table 'information_schema.columns' doesn't exist"


SAP BusinessObjects Cloud gives "An error occurred in Connection Server service: Table 'information_schema.columns' doesn't exist"



  • SAP BusinessObjects Cloud 2017.7.0 and later

Reproducing the Issue

  1. Connect to your SAP BusinessObjects Cloud tenant
  2. From the Main Menu click "Create > Model"
  3. Click "Use a datasource" and click "SQL Databases"
    • Connection Type: MySQL 5
    • Connection Name: Create New Connection
    • Connection Name: <ConnectionName>
    • Server: <Your MYSQL4 Server>:<Port>
    • Database: <Your Database>
    • User Name: <Your User>
    • Password: <Your Password>
  4. Attempt to add any table
  5. Notice the error


SAP BusinessObjects Cloud requires MYSQL version 5

MYSQL version 4 worked previously even though it was unsupported per System Requirements and Technical Prerequisites


Upgrade your MYSQL system to version 5 or higher or switch from a MYSQL4 to MYSQL5 system

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.


EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud, connecting, conecting, conectando, conexão, modelo, SBOC, MYSQL4, MYSQL5, table, object , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , Problem


SAP Analytics Cloud 1.0