Skip to Content
0
Former Member
Sep 08, 2009 at 11:04 AM

Short dump when activate InfoProvider

37 Views

Hi,

When I try to activate via right click Key Figure 0CO_AREA (in RSA1/InfoSources/Controlling). I've got following short dump

1.SQL statement violates database system restriction

2. Run-time error "DBIF_RSQL_INVALID_RSQL" occurred

In Details (ST11) dev_w1 trace file i found

C Fri Sep 4 12:51:06 2009

C *** ERROR in DB6Execute[dbdb6.c, 4322] CON = 0 (BEGIN)

C &*** DbSlModifyDB6: Number of input parameters does not match the number of parameter markers ( 1 parameters; 0+

C &*** ).+

C &***+

C &*** DELETE FROM "/BI0/PCO_AREA" WHERE "CHANGED" = 'D'+

C &*** cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, buffer_lobs=YES, op_type=8, reop+

C &***+

C &*** ABAP location info 'CL_RSDMD_ACTIVATE_MASTER_DATA=CP', 700+

C &*** SAP user 'XXX', transaction code 'RSA1'+

C &***+

C *** ERROR in DB6Execute[dbdb6.c, 4322] (END)

B ***LOG BYK=> current SQL statement exceeds a database limit [dbtran#11 @ 7482] [dbtran 7482 ]

B dbtran ERROR LOG (hdl_dbsl_error): DbSl 'DEL'

B RSLT: {dbsl=2, tran=16384}

B FHDR: {tab='/BI0/PCO_AREA', fcode=194, mode=2, bpb=0, dbcnt=0, crsr=0,

B hold=0, keep=1, xfer=0, pkg=0, upto=0, init:b=0,

B init:p=(nil), init:#=0, wa:p=(nil), wa:#=0}

B dbtran ERROR LOG (hdl_dbsl_error): DbSl 'DEL'

B STMT:

B CRSR: {tab='', id=0, hold=0, prop=0x1200, max.in@0=1, fae:blk=0,

B con:id=0, con:vndr=7, val=2,

B key:#=1, xfer=0, xin:#=1, row:#=0, upto=0, wa:p=0x7ffdebc23268}

SQL statement which generates dump is

DELETE FROM (<l_sx_itab>-name)

WHERE changed = rs_c_changed-delete

%_HINTS " note 1162665

ORACLE '&SUBSTITUTE VALUES&'

INFORMIX '&SUBSTITUTE VALUES&'

DB6 '&SUBSTITUTE VALUES&'

MSSQLNT '&SUBSTITUTE VALUES&'

ADABAS '&SUBSTITUTE VALUES&'.

I don't know which database limit is exceed. Any clue

Regards

Michal