cancel
Showing results for 
Search instead for 
Did you mean: 

DBIF_RSQL_SQL_ERROR, CX_SY_OPEN_SQL_DB

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

JPReyes
Active Contributor
0 Kudos

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

Former Member
0 Kudos

######################################

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

former_member189725
Active Contributor
0 Kudos

Please check if the /usr/sap/trans/log has the permission 755 and the owner/group as root/sapsys.

Edited by: Ratnajit Dey on Dec 19, 2011 6:55 PM

Former Member
0 Kudos

The log directory has the complete previlages and sapsys...

drwxrwxr-x 2 b12adm sapsys 524288 Dec 19 11:45 log

former_member189725
Active Contributor
0 Kudos

DO you find any other errors because of the undo segments getting filled up, other than this transport?

Answers (3)

Answers (3)

Former Member
0 Kudos

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

0 Kudos

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

former_member189725
Active Contributor
0 Kudos

Is the UNDO tablespace has autoextend on ?

Former Member
0 Kudos

No the autoextent value for this tablespace is OFF..