Error in import R3load in a migration R3 40B Oracle 8.1.7 Windows NT

[Former Member]

Hello,

I'm executing the import phase for a migration from SAP R/3 4.0B Oracle Windows NT. And in the last package I have the follow error:

#START: 20101029152725

TAB: SOC3

FIL: e:\EXP_EGP\DATA\SAPAPPL1.001 #20101029152725

DbSl Trace: DBSL-buffer (33000 bytes) too small for statement (requires 100045)

(IMP) ERROR: DbSlBegModify: rc = 2, table "SOC3"

(SQL error 0)

error message returned by DbSl:

ORA-00000: normal, successful completion

I add the parameter dbs/ora/array_buf_size=1000000 in the default profile, but the error is similar.

Where I must to modify the parameters?

regards, Alberto.

[tomas-krojzl]

Hello,

wow - SAP R/3 4.0B - quite antique...

I found this note: 94541 - DBIF_RSQL_INVALID_RSQL select .. where .. in <itab>

It is suggesting to adjust parameter dbs/io_buf_size =<size>

But I do not think that SAP parameter are playing any role in this - I would say that this is purely R3load stuff.

Do you use latest R3load? If not download latest dbsl and R3load from marketplace from archive.

I found there version:

SAP KERNEL 4.0B_EXT 32-BIT -> Windows Server on IA32 32bit -> ORACLE

R3load_30-10002453.CAR = R3LOAD patch level 30

SAP KERNEL 4.0B_COM 32-BIT -> Windows Server on IA32 32bit -> ORACLE

R3load_30-10000894.CAR = R3LOAD patch level 30

Not sure which kernel do you use...

Normally I would also recommend to download database library (dbsl) but unfortunately no such is available on Marketplace.

If this move is done as part of upgrade project - you might be lucky enough to get some support from SAP.

(Anyway be prepared to get answer from SAP: "Upgrade first to supported release and then attempt migration.")

Best regards.