SAP Knowledge Base Article - Preview

2114836 - ORA-01455: converting column overflows integer datatype in BW

Symptom

You get the following (or similar) short dump (check in transaction ST22 for dumps) when select data from table user_tab_modifications in a BW process/task:

Category               Installation Errors
Runtime Errors         DBIF_DSQL2_SQL_ERROR
Except.                CX_SY_NATIVE_SQL_ERROR

----------------------------------------------------------------------------------------------------
|What happened?                                                                                                  
|    The error 1455 occurred in the current database connection "DEFAULT".                    
|    Error Text of Database: "ORA-01455: converting column overflows integer                
|     datatype"                                                                                                        
|    SQL Statement Responsible:"FETCH NEXT "                                                          
----------------------------------------------------------------------------------------------------

|  391|  EXEC SQL.                                                                                                   
|>>>>>|    select sum(inserts), sum(updates), sum(deletes)                                       
|  393|     into :ins_rows, :upd_rows, :del_rows                                                           
|  394|     from user_tab_modifications                                                                      
|  395|     where table_name  = :i_tablnm                                                                 
|  396|  ENDEXEC.

----------------------------------------------------------------------------------------------------
|Active Calls/Events                                                                                                
----------------------------------------------------------------------------------------------------
|No.   Ty.          Program                             Include                             Line              
|      Name                                                                                                            
----------------------------------------------------------------------------------------------------
|   12 FORM         SAPLRSDU_UTIL_ORA                   LRSDU_UTIL_ORAF08                     392   
|      ESTIMATE_COUNT                                                                                                      
|   11 FUNCTION     SAPLRSDU_UTIL_ORA                   LRSDU_UTIL_ORAU07                      16 
|      RSDU_ESTIMATE_COUNT_ORA                                                                                     
|   10 FUNCTION     SAPLRSDU_UTIL                       LRSDU_UTILU07                          28        
|      RSDU_ESTIMATE_COUNT

|I_TABLNM                                                                                                                       
|    /BIC/FZCUBE_1 

During selective deletion from an infocube a RAISE_EXCEPTION dump happens in RSDRD_SEL_DELETION. The work process trace of the dump contains the following information:

select sum ( inserts ), sum ( updates ), sum ( deletes ) from user_tab_modifications where table_name = <FACT_TABLE>

B  ***LOG BY2=> sql error 1455 performing FET [dbds         531]
B  ***LOG BY0=> ORA-01455: converting column overflows integer datatype [dbds         531]


Read more...

Environment

SAP BW with Oracle database.

Product

SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

ORA-01455, DBIF_DSQL2_SQL_ERROR, CX_SY_NATIVE_SQL_ERROR, SAPLRSDU_UTIL_ORA, LRSDU_UTIL_ORAF08, ESTIMATE_COUNT, RAISE_EXCEPTION, RSDRD_SEL_DELETION , KBA , BW-BEX-OT-DBIF , Interface to Database , BW-SYS-DB-ORA , BW ORACLE , BW-WHM-DBA-SDEL , Selective deletion , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.