on 08-29-2007 9:46 PM
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
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!!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.