Question Re: "SQL error in the database when accessing a table "error in Technology Q&A

"SQL error in the database when accessing a table "error

Former Member — Sat, 01 Nov 2008 03:59:09 GMT

Hi Friends,

Its a support issue. Since the server was down yesterday messages stuck in the queues. To send the messages from queue now in smq2 once i click on the spcific queue i am getting another page which shows sysfail error , after clicking on that line in another page i am getting error SQL error in the database when accessing a table. when i click execute luw it is showing error in the status bar as Function module does not exist or EXCEPTION raised.

Please help me how resolve the issue and send the messages out of queue ?

Thanks,

Suresh.

Re: "SQL error in the database when accessing a table "error

Former Member — Sat, 01 Nov 2008 13:40:31 GMT

Hi Suresh,

I think the error is because of insufficient space in the table .Contact the BASIS team and increase the table space.

Bharath.

Re: "SQL error in the database when accessing a table "error

Former Member — Sat, 01 Nov 2008 20:51:14 GMT

Hi Suresh

Did they update SP level while system was down. if yes this can be a driver update issue as well.

Other than that System exception from database can be due to table is full, or PI is accessing the table if table level lock is implemented then refresh the cache or restart database.

Thanks

Gaurav

Re: "SQL error in the database when accessing a table "error

Former Member — Fri, 21 Nov 2008 12:06:15 GMT

Thanks Bharath. The issue got resolved after increasing the table space. sorry for the late response.

suresh.

Re: "SQL error in the database when accessing a table "error

Former Member — Tue, 30 Apr 2013 13:22:30 GMT

Hi All,

I got same issue in SQL Query

SELECT (FIELD_LIST)

INTO CORRESPONDING FIELDS OF TABLE I_COSP PACKAGE SIZE 1000

FROM COSP CLIENT SPECIFIED

WHERE GJAHR IN SELR_GJAHR

AND LEDNR EQ '00'

AND OBJNR IN SELR_OBJNR

AND PERBL IN SELR_PERBL

AND VERSN IN SELR_VERSN

AND WRTTP IN SELR_WRTTP

AND MANDT IN MANDTTAB

GROUP BY (GROUP_LIST).

But it is working for other inputs. Could you suggest me is that table space problem only or what ?