3341874 - Recurring TSV_TNEW_PAGE_ALLOC_FAILED memory dumps for InfoCube 0SMPICHNL

Similar ST22 short dumps getting generated in the system:

Category               Resource Shortage
Runtime Errors         TSV_TNEW_PAGE_ALLOC_FAILED

Short Text
    No more memory available to add rows to an internal table.

What happened?
    An attempt was made to add rows to an internal table. There was no
    memory available for this however.

How to correct the error
    "TSV_TNEW_PAGE_ALLOC_FAILED"
    "SAPLRSM1" or LRSM1F08
    "RSM1_INIT_PARTTAB"

Source Code Extract
Line  SourceCde
 5657   call function 'RSSM_RSMDATASTATE_MAINTAIN'
 5658     exporting
 5659       i_infocube       = p_icube
 5660     changing
 5661       c_s_rsmdatastate = rsmdatastate_s
 5662     exceptions
 5663       error            = 1
 5664       others           = 2.
 5665   if sy-subrc = 0.
 5666     data: l_t_part like g_t_part occurs 0 with header line.
 5667     l_t_part[] = g_t_part[].
>>>>>     sort l_t_part by partnr ascending.

Contents of system fields
Name     Val.
SY-SUBRC 0
SY-INDEX 2
SY-TABIX 0
SY-DBCNT 0
SY-FDPOS 0
SY-LSIND 0
SY-PAGNO 0
SY-LINNO 1
SY-COLNO 1
SY-PFKEY
SY-UCOMM
SY-TITLE CPIC and RFC Control
SY-MSGTY
SY-MSGID
SY-MSGNO 000
SY-MSGV1
SY-MSGV2
SY-MSGV3
SY-MSGV4
SY-MODNO 0
SY-DATUM 20230605
SY-UZEIT 170512
SY-XPROG SAPLSMD_FUNC
SY-XFORM SMD_DATA_LOADER100

Active Calls/Events
No.   Ty.          Program                             Include                             Line
      Name
   12 FORM         SAPLRSM1                            LRSM1F08                             5668
      RSM1_INIT_PARTTAB
   11 FORM         SAPLRSM1                            LRSM1U23                              209
      RSSM_UPDATE_RSMDATASTATE
   10 FUNCTION     SAPLRSM1                            LRSM1U23                              155
      RSSM_UPDATE_RSMDATASTATE
    9 FUNCTION     SAPLRSSM                            LRSSMU04                               64
      RSSM_APO_START_POSTPROCESSING
    8 FUNCTION     SAPLRSSM                            LRSSMU26                              360
      RSSM_APO_REQUEST_FINISH
    7 METHOD       CL_RSDRI_INFOCUBE=============CP    CL_RSDRI_INFOCUBE=============CM00H   165
      CL_RSDRI_INFOCUBE=>_WRITE_PACKAGE
    6 METHOD       CL_RSDRI_INFOCUBE=============CP    CL_RSDRI_INFOCUBE=============CM00D    18
      CL_RSDRI_INFOCUBE=>WRITE_PACKAGE
    5 FUNCTION     SAPLRSDRI_DBA                       LRSDRI_DBAU02                          87
      RSDRI_CUBE_WRITE_PACKAGE
    4 FUNCTION     SAPLSMD_FUNC                        LSMD_FUNCU04                         1093
      SMD_DATA_LOADER100
    3 FORM         SAPLSMD_FUNC                        LSMD_FUNCU04                            1
      SMD_DATA_LOADER100
    2 FORM         SAPMSSY1                            SAPMSSY1                              851
      REMOTE_FUNCTION_CALL
    1 MODULE (PBO) SAPMSSY1                            SAPMSSY1                               35
      %_RFC_START

P_ICUBE
    0SMPICHNL

And the check in the RSMDATASTATE_EXT table shows that the 0SMPICHNL InfoCube has much higher value than 1000 in the REQUESTS_ALL field.

SAP NetWeaver 7.4

SAP Solution Manager

0SMPICHNL, P_ICUBE, I_DTA, RSMDATASTATE, SAPLRSS2, LRSS2U41, RSS2_CHECK_DM_FOR_VALID_SID , KBA , BW-WHM-DST , Data Staging , BW-WHM-DBA-ICUB , InfoCubes , SV-SMG-MON-IPO-PI , PI Monitoring , How To