SAP Knowledge Base Article - Public

3457198 - Execution of algorithm failed: SQL prepare statement failed with error 259: invalid table name: Could not find table/view sap.fpa.service.dataLocking, when editing planning data from a story.

Symptom

  • When editing the data in the cells in a story, the error message containing the followings is generated. 

"EPM:... Execution of algorithm failed: SQL prepare statement failed with error 259: invalid table name: Could not find table/view sap.fpa.service.dataLocking:.... at SQLFrontned/SQLPrepprocessor/Rules/Impl/TableValidation.cpp:237(1000013)....
Correlation ID: xxxxxxxxxxxxx"

  • No data can be submitted into the model with the same error.
  • There is no data locking settings configured in the model. 

Environment

SAP Analytics Cloud (Enterprise)

Reproducing the Issue

  • Importing a data locking (DL) object alone, without importing the model. 

Cause

  • This is a product issue. 

Resolution

  • It is resolved in version 2024.10.
  • The interim workaround is redeploying the model(Redeploy option in the model preferences).

Keywords

dataLocking, Data locking, cannot edit, cannot submit, planning data, EPM error, data entry booked and unbooked, SQL prepare statement failed with error 259, invalid table name, could not find table, view , KBA , LOD-ANA-PL-DLK , Data Locking , Known Error

Product

SAP Analytics Cloud all versions