2345463 - ORA-01455 error for Archive Deletion Phase | SAP Knowledge Base Article

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 ONE Support launchpad (Login required).

Search for additional results

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