on 02-28-2008 7:41 AM
Hi,
We are doing an heterogeneous system copy of BW 3.5 from Solaris to Linux X86_64.
In order to speed up the import phase, we tried to use R3load with "-loadprocedure fast" option, as described in SAP note 1045847.
The import starts and after a while it failes with the following error:
"ORADPL:2008.02.26 16:25:24 (ret=-1) ORA-26002: Table "SAPSR3"."/BIC/B0000104000" has index defined upon it.
ORADPL:2008.02.26 16:25:24 fatal error in line 2145, (status=26002) cannot prepare direct path"
This error occurred for other different tables.
I don't really understand the error "table <abc> has index defined upon it". almost every table has at least one index, so why this error happen for these particular tables?
Best Regards,
Nahum
This may be a bug in SMIGR_DDL_SELECT_ORA that generates the CREATE INDEX commands in combination with the CREATE TABLE command. On which basis support package are you? The issue should be fixed as of:
620 SAPKB62061
640 SAPKB64019
700 SAPKB70010
Alternatively note 971840 can be applied.
Kind regards
Martin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Martin,
The note has not been released in English yet, but even with my poor German I can see that it mght solves the problem.
However when I look at the correction instaruction it says that the note is valid from SAPKB64017 - SAPKB64019, when I'm in SAPKB64014. for that reason SNOTE mark the note as "cannot be implemented".
Should I upgrade to basis SP 19 before impementing the correction?
Thanks,
Nahum
Hello Nahum,
the note should also be available in English. I only added the ORA-26002 message in the German version today in order to make it easier for our customers to detect this note when they run into the error. Therefore the English version is flagged as being not current.
Upgrading to a more current basis support package is definitly a good idea.
Kind regards
Martin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
i remeber having the same issue copying a bw system...i'd rather omit the option and restart SAPinst...all data that has been imported already will not be affected...
how many parallel r3load processes you are running?
GreetZ, AH
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.