cancel
Showing results for 
Search instead for 
Did you mean: 

Optimising initial table load via SLT

Former Member
0 Kudos

Hello All

We are running table raplication whereby initial load of tables run first into our HANA. For large tables, we have successfully ran these initial data load which then went into replication status. However, for few tables we have encountered a shortdump on our SAP Source System. The dump heading are:

Category           ABAP Programming Error
Runtime Errors     RAISE_EXCEPTION
ABAP Program       DMCACBTC

Application Component  CA-EUR

Short text

    Exception condition "SQL_FAILURE" raised.

...

...

...

Information on where terminated

    Termination occurred in the ABAP program "/1CADMC/SAPLDMC500000000002080" - in

     "/1CADMC/ACS_500000000002080".

    The main program was "DMCACBTC ".

    In the source code you have the termination point in line 194

    of the (Include) program "/1CADMC/LDMC500000000002080U02".

    The program "/1CADMC/SAPLDMC500000000002080" was started as a background job.

    Job Name....... "MWBACPLCALC_Z_MARC_051"

    Job Initiator.. "SLT_USER"

    Job Number..... 17124600

In the ABAP, line 194 is  "RAISE sql_failure." below:

...

...

...

REFRESH LT_PRT_S_MARC .
*
         LS_RECCOUNT-PORTION = PORTION .
         LS_RECCOUNT-STRUCTURE = 'S_MARC'.
         LS_RECCOUNT-RECCNT = SUM_S_MARC .
         APPEND LS_RECCOUNT TO EX_IT_RECCOUNTS .
*
         CLEAR L_PORT_BLOCKSIZE .
         clear SUM_S_MARC .
       ENDIF.
     ENDDO.
*
   CATCH cx_sql_exception INTO lref_sql_exception.
     l_msgtext = lref_sql_exception->get_text( ).
     IF lref_sql_exception->invalid_cursor NE true.
       RAISE sql_failure.
     ENDIF.
ENDTRY.

In this case, the SQL_FAILURE shortdump has happened on MARC.

There are no SAP Notes on this shortdump nor could I find any SDN entry about it. Has anyone else come across this problem, and what did you do to resolve it?

We are on HANA SP05 rev.52 and our SLT is on DMIS SP08. Source system on ECC 6 BASIS pack 10 and DMIS on SP08. As mentioned other large tables (eg 300m rows) successfully replicated except few which always error with the above shortdump.

Accepted Solutions (0)

Answers (1)

Answers (1)

tforslund
Discoverer
0 Kudos

Having the same issue, did you ever find a resolution?

Cheers,

Tim

Former Member
0 Kudos

i think i reloaded the table.

/Soyful