SAP Knowledge Base Article - Preview

2482203 - Error DBSQL_TABLE_UNKNOWN occurs when adding a hierarchy or running UJA_REFRESH_DIM_CACHE - BPC NW

Symptom

The following dump occurs when adding a hierarchy of a dimension or running program UJA_REFRESH_DIM_CACHE:

Category Installation Errors
Runtime Errors DBSQL_TABLE_UNKNOWN

Short Text
Table is unknown or does not exist.

Error analysis
In an SAP Open SQL statement, a table is specified that either does not
exist on the database, or that is not known to the ABAP Data
Dictionary.
This is table "/1CPMB/UOIY0EZ", or another table which the statement wants to
access. The database has returned SQL code "SQL code: 259" with the error text
"SQL message: invalid table name: Could not find table/view /1CPMB/UOIY0EZ

"DBSQL_TABLE_UNKNOWN"
"CL_UJAM_HIERARCHY_STORE=======CP" bzw. CL_UJAM_HIERARCHY_STORE=======CM00C
"IF_UJAM_HIERARCHY_STORE~GET_MAX_DEPTH"


Read more...

Environment

  • SAP BusinessObjects Planning and Consolidation 10.0, version for SAP NetWeaver
  • SAP BusinessObjects Planning and Consolidation 10.1, version for SAP NetWeaver
  • SAP Business Planning and Consolidation 11.0, version for SAP BW/4HANA 1.0
  • SAP Business Planning and Consolidation 11.1, version for SAP BW/4HANA 2.0
  • SAP Business Planning and Consolidation 2021, version for SAP BW/4HANA 2021 

Product

SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver ; SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver ; SAP Business Planning and Consolidation 11.0, version for SAP BW/4HANA ; SAP Business Planning and Consolidation 11.1, version for SAP BW/4HANA ; SAP Business Planning and Consolidation 2021, version for SAP BW/4HANA

Keywords

EPM, BPC NW, Business Planning and Consolidation for NetWeaver, SAP BPC FOR NetWeaver, CL_UJAM_HIERARCHY_STORE=======CP , ENTITY Dimension , Hierarchy Master data , Error , Dump , process Dimension , KBA , EPM-BPC-NW , NetWeaver Version , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.