cancel
Showing results for 
Search instead for 
Did you mean: 

SPAM update error

former_member105092
Participant
0 Kudos

Hi,

I update the kernel version from 7.00 to 7.01 -patch 55.

Then update the spam 7.00/36 to 7.01/38 . SPAM through the error.

SAPKD70138.SAR is showing while click the "import spam/saint update" in txn SAPM. But this throw the error .

" Error in phase: CHECK_REQUIREMENT

Reason for error: QUEUE_NOT_EMPTY"

Most of the option i tried.

-- R3trans -d :- OK.

--RSTPTEST :- OK.

- reconfigure the TMS. :- OK.

-- copy the transport profile to tpsettings file.

anything beyond this ?

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

Hi,

It seems that some of the components are not imported properly during the last run or may be someone deleted the queue before confirmation of the queue.check as following :

- login at OS level with <sid>adm

- issue following command.

tp showbuffer <SID> pf=/usr/sap/trans/bin/TP_DOMAIN_<SID>.PFL tag=SPAM

this will give you the list of the packages that buffer still holds. Replace the <SID> with the correct SID of your system.check if you find any packages and also let me know the results.

Best Regards

Niraj

former_member105092
Participant
0 Kudos

Result for --tp showbuffer <SID> pf=/usr/sap/trans/bin/TP_DOMAIN_<SID>.PFL tag=SPAM

that makes 150 transports to be imported.

tp finished with return code: 0

meaning:

Everything OK

HI amber,

I cleared all other files in the /EPS/ IN/ folder and also cofiles and data folder too. Now tried freshly the spam update 7.00/38 . Now also it's fails. same error.

Edited by: Jeevagan Vedhaiyan on Apr 4, 2010 6:56 AM

former_member105092
Participant
0 Kudos

I tried this also

D:\>tp unmark SAPKD70038 tag=SPAM

This is tp version 372.04.71 (release 700, unicode enabled)

E-TPSETTINGS could not be opened.

EXIT

Error in TPSETTINGS: transdir not set.

tp returncode summary:

TOOLS: Highest return code of single steps was: 0

ERRORS: Highest tp internal error was: 0208

tp finished with return code: 208

meaning:

error in transportprofil (param missing, unknown,...)

Former Member
0 Kudos

Hi Jeevagan,

Go to RZ10 and set the parameter DIIR_TRANS in the instance profile. The value of the parameter should be like this--

DIR_TRANS= <hostname of the domain controller>/sapmnt/trans.

Restart the system and it should work fine.

Regards

Sourabh Majumdar

former_member105092
Participant
0 Kudos

Hi Sourabh Majumdar,

Added in instance profile.

still no improvement.

Former Member
0 Kudos

Hope you have restarted your server.

Use this command and post the result--

tp connect <SID> pf=Drive:\usr\sap\trans\bin\TP_DOMAIN_<SID>.PFL

Take care of the slash (forward or backward) depending on your OS. The above command is for windows.

Regards

Sourabh Majumdar

former_member105092
Participant
0 Kudos

When updated the profile restarted the sap console.

The result for

D:\>tp connect BLR pf=D:\usr\sap\trans\bin\TP_DOMAIN_BLR.PFL

This is tp version 372.04.71 (release 700, unicode enabled)

Warning: Parameter IMPDP_BY_EVENT is no longer used.

Connection to Database of BLR was successful.

This is R3trans.exe version 6.14 (release 700 - 03.11.09 - 14:15:00).

unicode enabled version

R3trans.exe finished (0000).

tp finished with return code: 0

meaning:

Everything OK

Former Member
0 Kudos

So now the result shows that your tp is working fine. Now restart the SPAM update. If you face any issues paste the contents of latest SLOG file.

Regards

Sourabh Majumdar

former_member105092
Participant
0 Kudos

The Error is the same....

****SLOG*****

START INFORM SAP-SYSTEM OF BLR Q 20100403122314 BASIS Ehp4 20100403122302421

START tp_getprots BLR Q 20100403122315 BASIS Ehp4 20100403122302421

STOP tp_getprots BLR Q 20100403122321 BASIS Ehp4 20100403122302421

