Hello SAP experts,
I faced an really strange issue in my last migration which I want to share with you.
Source system: BW 7.00
Kernel < 720 P513
DB size 2.6TB
46 splitted tables
Kernel 720 EXT P500
Normal export/import procedure with R3load.
After the import was finished with no errors (all packages were imported shown in migration monitor) the installer (object checker) tells us as normal the invalid objects which includes as usual all splitted tables and some DB dependend objects.
I have checked the .tsk (task files) -> every packages was OK. DB size was only 700GB and this made me really reflective (should be arround 2TB).
I have checked the object_checker.log which includes the splitted table and the known ones ‘DBPROPERTIES’ and ‘DDLOG’.
My guess was on the basis of the size of the DB that the splitted tables are missing. So I have checked the logs and there was an error in all files:
(RFF) ERROR: no entry for table “DYNPSOURCE” in “X:\EXPORT\PBI\ABAP\DATA\DYNPSOURCE-1.TOC”
A normal restart of the command ended in the same error. So I cross checked the TOC and the TSK file:
D DYNPSOURCE I ok <<< strange because there should be “err”
(“PROGNAME” < ‘GPD2GH1YHUUR2Z73QFELVE68B2T’) OR (“PROGNAME” = ‘GPD2GH1YHUUR2Z73QFELVE68B2T’
AND “DYNPNUMBER” < ‘0001’) OR (“PROGNAME” = ‘GPD2GH1YHUUR2Z73QFELVE68B2T’
AND “DYNPNUMBER” = ‘0001’ AND “R3STATE” < ‘A’)
fil: DYNPSOURCE-1.001 1024
eot: #0 rows 20131109175632
sel: WHERE (“PROGNAME” < ‘GPD2GI5GE735UCJ74QK05ILGKD1’) OR (“PROGNAME” = ‘GPD2GI5GE735UCJ74QK05ILGKD1’
sel: AND “DYNPNUMBER” < ‘1000’) OR (“PROGNAME” = ‘GPD2GI5GE735UCJ74QK05ILGKD1’
sel: AND “DYNPNUMBER” = ‘1000’ AND “R3STATE” < ‘A’)
fil: DYNPSOURCE-1.001 1024
eot: #13470 rows 20131109183854
Before importing the dump the R3load cross checks the exact WHERE-clause in TOC and TSK file. And as you can see there are several differences.
For example the enter after WHERE and the space after the first OR. I have corrected these typos in the TOC file like the TSK file.
I rerun the R3load command for the export and it worked! But my situation was really bad, because I had to manually check and rerun round about 400 files.
So I have choosen the easiest way => do the export import again with the newest R3load/R3ldctrl.
Here are notes which were released only a few days after I have done the prepare check for the kernel level:
1905316 – R3load skips table with error message “no entry for table”
1914260 – Abort R3load task if TOC file has no entry for the table
So if you hit the same issue and you only have a few splitted tables which are affected you can fix it manually. If you have over 50, the error rate is to big to do it manually, because there were not always the same typos in the files.
It is not enough to change the R3load for the import! You have to export and import the dump with a kernel > P513!!! (720 based)
changes in P513:
( 0.513) Abort R3load task if TOC file has not entry for the table (Hinweis 1914260)
( 0.513) R3load stops with Syslog F38 and (CNVPOOL) rscp error occu (Hinweis 1899983)
I must complain a little bit about the migration monitor why such errors are not recognized and shown in the packages status / task files.
Hope this blog helps other colleagues to avoid such issues.
Thanks and best regards,
PS: every time use the latest kernel and R3load/R3ta/R3ldcrtl/R3szchk for your migration/system copy