Current Position:Home > Short Dump while Complete deletion of data Contents from a Cube.

Short Dump while Complete deletion of data Contents from a Cube.

Update:10-11Source: network consolidation
Advertisement
Hello Experts,
I am facing a runtime Short dump whenever i attempt to delete data from a Cube. Shown Below:-
Runtime Errors         MESSAGE_TYPE_X
Error analysis
    Short text of error message:
Data request to the OLTP
    Long text of error message:
    Technical information about t
    Message class....... "RSM"
    Number.............. 000
    Variable 1.......... " "
    Variable 2.......... " "
    Variable 3.......... " "
    Variable 4.......... " "
How to correct the error
    Probably the only way to eliminate the error is to correct the program.
    If the error occures in a non-modified SAP program, you may be able to
    find an interim solution in an SAP Note.
    If you have access to SAP Notes, carry out a search with the following
    keywords:
    "MESSAGE_TYPE_X" " "
    "SAPLRSM1" or "LRSM1U43"
    "RSSM_UPDATE_RSBKREQUEST"
Information on where terminated
    Termination occurred in the ABAP program "SAPLRSM1" - in
     "RSSM_UPDATE_RSBKREQUEST".
    The main program was "RSAWBN_START ".
    In the source code you have the termination point in line 117
    of the (Include) program "LRSM1U43".
Line  SourceCde
   87   call function 'RSSTATMAN_GET_TYPE_FOR_DTA'
   88     exporting
   89       i_dta  = l_dta
   90     importing
   91       e_type = l_dta_type
   92     exceptions
   93       error  = 1
   94       others = 2.
   95   if sy-subrc <> 0.
   96     message id sy-msgid type sy-msgty number sy-msgno
   97             with sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
   98   endif.
   99   call function 'RSSTATMAN_DELETE_STATUS'
  100     exporting
  101       i_dta      = l_dta
  102       i_dta_type = l_dta_type
  103       i_process  = 'ALL'.
  104
  105   sort l_t_iccont by rnsidlast ascending.
  106   loop at l_t_iccont.
  107     data: l_s_reqdone like rsreqdone.
  108     select single * from rsreqdone into l_s_reqdone where
  109            rnr = l_t_iccont-rnr.
  110     if sy-subrc <> 0.
  111       read table l_h_dtpreq with key
  112            requid = l_t_iccont-rnsidlast.
  113       if sy-subrc = 0 and
  114          ( l_h_dtpreq-ustate = '0' or l_h_dtpreq-tstate = '0' ).
  115         clear l_s_reqdone-archived.
  116       else.
>>>>>         message x000.
   118       endif.
  119     endif.
  120     if l_s_reqdone-archived <> rs_c_false.
  121       call function 'RSREQARCH_RELOAD_REQUEST'
  122         exporting
  123           i_rnr         = l_t_iccont-rnr.
  124     endif.
  125     select single * from rsbkrequest into l_s_req where
  126            requid = l_t_iccont-rnsidlast.
  127     if sy-subrc <> 0.
  128       continue.
  129     endif.
  130
  131     read table l_h_rsbkdtp with table key
  132          dtp = l_s_req-dtp.
  133     if sy-subrc <> 0.
  134       l_h_rsbkdtp-dtp = l_s_req-dtp.
  135       insert table l_h_rsbkdtp.
  136     endif.
This issue only exists in Production system not QTY or development thr Cube deletion is working fine.
So far I have tried Deleting Index's and then deleting the Cube Contents & Run Elementary Checks from RSRV but not find any lead yet.Also unable to find appropriate notes for this issue aswell I am using SAP_Bw comp 700 with SP26.
Any suggestion  would be of great help .
Thanks & Regards
Aman

The Best Answer

Advertisement
Hi Ap_SAP & Arvind,
Any recent upgrades or system refresh done?
In recent update just from SP24 to SP26 was updated and a DB stats Referesh was carried on.But this proublem existed before these activities.
Except deleting can you able to perform all other operations like loading data..etc?
Other than deletion I am able to do load data into cube extract from R3 and also i can delete data from PSA.Only deletion giving dump.
You are trying to delete transactional or master data.
I am tring for transaction data.
WHen I try to delete request by request it also lead to the same short dump.
@ arvind : I checked Sm12 there i see not table which has been locked.
Thanks
Aman
  • Short Dump while Complete deletion of data Contents from a Cube. Update:10-11

    Hello Experts, I am facing a runtime Short dump whenever i attempt to delete data from a Cube. Shown Below:- Runtime Errors         MESSAGE_TYPE_X Error analysis     Short text of error message: Data request to the OLTP     Long text of error message

  • Short dump while changing the end date of infotype 0167 through PA30 Update:10-11

    Hi all, I am getting short dump while changing the end date of infotype 0167(Health Plans) through Tcode PA30. dump descript is as below An exception occurred that was not caught. Runtime Errors         UNCAUGHT_EXCEPTION Except.                CX_HR

  • Short Dump Error in deleting the Init request Update:10-11

    Hi Gurus,   i am loading master data from sap r3 by init update. now due to some requirement i have to delete the init request , but when i try to delete the request it goes to short dump and gives the error message as Runtime Errors         MESSAGE_

  • Short Dump Error while loading master data. Update:10-11

    Hello All, I am trying to load data from PSA to Info Object (0Material_Attr) via DTP, I am getting error and itu2019s giving the short dump. Runtime Errors UNCAUGHT_EXCEPTION Exception CX_RSR_X_MESSAGE. "UNCAUGHT_EXCEPTION" "CX_RSR_X_MESSAG

  • Short dump when trying to Select date in Field Update:10-11

    Hi, I created generic data source based on Function Module. I went to RSA3 to test the extraction and I got this error message when I tried to enter a date as input selection in date field or any other selection field If I test the extraction without