Skip to Content
author's profile photo Former Member
Former Member

queue status

hi all,

in my scenario ie file2 file .......the message is stucked in queue.the queue status in smb_moni shows red stop.

when i execute smq2 and double click on the queue.its showing SYSFAIL and give a message "SQL error occurred in the database when accessing"

plz help

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 07, 2009 at 12:37 PM

    Hi,

    Double click in the Queue which is showing the SYSFAIL status. It will direct towards the messages failed in SXMB_MONI.

    Either restart or cancel the message.

    It will allow you to proceed further with backlog messages.

    Thanks

    Swarup

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 07, 2009 at 12:38 PM

    Hi,

    It's sound like SAP basic problems. Consult with your basic team for resolve the problem. Maybe the server thread's are broken, full disk, can be for listeners problems between aplication server and database.

    Check SM21 transaction, in this transaction you can see more detail about the occurred error.

    Best Regrads

    Ivá

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 08, 2009 at 04:59 AM

    Hi Pinaki,

    This is issue with the database. The database size must be full and hence it is not able to make any new entries. Please ask the BASIS team to clear the database. Just the cleanup of database should solve the problem.

    Regards,

    Sarvesh Desai

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.