cancel
Showing results for 
Search instead for 
Did you mean: 

Shortdump DBIF_RSQL_SQL_ERROR in ERP

Former Member
0 Kudos

Hi

we have copied standard table to addon table  from KNA to ZKNA1 in ERP.
also we loaded the ZKNA1 table using SLT HANA data provisioning at HANA studio modeler

In hana studio data provisioning, Loaded table gets error status instead of Inprocess.


I confirmed ERP short dump. it displays like this
DBIF_RSQL_SQL_ERROR
Error Text of the Database: "insufficient privilege: Not authorized"

Error analysis
    An exception occurred that is explained in detail below.
    The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught
     in
    procedure "/1CADMC/OLO_800000000000304" "(FUNCTION)", nor was it propagated by
     a RAISING clause.
    Since the caller of the procedure could not have anticipated that the
    exception would occur, the current program is terminated.
    The reason for the exception is:
    Error Text of the Database: "insufficient privilege: Not authorized"

It shows error in below code
        INSERT /1CADMC/S0000251 CLIENT SPECIFIED CONNECTION (con_name)
        FROM TABLE _IT_IO_R_ZKNA1

when i double click /1CADMC/S0000251, initially it says no table in Database.
so i went to tr-cd se14 and activated and adjusted the database.

now again i tried loading it still it gives error.


The short dump keeps coming for every 2minute and background job is active increasingly at SM37.

I could either stop the load of addon table or stop the dump.

also not sure which background job to delete to stop the addon table replicating.

Can you hint me where could be the problem

Regards

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi

Can anyone shed light on this.?

Regards

Former Member
0 Kudos

Did you get this addressed?