STOP INFORM SAP-SYSTEM OF BLR Q 20100403122321 BASIS Ehp4 20100403122302421

Former Member
0 Kudos

Jeevagan,

I do not see any error in your above post. Post the entire SLOG file as well as ALOG file.

Let us know at which phase the process is stuck?

Make sure of enough available space in tablespaces. Check Import Log->SPAM/SAINT update for any errors.

Regards

Sourabh Majumdar

former_member105092
Participant
0 Kudos

SLOG----


START INFORM SAP-SYSTEM OF BLR Q 20100403122314 BASIS Ehp4 20100403122302421

START tp_getprots BLR Q 20100403122315 BASIS Ehp4 20100403122302421

STOP tp_getprots BLR Q 20100403122321 BASIS Ehp4 20100403122302421

STOP INFORM SAP-SYSTEM OF BLR Q 20100403122321 BASIS Ehp4 20100403122302421

-


ALOG----


ALL BLR.ALL t 0000 20100404102552 BASIS Ehp4

ALL BLR.ALL t 0000 20100406120249 blradm Ehp4 20100406120248001778

ALL BLR.ALL t 0000 20100406142626 BASIS Ehp4

ALL BLR.ALL t 0000 20100406154245 blradm Ehp4 20100406154245001768

ALL BLR.ALL t 0000 20100406160418 BASIS Ehp4

-


I am using MSSQL server .... Tell me how to check the table space ?

Import log for SPAM / SAINt log show the last update only ... not the new one.

Edited by: Jeevagan Vedhaiyan on Apr 6, 2010 1:07 PM

former_member105092
Participant
0 Kudos

solved.

cleared the buffer file <SID> in the folder /usr/sap/trans/buffer

former_member198270
Active Contributor
0 Kudos

Hello Jeevagan, From the logs which you have pasted in the query it seems your OCS is not empty.

Cany you perform 2 steps and let us know.

-goto SPAM and check all the packages are in confirm status in before applying spam/saint version patch.

-goto SAINT and check the packages are in finish status.

You can patch your SPAM/SAINT version thru SPAM transaction.

Hope it helps.

Regards, Amber S | ITL

former_member105092
Participant
0 Kudos

HI Naveed Qureshi ,

SAPehpI tool only show to update the spam version, due to it is too low.

When we revert from kernel 7.01 to 7.00 , the java server node stopped due to error.

Hi Amber,

While click the confirm in txn SPAM, the OCS Package queue is empty shown in status bar.

In SAINT, None of the add-on tool started. Means not incompleted.

I tried this option too..

cofiles and data folder created newly and tried spam/saint ver 7.00/38 This also throw the same error

Edited by: Jeevagan Vedhaiyan on Apr 3, 2010 6:50 AM

former_member198270
Active Contributor
0 Kudos

Hello, could you plaste SLOG and ALOG files to have more analysis on it.

Location of Slog & Alog > usr/sap/trans/log

Regards, Amber S | ITL

former_member105092
Participant
0 Kudos

ALL BLR.ALL t 0000 20100403113220 BASIS Ehp4 / ***** ALOG *********/

/ *******C100403.BLR********/

1 ETP199X######################################

1 ETP186 R3TRANS CONNECT

1 ETP101 transport order : "ALL"

1 ETP102 system : "BLR"

1 ETP108 tp path : "tp"

1 ETP109 version and release : "372.04.71" "700"

1 ETP198

4 ETW000 R3trans.exe version 6.14 (release 700 - 03.11.09 - 14:15:00).

4 ETW000 unicode enabled version

4 ETW000 ===============================================

4 ETW000

4 ETW000 date&time : 03.04.2010 - 11:32:20

4 ETW000 control file: <no ctrlfile>

4 ETW000 R3trans was called as follows: R3trans.exe -w
Ehp4\sapmnt\trans\tmp\C100403.BLR -d

4 ETW000 trace at level 2 opened for a given file pointer

4 ETW000 [dev trc ,00000] Sat Apr 03 11:32:20 2010 7753 0.007753

