Database instance Export error

[Former Member]

Dear community,

I am doing system copy process. Our Version is ECC6.0 running on os400/DB2.

On the ABAP EXPORT process we are getting an error like this on the "export_monitor.log":

TRACE: 2012-11-22 03:36:25 com.sap.inst.migmon.LoadTask run
Unloading of 'ACCTCR-1' export package is started.

ERROR: 2012-11-22 03:36:25 com.sap.inst.migmon.LoadTask run
Unloading of 'ACCTCR-1' export package is interrupted with exception.
java.io.FileNotFoundException: DATA/ACCTCR.STR
at java.lang.Throwable.<init>(Throwable.java:195)
at java.lang.Exception.<init>(Exception.java:41)
at java.io.IOException.<init>(IOException.java:40)
at java.io.FileNotFoundException.<init>(FileNotFoundException.java:46)
at com.sap.inst.migmon.LoadTask.buildTaskFileCommand(LoadTask.java:463)
at com.sap.inst.migmon.LoadTask.processPackage(LoadTask.java:267)
at com.sap.inst.migmon.LoadTask.run(LoadTask.java:195)
at java.lang.Thread.run(Thread.java:534)
at com.sap.inst.lib.util.ThreadDispatcher$ThreadWrapper.run(ThreadDispatcher.java:113)

On the export_monitor_java.log:

Unloading of 'ACCTCR-1' export package: ERROR

On the same directory, should exist ACCTCR-1.log file but it does not exist....

Table ACCTCR is on txt file to be splitted like <table>%<nr of splits> : ACCTCR%2

Export prepare & Table splitting prepare are succesfully completed.

Kernel is updated recently, also r3load, R3ta + R3ldctl + R3szchk are updated to the last version available. Java is Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.2_19-b04)

Could you help me to achieve this issue, please??

Thanks in advance

Scott

[Former Member · Accepted solution]

Hello Scott,

I have this same problem running my export on Solaris 10 SPARC running DB2 LUW 9.7. I am running latest 720_EXT non-Unicode kernel with latest r3load, R3ta + R3ldctl + R3szchk and disp+work package. Export was running fine without table splitting but had to stop it because it was running to long on tables AABLG, CDCLS and KOCLU. So decided to try table splitting these tables with txt file same as what you did <tablename>%<number>. I am doing this export for a Unicode conversion.

Can you please let me know if you might have already found a solution to this problem, in the mean while if I find solution I will let you know.

Regards,

Jaco Viljoen.

[Former Member · Accepted solution]

Hello Scott,

I found this thread. I am trying to use it. So far export is picking up my splits now. Hope it will help you.

http://scn.sap.com/thread/870548

This is Carsten Finck's answer.

Dear all,

now I found the solution for my problem.

I hope this thread can help others to make table splitting easier.

Regards

Carsten

1. use  NW04s SR3 Software

2. Split Preparation

- create a file with all tables that you want to split like

ACCTIT%10

BSIS%5

- copy the latest R3ta in your /sapmnt/<SID>/exe directory

- copy R3ta_hints.txt to your installation directory

- make sure that PSAPTEMP is large enough

3. Export

- Let the environment variable TEMP point to your installation directory.

- copy the STR-files created during split preparation from the split-installation directory to /<EXPORT>/ABAP/DATA

- copy the WHR-files created during split preparation from /<EXPORT>/DATA to /<EXPORT>/ABAP/DATA

- start sapinst

- activate check box "Split STR files"

- activate check box "Split predefined tables" in the file that is requested make a list of all tables that are splitted like:

ACCTIT

BSIS

- I think it is a good idea to split packages with a size more than 5000MB. In my opinion in large systems the default value of 1000MB is to small.

- activate check box "Define Package Unload Order"

- Start the Export

- After a short time you are asked to edit the file order_by.txt. All packages that are splitted by the package size option are filled in correctly (SAPAPPL0_1, SAPAPPL0_2, etc.). All tables that are splitted by you have to be edited. E.g. ACCTIT has to be changed to ACCTIT-1, ACCTIT-2, ..., ACCTIT-10.

[Former Member]

Hello...Finally solved by myself.

I have stopped this Export, deleted folders created during the process and run it again from a new Export process but without use 'table splitting' option.

Export was succesfully ended.

Not the solution desired but it works for  me...hope it helps...

Thanks a lot for your time and help.

Scottie.