Skip to Content
avatar image
Former Member

DBIF_RSQL_SQL_ERROR, CX_SY_OPEN_SQL_DB

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Dec 19, 2011 at 12:55 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 19, 2011 at 12:54 PM

    Is the UNDO tablespace has autoextend on ?

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 19, 2011 at 12:54 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 20, 2011 at 02:23 AM

    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

    Add comment
    10|10000 characters needed characters exceeded