ORA-01455: converting column overflows integer datatype

[former_member117942]

Hi,

during export with sapinst for a system copy of a SAP Netweaver BI 7.0 Unicode on platform Windows 2003-Oracle 10 I've this error :

S:\usr\sap\BIP\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20110916204929

S:\usr\sap\BIP\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#23 $ SAP

S:\usr\sap\BIP\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jul 12 2011 02:00:09

process id 6440

S:\usr\sap\BIP\SYS\exe\uc\NTI386\R3load.exe -ctf E W:\EXPORT_BIP\ABAP\DATA\SAPDFACT_12.STR W:\EXPORT_BIP\ABAP\DB\DDLORA_LRG.TPL SAPDFACT_12.TSK ORA -l SAPDFACT_12.log

(RTF) ########## WARNING ###########

Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

S:\usr\sap\BIP\SYS\exe\uc\NTI386\R3load.exe: job completed

S:\usr\sap\BIP\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20110916204929

S:\usr\sap\BIP\SYS\exe\uc\NTI386\R3load.exe: START OF LOG: 20110916204929

S:\usr\sap\BIP\SYS\exe\uc\NTI386\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#23 $ SAP

S:\usr\sap\BIP\SYS\exe\uc\NTI386\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Jul 12 2011 02:00:09

process id 6364

S:\usr\sap\BIP\SYS\exe\uc\NTI386\R3load.exe -e SAPDFACT_12.cmd -datacodepage 4103 -l SAPDFACT_12.log -stop_on_error

(DB) INFO: connected to DB

(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF16

(DB) INFO: Export without hintfile

(GSI) INFO: dbname = "BIP20071121011110 "

(GSI) INFO: vname = "ORACLE "

(GSI) INFO: hostname = "ASOLO-BIP-01 "

(GSI) INFO: sysname = "Windows NT"

(GSI) INFO: nodename = "ASOLO-BIP-01"

(GSI) INFO: release = "5.2"

(GSI) INFO: version = "3790 Service Pack 1"

(GSI) INFO: machine = "8x Intel 801586 (Mod 1 Step 1)"

(GSI) INFO: instno = "INITIAL "

(RTF) ########## WARNING ###########

Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

(EXP) TABLE: "/BIC/E100129" #20110916205230

(EXP) TABLE: "/BIC/E100130" #20110916205434

(EXP) TABLE: "/BIC/E100131" #20110916205507

(EXP) TABLE: "/BIC/E100132" #20110916205512

(EXP) TABLE: "/BIC/E100133" #20110916205515

DbSl Trace: Error 1455 in stmt_fetch() from oci_fetch_stmt(), orpc=88745

DbSl Trace: ORA-1455 occurred when executing SQL stmt (parse error offset=186)

(EXP) ERROR: DbSlExeRead failed

rc = 99, table "/BIC/E100134"

(SQL error 1455)

error message returned by DbSl:

ORA-01455: converting column overflows integer datatype

(DB) INFO: disconnected from DB

S:\usr\sap\BIP\SYS\exe\uc\NTI386\R3load.exe: job finished with 1 error(s)

S:\usr\sap\BIP\SYS\exe\uc\NTI386\R3load.exe: END OF LOG: 20110916205519

I've tried also to update the last R3load but with no success.

Any idea ?

Thanks

Maurizio Manera

[Former Member]

Please advise, if you were able to solve this and how did you do that

[former_member189725]

Can you please check the oracle client version . What is the RDBMS version ? Just update the client version if required and check if that works.

[Former Member]

Can you please check as per note 23345 analyse.

599742 - Runtime error with ORA-1455 due to extent that is too big

601348 - ORA-1455 very big tables or extent that is too

586080 - ORA-1455 with an "Explain SQL"

146104 - SQL Error ORA-1455 for "Explain SQL" in SQL trace_

1557321 - Numeric Overflow during standard BW processes

992805 - Overflow during the arithmetical operation (type P)

Please check the above notes.

[nicholas_chang]

Hi,

Have you check are these tables exist?

Startup your system (ensure all jobs suspended, nothing run), go to se11 -> insert table name -> Utilities -> Database Object & Runtime Object -> Check

Cheers,

Thanks,

Nicholas Chang

[Former Member]

I assume the following error extract is from SAPDFACT_12.log

(EXP) ERROR: DbSlExeRead failed

rc = 99, table "/BIC/E100134"

(SQL error 1455)

error message returned by DbSl:

ORA-01455: converting column overflows integer datatype

(DB) INFO: disconnected from DB

See if these notes help

Note 591600 - Error due to inappropriate column values

Note 1557321 - Numeric Overflow during standard BW processes

Thanks