Skip to Content
avatar image
Former Member

Db13 both the jobs failed update stats and DB check

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jul 21, 2009 at 08:44 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

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

  • avatar image
    Former Member
    Jul 21, 2009 at 11:26 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 21, 2009 at 11:53 AM

    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

    Add comment
    10|10000 characters needed characters exceeded