SAP Knowledge Base Article - Public

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

Symptom

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

Environment

  • 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

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

See Also

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

Keywords

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

Product

SAP Analytics Cloud 1.0