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

  • Delete the data content for one InfoObject in processchain Update:11-30

    Hi Guys, We have requirement to delete the data content for one InfoObject in processchain(daily) .We made this infoObject as InfoProvider. Could you please tell me is there any function module or abap program or any other alternative to do this and

  • I want to delete the data content for InfoObject in processchain Update:11-30

    Hi Guys, We have requirement to delete  the data content for one InfoObject in processchain(daily) .Could you please tell me is there any function module or abap program or any other alternative to do this and which can be added to processchain. Than

  • I am trying to delete the data from the info cube. Update:11-30

    Hi All,            i am trying to delete the data from the info cube.in cube reporting symbol is availble.when i click on delete button delete symbol is coming again when i click on refresh button request is not deleting .please give me solution . Th

  • 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 in BIW 7.0 business content installation Update:11-30

    Dear Friends, I am trying to install business content in BIW 7.0 . In RSA1  ->BI Content --> Object Types > Query Elements> Grouping data flow before ---> Install. Once I start this installation process it gives short dump. The dump says Sh

  • 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 -Email on vendor Master data is same as of contact person(CRM_IC Update:11-30

    Hi Guru's I am working CRM IC Webclient, A short Dump is generated when the e-mail address ( Remittance) on the vendor Master record in the CRM is the same as on the contact partner Error 1) An error occured during event processing in view Bupasearch

  • 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