Solved: Cannot delete request from ODS

Former Member · ‎2007 Feb 08

Hi All,

I'm trying to delete a request (full load) from an ODS. But it ends up in a Runtime error. The load performed normal before.

Runtime errors: DBIF_RSQL_SQL_ERROR

Exception: CX_SY_OPEN_SQL_DB

1. ORACLE storage space request failed. (ORACLE error 1547)

2. Maximum number of extents reached for rollback segment. (ORACLE error 1556)

Anyone with an idea about this?

Thanks

Former Member · ‎2007 Feb 09

This is oracle system error. Your oracle DBA has to release rhe extents for you to carry out the operation.

Ravi Thothadri

Former Member · ‎2007 Feb 08

Hello Beumer,

do you have Informix? Look at this note - 36968. You certainly need Basis team intervention in this matter. usually they know better on these issues.

Viren

Former Member · ‎2007 Feb 08

Hi,

Check for the storage space in the system I think your table space is less then required that why it is not able to roll back.

If then contact the basis for more space,

hope it helps

thanks

Cannot delete request from ODS