Error ora-30926

[Former Member]

Hi All

I have an error (ora-30926:unable to get a stable set of rows in the source tables ) in a process chain, when rolling up of agregate is performed

if I launch the process chain by hand, this error doesn't occur

I found the Note 613064, but  it's not the right one, because i have oracle 11.2 and  SAP BW 7.3

[former_member182470 · Accepted solution]

Have you checked this?

http://scn.sap.com/thread/551239

[Former Member]

Hi Anton,

This type of error occurs due to Database problem. Contact Basis team to solve the issue.

Thanks,

Purushotham.

[former_member213275]

Hi Anton,

The error could be either caused because of table space or because of ORACLE merge functionlaity.

Generally Oracle merge functionlaity is used during rollup and compression and this could be cause for your error. Are there any duplicate records in your source tables?.

Might be you need to check relevant OSS note that supports your SP.

Srikanth.

[RamanKorrapati]

Hi Anton,

You may need OSS note. please check with DB team. its oracle related error.

http://www.dba-oracle.com/t_ora_30926_unable_to_get_a_stable_set_of_rows_in_the_source_tables.htm

Thanks