2114836 - ORA-01455: converting column overflows integer datatype in BW | SAP Knowledge Base Article

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                                                                                                           


Read more...

Environment

SAP BW with Oracle database.

Keywords

ORA-01455, DBIF_DSQL2_SQL_ERROR, CX_SY_NATIVE_SQL_ERROR, SAPLRSDU_UTIL_ORA, LRSDU_UTIL_ORAF08, ESTIMATE_COUNT , KBA , BW-BEX-OT-DBIF , Interface to Database , BW-SYS-DB-ORA , BW ORACLE , 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.