This website is not affiliated with, sponsored by, or approved by SAP AG.

DDIF_NAMETAB_GET error when deleting objects via transport

Business Warehouse

Moderators: Snowy, thx4allthefish

DDIF_NAMETAB_GET error when deleting objects via transport

Postby pruuostpj » Tue Feb 08, 2011 6:22 am

Dear all,
when importing a transport request in which several types of BI objects are deleted (Infocubes, DSO's, transformations, routines, DTP's, query elements, infosets, process chains) the import terminates with return code 12 due to an uncaught exception.

This only happens when transporting from acceptance to production. Transporting from development to acceptance did not raise this exception.

The ST22 dump (see below) refers in the "contents of system fields" section to a DSO, and to post-import activities. The DSO and the associated tables could not be found (rsa1 & se16), since they are deleted as desired.

Some of the relevant notes that I have found do refer to DSO related problems, but they all indicate to install SP19 which we already have installed (BW 7.0 Patch Level 23)

Could you please assist in pointing out potential solutions based on the information from the ST22 Runtime Error below?

Kind regards,
PJ


    Runtime Errors UNCAUGHT_EXCEPTION
    Except. CX_RS_PROGRAM_ERROR
    Date and Time 08.02.2011 10:48:14
    ------------------------
    Short text
    An exception occurred that was not caught.
    ------------------------
    What happened?
    The exception 'CX_RS_PROGRAM_ERROR' was raised, but it was not caught anywhere
    along the call hierarchy.

    Since exceptions represent error situations and this error was not
    adequately responded to, the running ABAP program
    'CL_RSDD_DS====================CP' has to be
    terminated.
    ------------------------
    Error analysis
    An exception occurred which is explained in detail below.
    The exception, which is assigned to class 'CX_RS_PROGRAM_ERROR', was not caught
    and therefore caused a runtime error.
    The reason for the exception is:
    Error in BW: Error in DDIF_NAMETAB_GET
    ------------------------
    How to correct the error
    If the error occurs 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:
    "UNCAUGHT_EXCEPTION" "CX_RS_PROGRAM_ERROR"
    "CL_RSDD_DS====================CP" or "CL_RSDD_DS====================CM001"
    "APPEND_DS_TEC_FIELDS"
    ------------------------
    System environment
    SAP-Release 700

    Application server... "dp1ci"
    Network address...... "<removed>"
    Operating system..... "HP-UX"
    Release.............. "B.11.23";
    Hardware type........ "ia64"
    Character length.... 16 Bits
    Pointer length....... 64 Bits
    Work process number.. 45
    Shortdump setting.... "full"

    Database server... "spisap02"
    Database type..... "ORACLE"
    Database name..... "DP1"
    Database user ID.. "SAPBIW"

    Terminal................. " "

    Char.set.... "C"

    SAP kernel....... 700
    created (date)... "Dec 14 2009 20:47:35"
    create on........ "HP-UX B.11.23 U ia64"
    Database version. "OCI_102 (10.2.0.1.0) "

    Patch level. 236
    Patch text.. " "

    Database............. "ORACLE 10.1.0.*.*, ORACLE 10.2.0.*.*, ORACLE 11.2.*.*.*"
    SAP database version. 700
    Operating system..... "HP-UX B.11";

    Memory consumption
    Roll.... 5979936
    EM...... 0
    Heap.... 1459888
    Page.... 40960
    MM Used. 6988880
    MM Free. 415648
    ------------------------
    User and Transaction
    Client.............. 000
    User................ "DDIC"
    Language key........ "E"
    Transaction......... " "
    Transactions ID..... "4D5111661004210BE10000000AFA2502"

    Program............. "CL_RSDD_DS====================CP"
    Screen.............. "SAPMSSY0 1000"
    Screen line......... 6
    ------------------------
    Information on where terminated
    Termination occurred in the ABAP program "CL_RSDD_DS====================CP" -
    in "APPEND_DS_TEC_FIELDS".
    The main program was "RDDEXECU ".

    In the source code you have the termination point in line 61
    of the (Include) program "CL_RSDD_DS====================CM001".
    The program "CL_RSDD_DS====================CP" was started as a background job.
    Job Name....... "RDDEXECL"
    Job Initiator.. "DDIC"
    Job Number..... 10475900
    ------------------------
    Source Code Extract
    Line SourceCde
    31 RAISE EXCEPTION TYPE cx_rs_program_error
    32 EXPORTING
    33 text = 'Invalid DSO subtype'. "#EC NOTEXT
    34 ENDCASE.
    35
    36 * get table name from DDIC
    37 CALL METHOD cl_rsd_odso=>get_tablnm
    38 EXPORTING
    39 i_odsobject = n_infoprov
    40 i_tabt = l_tab
    41 IMPORTING
    42 e_tablnm = l_tablnm
    43 EXCEPTIONS
    44 OTHERS = 1.
    45
    46 IF sy-subrc <> 0.
    47 RAISE EXCEPTION TYPE cx_rs_program_error
    48 EXPORTING
    49 text = 'Error in CL_RSD_ODSO=>get_Tablnm'. "#EC NOTEXT
    50 ENDIF.
    51
    52 CALL FUNCTION 'DDIF_NAMETAB_GET'
    53 EXPORTING
    54 tabname = l_tablnm
    55 TABLES
    56 dfies_tab = l_t_comp
    57 EXCEPTIONS
    58 not_found = 1
    59 OTHERS = 2.
    60 IF sy-subrc <> 0.
    >>>>> RAISE EXCEPTION TYPE cx_rs_program_error
    62 EXPORTING
    63 text = 'Error in DDIF_NAMETAB_GET'. "#EC NOTEXT
    64 ENDIF.
    65
    66
    67 ELSE.
    68 * model table only needed for standard datastore objects, for
    69 * write optimized DSOs target table is a changelog that is fully described by
    70 * dta_pro (infoobjects)
    71 CHECK n_s_dta-odsotype = rsdod_c_type-standard.
    72
    73 * get model table fields to add
    74 CALL METHOD cl_rsd_odso=>get_mod_tab
    75 IMPORTING
    76 e_mod_fld_ur = l_t_comp.
    77 ENDIF.
    78
    79 * according to T.B. ( 13.04.2007) the correct position is
    80 * not needed in the D version
    ------------------------
    Contents of system fields
    Name Val.
    SY-SUBRC 0
    SY-INDEX 0
    SY-TABIX 1
    SY-DBCNT 1
    SY-FDPOS 0
    SY-LSIND 0
    SY-PAGNO 0
    SY-LINNO 1
    SY-COLNO 1
    SY-PFKEY
    SY-UCOMM
    SY-TITLE Execute Post-Import Methods and XPRAs for Transport Request
    SY-MSGTY E
    SY-MSGID DA
    SY-MSGNO 300
    SY-MSGV1 /BIC/AV_AMOFCB40
    SY-MSGV2
    SY-MSGV3
    SY-MSGV4
    SY-MODNO 0
    SY-DATUM 20110208
    SY-UZEIT 104759
    SY-XPROG SAPLSYST
    SY-XFORM SYSTEM_HOOK_OPEN_DATASET
pruuostpj
 
Posts: 8
Joined: Tue Apr 25, 2006 3:29 am

Return to Business Warehouse

Who is online

Users browsing this forum: No registered users and 8 guests





loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.