Update statistics failing in BW systems..

187 Views

Hai,

Update statistics in BW system fails with the below error.

Error details:

BR0886E Checking/collecting statistics failed for index SAPCAV./BI0/F0BWTC_C02~01

BR0280I BRCONNECT time stamp: 2009-01-15 16.28.36

BR0882I Collecting statistics for index SAPCAV./BI0/F0BWTC_C02~02 with method/sample E/P30 ...

BR0280I BRCONNECT time stamp: 2009-01-15 16.28.36

BR0301E SQL error -1008 at location stats_ind_collect-3, SQL statement:

'BEGIN DBMS_STATS.GATHER_INDEX_STATS (OWNNAME => '"SAPCAV"', INDNAME => '"/BI0/F0BWTC_C02~02"', ESTIMATE_PERCENT => 30, DEGREE => NULL, GRANULARITY => 'ALL',

NO_INVALIDATE => FALSE); END;'

ORA-01008: not all variables bound

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

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

ORA-06512: at line 1

BR0886E Checking/collecting statistics failed for index SAPCAV./BI0/F0BWTC_C02~02

BR0280I BRCONNECT time stamp: 2009-01-15 16.28.36

BR0882I Collecting statistics for index SAPCAV./BI0/F0BWTC_C02~04 with method/sample E/P30 ...

BR0280I BRCONNECT time stamp: 2009-01-15 16.28.36

BR0882I Collecting statistics for index SAPCAV./BI0/F0BWTC_C02~05 with method/sample E/P30 ...

BR0280I BRCONNECT time stamp: 2009-01-15 16.28.36

BR0301E SQL error -1008 at location stats_ind_collect-3, SQL statement:

'BEGIN DBMS_STATS.GATHER_INDEX_STATS (OWNNAME => '"SAPCAV"', INDNAME => '"/BI0/F0BWTC_C02~05"', ESTIMATE_PERCENT => 30, DEGREE => NULL, GRANULARITY => 'ALL',

NO_INVALIDATE => FALSE); END;'

ORA-01008: not all variables bound

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

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

ORA-06512: at line 1

Server Details:

SAP BW, Component: NW 04

Software component: SAP_BW,Release: 350,Level: 0017

Database system: ORACLE

Release: 10.2.0.4.0

Operating system: Linux

Machine type: x86_64

Thanks for help.

Regards,

Yoganand.V