Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ORA-01455: converting column overflows integer datatype

Hi All,

Recently we have faced an issue in our SAP BW environment (SAP BW 7.3 and Oracle 11.2.3). We were getting runtime errors DBIF_DSQL2_SQL_ERROR with this Oracle Error:

ORA-01455: converting column overflows integer datatype

Source code is like that:

  EXEC SQL.

    select sum(inserts), sum(updates), sum(deletes)

     into :ins_rows, :upd_rows, :del_rows

     from user_tab_modifications

     where table_name  = :i_tablnm

  ENDEXEC.

i_Tablnm is /BIC/FGPAC13A.

After some research I figured out that the table statistics  look not good:

After update the statistics with BrConnect issue was solved.

Any idea about what can be the root cause of this incident and how we can prevent it. I have never seen before that a program fails because a table hasn't statistics. Performance problems yes, but run time errors ....

Kind Regards.

Former Member
replied

Hi Jose,

the screenshots are the current state after running brconnect, right?

A NULL value (depending on the definition of ":ins_rows, :upd_rows, :del_rows") may also cause that issue, but we need to know the definition of the target variables and how the returned values looked like when the dump occurred.

Regards

Stefan

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question