SQL error in the database when accessing a table.

[Former Member]

Hi all.

The queues in smq2 in XI are not running anymore. All queues are stopped because of SYSFAIL. When I click on SYSFAIL, I get the message 'SQL error in the database when accessing a table'. Has anyone encountered this before?

Thanks

[Shabarish_Nair · Accepted solution]

>

> Hi all.
> 
> The queues in smq2 in XI are not running anymore. All queues are stopped because of SYSFAIL. When I click on SYSFAIL, I get the message 'SQL error in the database when accessing a table'. Has anyone encountered this before?
> 
> Thanks

the reason for this usually is when the underlying SAP table gets filled. Inform your basis to clear the table space or increase it.

[Former Member · Accepted solution]

Hi Shab,

May i know which tables i have to look into when i get this error.

Could you please name those table names.

Regards

[former_member200962]

same problem solved inhere:

[Shabarish_Nair]

/people/sap.user72/blog/2005/11/29/xi-how-to-re-process-failed-xi-messages-automatically

help yourself to process those messages

[Former Member]

Hello,

Just double click on the queue second or first columm and u will find which message is stucked.

Check the target system wether it is up or not . Because the queue is showing the sysfail because max. Retry is completed and may be reciver system is down.

Thanks and Regards

Hemant