SAP Knowledge Base Article - Preview

2345463 - ORA-01455 error for Archive Deletion Phase

Symptom

The following error information is displayed in the job log of archive deletion phase:

|dd.mm.yyyy|hh:mm:ss|set threshold for delete mode: ( 40 )                                                                                        |    RSDRD    |    001    |     I      |
|dd.mm.yyyy|hh:mm:ss|class CL_RSDRD_SELDEL_PACK_ORA instantiated                                                                                  |    RSDRD    |    001    |     I      |
|dd.mm.yyyy|hh:mm:ss|set flag for transactional deletion: ( )                                                                                     |    RSDRD    |    001    |     I      |
|dd.mm.yyyy|hh:mm:ss|number of records to be deleted: XXXXXXXXX                                                                                    |    RSDRD    |    001    |     I      |
|dd.mm.yyyy|hh:mm:ss|Deletion of data recs using Insert/Select <ODS Active Table>--> terminated with errors                                         |    RSDRD    |    113    |     I      |
|dd.mm.yyyy|hh:mm:ss|An SQL error has occurred: ORA-01455: converting column overflows integer datatype                                           |    RSDRD    |    001    |     I      |
|dd.mm.yyyy|hh:mm:ss|An exception with the type CX_SY_NATIVE_SQL_ERROR occurred, but was neither handled locally, nor declared in a RAISING clause|    RSDRD    |    001    |     I  

 

***** Note *****

number of records to be deleted: XXXXXXXXX         =>     XXXXXXXXX   is more than two billion.

                                                                        


Read more...

Environment

SAP NetWeaver

Product

SAP NetWeaver all versions

Keywords

ADK, Session, Package deletion of data, Job cancelled after system exception ERROR_MESSAGE, CL_RSDA_DAP_REQUEST_COLLECTIONCM00A, CL_RSDA_DAP_REQUEST_COLLECTIONCP, CL_RSDRD_SELDEL_PACK_ORA, TRUNCATE TABLE, TESTDATRNRPART0, RSDA_REQUEST_EXECUTE , KBA , BW-WHM-DST-ARC , Archiving , BW-BEX-OT-DBIF , Interface to Database , BC-DB-ORA , Oracle , 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 for Me (Login required).

Search for additional results

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