on 12-19-2011 12:40 PM
Hi
We are importing the transport requests on BW Prod system and it completly utilizing the PSAPUNDO table space.
We have extended the table space 2 times with 2GB space, but still the transport request has failed with the above dump.
Runtime Errors DBIF_RSQL_SQL_ERROR
Exceptn CX_SY_OPEN_SQL_DB
ShrtText
An SQL error occurred when accessing a table.
How to correct the error
Database error text........: "ORA-30036: unable to extend segment by 8 in undo
tablespace 'PSAPUNDO'"
Internal call code.........: "[RSQL/DELE/RSOOBJCACHET ]"
Please check the entries in the system log (Transaction SM21).
You may able to find an interim solution to the problem
in the SAP note system. If you have access to the note system yourself,
use the following search criteria:
Please anyone is known about this issue.
Thanks & Regards
Somayya M Nandikolmath | SAP Basis Consultant
Well, your UNDO tablespace may be to small, what are you transporting?
You could potentially change the UNDO retention period temporarely but I would recommend that you take a full backup and do it out of hours.
Can you please add more info to the thread?
Regards
Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
######################################
Execution of programs after import (XPRA)
Transport request : E12K904828
System : B12
tp path : tp
Version and release: 340.16.66 640
Post-import methods for change/transport request: E12K904828
on the application server: ukcsbpw1
Post-import method AFTER_IMP_SXCI started for SXCI L, date and time: 20111216161105
Post-import method AFTER_IMP_SXCI completed for SXCI L, date and time: 20111216161105
Post-import method RS_AFTER_IMPORT started for UPDR L, date and time: 20111216161105
Program terminated (job: RDDEXECL, no.: 16110400)
See job log
Execution of programs after import (XPRA)
End date and time : 20111219114511
Ended with return code: ===> 12 <===
######################################
Job started
Step 001 started (program RDDEXECL, variant , user ID DDIC)
All DB buffers of application server ukcsbpw1 were synchronized
STDO: Log could not be written on output device T
ABAP/4 processor: DBIF_RSQL_SQL_ERROR
Job cancelled
User | Count |
---|---|
78 | |
10 | |
10 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.