SPAM/SAINT update

[Former Member]

Hi All,

I have installed solman7.0 ehp1 with SP18. Now i am upgrading to SP23. The phase MAIN IMPORT finished with return code 4 from 2 hrs. What could be the reason for this? Please find the log from SLOG.

START CMDIMPORT SM2 L 20100812120425 INF101902 chnmct211397d 20100812120423949

STOP CMDIMPORT SM2 L 20100812120438 INF101902 chnmct211397d 20100812120423949

START imp all SM2 20100812120509 INF101902 chnmct211397d 20100812120509058

INFO: event SAP_IMPORT_START triggered successfully

START DD IMPORT SM2 H 20100812120510 INF101902 chnmct211397d 20100812120509058

STOP DD IMPORT SM2 H 20100812120617 INF101902 chnmct211397d 20100812120509058

START DD ACTIVATION SM2 A 20100812120619 INF101902 chnmct211397d 20100812120509058

START tp_getprots SM2 J 20100812120619 INF101902 chnmct211397d 20100812120509058

STOP tp_getprots SM2 J 20100812120927 INF101902 chnmct211397d 20100812120509058

STOP DD ACTIVATION SM2 A 20100812120927 INF101902 chnmct211397d 20100812120509058

START DISTRIBUTION OF DD-O SM2 S 20100812120927 INF101902 chnmct211397d 20100812120509058

START tp_getprots SM2 S 20100812120927 INF101902 chnmct211397d 20100812120509058

STOP tp_getprots SM2 S 20100812120943 INF101902 chnmct211397d 20100812120509058

STOP DISTRIBUTION OF DD-O SM2 S 20100812120943 INF101902 chnmct211397d 20100812120509058

INFO TBATG CONVERSION OF SM2 N not needed INF101902 chnmct211397d 20100812120509058

START MOVE NAMETABS SM2 6 20100812120943 INF101902 chnmct211397d 20100812120509058

START tp_getprots SM2 P 20100812120943 INF101902 chnmct211397d 20100812120509058

STOP tp_getprots SM2 P 20100812121040 INF101902 chnmct211397d 20100812120509058

STOP MOVE NAMETABS SM2 6 20100812121040 INF101902 chnmct211397d 20100812120509058

START MAIN IMPORT SM2 I 20100812121040 INF101902 chnmct211397d 20100812120509058

STOP MAIN IMPORT SM2 I 20100812121318 INF101902 chnmct211397d 20100812120509058

START TBATG CREATION OF EN SM2 n 20100812121318 INF101902 chnmct211397d 20100812120509058

START tp_getprots SM2 Y 20100812121319 INF101902 chnmct211397d 20100812120509058

STOP tp_getprots SM2 Y 20100812121444 INF101902 chnmct211397d 20100812120509058

STOP TBATG CREATION OF EN SM2 n 20100812121444 INF101902 chnmct211397d 20100812120509058

START EXECUTION OF REPORTS SM2 R 20100812121444 INF101902 chnmct211397d 20100812120509058

START tp_getprots SM2 R 20100812121444 INF101902 chnmct211397d 20100812120509058

STOP tp_getprots SM2 R 20100812122151 INF101902 chnmct211397d 20100812120509058

STOP EXECUTION OF REPORTS SM2 R 20100812122151 INF101902 chnmct211397d 20100812120509058

INFO: event SAP_IMPORT_STOP triggered successfully

STOP imp all SM2 0004 20100812122153 INF101902 chnmct211397d 20100812120509058

START CMDIMPORT SM2 L 20100812122512 INF101902 chnmct211397d 20100812122512320

STOP CMDIMPORT SM2 L 20100812122551 INF101902 chnmct211397d 20100812122512320

START CMDIMPORT SM2 L 20100812134139 INF101902 chnmct211397d 20100812134138982

STOP CMDIMPORT SM2 L 20100812134141 INF101902 chnmct211397d 20100812134138982

