R3load error during import

[Former Member]

Hi All,

We are doing the migration from AIX to Linux .

During the import , most of the packages got imported succfully. But there is issue with only one.SAPAPPL1_12.

In this there is a table SOFFCONT1 which data import is giving the following error.

**************************

(IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed

rc = 99, table "SOFFCONT1"

(SQL error 1691)

error message returned by DbSl:

ORA-01691: unable to extend lob segment SAPSR3.SYS_LOB0000125428C00007$$ by 8192 in tablespace PSAPSR3

(RFS) ERROR: unexpected message "00977980 00000032"

instead of END OF JOB

(DB) INFO: disconnected from DB

************************

I have nearly increased the space for the tablespace by 70G but too i am getting this error.

What can be the cause. I dont think it is space problem

Please suggest

Br

Anthony

[former_member189546]

Hello,

Check file system need to have large file system enabled.

Also check note 500340.

It mentions:

an update that shrinks only values in a lob column needs to

extend the corresponding lobsegment because the new value in the

lob column does not overwrite the old value but is placed in the

lobsegment additionally. Possible errors:

- ORA-01693: max # extents ... reached in lob segment ...

- ORA-01691: unable to extend lob segment ... by ... in

tablespace ...

Those errors can be handled in the normal way by increasing the

maxextents/nextextentsize respectively the tablespace size.

regards,

John Feely

[markus_doehr2]

> **************************

> (IMP) ERROR: DbSlExeModify/DbSlLobPutPiece failed

> rc = 99, table "SOFFCONT1"

> (SQL error 1691)

> error message returned by DbSl:

> ORA-01691: unable to extend lob segment SAPSR3.SYS_LOB0000125428C00007$$ by 8192 in tablespace PSAPSR3

> (RFS) ERROR: unexpected message "00977980 00000032"

> instead of END OF JOB

> (DB) INFO: disconnected from DB

Are you using the newest R3load and libdbora.so files to do the import?

Markus

[Former Member]

Hi Markus,

Yes , the new R3load and libdbora.so were used.

Basically when i checked the lob segement in the target it was 44G in size , even through i increased the size of my tablespace by 70G i was still geting the same error.

Is there any special way or process to handle lob export / import?

Br

Anthony

[markus_doehr2]

> Basically when i checked the lob segement in the target it was 44G in size , even through i increased the size of my tablespace by 70G i was still geting the same error.

How big is that tablespace and table in the source system? It may still be too small.

Markus