SAP Knowledge Base Article - Public

3563214 - [ERROR] (DBMAN-099) error happens when running BW import job in SAC

Symptom

When running BW import job in SAC by using cloud agent 1.0.411, the below error happens:

[ERROR] (DBMAN-099) Olap temporary data size exceeded 31/32 bit limit.

Environment

  • SAP Analytics Cloud 2024.21.14 

Reproducing the Issue

  1. Use SAC Cloud Agent  2024.21.14 version.
  2. Create a import model job based on BW.
  3. Refresh the job and confirmed the below error in cloud agent trace:
    com.sap.fpa.cloud.rest.bw.QueryException: ERROR_FETCHING_DATA   [ERROR] (DBMAN-099) Olap temporary data size exceeded 31/32 bit limit;XXXXXXX refs in 43 columns/[Request Info: Object Name = "XXXX"."XXXXXXXXX", FM ...       [ERROR] (DBMAN-099) Name = XXXXXX]  [ERROR] (DBMAN-901) Error 2,724 has occurred in the XXXX/SAP HANA server 

This issue doen not happen if roll back the cloud agent version to 1.0.383.

Cause

This issue is currently under investigation of development team.

Resolution

This issue is currently under investigation of development team.

See Also

  • KBA 2154870 - How-To: Understanding and defining SAP HANA Limitations
  • KBA 2000002 - FAQ: SAP HANA SQL Optimization
  • SAP Note 2704926 - Index creation on partitioned CS table fails with error "Olap temporary data size exceeded 31/32 bit limit"

Keywords

OLAP, limitation, hana, hana 1.0, hana 2.0, optimization, 2048, [2724] Olap temporary data size exceeded 31/32 bit limit, column store error: search table: error , KBA , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Problem

Product

SAP Analytics Cloud 1.0