Skip to Content

ORA-01455 error

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Aug 30, 2007 at 06:45 AM

    Hi Vince,

    Looks like the cause of this problem is the converted form of the specified expression was too large for the specified datatype.

    Try to define a larger datatype or correct the data.

    Regards,

    Rohit

    Message was edited by:

    Rohit Goswami

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 13, 2007 at 07:20 PM

    Vince,

    Have you looked at note# Note 1050329 - BR*Tools fails with ORA-01455 when database exceeds 16 TB (in case your database exceeds this size).

    Thanks

    BMG

    Add comment
    10|10000 characters needed characters exceeded

    • > Note 1003467 - Short Dump COMPUTE_BCD_OVERFLOW in

      > DB02, COLL-Job or STD3

      From the note:

      "The data area or log area of your MaxDB database is larger than 2^31 KB = 2048 GB = 2 TB."

      1. we use Oracle

      2. Our database is only about 550Gb

  • Sep 14, 2007 at 02:57 PM

    Solved.

    Apparently the admin who refreshed the database did so from a 9.2.0.4 database to a server that was running 9.2.0.8. i reran the catalog.sql and catproc.sql scripts and now all the tools/screens are happy.

    Thanks for everyones input!!

    Add comment
    10|10000 characters needed characters exceeded