Skip to Content
0
Aug 29, 2007 at 08:46 PM

ORA-01455 error

491 Views

The kernel was 2307 and has been updated to 2265. Since then we have

been getting the following error when using BRtools :

BR0301E SQL error -1455 at location BrSegListGet-4

ORA-01455: converting column overflows integer datatype

We are also getting short dumps when we try to go into DB02 and other database related transactions:

Overflow for arithmetical operation (type P) in program "SAPLSTD4 "

SAP note system. If you have access to

the SAP notes system yourself, enter the following search strings:

"COMPUTE_BCD_OVERFLOW"

"BCD_FIELD_OVERFLOW" (By release 4.0a, this error has been remedied at this

point)

"SAPLSTD4 " or "LSTD4U02 "

"NEW_ANALYSIS"

001640 LOOP AT SEGMENTS_CACHE.

001650 IF SEGMENTS_CACHE-S_TYPE(5) = 'TABLE'.

001660 WORK_TABLE_NO = WORK_TABLE_NO + 1.

> WORK_TABLE_SIZE = WORK_TABLE_SIZE + SEGMENTS_CACHE-KBYTES.

001680 IF SEGMENTS_CACHE-EXTENTS > 1.

001690 WORK_TABLE_1EX = WORK_TABLE_1EX + 1.

001700 ENDIF.

Any ideas? We are running Oracle 9i on HP-UX. Nothing in the OS or the database has changed. Only Kernel upgrades. Digging through SAP Notes has not helped.

Thanks

Vince