on 11-21-2008 6:47 AM
Hi Gurus,
Good day.
We have a number of Batch jobs failing with Oracle error. DBIF_SETG_SQL_ERROR is the eror that we are getting and the primary reason for this is this error is ORA-01455 (converting column overflows integer data).
Do you think a certain OSS Note can fix this problem? Kindly advise.
Thanks!
check Note 591600 - Error due to inappropriate column values
cheers,
-Sunil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Brando
I'm experiencing exactly the same issue. You've marked this as answered. Can you please state what did you do to solve this issue ?
Regards
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi gurus,
Adding additional information:
I would like to ask for your help with regard to the short dump that we experienced with Job SAP_COLLECTOR_FOR_PERFMONITOR (program RSCOLL00). The error is DBIF_SETG_SQL_ERROR.
Date Time Message text
24.11.2008 02:30:39 Job started
24.11.2008 02:30:39 Step 001 started (program RSCOLL00)
24.11.2008 02:30:44 ABAP/4 processor: DBIF_SETG_SQL_ERROR
24.11.2008 02:30:44 Job cancelled
ORA-01455 is said to be the reason why we encountered DBIF_SETG_SQL_ERROR.
Database error text........: "ORA-01455: converting column overflows integer datatype"
Can you advise an OSS Note or certain solution that can fix this issue? Thank you very much!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Eric and Sunil,
Thank you very much for your reply!
Yes, I was able to check on the SAP Note. Unfortunately, it seems that it's not the correct note per se.
In the note 591600 it is stated that "ORA-01455: In the context of a SELECT, you try to transfer the content of a column to an integer variable where the content of the column disrupts the integer number area."
Our programs are being terminated in Function Module RS_COMPONENT_VIEW:
Information on where terminated
Termination occurred in the ABAP program "SAPLSEU_COMPONENT" - in
"RS_COMPONENT_VIEW".
The main program was "SAPMS07A ".
To be specific in this line:
IF refresh IS INITIAL.
* get table "nodetab" of all object lists
* of the desired type "object_type":
IMPORT date nodetab FROM DATABASE dwtree(ap) ID apid
ACCEPTING PADDING.
subrc = sy-subrc.
ENDIF.
Hi Eric,
Thanks again for your reply!
I'm an ABAPer and to be honest, currentlly, I don't have any idea if the client really did an ECC 6 upgrade --- when they did it. I will just check the table that you sent.
I just had the impression that it might be due to an ECC 6 Upgrade since I saw this case over the Internet:
"DBIF_SETG_SQL_ERROR" and "ORA-03106: fatal two-task communication protocol error" after ERP 6.0 Upgrade ( http://sap.ittoolbox.com/groups/technical-functional/sap-basis/dbif_setg_sql_error-and-ora-03106-fat... ).
Yes, we are also experiencing DBIF_SETG_SQL_ERROR (ORA-03106). But, I'm taking care of DBIF_SETG_SQL_ERROR (ORA-01455).
By the way, I saw that jobs EU_PUT and EU_REORG are being executed in background every morning at around 1 AM. And we are receiving the error DBIF_SETG_SQL_ERROR (ORA-01455) at around 2 AM - 3 AM, and a few at around 3 AM - 5 AM.
With these I have two questions:
(1) Do you think we still need to rerun EU_PUT and EU_REORG? Perhaps before 2 AM ?
(2) Do you think this is a Basis Issue and nothing to do with ABAP anymore?
Thank you very much!
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.