BR0804I BRCONNECT terminated with error code 5

[Former Member]

hi all,

we r exporting source system , at step 2 "Update database statistice" error occur

An error occurred while processing service SAP ERP 6.0 Support Release 3 > Software Life-Cycle Options > System Copy > Oracle > Source System Export > Central System > Based on AS ABAP > Database Instance Export( Last error reported by the step :Process call 'G:\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.). You may now
choose Retry to repeat the current step.
choose View Log to get more information about the error.
stop the task and continue with it later.
Log files are written to C:\Program Files/sapinst_instdir/ERP/LM/COPY/ORA/EXP/CENTRAL/AS-ABAP/EXP.

BR0280I BRCONNECT thread 2: time stamp: 2010-03-17 13.32.29
BR0850I 69902 of 69902 objects processed - 82.467 of 82.467 units done
BR0204I Percentage done: 100.00%, estimated end time: 13:32
BR0001I **************************************************

BR0280I BRCONNECT time stamp: 2010-03-17 13.32.29
BR0848I Thread 2 finished with return code 0

BR0280I BRCONNECT time stamp: 2010-03-17 13.32.29
BR0879I Statistics checked for 0 tables
BR0878I Number of tables selected to collect statistics after check: 0
BR0880I Statistics collected for 69902/0 tables/indexes
BR0889I Structure validated for 0/83617/0 tables/indexes/clusters

BR0806I End of BRCONNECT processing: cecuoaya.sta 2010-03-17 13.32.29
BR0280I BRCONNECT time stamp: 2010-03-17 13.32.30
BR0804I BRCONNECT terminated with errors

ERROR      2010-03-17 13:32:30.171 
           CJSlibModule::writeError_impl() 
CJS-30023  Process call 'G:\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.

ERROR      2010-03-17 13:32:30.187 [sixxcstepexecute.cpp:951]
FCO-00011  The step updateOracleStatistics with step key |NW_Export|ind|ind|ind|ind|0|0|NW_Export_Pre|ind|ind|ind|ind|3|0|NW_ORA_Statistics_Update|ind|ind|ind|ind|0|0|updateOracleStatistics was executed with status ERROR ( Last error reported by the step :Process call 'G:\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.)

plz guide

[Former Member]

there is some more error we are posting a new question. And closing this

[markus_doehr2]

> FCO-00011 The step updateOracleStatistics with step key |NW_Export|ind|ind|ind|ind|0|0|NW_Export_Pre|ind|ind|ind|ind|3|0|NW_ORA_Statistics_Update|ind|ind|ind|ind|0|0|updateOracleStatistics was executed with status ERROR ( Last error reported by the step :Process call 'G:\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.)

>

> plz guide

Please read what you just posted. Check brconnect.log

Markus

[Former Member]

this is brconnect.log

BR0801I BRCONNECT 7.00 (38)
BR0805I Start of BRCONNECT processing: cecuoaya.sta 2010-03-17 12.47.44
BR0484I BRCONNECT log file: G:\oracle\PRD\sapcheck\cecuoaya.sta

BR0280I BRCONNECT time stamp: 2010-03-17 12.47.47
BR0813I Schema owner found in database PRD: SAPSR3*

BR0280I BRCONNECT time stamp: 2010-03-17 12.47.51
BR0814I Number of tables in schema of owner SAPSR3: 69902
BR0836I Number of info cube tables found for owner SAPSR3: 49

BR0280I BRCONNECT time stamp: 2010-03-17 12.48.00
BR0815I Number of indexes in schema of owner SAPSR3: 83618

BR0280I BRCONNECT time stamp: 2010-03-17 12.48.00
BR0818I Number of tables found in DBSTATC for owner SAPSR3: 390

BR0280I BRCONNECT time stamp: 2010-03-17 12.48.00
BR0807I Name of database instance: PRD
BR0808I BRCONNECT action ID: cecuoaya
BR0809I BRCONNECT function ID: sta
BR0810I BRCONNECT function: stats
BR0811I Owner of database schema for processing: SAPSR3
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: 69902
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: 0
BR0862I Force option with value 'allsel,collect,keep,method,precision,space' set
BR0846I Number of threads that will be started in parallel to the main thread: 4
BR0126I Unattended mode active - no operator confirmation required

BR0280I BRCONNECT time stamp: 2010-03-17 12.48.01
BR0877I Checking and collecting table and index statistics...
BR0847I Thread 1 started successfully
BR0847I Thread 2 started successfully
BR0847I Thread 3 started successfully
BR0847I Thread 4 started successfully

BR0280I BRCONNECT thread 4: time stamp: 2010-03-17 12.51.13
BR0850I 3349 of 69902 objects processed - 3.325 of 82.467 units done
BR0204I Percentage done: 4.03%, estimated end time: 14:07
BR0001I **________________________________________________


BR0280I BRCONNECT thread 3: time stamp: 2010-03-17 13.22.31
BR0850I 62228 of 69902 objects processed - 37.139 of 82.467 units done
BR0204I Percentage done: 45.04%, estimated end time: 14:04
BR0001I ***********************___________________________
BR0280I BRCONNECT thread 1: time stamp: 2010-03-17 13.23.48
BR0301E SQL error -8100 in thread 1 at location stats_ind_validate-2, SQL statement:
'ANALYZE INDEX "SAPSR3"."TST03~0" VALIDATE STRUCTURE'
ORA-08100: index is not valid - see trace file for diagnostics
BR0893E Validating structure failed for index SAPSR3.TST03~0

BR0280I BRCONNECT time stamp: 2010-03-17 13.25.41
BR0848I Thread 3 finished with return code 0

BR0280I BRCONNECT time stamp: 2010-03-17 13.25.41
BR0848I Thread 4 finished with return code 0

BR0280I BRCONNECT time stamp: 2010-03-17 13.25.50
BR0848I Thread 1 finished with return code -1

BR0280I BRCONNECT thread 2: time stamp: 2010-03-17 13.32.29
BR0850I 69902 of 69902 objects processed - 82.467 of 82.467 units done
BR0204I Percentage done: 100.00%, estimated end time: 13:32
BR0001I **************************************************

BR0280I BRCONNECT time stamp: 2010-03-17 13.32.29
BR0848I Thread 2 finished with return code 0

BR0280I BRCONNECT time stamp: 2010-03-17 13.32.29
BR0879I Statistics checked for 0 tables
BR0878I Number of tables selected to collect statistics after check: 0
BR0880I Statistics collected for 69902/0 tables/indexes
BR0889I Structure validated for 0/83617/0 tables/indexes/clusters

BR0806I End of BRCONNECT processing: cecuoaya.sta 2010-03-17 13.32.29
BR0280I BRCONNECT time stamp: 2010-03-17 13.32.30
BR0804I BRCONNECT terminated with errors

[markus_doehr2]

> BR0301E SQL error -8100 in thread 1 at location stats_ind_validate-2, SQL statement:

> 'ANALYZE INDEX "SAPSR3"."TST03~0" VALIDATE STRUCTURE'

> ORA-08100: index is not valid - see trace file for diagnostics

You have a corrupt index.

I'd use transaction SE14 on table TST03, drop and recreate the index.

Markus

[Former Member]

Thanks Master,

you mean in se14, at "excute database operation" there is "delete database index"

click on "delete database index" then create it again

[Former Member]

when click on "delete database index"

messege appear

You may not delete the primary index

[former_member204746]

try at OS level:

sqlplus / as sysdba

drop index SAPSR3."TST03~0" ;

exit;

[Former Member]

thanks Eric,

we have drop index TST03~0

now how we create it

[Former Member]

Hi,

to create Index:

Yo have to use transaction SE11 into Dev system.

Enter the database table name and press

Display -> Indexes -> Create

Enter index name.

Choose Maintain logon language.

Enter short description and index fields.

Then press save and create the request to transport the index to QA and

PRD.

Then press activate.

You can also create from the database front, But always recommended to carry out the db level activities from the sap gui.

Note: Advice to initiate the deletion activities, if creation is know. always request consultants answering give with a complete solution

cheers

[Former Member]

hi,

TST03, drop and recreate the index now export has failed 2 job outof 43,

export_monitor.java.log

Unloading of 'SAPAPPL0_4' export package: OK
Export Monitor jobs: running 1, waiting 30, completed 12, failed 0, total 43.
Export Monitor jobs: running 2, waiting 29, completed 12, failed 0, total 43.
Export Monitor jobs: running 3, waiting 28, completed 12, failed 0, total 43.
Unloading of 'SAPAPPL1_2' export package: ERROR
Export Monitor jobs: running 2, waiting 28, completed 12, failed 1, total 43.
Export Monitor jobs: running 3, waiting 27, completed 12, failed 1, total 43.
Unloading of 'SAPAPPL1_3' export package: ERROR
Export Monitor jobs: running 2, waiting 27, completed 12, failed 2, total 43.
Export Monitor jobs: running 3, waiting 26, completed 12, failed 2, total 43.

'SAPAPPL1_2.log

(RTF) ########## WARNING ###########
	Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases


G:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe: job completed
G:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20100319145456

G:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20100319145456

G:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#18 $ SAP
G:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]
Compiled Nov 18 2008 23:19:12
G:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe -e SAPAPPL1_2.cmd -datacodepage 4103 -l SAPAPPL1_2.log -stop_on_error 

(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8
(DB) INFO: Export without hintfile
(GSI) INFO: dbname   = "PRD20090418030425                                                                                "
(GSI) INFO: vname    = "ORACLE                          "
(GSI) INFO: hostname = "PRDSAP                                                          "
(GSI) INFO: sysname  = "Windows NT"
(GSI) INFO: nodename = "PRDSAP"
(GSI) INFO: release  = "5.2"
(GSI) INFO: version  = "3790 Service Pack 1"
(GSI) INFO: machine  = "8x AMD64 Level 6 (Mod 23 Step 10)"
(GSI) INFO: instno   = "0020500723"

EXP) TABLE: "K002" #20100319145654

(EXP) ERROR: DbSlExeRead failed
  rc = 103, table "K9RPRD7000001"
  (SQL error 942)
  error message returned by DbSl:
ORA-00942: table or view does not exist
(DB) INFO: disconnected from DB

G:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)
G:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20100319145654

SAPAPPL1_3.log

G:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20100319145655

G:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#18 $ SAP

G:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]

