Reset the Spam-Queue ?

[Former Member]

Hello,

we want to implement SP25 in our Solution Manager.

Transaction SPAM shows the following error:

ERROR: SAPK-1507OINSTPL : couldn't locate TA-info in .../cofiles

(illegal format detected)

HALT 20110407094709

ERROR: tpsettainfo: /usr/sap/STD/trans/cofiles/K-1507OINSTPL.SAP contains no valid information

ERROR: EXIT(16) -> process ID is: 21223

After this, we download the files again and unpack the Files new...

Same error...

We have tried to reset the state of the queue, but we get another error ( [Screenshot1|http://www.christoph-bastian.de/sap/screenshot1.jpg] )

Then, we tried to delete the queue -> new error ( [Screenshot2|http://www.christoph-bastian.de/sap/screenshot2.jpg] )

Delete the entry out of the table PAT01 or execute function OCS_REST_QUEUE ( [Screenshot3|http://www.christoph-bastian.de/sap/screenshot3.jpg] ) brings no change...

How can we reset the queue, so that we get an consistent state ?

How can we solve the problem with the first error-message 'cofile contains no valid information) ?

best regards

Christoph

[Former Member]

Hi,

The cofile could not be created from the corresponding data

file. One possible error is that <sys>adm does not have write authorization for the

directory /usr/sap/trans/cofiles (UNIX). Check whether the data file was created.

If it was not created, check that the option Create new data file is activated in the SPAM

settings

Login t code -> SPAM, choose Extras -> Settings you must assign the below settings

Transmission Monitor Off

Scenario Default(standard)

Create new data file On

Delete data file after import On

Run ABAP generator/screen generator Off(never)

you will try to RESET t code Spam ->Extras -> Reset status

Regards,

kalees

[Former Member]

Thank you for the hint with the cofile...

We will try this, when we can reset the queue...

The way SPAM -> Extras -> reset status shows the error from screenshot2...

The function can't delete some packages..

As i wrote, editing the table PAT01 or using the function ocs_reset_queue does'nt solve the problem...

best regards

Christoph

[Former Member]

Hi,

You will try this commandat db level:

select * from sapsid.pat01 & 02

delete count(*) sapsid.tablename

you can't reset the queue by yourself so you'll have to raise a OSS message so that SAP can reset the queue.

Regards,

kalees

Edited by: kalees waran on Apr 8, 2011 1:41 PM