SAP Knowledge Base Article - Preview

3038366 - Activation of requests in huge aDSO-s fails

Symptom

The request activation in an Advanced DataStore Object fails with one of the following symptoms:

  • RSODSO_PROCESSING094 Error during in-memory activation
    SQL Code:129
    SQL Text: transaction rolled back by an internal error
    transaction rolled back by an internal error: fail ed to activate dso with persisted changelog: [41002] numeric value out of range: exceed the number of the parameters
  • RSDRI_HDB002 exceed the number of the parameters
  • RSODSO_IMOACT000 Serious error occurred: numeric value out of range: exceed the number of the parameters
  • "TSV_TNEW_PAGE_ALLOC_FAILED" dump in "CL_RSPM_PERSISTENCY_STANDARD==CP" bzw. CL_RSPM_PERSISTENCY_STANDARD==CM00C "IF_RSPM_QUERY_RETRIEVE~QUERY_REQUEST"

The activation process tries to activate more than ~10.000 Requests in one go. This can happen usually in planning scenarios (BPC), where data is regurarly written to the aDSO but no activation/cleanup is performed for a long time.


Read more...

Environment

  • SAP NetWeaver 7.50
  • SAP BW/4HANA 1.00
  • SAP BW/4HANA 2.00

Product

SAP BW/4HANA 1.0 ; SAP BW/4HANA 2.0 ; 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 NetWeaver 7.5

Keywords

RSODSO_PROCESSING 094, RSDRI_HDB 002, RSODSO_IMOACT 000, CL_RSPM_PERSISTENCY_STANDARD, RSPM_HOUSEKEEPING, housekeeping, BPC, /CPMB/, BPC, Lite Optimize, Lite Optimization, , KBA , BW4-DM-ADSO , DataStore Object (Advanced) , BW-WHM-DBA-ADSO , DataStore Object (advanced) , EPM-BPC-NW , NetWeaver Version , EPM-BPC-BW4 , BPC/4 , Problem

About this page

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

Search for additional results

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