Dump while executing table contents for QMAT table.

[Former Member]

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.

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

[gouravkumar64]

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.

[ThangaPrakash]

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

[Former Member]

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

[nabheetscn]

Hi Nilesh

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

Nabheet