cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Db13 both the jobs failed update stats and DB check

Former Member

on ‎07-21-2009 7:14 AM

0 Kudos

Dear Friends,

Request you to look at following logs and suggest .

Thanks in advance.

BR0883I Table selected to collect statistics after check: SAPSR3.ALSLDCTRL (1/0:34:0)

BR0280I BRCONNECT time stamp: 2009-07-20 23.00.50

BR0881I Collecting statistics for table SAPSR3.ALSLDCTRL with method/sample C ...

BR0280I BRCONNECT time stamp: 2009-07-20 23.00.50

BR0884I Statistics collected for table: SAPSR3.ALSLDCTRL, rows old/new: 1/1

BR0280I BRCONNECT time stamp: 2009-07-20 23.00.50

BR0883I Table selected to collect statistics after check: SAPSR3.ALTSTLOD (118/0:6940:0)

BR0280I BRCONNECT time stamp: 2009-07-20 23.00.50

BR0881I Collecting statistics for table SAPSR3.ALTSTLOD with method/sample C ...

BR0280I BRCONNECT time stamp: 2009-07-20 23.00.50

BR0884I Statistics collected for table: SAPSR3.ALTSTLOD, rows old/new: 118/118

BR0280I BRCONNECT time stamp: 2009-07-20 23.00.50

BR0850I 9 of 102 objects processed - 0.105 of 9.323 units done

BR0204I Percentage done: 1.12%, estimated end time: 23:11

BR0001I *_________________________________________________

BR0280I BRCONNECT time stamp: 2009-07-20 23.00.50

BR0883I Table selected to collect statistics after check: SAPSR3.ARFCRSTATE (43/29218:7005:29195)

BR0280I BRCONNECT time stamp: 2009-07-20 23.00.50

BR0881I Collecting statistics for table SAPSR3.ARFCRSTATE with method/sample C ...

BR0280I BRCONNECT time stamp: 2009-07-20 23.00.53

BR0884I Statistics collected for table: SAPSR3.ARFCRSTATE, rows old/new: 43/66

BR0280I BRCONNECT time stamp: 2009-07-20 23.00.53

BR0883I Table selected to collect statistics after check: SAPSR3.ARFCSDATA (153830/419010:0:296422)

BR0280I BRCONNECT time stamp: 2009-07-20 23.00.53

BR0881I Collecting statistics for table SAPSR3.ARFCSDATA with method/sample E/P10 ...

BR0280I BRCONNECT time stamp: 2009-07-20 23.01.12

BR0884I Statistics collected for table: SAPSR3.ARFCSDATA, rows old/new: 153830/274700

BR0280I BRCONNECT time stamp: 2009-07-20 23.01.12

BR0850I 11 of 102 objects processed - 0.550 of 9.323 units done

BR0204I Percentage done: 5.90%, estimated end time: 23:08

BR0001I ***_______________________________________________

BR0280I BRCONNECT time stamp: 2009-07-20 23.01.12

BR0301W SQL error -1 at location brc_dblog_write-2, SQL statement:

'INSERT INTO SAP_SDBAD (BEG, FUNCT, SYSID, POS, LINE) VALUES ('20090720230019', 'sta', 'WIP', '0000', 'A 00000000 00000000 00000

ORA-00001: unique constraint (SAPSR3DB.SDBAD__0) violated

BR0325W Writing to database log failed

BR0280I BRCONNECT time stamp: 2009-07-20 23.01.12

BR0883I Table selected to collect statistics after check: SAPSR3.ARFCSSTATE (4029/146985:38657:32482)

BR0280I BRCONNECT time stamp: 2009-07-20 23.01.12

BR0881I Collecting statistics for table SAPSR3.ARFCSSTATE with method/sample E/P10 ...

BR0280I BRCONNECT time stamp: 2009-07-20 23.01.27

BR0884I Statistics collected for table: SAPSR3.ARFCSSTATE, rows old/new: 4029/119330

BR0280I BRCONNECT time stamp: 2009-07-20 23.01.27

BR0883I Table selected to collect statistics after check: SAPSR3.BAL_AMODAL (0/70:0:70)

BR0280I BRCONNECT time stamp: 2009-07-20 23.01.27

BR0881I Collecting statistics for table SAPSR3.BAL_AMODAL with method/sample C ...