Compiled Nov 18 2008 23:19:12

G:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe -ctf E I:\PRD_Exp\ABAP\DATA\SAPAPPL1_3.STR I:\PRD_Exp\ABAP\DB\DDLORA_LRG.TPL SAPAPPL1_3.TSK ORA -l SAPAPPL1_3.log

(RTF) ########## WARNING ###########
	Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases


G:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe: job completed
G:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20100319145656

G:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe: START OF LOG: 20100319145656

G:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe: sccsid @(#) $Id: //bas/700_REL/src/R3ld/R3load/R3ldmain.c#18 $ SAP
G:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe: version R7.00/V1.4 [UNICODE]
Compiled Nov 18 2008 23:19:12
G:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe -e SAPAPPL1_3.cmd -datacodepage 4103 -l SAPAPPL1_3.log -stop_on_error 

(DB) INFO: connected to DB
(DB) INFO: DbSlControl(DBSL_CMD_NLS_CHARACTERSET_GET): UTF8
(DB) INFO: Export without hintfile
(GSI) INFO: dbname   = "PRD20090418030425                                                                                "
(GSI) INFO: vname    = "ORACLE                          "
(GSI) INFO: hostname = "PRDSAP                                                          "
(GSI) INFO: sysname  = "Windows NT"
(GSI) INFO: nodename = "PRDSAP"
(GSI) INFO: release  = "5.2"
(GSI) INFO: version  = "3790 Service Pack 1"
(GSI) INFO: machine  = "8x AMD64 Level 6 (Mod 23 Step 10)"
(GSI) INFO: instno   = "0020500723"

EXP) ERROR: DbSlExeRead failed
  rc = 103, table "QCMZPORD_LINE"
  (SQL error 942)
  error message returned by DbSl:
ORA-00942: table or view does not exist
(DB) INFO: disconnected from DB

G:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe: job finished with 1 error(s)
G:\usr\sap\PRD\SYS\exe\uc\NTAMD64\R3load.exe: END OF LOG: 20100319145717

[Former Member]

Hi Imran,

Go to se14 and delete the invalid tables from the menu Extras --> Invalid temp table

you will find QCM tables. check and delete them. Restart the process.

cheers

[Former Member]

hi gobal,

there is no invalid temp table, we have restart the process but again jobs fail

Regards

Khan

[Former Member]

Hi Imran,

You can again create the index with this statement:

create index SAPSR3."TST03~0" ON SAPSR3.TST03;

With Regards,

Mohan.