Dump CX_RSR_X_MESSAGE during 3.x load into InfoCube

Problem During 3.x load into InfoCube (DataSource -> PSA -> InfoCube), loading status stays in the yellow status. Looking into ST22, the following short dump comes up with the exception CX_RSR_X_MESSAGE. Diagnosis The data update was not finished. A short dump has probably been logged in BI. This provides information about the error. System Response “Caller...

How to debug dynamically called program in background?

There might be a problem when you need to debug such a program, because you never know, when your code will be called.Here is the trick:     DATA: lv_counter TYPE i. *   Call neverending loop in your code    WHILE lv_counter = 0.           “this will stop, when you change lv_counter            “to s/thing else in debugger    ...

How to get database size in DB6 using ABAP

After long research of searching function modules,... here is the example:      DATA lt_db6 TYPE STANDARD TABLE OF db6pmdb02. FIELD-SYMBOLS: <ls_db6> LIKE LINE OF lt_db6.  CALL FUNCTION 'DB6_HIS_OVERVIEW'* EXPORTING* CONNECTION = TABLES it_db6pmdb02 = lt_db6 EXCEPTIONS no_history_found = 1 invalid_parameter_set = 2 adbc_error = 3 system_error = 4 OTHERS = 5.  READ TABLE lt_db6...

How to delete BW Query from ABAP code?

BW Query is stored as component(reusable element) in database table RSZCOMPDIR. To delete it, you need to search for query’s component UID (COMPUID) for existing query’s technical name saved in COMPID field. DATA: lv_compuid TYPE sysuuid_25, lv_subrc TYPE sysubrc. CALL FUNCTION ‘RSZ_X_COMPONENT_DELETE’  EXPORTING   i_compuid = lv_compuid          “hashed UID   i_delete_variables = rs_c_false “delete all related variables ...

How to debug BEx (Query designer)

To be able to debug external application, which uses RFC functions, you have to use external degugging. Sometime, this external breakpoint does not work. If so, firstly start RSRTRACE transaction, and now the breakpoint will work. QD uses class CL_RSZA_QUERY and its methods.Method that loads the query -> LOAD_QUERY (FM that loads the query element...

BEx Query designer – Introduction

Helpful presentations for BEx beginners Overview:Unit 1 – Introduction to BW ReportingUnit 2 – First steps in query designerUnit 3 – Restricted and Calculated Key figuresUnit 5 – Query variablesUnit 6 – Query propertiesariablesUnit 7 – Exceptions and conditions To see full screen presentations, click on provided link before each presentation Unit 1 – Introduction...

Exception condition “INCONSISTENCY” raised.

 I have encountered this error after saving Query using ABAP FM (usually you do this using Query Designer) The case is usually that in database tables are still stored some referencies for elements (RSZELTXREF), that are not present in element table (RSZELTDIR) To find out, where is the problem, run ANALYZE_RSZ_TABLES program through SE80 or SE38....