cancel
Showing results for 
Search instead for 
Did you mean: 

Update statistics failing in BW systems..

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

markus_doehr2
Active Contributor
0 Kudos

Do you have all the interim patches as of note

Note 1137346 - Oracle Database 10g: Patches for Release 10.2.0.4

applied? Especially the optimizer mergefixes?

Markus

Former Member
0 Kudos

Hai Markus,

Majority of the patches has been applied except the new ones, but the Patch 7592168 for Optimizer merge is not applied. I guess applying this merge patch and updating to the latest patch ie., 28 (Patch 7573151) according to the SAP Note will solve the problem.

Please suggest..

Regards,

Yoganand.V

stefan_koehler
Active Contributor
0 Kudos

Hello Yoganand,

is this a partitioned index / table?

If yes, i think you hit the bug 6896371. It is described in metalink note 6896371.8

Please check this. I can not find this patch as an official certified patch by SAP, but this patch seems also to be pretty new.

Regards

Stefan

Former Member
0 Kudos

Hai,

Please find the output of the command:

select INDEX_NAME,PARTITION_NAME,STATUS

2 from DBA_IND_PARTITIONS where

3 INDEX_NAME='/BI0/F0BWTC_C02~02';

INDEX_NAME PARTITION_NAME STATUS

-


-


-


/BI0/F0BWTC_C02~02 /BI0/F0BWTC_C020000000005 USABLE

/BI0/F0BWTC_C02~02 /BI0/F0BWTC_C020000000003 USABLE

/BI0/F0BWTC_C02~02 /BI0/F0BWTC_C020000000035 USABLE

/BI0/F0BWTC_C02~02 /BI0/F0BWTC_C020000000014 USABLE

/BI0/F0BWTC_C02~02 /BI0/F0BWTC_C020000000023 USABLE

/BI0/F0BWTC_C02~02 /BI0/F0BWTC_C020000000008 USABLE

/BI0/F0BWTC_C02~02 /BI0/F0BWTC_C020000000031 USABLE

/BI0/F0BWTC_C02~02 /BI0/F0BWTC_C020000000073 USABLE

/BI0/F0BWTC_C02~02 /BI0/F0BWTC_C020000000074 USABLE

/BI0/F0BWTC_C02~02 /BI0/F0BWTC_C020 USABLE

/BI0/F0BWTC_C02~02 /BI0/F0BWTC_C020000000013 USABLE

It is usable and also it is a partitioned index, according to SAP Note 1137346 shall we go ahead and apply the merge fix patch. Will that fix the problem.

Plese suggets.

stefan_koehler
Active Contributor
0 Kudos

Hello,

you haven't read the metalink note 6896371.8

Regards

Stefan

Former Member
0 Kudos

Hai,

I have gone through the Note in Metalink, please suggest what to do next?

Regards,

Yoganand.V

Former Member
0 Kudos

Hi Yoganand,

As per your output, I would suggest to wait for the next run of the updatestats as per your DB13 schedule. The error should not be repeated then.

Regards,

Deoraj Alok.

Former Member
0 Kudos

Hai,

Dropped and re-created all indexes that it complained about and now everything is ok again.

Thanks for all the inputs.

Regards,

Yoganand.V

Answers (2)

Answers (2)

former_member204746
Active Contributor
0 Kudos

it might be a temporary problem, this happens if this object was being updates/dropped while a BW data load was being done.

try with this command and see if this happens again:

brconnect -c -u / -f stats -t "/BI0/F0BWTC_C02" -f collect

Former Member
0 Kudos

Hi Yoganand,

Can you please check and paste the output of the following query ?

select INDEX_NAME,PARTITION_NAME,STATUS from DBA_IND_PARTITIONS where INDEX_NAME='/BI0/F0BWTC_C02~02';

Regards,

Deoraj Alok.