R3load strange problem

[Former Member]

Hi Experts,

I met a strange problem.

I am trying to migrate a ECC system, the import procedure came to package 16 (totally 19), but the speed was too slow that I can't bear so I decide to manually R3load one by one (just a try).

the manual r3load also failed, then I try to run command r3load -testconnect, I found the error message is:

(DB) ERROR: this R3load operates only on ORACLE databases

The detail error log is:

D:\usr\sap\PWO\SYS\exe\uc\NTAMD64\R3load.exe -testconnect
sapparam: sapargv( argc, argv) has not been called.
sapparam(1c): No Profile used.
sapparam: SAPSYSTEMNAME neither in Profile nor in Commandline
R3load.exe: START OF LOG: 20110727155007

R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#14 $ SAP
R3load.exe: version R7.00/V1.4 [UNICODE]
Compiled Feb 27 2011 23:07:07
R3load.exe -testconnect 

(DB) ERROR: this R3load operates only on ORACLE databases

R3load.exe: Job finished with 1 errors
R3load.exe:END OF LOG: 20110727155007

It's so strange that I use windows server 2003 + oracle 10g, and the kernel was the latest version for Oracle, level 291...

The r3load.exe used during export is the same as in the import phase.

Oracle instance was confirmed started up, lsnrctl status ok.

Could any expert help me on this?

Thank you in advance.

Li

[sunny_pahuja2]

Hi,

It's only slow performance that is creating trouble or you are facing some error ?

How many parallel R3load process you have given for import ? What is the system configuration (RAM and CPU) ? What is the CPU and RAM utilization when we import is running ?

Thanks

Sunny

[Former Member]

Hi Sunny,

Only 1 R3load process running, loadprocedure fast option was not switched on since H/W of my training machine is not strong enough (3.25G physical RAM, P4 3G dual core, but the disk capability is very poor, 5400rpm with low cache).

I was stopped at importing package SAPAPPL2 task, the r3load process running two many hours (above 10 hours, tried several times), I can see from windows task manager that the RAM cost more and more (from 1.5GB to 11GB), but there isn't any tables being created or data loaded (see from SAPAPPL2.log).

So I just want to try to load by manual, try to load only one table(modified TSK file) to see the result, but also failed, at this moment I found R3load -testconnect shows strange message, I don't know why...

Thanks and best regards,

Li

[Former Member]

hi all

problem solved with reference to sdn:

in short, we should use sidadm to logon system instead of administrator since there are many user env variables...

one more question, why the load speed is still too slow if I use R3load manually to load only one table?

I use command:

C:\Program Files\sapinst_instdir\ERP\LM\COPY\ORA\SYSTEM\CENTRAL\AS> R3load -i SAPAPPL2.cmd -dbcodepage 4103 -l SAPAPPL2.log -stop_on_error

contents in SAPAPPL2.cmd:

tsk: "C:\Program Files\sapinst_instdir\ERP\LM\COPY\ORA\SYSTEM\CENTRAL\AS\SAPAPPL2.TSK"
icf: "F:\PWOEXP\ABAP\DATA\SAPAPPL2.STR"
dcf: "C:\Program Files\sapinst_instdir\ERP\LM\COPY\ORA\SYSTEM\CENTRAL\AS\DDLORA.TPL"
dat: "F:\PWOEXP\ABAP\DATA\" bs=1k fs=1000M
dir: "F:\PWOEXP\ABAP\DATA\SAPAPPL2.TOC"
ext: "F:\PWOEXP\ABAP\DB\ORA\SAPAPPL2.EXT"

contents of SAPAPPL2.TSK:

T A003 C xeq
D A003 I xeq
P A003~0 C xeq

contents of SAPAPPL2.STR and SAPAPPL2.EXT were also modified, only contains table A003 for testing.

while R3 loading, the RAM also cost too much, from 995M to 4.75G now, and is still increasing...

expert help...thank you

[Former Member]

I found the large memory consumption was caused by file SAPAPPL2.TOC,

if I modify this file - SAPAPPL2.TOC to contains only one table, the speed was up and the table can be created successfully.

comparing with other TOC files, this one is the biggest one, it is 3MB and 133342 lines, I think maybe the r3load program allocates spaces for all the tables within the TOC file at first, and thus made the large memory consumption and slow system response time. is my understanding correct?

could any expert tell me the function of TOC file? is there any other way to split this kind of large file (package SAPAPPL2) into several small ones so that the workload of R3load are not so heavy?

Thank you very much.

[sunny_pahuja2]

Hi,

You can further split TCO files based on Table Splitting feature. If you split tables using table spliting option in sapinst then you can get away with this problem.

Thanks

Sunny

[Former Member]

thanks, the problem has been solved by splitting big packages into several small ones.