Skip to Content
avatar image
Former Member

Need to delete the SPAM requests from the import queue

Dear all,

There were some issues with my QA system SAP patch application and we were forced to do a DB refresh from our production system. Now our QA system ABAP stack is having an issue with the STMS import queue which shows 4 old patches(witch were applied to the system before the refresh) with u201Crequest will not be importedu201D status. When I try to delete these requests from the import queue it shows the following error

u201CThis is tp version 372.04.29 (release 700, unicode enabled)

ERROR: Client 'ALL' is not possible.

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0246

standard output from tp and from tools called by tpu201D

When I try to import a new support package it gives the following error,

Error in phase: CHECK_REQUIREMENTS

Reason for error: QUEUE_NOT_EMPTY

Not sure how these requests arew still in the import queue even after the DB refresh. How can I delete these 4 old requests from the import queue?

The System is ECC6.0 ABAP+JAVA stack with Oracle 10g on Win2003 server.

Thank you,

Siju Sam

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 26, 2009 at 05:12 AM

    Hi,

    As per your query you can delete import queue form QA system. In case you are not able to delete then you can delete on os lavel.

    Anil

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hello Sam

      Some of the tryouts can be

      1. stms-queue-select request-delete

      2. check trbat table and delete those entries

      3. or on os lever use tp command to delete those request

      success !!

      -Ganesh

  • avatar image
    Former Member
    Mar 26, 2009 at 12:14 PM

    Hi

    Can you check in tables

    E070 &E071

    Regards

    Uday

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 26, 2009 at 09:00 AM

    Hi

    Check the table entries in PAT01 & PAT03 if you found any entries delete those from database level

    Let me know if needed more information

    Regards

    Uday

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thank you for your reply,

      I have checked the tables trbat, PAT01 and PAT03 none of these tables contain the Supportpack(corresponding TP request) shown in the import queue of STMS(NOT SPAM). So I think we can ignore the "support pack" and just wanted to remove the(a) transport request from STMS import queue. Is there any file at OS level wich stores the transport request details of STMS import queue?(Becoz I'm quite sure that I have done a complete DB refresh)

      Thank you,

      Siju

  • avatar image
    Former Member
    Mar 26, 2009 at 09:04 AM

    Hi,

    If you delete the queue after objects have already been transported (for example,

    after an error in step DDIC_IMPORT), your system is inconsistent. Only delete the

    queue in these SPAM steps to correct errors, and then import the Support Packages

    again as soon as you can. Note that, as of SPAM/SAINT Version 11, you cannot delete

    the queue once you have reached the step DDIC_IMPORT.

    Procedure :

    1. In the initial screen of Transaction SPAM, choose Display/define. A dialog box appears

    displaying the current queue.

    2. Choose the Delete queue icon.

    The queue has been deleted. You can now define a new queue.

    Regards

    Krishna Vanga

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 28, 2009 at 05:51 AM

    I have just reconfigured the STMS in my QA system and then applied the patches. everything went fine.

    Thanks for your help.

    Regards,

    Siju

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 08, 2015 at 06:55 PM

    This message was moderated.

    Add comment
    10|10000 characters needed characters exceeded