START DD IMPORT SM2 H 20100812134555 INF101902 chnmct211397d 20100812134554531

STOP DD IMPORT SM2 H 20100812134629 INF101902 chnmct211397d 20100812134554531

START DD ACTIVATION SM2 A 20100812134634 INF101902 chnmct211397d

START tp_getprots SM2 J 20100812134634 INF101902 chnmct211397d

STOP tp_getprots SM2 J 20100812134740 INF101902 chnmct211397d

STOP DD ACTIVATION SM2 A 20100812134740 INF101902 chnmct211397d

START imp all SM2 20100812134742 INF101902 chnmct211397d 20100812134741729

INFO: event SAP_IMPORT_START triggered successfully

START DD IMPORT SM2 H 20100812134742 INF101902 chnmct211397d 20100812134741729

STOP DD IMPORT SM2 H 20100812134742 INF101902 chnmct211397d 20100812134741729

START DISTRIBUTION OF DD-O SM2 S 20100812134742 INF101902 chnmct211397d 20100812134741729

START tp_getprots SM2 S 20100812134742 INF101902 chnmct211397d 20100812134741729

STOP tp_getprots SM2 S 20100812134745 INF101902 chnmct211397d 20100812134741729

STOP DISTRIBUTION OF DD-O SM2 S 20100812134746 INF101902 chnmct211397d 20100812134741729

INFO TBATG CONVERSION OF SM2 N not needed INF101902 chnmct211397d 20100812134741729

START MOVE NAMETABS SM2 6 20100812134746 INF101902 chnmct211397d 20100812134741729

START tp_getprots SM2 P 20100812134746 INF101902 chnmct211397d 20100812134741729

STOP tp_getprots SM2 P 20100812134749 INF101902 chnmct211397d 20100812134741729

STOP MOVE NAMETABS SM2 6 20100812134749 INF101902 chnmct211397d 20100812134741729

START MAIN IMPORT SM2 I 20100812134749 INF101902 chnmct211397d 20100812134741729

STOP MAIN IMPORT SM2 I 20100812134836 INF101902 chnmct211397d 20100812134741729

START TBATG CREATION OF EN SM2 n 20100812134836 INF101902 chnmct211397d 20100812134741729

START tp_getprots SM2 Y 20100812134836 INF101902 chnmct211397d 20100812134741729

STOP tp_getprots SM2 Y 20100812134842 INF101902 chnmct211397d 20100812134741729

STOP TBATG CREATION OF EN SM2 n 20100812134842 INF101902 chnmct211397d 20100812134741729

INFO: event SAP_IMPORT_STOP triggered successfully

STOP imp all SM2 0000 20100812134843 INF101902 chnmct211397d 20100812134741729

START EXECUTION OF REPORTS SM2 R 20100812134853 INF101902 chnmct211397d

START tp_getprots SM2 R 20100812134853 INF101902 chnmct211397d

STOP tp_getprots SM2 R 20100812134858 INF101902 chnmct211397d

STOP EXECUTION OF REPORTS SM2 R 20100812134858 INF101902 chnmct211397d

START tp_rm_cntl_mark SM2 20100812134859 INF101902 chnmct211397d

STOP tp_rm_cntl_mark SM2 20100812134859 INF101902 chnmct211397d

START CMDIMPORT SM2 L 20100812135841 INF101902 chnmct211397d 20100812135841429

STOP CMDIMPORT SM2 L 20100812135955 INF101902 chnmct211397d 20100812135841429

START DD IMPORT SM2 H 20100812142143 INF101902 chnmct211397d 20100812142142572

STOP DD IMPORT SM2 H 20100812143247 INF101902 chnmct211397d 20100812142142572

START DD ACTIVATION SM2 A 20100812143307 INF101902 chnmct211397d

START tp_getprots SM2 J 20100812143312 INF101902 chnmct211397d

STOP tp_getprots SM2 J 20100812150530 INF101902 chnmct211397d

