SAP Knowledge Base Article - Public

2950904 - Error "dberror(Connection.prepareStatement): 257 - sql syntax error: incorrect syntax near "EXISTS" - LOD-ANA-PL

Symptom

  • The model property "Data Locking" is set to ON
  • When importing data from a file with update method is "Clean and Replace", error "dberror(Connection.prepareStatement): 257 - sql syntax error: incorrect syntax near "EXISTS": line 1 col 330 (at pos 330)" happens.

Environment

SAP Analytics Cloud (SAC)

Reproducing the Issue

1) Open the model > Data Management > Import Data from a File > Excel

2) Complete the mappings

3) Sets the update method to "Clean and Replace"

Cause

This is a product defect.

Resolution

Issue is fixed on SAC version 2020.17.

See Also

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, ON, OFF, dberror , KBA , LOD-ANA-PL , Planning , Problem

Product

SAP Analytics Cloud 1.0