Skip to Content
0
Former Member
Oct 04, 2012 at 08:49 AM

Shortdump DBIF_RSQL_SQL_ERROR in ERP

40 Views

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