Skip to Content
0
Former Member
Dec 14, 2011 at 10:53 PM

Short Dump:DBIF_RSQL_SQL_ERROR; Exception :CX_SY_OPEN_SQL_DB

3990 Views

Hi All,

I am getting the below short when i try to load the data into BI system. when I start the Info Package, it is immediately going to this short dump.

Runtime Errors DBIF_RSQL_SQL_ERROR

Except. CX_SY_OPEN_SQL_DB

Date and Time 15.12.2011 02:43:18

Short text

SQL error in the database when accessing a table.

Please find the short dump details below.

Runtime Errors DBIF_RSQL_SQL_ERROR

Except. CX_SY_OPEN_SQL_DB

Date and Time 15.12.2011 02:43:18

Short text

SQL error in the database when accessing a table.

Missing RAISING Clause in Interface

Program SAPLBTCH

Include LBTCHFXX

Row 1.525

Module type (FORM)

Module Name STORE_NEW_STEPLIST_IN_DB

Trigger Location of Exception

Program SAPLBTCH

Include LBTCHFXX

Row 1.652

Module type (FORM)

Module Name STORE_NEW_STEPLIST_IN_DB

Source Code Extract

Line SourceCde

1622 ID 'DATA' FIELD jobinfo_egj.

1623

1624 rc = 1.

EXIT.

ELSE.

db_steplist-priparkey = tmp_key.

ENDIF.

ENDIF.

SEIF new_steplist-typ = btc_xcmd." Step executes external command

db_steplist-extcmd = new_steplist-program.

db_steplist-xpgparams = new_steplist-parameter.

db_steplist-xpgflag = 'X'.

SE. " Step führt ein externes Programm aus

db_steplist-xpgprog = new_steplist-program.

db_steplist-xpgparams = new_steplist-parameter.

db_steplist-xpgflag = 'X'.

DIF.

steplist-sdldate = newjob_head-sdldate.

steplist-sdltime = newjob_head-sdltime.

steplist-sdluname = newjob_head-sdluname.

PEND db_steplist.

ep_count = step_count + 1.

OOP.

liste in DB speichern

RT tbtcp FROM TABLE db_steplist ACCEPTING DUPLICATE KEYS."n952782

y-subrc NE 0.

dialog EQ btc_yes.

MESSAGE s120 WITH new_job_head-jobname.

ENDIF.

CONCATENATE new_job_head-jobname new_job_head-jobcount INTO

jobinfo_egj SEPARATED BY '/'.

CALL 'C_WRITE_SYSLOG_ENTRY' ID 'TYP' FIELD ' '

ID 'KEY' FIELD tbtcp_insert_db_error

ID 'DATA' FIELD jobinfo_egj.

rc = 1.

EXIT.

ENDIF.

rc = 0.

DFORM. " STORE_NEW_STEPLIST_IN_DB

I would like to know where exactly it is getting error. Please help me on this.

Regards,

Venkat.