cancel
Showing results for 
Search instead for 
Did you mean: 

Update Database Statistics during System Export

former_member182034
Active Contributor
0 Kudos

hi All,

I am getting following error on step (Update Database Statistics ) during system export.

WARNING 2011-06-17 15:13:35
Execution of the command "E:\usr\sap\PRD\SYS\exe\uc\NTAMD64\
brconnect.exe -u / -c -o summary -f stats -o SAPSR3 -t all -m +I -s
 P10 -f allsel,collect,method,precision,space,keep -p 4"
finished with return code 5. 
Output: BR0801I BRCONNECT 7.00 (31)BR0805I Start of BRCONNECT processing: 
cegczbfe.sta 2011-06-17 15.12.02BR0484I BRCONNECT log file:
G:\oracle\PRD\sapcheck\cegczbfe.sta
ERROR 2011-06-17 15:13:35
CJS-30023  Process call 'E:\usr\sap\PRD\SYS\exe\uc\NTAMD64\
brconnect.exe -u / -c -o summary -f stats -o SAPSR3 -t all -m +I -s P10
 -f allsel,collect,method,precision,space,keep -p 4' 
exits with error code 5. For details see log file(s) brconnect.log.

there is small part of brconnect.log is:

BR0204I Percentage done: 27.88%, estimated end time: 15:16
BR0001I **************____________________________________
BR0280I BRCONNECT thread 2: time stamp: 2011-06-17 15.13.31
BR0301E SQL error -20003 in thread 2 at location stats_tab_collect-20, SQL statement:
'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"/BEV3/CHCL_STAT"', ESTIMATE_PERCENT => NULL, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, CASCADE => TRUE, NO_INVALIDATE => FALSE); END;'
ORA-20003: Specified bug number (5099019) does not exist
ORA-06512: at "SYS.DBMS_STATS", line 14830
ORA-06512: at "SYS.DBMS_STATS", line 14851
ORA-06512: at line 1
BR0886E Checking/collecting statistics failed for table SAPSR3./BEV3/CHCL_STAT
BR0280I BRCONNECT thread 2: time stamp: 2011-06-17 15.13.31
BR0301E SQL error -20003 in thread 2 at location stats_tab_collect-20, SQL statement:
'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"/BEV3/CHCL_STATT"', ESTIMATE_PERCENT => NULL, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, CASCADE => TRUE, NO_INVALIDATE => FALSE); END;'
ORA-20003: Specified bug number (5099019) does not exist
ORA-06512: at "SYS.DBMS_STATS", line 14830
ORA-06512: at "SYS.DBMS_STATS", line 14851
ORA-06512: at line 1
BR0886E Checking/collecting statistics failed for table SAPSR3./BEV3/CHCL_STATT
BR0280I BRCONNECT thread 2: time stamp: 2011-06-17 15.13.31
BR0301E SQL error -20003 in thread 2 at location stats_tab_collect-20, SQL statement:
'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"/BEV3/CHCMVWOBJ"', ESTIMATE_PERCENT => NULL, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, CASCADE => TRUE, NO_INVALIDATE => FALSE); END;'
ORA-20003: Specified bug number (5099019) does not exist
ORA-06512: at "SYS.DBMS_STATS", line 14830
ORA-06512: at "SYS.DBMS_STATS", line 14851
ORA-06512: at line 1
BR0886E Checking/collecting statistics failed for table SAPSR3./BEV3/CHCMVWOBJ
BR0280I BRCONNECT thread 2: time stamp: 2011-06-17 15.13.31
BR0301E SQL error -20003 in thread 2 at location stats_tab_collect-20, SQL statement:
'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"/BEV3/CHCMVWOBPR"', ESTIMATE_PERCENT => NULL, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, CASCADE => TRUE, NO_INVALIDATE => FALSE); END;'
ORA-20003: Specified bug number (5099019) does not exist
ORA-06512: at "SYS.DBMS_STATS", line 14830
BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"/BEV3/CHCTLVAR"', ESTIMATE_PERCENT => NULL, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, CASCADE => TRUE, NO_INVALIDATE => FALSE); END;'
ORA-20003: Specified bug number (5099019) does not exist
ORA-06512: at "SYS.DBMS_STATS", line 14830
ORA-06512: at "SYS.DBMS_STATS", line 14851
ORA-06512: at line 1

ORA-06512: at line 1

BR0886E Checking/collecting statistics failed for table SAPSR3./BEV3/CHCTMSTFUB

BR0280I BRCONNECT thread 2: time stamp: 2011-06-17 15.13.34
BR0844E 100 errors occurred in thread 2 - terminating processing of the thread...

BR0280I BRCONNECT time stamp: 2011-06-17 15.13.34
BR0848I Thread 2 finished with return code -1

BR0280I BRCONNECT time stamp: 2011-06-17 15.13.34
BR0879I Statistics checked for 0 tables
BR0878I Number of tables selected to collect statistics after check: 0
BR0880I Statistics collected for 639/0 tables/indexes
BR0889I Structure validated for 0/749/0 tables/indexes/clusters
BR1308E Collection of statistics failed for 68292/0 tables/indexes