BR2.16

20.07.2009 23:12:50 BR0884I Statistics collected for table: SAPSR3.TSP02, rows old/new: 23263/24250

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.16

20.07.2009 23:12:50 BR0883I Table selected to collect statistics after check: SAPSR3.TSP02FX (1511/9606:0:9600)

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.16

20.07.2009 23:12:50 BR0881I Collecting statistics for table SAPSR3.TSP02FX with method/sample C ...

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.16

20.07.2009 23:12:50 BR0884I Statistics collected for table: SAPSR3.TSP02FX, rows old/new: 1511/1517

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.16

20.07.2009 23:12:50 BR0883I Table selected to collect statistics after check: SAPSR3.TSP02W (1511/9606:0:9600)

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.16

20.07.2009 23:12:50 BR0881I Collecting statistics for table SAPSR3.TSP02W with method/sample C ...

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.16

20.07.2009 23:12:50 BR0884I Statistics collected for table: SAPSR3.TSP02W, rows old/new: 1511/1517

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.16

20.07.2009 23:12:50 BR0883I Table selected to collect statistics after check: SAPSR3.TSPOPTIONS (12/0:10970:0)

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.16

20.07.2009 23:12:50 BR0881I Collecting statistics for table SAPSR3.TSPOPTIONS with method/sample C ...

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.17

20.07.2009 23:12:50 BR0884I Statistics collected for table: SAPSR3.TSPOPTIONS, rows old/new: 12/12

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.17

20.07.2009 23:12:50 BR0883I Table selected to collect statistics after check: SAPSR3.TSPSVI (5/0:19210:0)

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.17

20.07.2009 23:12:50 BR0881I Collecting statistics for table SAPSR3.TSPSVI with method/sample C ...

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.17

20.07.2009 23:12:50 BR0884I Statistics collected for table: SAPSR3.TSPSVI, rows old/new: 5/5

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.17

20.07.2009 23:12:50 BR0883I Table selected to collect statistics after check: SAPSR3.TST01 (31843/15941:56883:15606)

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.17

20.07.2009 23:12:50 BR0881I Collecting statistics for table SAPSR3.TST01 with method/sample E/P30 ...

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.19

20.07.2009 23:12:50 BR0884I Statistics collected for table: SAPSR3.TST01, rows old/new: 31843/31640

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.19

20.07.2009 23:12:50 BR0883I Table selected to collect statistics after check: SAPSR3.TUCNTRAW (63/83:16833:91)

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.19

20.07.2009 23:12:50 BR0881I Collecting statistics for table SAPSR3.TUCNTRAW with method/sample C ...

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.19

20.07.2009 23:12:50 BR0884I Statistics collected for table: SAPSR3.TUCNTRAW, rows old/new: 63/55

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.19

20.07.200 for table: SAPSR3.ZWS_POSTING_DATE, rows old/new: 582110/578840

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.49

20.07.2009 23:12:50 BR0883I Table selected to collect statistics after check: SAPSR3DB.BC_UDDI_PARAM (82/320:4:320)

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.49

20.07.2009 23:12:50 BR0881I Collecting statistics for table SAPSR3DB.BC_UDDI_PARAM with method/sample C ...

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.49

20.07.2009 23:12:50 BR0884I Statistics collected for table: SAPSR3DB.BC_UDDI_PARAM, rows old/new: 82/82

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.49

20.07.2009 23:12:50 BR0883I Table selected to collect statistics after check: SAPSR3DB.J2EE_KEYSEQUENCE (1/0:8:0)

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.49

20.07.2009 23:12:50 BR0881I Collecting statistics for table SAPSR3DB.J2EE_KEYSEQUENCE with method/sample C ...

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.49

20.07.2009 23:12:50 BR0884I Statistics collected for table: SAPSR3DB.J2EE_KEYSEQUENCE, rows old/new: 1/1

20.07.2009 23:12:50

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.49

20.07.2009 23:12:50 BR0850I 102 of 102 objects processed - 9.323 of 9.323 units done

20.07.2009 23:12:50 BR0204I Percentage done: 100.00%, estimated end time: 23:12

20.07.2009 23:12:50 BR0001I **************************************************

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.49

