SAP Knowledge Base Article - Public

3045093 - Error when trying to save a custom property of type 'Integer' for Version dimension in SAP Analytics Cloud for Planning (SAC)

Symptom

Attempting to add a custom property of type "Integer" to a Version dimension results in error:

InternalError: dberror(PreparedStatement.executeUpdate): 491 - invalid EPM Model definition: Session (user: '_SYS_EPM', schema: '_SYS_EPM', model: '$VALIDATION$', version: '42')
PDC (id: '0', name: 'mainPDC')
Algorithm (id: 'extend_to_cube_structure', name: 'transform PDC for query')
Operation (id: 'extend_structure', name: 'extend to cube structure'):
const mapping value '' cannot be converted to data type field Version.YearUsed
Correlation ID: 27045459-1742-4242-9303-338556393392

Environment

  • SAP Analytics Cloud (Enterprise) 2021.08.01

Reproducing the Issue

  • Open any Planning type model.
  • Go to Version dimension and add a custom property of type "Integer".
  • Save.
  • Error will occur.

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, Sac, Acquisition, Model, Connect, Story, Tenant, Import, Failed, Using, Working , KBA , LOD-ANA-PL , Planning , Problem

Product

SAP Analytics Cloud 1.0