cancel
Showing results for 
Search instead for 
Did you mean: 

DBIF_SETG_SQL_ERROR and ORA-01455

Former Member
0 Kudos

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!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

check Note 591600 - Error due to inappropriate column values

cheers,

-Sunil

Answers (2)

Answers (2)

Former Member
0 Kudos

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

Former Member
0 Kudos

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!

former_member204746
Active Contributor
0 Kudos

have you checked and read Sunil's answer?

check Note 591600 - Error due to inappropriate column values

Former Member
0 Kudos

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.

former_member204746
Active Contributor
0 Kudos

try to run jobs EU_PUT and EU_REORG.

Former Member
0 Kudos

Hi Eric,

Thank you very much!

I checked Note 18023 - Jobs EU_INIT, EU_REORG, EU_PUT.

We need to apply our fix in the Production Box.

With this I just have a question:

(1) Is there something that we should be concerned about after running EU_PUT and EU_REORG?

former_member204746
Active Contributor
0 Kudos

no, I was told that this reorgs "where-Used list".

so, no big thing as it is mainly used by abappers.

Former Member
0 Kudos

Hi Eric,

Thank you very much.

This looks like an SAP Upgrade ECC 6 Problem, right?

Do you have any idea where I can check the date when the ECC 6 upgrade or patch has been made?

former_member204746
Active Contributor
0 Kudos

you upgraded recently? it's the first time you tell us this.

table UVERS might help you.

Former Member
0 Kudos

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!

former_member204746
Active Contributor
0 Kudos

1) no need to change EU_* jobs

2) you need to find out which job triggers that error. once you find it, you might get a better idea if this is ABAP or BASIS related.