20.07.2009 23:12:50 BR0301W SQL error -1 at location brc_dblog_write-2, SQL statement:

20.07.2009 23:12:50 'INSERT INTO SAP_SDBAD (BEG, FUNCT, SYSID, POS, LINE) VALUES ('20090720230019', 'sta', 'WIP', '0000', 'A 00000000 00000000 00000

20.07.2009 23:12:50 ORA-00001: unique constraint (SAPSR3DB.SDBAD__0) violated

20.07.2009 23:12:50 BR0325W Writing to database log failed

20.07.2009 23:12:50

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.49

20.07.2009 23:12:50 BR0879I Statistics checked for 68351 tables

20.07.2009 23:12:50 BR0878I Number of tables selected to collect statistics after check: 102

20.07.2009 23:12:50 BR0880I Statistics collected for 102/0 tables/indexes

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.49

20.07.2009 23:12:50 BR0301W SQL error -1 at location brc_dblog_write-2, SQL statement:

20.07.2009 23:12:50 'INSERT INTO SAP_SDBAD (BEG, FUNCT, SYSID, POS, LINE) VALUES ('20090720230019', 'sta', 'WIP', '0000', 'A 00000000 00000000 00000

20.07.2009 23:12:50 ORA-00001: unique constraint (SAPSR3DB.SDBAD__0) violated

20.07.2009 23:12:50 BR0325W Writing to database log failed

20.07.2009 23:12:50

20.07.2009 23:12:50 BR0806I End of BRCONNECT processing: cebbggbz.sta2009-07-20 23.12.49

20.07.2009 23:12:50 BR0280I BRCONNECT time stamp: 2009-07-20 23.12.49

20.07.2009 23:12:50 BR0803I BRCONNECT completed successfully with warnings

20.07.2009 23:12:50 External program terminated with exit code 1

20.07.2009 23:12:50 BRCONNECT returned error status E

20.07.2009 23:12:50 Job finished

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
‎07-21-2009 12:53 PM
0 Kudos

Hi Jiggi,

Can you tell me whether your able to run the job in os level(like unix level/command prompt)..

Login with the sidadm and execute the command which u can find out from the log and check whether it is finishing fine or not.

As per the result we need to trace the prob.

-Jag

Show replies
Show replies
Former Member
‎07-21-2009 12:26 PM
0 Kudos

Hi,

BR0301W SQL error -1 at location brc_dblog_write-2, SQL statement: 20.07.2009 23:12:50 'INSERT INTO SAP_SDBAD (BEG, FUNCT, SYSID, POS, LINE) VALUES ('20090720230019', 'sta', 'WIP', '0000', 'A 00000000 00000000 00000 20.07.2009 23:12:50 ORA-00001: unique constraint (SAPSR3DB.SDBAD__0) violated 20.07.2009 23:12:50 BR0325W Writing to database log failed

This looks like you have dual stack system installed.

Please check the Note 853610 - Configuring transaction DB13C for Oracle. This may help you. See caution 3.

Show replies
Show replies
anindya_bose
Active Contributor
‎07-21-2009 9:44 AM
0 Kudos

Hi Jiggi

Are you running 2 jobs at the same time from DB13? What do you mean by >Db13 both the jobs failed

>ORA-00001: unique constraint

can happen due to lot of reasons in SAP. Basically it means you are insertion of already existing records.

This also may happen due to bug in brtools patch level. What is your brtools patch level?

You can also have a look at

https://service.sap.com/sap/support/notes/421697

https://service.sap.com/sap/support/notes/458872

Anindya

Show replies
Show replies
Former Member
‎07-21-2009 10:08 AM
0 Kudos

Hi Anindya,

Both job means we are running 2 jobs ie. update stas and Db Checks not simultaneously.

BR0651I BRTOOLS 7.00 (26) this is the brtools version.

Will go through the given link.

Thanks in advance.

regards

Jiggi,

Former Member
‎07-21-2009 11:11 AM
0 Kudos

Hi Jiggi,

Anindya made a valid comment.The job run should not overlap.

The other should run after the completion of first only.

Regards

Ashok Dalai

Former Member
‎07-21-2009 12:50 PM
0 Kudos

Your BRTOOLS version seems to be old. You can find current versions from Note 12741 - Current versions of BR*Tools and SAPDBA

Ask a Question