4 ETW000 [dev trc ,00000] db_con_init called 95 0.007848

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/ftabsize 500. 32 0.137307

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/irbdsize 100. 25 0.137332

4 ETW000 [dev trc ,00000] NTAB: rsdb/ntab/sntabsize 100. 26 0.137358

4 ETW000 [dev trc ,00000] NTAB: compute_hash_card: 2003. 34 0.137392

4 ETW000 [dev trc ,00000] NTAB: maxcnt 1000. 38 0.137430

4 ETW000 [dev trc ,00000] NTAB: hfactor 2003. 26 0.137456

4 ETW000 [dev trc ,00000] NTAB: mem_protocol_size 112 25 0.137481

4 ETW000 [dev trc ,00000] NTAB: hdr_backpack_offset 0 25 0.137506

4 ETW000 [dev trc ,00000] NTAB: hdr_backpack_size 0 25 0.137531

4 ETW000 [dev trc ,00000] NTAB: FTAB: header_size 80. 25 0.137556

4 ETW000 [dev trc ,00000] NTAB: FTAB: item_size 64. 25 0.137581

4 ETW000 [dev trc ,00000] NTAB: FTAB: item_cnt 1000. 26 0.137607

4 ETW000 [dev trc ,00000] NTAB: FTAB: unit_size 4 25 0.137632

4 ETW000 [dev trc ,00000] NTAB: FTAB: unit_cnt 128000. 108 0.137740

4 ETW000 [dev trc ,00000] NTAB: FTAB: data_size 512000. 26 0.137766

4 ETW000 [dev trc ,00000] NTAB: IREC: header_size 80. 26 0.137792

4 ETW000 [dev trc ,00000] NTAB: IREC: item_size 64. 25 0.137817

4 ETW000 [dev trc ,00000] NTAB: IREC: item_cnt 250. 25 0.137842

4 ETW000 [dev trc ,00000] NTAB: IREC: unit_size 8 34 0.137876

4 ETW000 [dev trc ,00000] NTAB: IREC: unit_cnt 12800. 34 0.137910

4 ETW000 [dev trc ,00000] NTAB: IREC: data_size 102400. 33 0.137943

4 ETW000 [dev trc ,00000] NTAB: STAB: header_size 80. 26 0.137969

4 ETW000 [dev trc ,00000] NTAB: STAB: item_size 64. 25 0.137994

4 ETW000 [dev trc ,00000] NTAB: STAB: item_cnt 250. 26 0.138020

4 ETW000 [dev trc ,00000] NTAB: STAB: unit_size 4 24 0.138044

4 ETW000 [dev trc ,00000] NTAB: STAB: unit_cnt 25600. 25 0.138069

4 ETW000 [dev trc ,00000] NTAB: STAB: data_size 102400. 26 0.138095

4 ETW000 [dev trc ,00000] NTAB: TTAB: header_size 192. 25 0.138120

4 ETW000 [dev trc ,00000] NTAB: TTAB: item_size 40. 26 0.138146

4 ETW000 [dev trc ,00000] NTAB: TTAB: item_cnt 1000. 25 0.138171

4 ETW000 [dev trc ,00000] NTAB: TTAB: unit_size 256 25 0.138196

4 ETW000 [dev trc ,00000] NTAB: TTAB: unit_cnt 1000. 26 0.138222

4 ETW000 [dev trc ,00000] NTAB: TTAB: data_size 256000. 25 0.138247

4 ETW000 [dev trc ,00000] NTAB: FTAB: hh_p 22bf50, hh_len 80 1408 0.139655

4 ETW000 [dev trc ,00000] NTAB: FTAB: aa_p 2e9010, aa_len 16024 37 0.139692

4 ETW000 [dev trc ,00000] NTAB: FTAB: ia_p 921a080, ia_len 64000 26 0.139718

4 ETW000 [dev trc ,00000] NTAB: FTAB: dat_p 922a080, dat_len 512000 27 0.139745

4 ETW000 [dev trc ,00000] NTAB: IREC: hh_p 22bfb0, hh_len 80 26 0.139771

