ORA-01455 error

[vince_laurent]

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

[vince_laurent]

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!!

[Former Member]

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

[vince_laurent]

> 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).

Yes, I did. Our DB is a mere 1/2TB... the largest datafiles are 2G.

[former_member204746]

so, you probably have more than 254 datafiles?

alter database backup controlfile to trace ;

check trace results for value on MAXDATAFILES

[vince_laurent]

> so, you probably have more than 254 datafiles?

MAXDATAFILES 600

[former_member84399]

Note 1003467 - Short Dump COMPUTE_BCD_OVERFLOW in DB02, COLL-Job or STD3

[former_member84399]

Hello Vince,

Do you have a test system to upgrade the kernel further to version 2337 or 2341? If this problem occured as part of a kernel upgrade, it might be useful to see if it can be solved by going to a higher kernel level . Just download the dw and enq .CAR files and try it

Also , on the SP level , I didn't find any 4.6C basis pack greater than 53, so I assume you are in 53 and not in 54? Please correct me if I am wrong. In any case you have the latest, so not much can be done there!

Let me know how you are getting on

Andreas

[vince_laurent]

> 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

[Former Member]

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

[vince_laurent]

But it is SAP delivered code. There was no issue with the Itanium systems. Just the PA-RISC.

[Former Member]

Hello,

Please check if note

Note 682382 - Oversized datafiles in transaction DB02

is applicable for you

What SAP version are you running? Also, you write that

"The kernel was 2307 and has been updated to 2265" Do you mean updated to 2365 maybe?

Regards

Andreas

Message was edited by:

Andreas Malandrinos

[vince_laurent]

Q: What SAP version are you running?

A: 4.6C with 4.6D_ext kernel

Q: "The kernel was 2307 and has been updated to 2265" Do you mean updated to 2365 maybe?

Does this help?

disp+work information

-

---

kernel release 46D

kernel make variant 46D_EXT

DBMS client library OCI_920_64__OCI_7_API

DBSL shared library version 46D.00

compiled on HP-UX B.11.00 A 9000/800

compiled for 64 BIT

compile time Feb 20 2007 21:50:52

update level 0

patch number 2307

source id 0.2307

was

disp+work information

-

---

kernel release 46D

kernel make variant 46D

DBMS client library OCI_805_64__OCI_7_API

DBSL shared library version 46D.00

compiled on HP-UX B.11.00 U 9000/800

compiled for 64 BIT

compile time Jul 24 2006 20:46:27

update level 0

patch number 2265

source id 0.2265

I am looking into the SAP note right now too...

Vince

[vince_laurent]

> Note 682382 - Oversized datafiles in transaction DB02

> is applicable for you

Our largest datafile is 2G.

[Former Member]

Hello again,

Please have a look at

Note 591600 - Error due to inappropriate column values

Let me know your Basis Support pack level as well

Andreas

[vince_laurent]

> Hello again,

>

> Please have a look at

>

> Note 591600 - Error due to inappropriate column values

>

> Let me know

That is the note I was working on first. Been doing the analyse in the slow times on the database. Nothing yet. I will try the trace next...

Vince

[Former Member]

Please let me know your Basis Support pack level as well

[vince_laurent]

> Please let me know your Basis Support pack level as well

54