topic Re: Dump while executing table contents for QMAT table. in Application Development and Automation Discussions

Dump while executing table contents for QMAT table.

Former Member — Wed, 12 Feb 2014 08:20:47 GMT

We encountered an issue that when we try to display contents of QMAT table.

Dump details are as follows.

******************************************************************************

Category Installation Errors

Runtime Errors DBIF_RSQL_SQL_ERROR

Except. CX_SY_OPEN_SQL_DB

Short text

SQL error "-1655" when accessing table "QMAT".

What happened?

Error Text of the Database: "SQL1655C The operation co

to an error accessing data on disk. SQLSTATE=58030"

Source Code: (Program - /1BCDWB/DBQMAT)

START-OF-SELECTION.

IF MAX_SEL > 0.

RSEUMOD-TBMAXSEL = MAX_SEL.

ELSEIF MAX_SEL = 0.

CLEAR RSEUMOD-TBMAXSEL.

ENDIF.

IMPORT G_DATA_EXIT FROM MEMORY ID MEM_ID.

IF SY-BATCH IS INITIAL AND G_DATA_EXIT IS INITIAL.

IMPORT ACTION FROM MEMORY ID MEM_ID.

ELSE.

ACTION = 'ANZE'.

concatenate '/1BCDWB/DB' 'QMAT' into g_dbdatakey-eu_name.

g_dbdatakey-username = c_all.

import sort_NAME_TAB to %_TAB2_sort

field_name_tab to %_TAB2_field

from database dbdata(DB) id g_dbdatakey.

if sy-subrc = 0.

delete from dbdata

where relid = 'DB' and

eu_name = g_dbdatakey-eu_name and

username = c_all.

describe table %_tab2_field lines %_l_lines.

if not %_l_lines is initial.

%_TAB2[] = %_tab2_field[].

endif.

ENDIF.

CASE ACTION.

WHEN 'ANZE'.

try.

>>>>>>> SELECT * FROM QMAT "client specified

APPENDING TABLE IQMAT

UP TO RSEUMOD-TBMAXSEL ROWS BYPASSING BUFFER

WHERE ART IN I1

AND MATNR IN I2

AND WERKS IN I3.

CATCH CX_SY_DYNAMIC_OSQL_SEMANTICS INTO xref.

IF xref->kernel_errid = 'SAPSQL_ESCAPE_WITH_POOLTABLE'.

message i412(mo).

exit.

ELSE.

RAISE EXCEPTION xref.

ENDif.

ENDTRY.

******************************************************************************

Can anybody suggest the solution to solve this dump???

Thanks,

Nilesh

Re: Dump while executing table contents for QMAT table.

gouravkumar64 — Wed, 12 Feb 2014 08:28:34 GMT

Hi,

This error generally comes related to table space error or overflow.

Check with your basis team with few sap notes like

1513862 - DB6: Table conversion using DB6CONV Version 5.01 or higher

874798 - DBUA/Upgrade to 10.1: ORA-01653 / ORA-01655

3155 - Termination due to tablespace overflow

Thanks

Gourav.

Re: Dump while executing table contents for QMAT table.

ThangaPrakash — Wed, 12 Feb 2014 08:52:34 GMT

Hi Nilesh,

Check the below OSS notes.

942661 - BD10: DBIF_RSQL_SQL_ERROR during sending of articles/mats

1061620 - Problems when you delete inspection types

Reagrds,

Thanga

Re: Dump while executing table contents for QMAT table.

Former Member — Wed, 12 Feb 2014 12:48:22 GMT

more clarification abut this dump as follows:--

We are on

ECC DEV 6.0

Windows Server 2008 R2

IBM DB2 (DB Realese 09.07.0004)

Support package level as follows.

We are getting DUMP, while trying to see the contents of table QMAT and MBEW via SE11,

Dump details as above

Re: Dump while executing table contents for QMAT table.

nabheetscn — Wed, 12 Feb 2014 13:05:26 GMT

Hi Nilesh

If you look at dump its installation dump. Please show this to basis guys

Nabheet