on 10-09-2012 6:14 AM
Update Optimizer statistics job and check db is not executing from Planning Calender of SAP GUI.If i schedule from BRTools job is getting successful.Please let me know the issue and resolution.
Please attach log file of failed job. Also provide info about your operating system.
Regards
Roman
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
First please check permissions according to Note 113747 - Owners and authorizations for BR*Tools and try again.
Regards
Roman
Hi Roman,
Thanks for support but permissions are fine .
BLR-RQAS-RQ1:orarq1 8> ls -lrt br*
-rwxrwxr-x 1 rq1adm sapsys 2794686 Aug 2 2011 brrestore
-rwxrwxr-x 1 rq1adm sapsys 3534618 Aug 2 2011 brtools
-rwsrwxr-x 1 orarq1 sapsys 6638433 Aug 3 2011 brarchive
-rwsrwxr-x 1 orarq1 sapsys 6811874 Aug 3 2011 brbackup
-rwsrwxr-x 1 orarq1 sapsys 8875936 Aug 3 2011 brconnect
-rwxrwxr-x 1 rq1adm sapsys 7390106 Aug 3 2011 brrecover
-rwxrwxr-x 1 rq1adm sapsys 9406516 Aug 3 2011 brspace
Hi All,
Please find below log .
BLR-RQAS-RQ1:rq1adm 62> brconnect -u / -c -f stats -t ALL
BR0801I BRCONNECT 7.20 (16)
BR0805I Start of BRCONNECT processing: cejpxrbw.sta 2012-10-10 16.15.16
BR0484I BRCONNECT log file: /oracle/RQ1/sapcheck/cejpxrbw.sta
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.17
BR0813I Schema owners found in database RQ1: SAPRP1*, SAPRP1DB%
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.22
BR0814I Number of tables in schema of owner SAPRP1: 86221
BR0836I Number of tables treated as info cubes for owner SAPRP1: 93
BR0814I Number of tables in schema of owner SAPRP1DB: 586
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.43
BR0815I Number of indexes in schema of owner SAPRP1: 102720
BR0815I Number of indexes in schema of owner SAPRP1DB: 1096
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.45
BR0818I Number of tables found in DBSTATC for owner SAPRP1: 390
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.45
BR0807I Name of database instance: RQ1
BR0808I BRCONNECT action ID: cejpxrbw
BR0809I BRCONNECT function ID: sta
BR0810I BRCONNECT function: stats
BR0812I Database objects for processing: ALL
BR0851I Number of tables with missing statistics: 0
BR0852I Number of tables to delete statistics: 0
BR0854I Number of tables to collect statistics without checking: 0
BR0855I Number of indexes with missing statistics: 0
BR0856I Number of indexes to delete statistics: 0
BR0857I Number of indexes to collect statistics: 0
BR0853I Number of tables to check (and collect if needed) statistics: 86807
Owner SAPRP1DB: 586
BR0126I Unattended mode active - no operator confirmation required
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0817I Number of monitored/modified tables in schema of owner SAPRP1: 86221/19025
BR0817I Number of monitored/modified tables in schema of owner SAPRP1DB: 586/27
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0877I Checking and collecting table and index statistics...
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0883I Table selected to collect statistics after check: SAPRP1.BTCCTL (28/0:59:0)
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0881I Collecting statistics for table SAPRP1.BTCCTL with method/sample C ...
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0884I Statistics collected for table: SAPRP1.BTCCTL, rows old/new: 28/28
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0850I 1 of 11 objects processed - 0.005 of 0.053 units done
BR0204I Percentage done: 9.09%, estimated end time: 16:15
BR0001I *****_____________________________________________
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0883I Table selected to collect statistics after check: SAPRP1.SORAMON (10/7:0:7)
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0881I Collecting statistics for table SAPRP1.SORAMON with method/sample C ...
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0884I Statistics collected for table: SAPRP1.SORAMON, rows old/new: 10/10
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0850I 2 of 11 objects processed - 0.010 of 0.053 units done
BR0204I Percentage done: 18.18%, estimated end time: 16:15
BR0001I *********_________________________________________
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0883I Table selected to collect statistics after check: SAPRP1.SRT_MONI_TS (1/0:1:0)
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0881I Collecting statistics for table SAPRP1.SRT_MONI_TS with method/sample C ...
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0884I Statistics collected for table: SAPRP1.SRT_MONI_TS, rows old/new: 1/1
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0850I 3 of 11 objects processed - 0.015 of 0.053 units done
BR0204I Percentage done: 27.27%, estimated end time: 16:15
BR0001I **************____________________________________
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0883I Table selected to collect statistics after check: SAPRP1.SWWREPSTATUS (9/0:7:0)
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0881I Collecting statistics for table SAPRP1.SWWREPSTATUS with method/sample C ...
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0884I Statistics collected for table: SAPRP1.SWWREPSTATUS, rows old/new: 9/9
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0850I 4 of 11 objects processed - 0.019 of 0.053 units done
BR0204I Percentage done: 36.36%, estimated end time: 16:15
BR0001I ******************________________________________
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0883I Table selected to collect statistics after check: SAPRP1.TBTCS (44/21:36:21)
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0881I Collecting statistics for table SAPRP1.TBTCS with method/sample C ...
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0884I Statistics collected for table: SAPRP1.TBTCS, rows old/new: 44/44
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0850I 5 of 11 objects processed - 0.024 of 0.053 units done
BR0204I Percentage done: 45.45%, estimated end time: 16:15
BR0001I ***********************___________________________
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0883I Table selected to collect statistics after check: SAPRP1.TRBAT (0/5:0:5)
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0881I Collecting statistics for table SAPRP1.TRBAT with method/sample C ...
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0884I Statistics collected for table: SAPRP1.TRBAT, rows old/new: 0/0
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0850I 6 of 11 objects processed - 0.029 of 0.053 units done
BR0204I Percentage done: 54.55%, estimated end time: 16:15
BR0001I ***************************_______________________
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0883I Table selected to collect statistics after check: SAPRP1DB.BC_JMSTOPIC (1/58:0:0)
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0881I Collecting statistics for table SAPRP1DB.BC_JMSTOPIC with method/sample C ...
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0884I Statistics collected for table: SAPRP1DB.BC_JMSTOPIC, rows old/new: 1/59
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0850I 7 of 11 objects processed - 0.034 of 0.053 units done
BR0204I Percentage done: 63.64%, estimated end time: 16:15
BR0001I ********************************__________________
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0883I Table selected to collect statistics after check: SAPRP1DB.JCS_APILOCK0 (2/0:8:0)
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0881I Collecting statistics for table SAPRP1DB.JCS_APILOCK0 with method/sample C ...
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0884I Statistics collected for table: SAPRP1DB.JCS_APILOCK0, rows old/new: 2/2
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0850I 8 of 11 objects processed - 0.039 of 0.053 units done
BR0204I Percentage done: 72.73%, estimated end time: 16:15
BR0001I ************************************______________
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0883I Table selected to collect statistics after check: SAPRP1DB.JCS_JOBDEFCOUNT0 (5/0:4:0)
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0881I Collecting statistics for table SAPRP1DB.JCS_JOBDEFCOUNT0 with method/sample C ...
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0884I Statistics collected for table: SAPRP1DB.JCS_JOBDEFCOUNT0, rows old/new: 5/5
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0850I 9 of 11 objects processed - 0.044 of 0.053 units done
BR0204I Percentage done: 81.82%, estimated end time: 16:15
BR0001I *****************************************_________
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0883I Table selected to collect statistics after check: SAPRP1DB.JCS_JOBPERF0 (3/4:0:4)
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.47
BR0881I Collecting statistics for table SAPRP1DB.JCS_JOBPERF0 with method/sample C ...
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.48
BR0884I Statistics collected for table: SAPRP1DB.JCS_JOBPERF0, rows old/new: 3/3
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.48
BR0850I 10 of 11 objects processed - 0.048 of 0.053 units done
BR0204I Percentage done: 90.91%, estimated end time: 16:15
BR0001I *********************************************_____
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.48
BR0883I Table selected to collect statistics after check: SAPRP1DB.JCS_LOCK0 (2/0:59:0)
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.48
BR0881I Collecting statistics for table SAPRP1DB.JCS_LOCK0 with method/sample C ...
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.48
BR0884I Statistics collected for table: SAPRP1DB.JCS_LOCK0, rows old/new: 2/2
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.48
BR0850I 11 of 11 objects processed - 0.053 of 0.053 units done
BR0204I Percentage done: 100.00%, estimated end time: 16:15
BR0001I **************************************************
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.48
BR0879I Statistics checked for 86807 tables
BR0878I Number of tables selected to collect statistics after check: 11
BR0880I Statistics collected for 11/0 tables/indexes
BR0806I End of BRCONNECT processing: cejpxrbw.sta 2012-10-10 16.15.48
BR0280I BRCONNECT time stamp: 2012-10-10 16.15.48
BR0802I BRCONNECT completed successfully
OSLevel update stats job is executed successfully but SAP GUI end db13>unable to execute job>
Dear Orkun
Please find below output of SM49
10.10.2012 16:46:03 Job started
10.10.2012 16:46:03 Step 001 started (program RSDBAJOB, variant &0000000000128, user ID 00014442)
10.10.2012 16:46:03 Execute logical command BRCONNECT On host BLR-RQAS-RQ1
10.10.2012 16:46:03 Parameters: -u / -jid STATS20121010164603 -c -f stats -t ALL
10.10.2012 16:46:04 BR0801I BRCONNECT 7.00 (43)
10.10.2012 16:46:04 BR0805I Start of BRCONNECT processing: cejpxtux.sta 2012-10-10 16.46.03
10.10.2012 16:46:04 BR0484I BRCONNECT log file: /oracle/RQ1/sapcheck/cejpxtux.sta
10.10.2012 16:46:04
10.10.2012 16:46:04 BR0600E STATS not supported by BRCONNECT 7.00 forOracle version higher than 10.2
10.10.2012 16:46:04
10.10.2012 16:46:04 BR0806I End of BRCONNECT processing: cejpxtux.sta2012-10-10 16.46.04
10.10.2012 16:46:04 BR0280I BRCONNECT time stamp: 2012-10-10 16.46.04
10.10.2012 16:46:04 BR0804I BRCONNECT terminated with errors
10.10.2012 16:46:04 External program terminated with exit code 3
10.10.2012 16:46:04 BRCONNECT returned error status E
10.10.2012 16:46:04 Job finished
Hi Roman,
Please find output as you requested and let me know further steps to proceed.
BLR-RQAS-RQ1:rq1adm 3> which brconnect
/usr/sap/RQ1/SYS/exe/run/brconnect
BLR-RQAS-RQ1:rq1adm 4> `which brconnect` -V
BR0801I BRCONNECT 7.20 (16)
Patch Date Info
1 2010-01-26 BR*Tools support for Oracle 11g (note 1430669)
9 2010-10-27 BR*Tools support for eSourcing databases (note 1523205)
10 2010-11-24 MISSING_STATISTICS alert straight after update statistics (note 1532316)
11 2011-01-27 Long running time of BRCONNECT function 'check' (note 1553244)
16 2011-07-28 Corrections in BR*Tools 7.20 patch 16 (note 1615503)
release note 1428529
kernel release 720
patch date 2011-07-28
patch level 16
make platform rs6000_64
make mode OCI_102
make date Aug 2 2011
HI Roman,
As you asked please find below info.
BR0801I BRCONNECT 7.00 (43) Patch Date Info 1 2005-05-31 New check condition CRITICAL_TABLESPACE in BRCONNECT (note 849484) 3 2005-07-26 Support for wildcards in BRCONNECT parameters (note 865365) 4 2005-07-26 Changes in collecting statistics for partitions (note 865366) 7 2005-10-26 Extended support for non-ABAP databases in BRCONNECT (note 892294) 8 2005-10-26 Enhancements in statistics collection in BRCONNECT (note 892296) 10 2006-01-05 BR*Tools fail due to SAP license problems (note 912969) 11 2006-01-11 Small functional enhancements in BR*Tools (note 914174) 13 2006-03-29 BR*Tools support for MDM databases (note 936665) 14 2006-05-23 Wrong exit code of BRARCHIVE and BRCONNECT (note 950787) 16 2006-08-11 BR*Tools start error: library libnnz10 not found (note 972136) 20 2006-11-24 Extended support for system copy in BR*Tools (note 1003028) 24 2007-03-01 BR*Tools support for Oracle 10g RAC (note 1033126) 25 2007-04-26 BR*Tools failing with ORA-01455 for database > 16 TB (note 1050329) 26 2007-05-31 New BR*Tools command options (note 1060696) 27 2007-07-05 Further enhancements in collection of statistics (note 892296) 32 2008-02-05 Corrections for BR*Tools 7.00 patch 31 (note 1138968) 35 2008-07-29 SQL error ORA-01012 in BRCONNECT in offline backup (note 1235951) 36 2008-07-29 Small functional enhancements in BR*Tools (2) (note 1235952) release note 849483 kernel release 700 patch date 2009-08-12 patch level 43 make platform rs6000_64 make mode OCI_102 make date Aug 15 2009
hi Narendra,
would you share the log of failed job.
for meanwhile,
check the space of SAP tablespaces and below SAP Notes...
834917,1028220.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.