STOP DD ACTIVATION SM2 A 20100812150530 INF101902 chnmct211397d

START imp all SM2 20100812150535 INF101902 chnmct211397d 20100812150534792

INFO: event SAP_IMPORT_START triggered successfully

START DD IMPORT SM2 H 20100812150536 INF101902 chnmct211397d 20100812150534792

STOP DD IMPORT SM2 H 20100812150536 INF101902 chnmct211397d 20100812150534792

START DISTRIBUTION OF DD-O SM2 S 20100812150536 INF101902 chnmct211397d 20100812150534792

START tp_getprots SM2 S 20100812150537 INF101902 chnmct211397d 20100812150534792

STOP tp_getprots SM2 S 20100812150732 INF101902 chnmct211397d 20100812150534792

STOP DISTRIBUTION OF DD-O SM2 S 20100812150733 INF101902 chnmct211397d 20100812150534792

START TBATG CONVERSION OF SM2 N 20100812150733 INF101902 chnmct211397d 20100812150534792

START tp_getprots SM2 N 20100812150733 INF101902 chnmct211397d 20100812150534792

STOP tp_getprots SM2 N 20100812150743 INF101902 chnmct211397d 20100812150534792

STOP TBATG CONVERSION OF SM2 N 20100812150743 INF101902 chnmct211397d 20100812150534792

START MOVE NAMETABS SM2 6 20100812150743 INF101902 chnmct211397d 20100812150534792

START tp_getprots SM2 P 20100812150743 INF101902 chnmct211397d 20100812150534792

STOP tp_getprots SM2 P 20100812152243 INF101902 chnmct211397d 20100812150534792

STOP MOVE NAMETABS SM2 6 20100812152243 INF101902 chnmct211397d 20100812150534792

START MAIN IMPORT SM2 I 20100812152244 INF101902 chnmct211397d 20100812150534792

please provide your solution...

thanks in advance

[former_member189725]

Can you check if any tp/R3trans is running in the OS level ?

Also go into the directory /usr/sap/trans/tmp

Check if the last log file is updated .

Regards

Ratnajit

[nelson_chamba2]

Hi Amit,

My SP still working if you go to sm50 i can see activity there. I don´t believe that there is CPU or Memory bottlenecks but please can you tell me how do i check this?

Khushu, i´m not using oracle it´s all Microsoft, MS SQL Server 2005 on Windows 2008 EE R2.

Dey, there is nothing on the ...\tmp\ directory. I deleted everything from there in order to restart the import process. I deleted all the packages from the \tmp and from EPS\in but after i start the import because it is on stage 5/6 i brings again the files from i don´t know where to the \usr\sap\trans\tmp and start importing it.

The error or information it shows me now on sap gui is:

MAIN IMPORT finished with returncode 4 and stay there for the all day.

On the \tmp i can see these files:

SAPI-603DDINSAPAPP.SAR

SAPI-603FINSAPAPPL.SAR

SAPI-603DFINSAPAPPL.SAR

SAPI-603DRINSAPAPPL.SAR

SAPI-603DWINSAPAPPL.SAR

SAPKKI-603DRINSAPAPPL.SAR

SAPKKI-603DWINSAPAPPL.SAR

All of them disappeared and just still these two

SAPI-603FINSAPAPPL.SAR

SAPI-603DFINSAPAPPL.SAR

And file size keep increasing.

any idea,

regards

Nelson/

[former_member204746]

check if you see moved on directory /usr/sap/trans/tmp

in SM50, see if you have any activity.

[nelson_chamba2]

Hi for my case it shows activiy but took the all day keep updating the numbers.

[Former Member]

hello Nelson

is your SP upgrade currently stopped  ? can you check your O.S to make sure there is no CPU or memory bottlenecks as it can make your imports slow.

Regards

Amit

[Former Member]

Hi,

If this is Oracle did you run the stats before the SP upgrade. If not please run them particularly the space stats.that should quicked ur SP upgrade time.

regards.

Ruchit.