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

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...

SAP BW with Oracle database.

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

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