cancel
Showing results for 
Search instead for 
Did you mean: 

Update Stats job is failing after scheduling at DBA Planning calender

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Please attach log file of failed job. Also provide info about your operating system.

Regards

Roman

Former Member
0 Kudos

Hi Roman,

OS = AIX 7.1

from BRTOOLS log is creating and job too completed successfully if i schedule from planning calender in SAP GUI ,job is getting failed and no log is created .

Former Member
0 Kudos

First please check permissions according to Note 113747 - Owners and authorizations for BR*Tools and try again.

Regards

Roman

Former Member
0 Kudos

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

former_member182034
Active Contributor
0 Kudos

hi Narendra,

Please check below thread. it may be helpful.

http://scn.sap.com/thread/3222169

Regards,

Former Member
0 Kudos

Please provide the output from failed command as rq1adm user, e.g.

# su - rq1adm

$ brconnect -u /  -c -f stats -t ALL

Regards

Roman

Former Member
0 Kudos

Hi Narendra,

Could you execute the brconnect command with "-u /  -c -f stats -t ALL" on SM49 and paste the result here?

Best regards,

Orkun GEdik

Former Member
0 Kudos

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>

Former Member
0 Kudos

>> OSLevel update stats job is executed successfully but SAP GUI end db13>unable to execute job>

Could you paste the SM49 output here?

Former Member
0 Kudos

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

Former Member
0 Kudos

You have different versions of brconnect executed in each case: 7.20(16) and 7.00(43). Please run as rq1adm user:

$ which brconnect

$ `which brconnect` -V

and check version.

Regards

Roman

Former Member
0 Kudos

Hi Roman,

Please share a link BRConnect 7.20(16) to download.

Former Member
0 Kudos

It seems that you system have two different versions of brconnect. Check this. Please provide output from commands as rq1adm user:

$ which brconnect

$ `which brconnect` -V

Regards

Roman

Former Member
0 Kudos

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

Former Member
0 Kudos

Ok. Please in SM59 run brconnect -V command and provide output here.

Regards

Roman

Former Member
0 Kudos

Hi Roman,

i entered in to SM59 then how to run the command ?

Former Member
0 Kudos

Sorry. I made a wrong typing. Please run brconnect -V in SM49.

Regards

Roman

Former Member
0 Kudos

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

Former Member
0 Kudos

Find the brtools located at the OS level, by using the commands below;

% cd /

% find . -name brconnect

Then, replace all the folders you found above, with the 720 release brtools.

Best regards,

Orkun Gedik

volker_borowski2
Active Contributor
0 Kudos

... or run "which brconnect" from SM49 to see which one is taken ...

Looks like you have got lost old versions somewhere along the PATH locations ...

Volker

Former Member
0 Kudos

Try to find incorrect version of brconnect as Volker suggests. Do this from SM49 tcode with "which brconnect" command not from shell as <sid>adm profile seems to be correct.

Regards

Roman

former_member182034
Active Contributor
0 Kudos

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,

Former Member
0 Kudos

Please find error log as you requested.

BRCONNECT Action Log for Database RQ1 



From:   27.09.2012 08:00:49 
LogFile:   cejnkbqv.chk 
Return Code:   0003 Error during initialization 
Database Host:   BLR-RQAS-RQ1 
   
   No action log for this action found in the database 
   Check the detail log