cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with import of split tables.

Former Member
0 Kudos

We are creating copy of our production system. The

system copy has a change of Operating system from HP-UX to Windows

X86_64 and is also has unicode conversion. We followed the following

steps:

1) Performed post copy steps and pre-unicode conversion steps

2) Split big tables using OSS note 1043380 - Efficient Table Splitting

for Oracle Databases

3) Copied *.WHR files to export directory and performed export using SAPinst

4) Copied files export dump to new server.

5) Created whr.txt manually and copied it to the DATA directory of

export dump

6) Started import using SAPinst

Surprisingly the import does not consider the split tables but marks

them as complete in the TSK files. Also the rows imported is 0 for

those tables.

The only error is:

(RFF) ERROR: no entry for table "CDCLS" in "F:\export\ABAP\DATA\CDCLS-1.TOC"

(IMP) INFO: import of CDCLS completed (0 rows) #20110122022015

Why is SAPinst not importing the tables that are split. All table that were not split are importing successfully and R3load is patched.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Resolved.

this is a known issue which is due to the sql splitter tool which

generates space characters at the end of the 'where' clause within the

TSK-file.

At the import that leads to the fact that the entries are not

recognized and nothing is imported, so in the import log you get

no entry for table "BALDAT" in "F:\ccpexport\CCP\ABAP\DATA\BALDAT-1.TOC"

As a workarround I would like you to apply the following:

1. remove all blank characters at the end of the WHR clause in the TSK

-file, that is i.e.:

D BALDAT I ok

WHERE ("LOG_HANDLE" < '4iLKIlCIjLpX0000p5bqa0')__ <-- I have marked the

two blank characters at the end of the line by '_'

remove this characters, so that the thera are no blanks at the end of

the line

2. set the status in the corresponding TSK-file from 'ok' to 'err'

3. repeat the import of the corresponding packages

I would like to mention that as per note # 1043380 you should use

both for the export and import:

R3load 7.00 version built newer than June 18th, 2008

- where this issue should be fixed.

Former Member
0 Kudos

Hi, I'm facin the same error.

I'm doing the import on AIX, while the source system was on Windows and during the export I splitted some table using the splitter of note 1043380.

You says there is a know bugs for the oracle splitter , please where is described ? I'm not able to find any Oss notes..

Please could you describe a little bit better how to modify the .TSK files ?

Here one of my TSK files involved ( I'm not able to find out the two spaces you indicated):

VBFA-1__TPI.TSK

D VBFA I ok

WHERE (ROWID >= CHARTOROWID('AAAaZsAAEAAAqYJAAA') and ROWID <= CHARTOROWID('AAAaZsAAEAAArYIEI/'))

/*+ ROWID ("VBFA") */

D VBFA I ok

WHERE (ROWID >= CHARTOROWID('AAAaZsAAEAACGUJAAA') and ROWID <= CHARTOROWID('AAAaZsAAEAACIUIEI/'))

/*+ ROWID ("VBFA") */

Did you modify also the import_state.properties file setting '-' instead of Ok for those packages you modify the .TSK files ?

Best regards