using SPAM to apply patch took looooong time

[peter_yu3]

Hi All,

I am working on apply a patch to my business suite on hana system. the patch I tried to apply is SAP_UI 74010(SAPK-74010INSAPUI), but it already took 20 hours, still not finished yet. /usr/sap/trans/log's last update is 20 hours ago, /usr/sap/trans/tmp has a file SAPI-74010INSAPUI.EC7 keep increasing. Any ways I can accelerate this import...? thanks.

this is a EhP 7 system on SuSE Linux, backend database is HANA(1.00.85.01.399276 (NewDB100_REL))

BR,

Peter

[williams_ruter3]

Hey Peter,

I had a similar error, to fix i did stop the process and define // import process for R3trans, the option is available from the menu extra in SPAM and re-run the import from where it stop.

It should fix your issue too.

Williams

[RolandKramer]

Hi,

did you tried SUM instead? SUM has more performance options.

Furthermore applying SAP_UI 74010(SAPK-74010INSAPUI) without a complete stack could cause additional problems, as it is part of the SP09 Stack for 7.40

Best Regards Roland

[HayBouten]

Do a tail -f on the file SAPI-74010INSAPUI.EC7 in /usr/sap/trans/tmp and show us what is written in the last 50 lines.

[peter_yu3]

Hay,

SAP_UI 740 10 finished in around 20 hours, now it is SAP_UI 740 11, it has already been run 12 hours, here is the last 50 lines:

saphana2:ec7adm 182> tail -n 50 SAPI-74011INSAPUI.EC7

4 ETW000   0 entries from SMIMPHF (D005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHF (C005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHF (B005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHF (A005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHF (9005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHF (8005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHF (6005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHF (5005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHF (4005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHF (3005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHF (2005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHF (1005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (d005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (c005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (Y005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (X005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (W005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (V005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (U005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (T005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (S005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (R005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (Q005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (P005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (O005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (N005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (M005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (L005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (K005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (J005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (I005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (H005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (G005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (F005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   1 d /   1 i /   0 u /   0 =   0% ucf SMIMPHIO

4 ETW000   1 entry for SMIMPHIO imported (E005056A207351ED39797D7E2BCA316B2*).

4 ETW000   0 entries from SMIMPHIO (D005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (C005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (B005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (A005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (9005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (8005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (6005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (5005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (4005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (3005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (2005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHIO (1005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHPR (d005056A207351ED39797D7E2BCA316B2%) deleted.

4 ETW000   0 entries from SMIMPHPR (c005056A207351ED39797D7E2BCA316B2%) deleted.

saphana2:ec7adm 183>

thanks for your help!

BR,

Peter

[HayBouten]

Hi Peter,

Looks like the SPAM is still running correctly, but only slow.

Did you follow the guidelines in SAP Note 1706930 - Inst. SAP Sys. Based on NW 7.3 and higher: SAP HANA DB, UNIX. on "REPOSRC Import Slow: Activating HANA Mass Import" and SAP Note 1775293 - Migration or system copy to SAP HANA using the latest software provisioning manager (SWPM 1.0).

These explain maybe the root cause of the problem and included a fix that could be applied before the start of the support package import.

-- Hay

[peter_yu3]

Hi Hay,

I have gone through those notes before, it related to mass import by R3load, but with my current SAPM apply patch, I saw it is tp control to call R3trans. I am not sure if R3trans also has the option HDB_MASSIMPORT=YES.

BR,

Peter