Error in brconnect.

[former_member225670]

Getting error in Brconnect

error log:

R0301E SQL error -1555 in thread 1 at location stats_tab_collect-20, SQL statement:

'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPR1P"', TABNAME => '"VBAP"', ESTIMATE_PERCENT => NULL, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE =>

NULL, CASCADE => TRUE, NO_INVALIDATE => FALSE); END;'

ORA-01555: snapshot too old: rollback segment number 612 with name "_SYSSMU612$" too small

ORA-06512: at "SYS.DBMS_STATS", line 14531

ORA-06512: at "SYS.DBMS_STATS", line 14552

ORA-06512: at line 1

[Former Member]

Hi,

The easiest way to solve this problem is adding datafile to PSAPUNDO.

Best regards,

Orkun Gedik

[Former Member]

Hi Hemanth,

Also try granting the role according to this note.

Note 838725 - Oracle dictionary statistics and system statistics

Br,

Venky

[former_member188883]

Hi Hemanth,

You can look into following SAP notes

Note 185822 - ora-1555 - cause and action

Note 582427 - Error due to inconsistent Oracle DDIC

Regards,

Deepak Kori