SAP Knowledge Base Article - Public

2994464 - incorrect syntax near "CUR" when exporting Fact Data Only in SAP Analytics Cloud (SAC)


When choosing the "Fact Data Only" option to export the data for a Hana based Import model, you get the error

EPM_SERVICE : dberror(Connection.prepareStatement): 257 - sql syntax error: incorrect syntax near "CUR": line 1 col 113 (at pos 113) executeUpdate@/sap/fpa/services/core/db/CommonDbConnection.xsjslib:471 Connection.prototype.executeUpdate@/sap/fpa/services/core/db/DbConnection.xsjslib:289 RestExportModelHana.prototype._createTempTableFromOptions@/sap/fpa/services/modeling/exportModel/RestExportModelHana.xsjslib:259

Exporting with the option "Account Calculations and Fact Data" works without error


  • SAP Analytics Cloud (Enterprise) 2020.14.29

Reproducing the Issue

  1. Create new model based off of Hana Import
  2. Export it to Fact Data Only
  3. Get Error


This issue is currently under investigation by development.


This issue is currently under investigation by development.

See Also

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


SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped , KBA , LOD-ANA-DES , Model, Story Design & Visualizations , Problem


SAP Analytics Cloud 1.0