Transport Error - RDDIMPDP 1) Error encountered
2) Check Background Job RDDIMPDP
3) Why the job RDDIMPDP got canceled
4) Check details via SM21
Database error 1653 at INS access to table TBTCP > ORA-01653: unable to extend table SAPECP.TBTCP by 1024 in > tablespace PSAPECP Perform rollback Run-time error "DBIF_RSQL_SQL_ERROR" occurred Database error 1653 at EXE > ORA-01653: unable to extend table SAPECP.SNAP by 1024 in > tablespace PSAPECP > Include SAPMSSY2 line 4925. 5) Check details via ST22 - Could not check because there’s no ABAP DUMP available.
6) It’s either increase tablespace or clear old table contents. In this case, clear old table contents seem to be fitting.
Cause of problem : Database error 1653 at INS access to table TBTCP > ORA-01653: unable to extend table SAPECP.TBTCP by 1024 in > tablespace PSAPECP Perform rollback Run-time error "DBIF_RSQL_SQL_ERROR" occurred Database error 1653 at EXE > ORA-01653: unable to extend table SAPECP.SNAP by 1024 in > tablespace PSAPECP > Include SAPMSSY2 line 4925.
-
Table TBTCP and SNAP are full - SNAP = table for ABAP Dumps - TBTCP = table for background job step overview
How to resolve :
-
Run or schedule job RSSNAPDL to delete short dumps from SNAP table. Job name : SAP_REORG_ABAPDUMPS Program : RSSNAPDL Variant : Yes Parameters variant : 30000 / 500 Frequency : Daily Description : Delete short dumps from SNAP table.
-
Run or schedule job RSBTCDEL2 to delete background job step overview in table RBTCP and delete physical log file in /export/sapmnt/<SID>/global (this is where all the physical batch job log file located) Job name : SAP_REORG_JOBS Program : RSBTCDEL2 Variant : Yes Parameters variant : 7 days (good value, but check in company) Frequency : Daily Description : Delete batch job logs