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
Hello Somayya,
Log clearly says your undo tablespace PSAPUNDO does not have enough space to extend. Please extend it further and import that transport.
Thanks,
Siva Kumar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Somayya,
Regarding the issue reported by you can you kindly review the following SAP Notes and KBA article:
1045320 - ORA-30036 despite high number expired/unexpired undo extents
1221694 - Oracle error messages during consolidation (ORA-01555 and ORA-30036)
These would help you out.
Regards,
Abhishek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Is the UNDO tablespace has autoextend on ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.