4 ETW000 [dev trc ,00000] NTAB: IREC: aa_p 2ecec0, aa_len 16024 26 0.139797

4 ETW000 [dev trc ,00000] NTAB: IREC: ia_p 2f0d70, ia_len 16000 33 0.139830

4 ETW000 [twdydbacc.c ,00572] db_fd_p<i>.offset: 0 24 0.141696

                    1. SLOG #########################

START CMDIMPORT BLR L 20100312193623 BASIS Ehp4 20100312193623312

STOP CMDIMPORT BLR L 20100312193624 BASIS Ehp4 20100312193623312

START MAIN IMPORT BLR I 20100312193625 BASIS Ehp4 20100312193624968

STOP MAIN IMPORT BLR I 20100312193629 BASIS Ehp4 20100312193624968

START CMDIMPORT BLR L 20100312193630 BASIS Ehp4 20100312193629562

STOP CMDIMPORT BLR L 20100312194211 BASIS Ehp4 20100312193629562

START DD IMPORT BLR H 20100312224258 BASIS Ehp4 20100312224257765

STOP DD IMPORT BLR H 20100312235310 BASIS Ehp4 20100312224257765

START DD ACTIVATION BLR A 20100312235327 BASIS Ehp4

START tp_getprots BLR J 20100312235327 BASIS Ehp4

ERROR SAPK-20001INWFMCORE BLR A 0008 20100313034632 WFMCOREUSER BASIS Ehp4

ERROR SAPK-20002INWFMCORE BLR A 0008 20100313034632 WFMCOREUSER BASIS Ehp4

ERROR SAPK-20003INWFMCORE BLR A 0008 20100313034632 WFMCOREUSER BASIS Ehp4

ERROR SAPK-20004INWFMCORE BLR A 0008 20100313034632 WFMCOREUSER BASIS Ehp4

ERROR SAPK-20005INWFMCORE BLR A 0008 20100313034632 WFMCOREUSER BASIS Ehp4

ERROR SAPK-20006INWFMCORE BLR A 0008 20100313034632 WFMCOREUSER BASIS Ehp4

ERROR SAPK-20007INWFMCORE BLR A 0008 20100313034632 WFMCOREUSER BASIS Ehp4

ERROR SAPK-20008INWFMCORE BLR A 0008 20100313034632 WFMCOREUSER BASIS Ehp4

ERROR SAPK-20009INWFMCORE BLR A 0008 20100313034632 WFMCOREUSER BASIS Ehp4

ERROR SAPK-20011INWFMCORE BLR A 0008 20100313034632 WFMCOREUSER BASIS Ehp4

ERROR SAPK-20012INWFMCORE BLR A 0008 20100313034632 WFMCOREUSER BASIS Ehp4

ERROR SAPK-20013INWFMCORE BLR A 0008 20100313034632 WFMCOREUSER BASIS Ehp4

ERROR SAPK-200IDINWFMCORE BLR A 0008 20100313034632 WFMCOREUSER BASIS Ehp4

ERROR SAPK-200IMINWFMCORE BLR A 0008 20100313034632 WFMCOREUSER BASIS Ehp4

ERROR SAPK-200IRINWFMCORE BLR A 0008 20100313034632 WFMCOREUSER BASIS Ehp4

ERROR SAPK-27001INCCM BLR A 0008 20100313034632 CCMUSER BASIS Ehp4

ERROR SAPK-27002INCCM BLR A 0008 20100313034632 CCMUSER BASIS Ehp4

ERROR SAPK-27004INCCM BLR A 0008 20100313034632 CCMUSER BASIS Ehp4

ERROR SAPK-27005INCCM BLR A 0008 20100313034632 CCMUSER BAS

former_member198270
Active Contributor
0 Kudos

None of the components have ended with more than RC 008, can you please try re-patching the component by doing reset OCS queue ?

Regards, Amber S | ITL

Former Member
0 Kudos

Going from 7.00 to 7.01 is done through Enhancement Pack installer. You need to use that. Look for Netweaver Enhancement pack 1 upgrade guide under [https://websmp107.sap-ag.de/instguidesNW70].

Thanks,

Naveed