BR0806I End of BRCONNECT processing: cegczbfe.sta 2011-06-17 15.13.34
BR0280I BRCONNECT time stamp: 2011-06-17 15.13.35
BR0804I BRCONNECT terminated with errors

how can I resolve this issue?

Regards,

majamil

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member185031
Active Contributor
0 Kudos

Have you searched on the error which you are getting ?

I found two threads which seems same error and solutions are also given. Have a look and try.

Regards,

Subhash

former_member182034
Active Contributor
0 Kudos

hi SC,

thx for these link,

this error is removed after apply the Oracle Patches.

but when now i am getting following error:

ORA-25153: Temporary Tablespace is Empty
ORA-06512: at "SYS.DBMS_STATS", line 14990
ORA-06512: at "SYS.DBMS_STATS", line 15336
ORA-06512: at "SYS.DBMS_STATS", line 17653
ORA-06512: at "SYS.DBMS_STATS", line 17695
ORA-06512: at line 1
BR1313E Collection of Oracle dictionary statistics failed

now i have to add new temporary tablespace or datafile in PSAPTEMP?

how can i do it with BRTOOLS?

Regards,

former_member185031
Active Contributor
0 Kudos
now i have to add new temporary tablespace or datafile in PSAPTEMP?

This is strange that your system TEMP table space does not have any datafile. Have you verified at OS level ? If you donot have any data file on that table space then add it throgu BRTOOLS. It is common as you add any other data file.

Regards,

Subhash

former_member182034
Active Contributor
0 Kudos

hi Subhash,

thx for reply. system was running fine before start system export and during system export i got the following error on Update Database Statistics :

ORA-20003: Specified bug number (5099019) does not exist

so, I applied oracle patches and got following error

ORA-25153: Temporary Tablespace is Empty

there was not empty tablespace PSAPTEMP before Oracle patching.

now i created datafile in PSAPTEMP tablespace and after that one job is failed out of 100 on Import ABAP , I just retry the installation and system export successfully completed.

would you tell me how this PSAPTEMP tablespace empty?

Regards,

Former Member
0 Kudos

When you say Oracle Patches, you have to Apply Oracle PSU (Patch Set Updates) and SBP ( SAP Bundle Patches). Then you can retry updating DIct and System statistics, the best is to use MOPatch.

Thanks

SM

former_member182034
Active Contributor
0 Kudos

hi SM,

fyi..... ECC 6 installed on Window 2003 server 64 bit R2 with Oracle 10.2.0.4. remaining all patches applied successfully while i did not apply MOPatch on window.

Regards,

Former Member
0 Kudos

p9843740_10204_Generic.zip

10204_Patch44_MSWIN-x86-64.zip

https://websmp204.sap-ag.de/oracle-download

Have you applied the above 2 patches using MOPatch/Opatch?

thanks

SM

former_member182034
Active Contributor
0 Kudos

hi SM,

I have applied these patches with Opatch which successfully applied.

is it ok or i had to use the MOpatch for these?

one more thing for your information , when i execute Delete Harmful Statistics under Database Statistics in brtools then i got following

BR0280I BRCONNECT time stamp: 2011-06-30 08.10.53
BR0818I Number of tables found in DBSTATC for owner SAPSR3: 390

BR0280I BRCONNECT time stamp: 2011-06-30 08.10.53
BR0807I Name of database instance: PRD
BR0808I BRCONNECT action ID: cegfjniv
BR0809I BRCONNECT function ID: dst
BR0810I BRCONNECT function: stats
BR0812I Database objects for processing: HARMFUL
BR0852I Number of tables to delete statistics: 0
BR0856I Number of indexes to delete statistics: 0
BR0863W No tables/indexes found to update/delete statistics or validate structur
e

BR0806I End of BRCONNECT processing: cegfjniv.dst 2011-06-30 08.10.53
BR0280I BRCONNECT time stamp: 2011-06-30 08.10.53
BR0803I BRCONNECT completed successfully with warnings

###############################################################################

BR0292I Execution of BRCONNECT finished with return code 1

BR0668I Warnings or errors occurred - you can continue to ignore them or go back
 to repeat the last action

BR0280I BRTOOLS time stamp: 2011-06-30 08.10.53
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c

why i am getting this return code 1?

Regards,

Edited by: majamil on Jun 30, 2011 8:20 AM

Former Member
0 Kudos

BR0863W No tables/indexes found to update/delete statistics or validate structure, which means BRTOOLS didn't find any table or index to delete harmful stats, which is fine for your original issue.

And

BR0818I Number of tables found in DBSTATC for owner SAPSR3: 390

Incredible, SAP Instance with just 390 Tables.

Thanks

SM

former_member182034
Active Contributor
0 Kudos

hi SM,

I have applied these patches with Opatch which successfully applied.

is it ok or i had to use the MOpatch for these? what do you suggest about patching sequence mean if i apply in future?

Former Member
0 Kudos

One work MOPatch, it applies all the patches at one shot and checks for all the prereqs and conflicts.

When ever you download the patches, there is an HTML page with all the required info in it.

Also use the latest MOpatch before you apply.

Thanks

SM