Brconnect error

[Former Member]

Hi Gurus ,

We are now installing the ECC 6.O with Oracle 10.2.0.2 , While installing in the phase of create database statics we facing the following mentioned error .

ERROR 2008-10-22 17:16:30.640

CJS-30023 Process call 'G:\usr\sap\IDS\SYS\exe\uc\NTAMD64\brconnect.exe -u / -c -o summary -f stats -o SAPSR3 -t all -p 2 -f nocasc' exits with error code 5. For details see log file(s) brconnect.log.

ERROR 2008-10-22 17:16:31.593

FCO-00011 The step createOracleStatisticsABAP with step key |NW_Onehost|ind|ind|ind|ind|0|0|NW_Onehost_System|ind|ind|ind|ind|2|0|NW_CreateDBandLoad|ind|ind|ind|ind|10|0|NW_Postload|ind|ind|ind|ind|10|0|NW_Postload_ORA|ind|ind|ind|ind|0|0|NW_ORA_Statistics_Create|ind|ind|ind|ind|0|0|createOracleStatisticsABAP was executed with status ERROR ( Last error reported by the step :Process call 'G:\usr\sap\IDS\SYS\exe\uc\NTAMD64\brconnect.exe -u / -c -o summary -f stats -o SAPSR3 -t all -p 2 -f nocasc' exits with error code 5. For details see log file(s) brconnect.log.).

Kindly advice me to solve this problem

Regards

Selvan

[Former Member · Accepted solution]

Hi Anish ,

Here below i paste the brconnect.log

BR0801I BRCONNECT 7.00 (32)

BR0805I Start of BRCONNECT processing: cdzbyyrc.sta 2008-10-22 17.36.36

BR0484I BRCONNECT log file: G:\oracle\IDS\sapcheck\cdzbyyrc.sta

BR0280I BRCONNECT time stamp: 2008-10-22 17.36.44

BR0813I Schema owners found in database IDS: SAPSR3*, SAPSR3DB%

BR0280I BRCONNECT time stamp: 2008-10-22 17.37.13

BR0814I Number of tables/partitions in schema of owner SAPSR3: 79352/7

BR0836I Number of info cube tables found for owner SAPSR3: 469

BR0280I BRCONNECT time stamp: 2008-10-22 17.37.49

BR0815I Number of indexes/partitions in schema of owner SAPSR3: 95733/63

BR0280I BRCONNECT time stamp: 2008-10-22 17.37.50

BR0818I Number of tables found in DBSTATC for owner SAPSR3: 2007

BR0280I BRCONNECT time stamp: 2008-10-22 17.37.50

BR0807I Name of database instance: IDS

BR0808I BRCONNECT action ID: cdzbyyrc

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: 16951

BR0852I Number of tables to delete statistics: 0

BR0854I Number of tables to collect statistics without checking: 386

BR0855I Number of indexes with missing statistics: 20836

BR0856I Number of indexes to delete statistics: 0

BR0857I Number of indexes to collect statistics: 9666

BR0853I Number of tables to check (and collect if needed) statistics: 78948

BR0862I Force option with value 'nocasc' set

BR0846I Number of threads that will be started in parallel to the main thread: 2

BR0126I Unattended mode active - no operator confirmation required

BR0280I BRCONNECT time stamp: 2008-10-22 17.37.55

BR0817I Number of monitored/modified tables in schema of owner SAPSR3: 79352/7163

BR0817I Number of monitored/modified tables in schema of owner SAPSR3DB: 318/31

BR0280I BRCONNECT time stamp: 2008-10-22 17.37.56

BR0877I Checking and collecting table and index statistics...

BR0847I Thread 1 started successfully

BR0847I Thread 2 started successfully

BR0280I BRCONNECT thread 2: time stamp: 2008-10-22 17.37.56

BR0882I Collecting statistics for index SAPSR3.D010INC~0 with method/sample C ...

BR0280I BRCONNECT thread 1: time stamp: 2008-10-22 17.37.56

BR0882I Collecting statistics for index SAPSR3.D010TAB~0 with method/sample C ...

BR0280I BRCONNECT thread 2: time stamp: 2008-10-22 17.37.56

BR0885I Statistics collected for index: SAPSR3.D010INC~0, rows old/new: -1/0

BR0280I BRCONNECT thread 2: time stamp: 2008-10-22 17.37.56

BR0882I Collecting statistics for index SAPSR3.D010INC~1 with method/sample C ...

BR0280I BRCONNECT thread 1: time stamp: 2008-10-22 17.37.56

BR0885I Statistics collected for index: SAPSR3.D010TAB~0, rows old/new: -1/0

BR0280I BRCONNECT thread 1: time stamp: 2008-10-22 17.37.56

BR0882I Collecting statistics for index SAPSR3.D010TAB~1 with method/sample C ...

BR0280I BRCONNECT thread 1: time stamp: 2008-10-22 17.37.56

BR0885I Statistics collected for index: SAPSR3.D010TAB~1, rows old/new: -1/0

BR0280I BRCONNECT thread 2: time stamp: 2008-10-22 17.37.56

BR0885I Statistics collected for index: SAPSR3.D010INC~1, rows old/new: -1/0

BR0280I BRCONNECT thread 2: time stamp: 2008-10-22 17.38.08

BR0850I 366 of 36432 objects processed - 0.549 of 54.685 units done

BR0204I Percentage done: 1.00%, estimated end time: 17:57

BR0001I *_________________________________________________

BR0280I BRCONNECT thread 2: time stamp: 2008-10-22 17.38.15

BR0850I 730 of 36432 objects processed - 1.096 of 54.685 units done

BR0204I Percentage done: 2.00%, estimated end time: 17:53

BR0001I *_________________________________________________

BR0280I BRCONNECT thread 1: time stamp: 2008-10-22 17.38.44

BR0850I 1822 of 36432 objects processed - 2.735 of 54.685 units done

BR0204I Percentage done: 5.00%, estimated end time: 17:53

BR0001I ***_______________________________________________

BR0280I BRCONNECT thread 2: time stamp: 2008-10-22 17.39.35

BR0850I 3644 of 36432 objects processed - 5.470 of 54.685 units done

BR0204I Percentage done: 10.00%, estimated end time: 17:54

BR0001I *****_____________________________________________

BR0280I BRCONNECT thread 2: time stamp: 2008-10-22 17.40.16

BR0850I 5466 of 36432 objects processed - 8.205 of 54.685 units done

BR0204I Percentage done: 15.00%, estimated end time: 17:53

BR0001I ********__________________________________________

BR0280I BRCONNECT thread 2: time stamp: 2008-10-22 17.41.06

BR0850I 7287 of 36432 objects processed - 10.938 of 54.685 units done

BR0204I Percentage done: 20.00%, estimated end time: 17:53

BR0001I **********________________________________________

BR0280I BRCONNECT thread 2: time stamp: 2008-10-22 17.42.16

BR0850I 9108 of 36432 objects processed - 13.671 of 54.685 units done

BR0204I Percentage done: 25.00%, estimated end time: 17:55

BR0001I *************_____________________________________

Kindly advice me

selvan

[Former Member · Accepted solution]

Hi dear "solman manager", as i can see your other thread are answered? Or not? If yes please close it. In this thread are you post full "brconnect.log" ? Try to check SWAP space to, as in other your thread suggested(because you have many other errors to...) Regards....

[Former Member]

Hi Sergo ,

Thanks ,

Selvan

[former_member204746]

People really have a hard time reading their error messages.

in this case( like many others), it tells you what to do:

For details see log file(s) brconnect.log

[Former Member]

Hi,

Check brconnect.log fro errors.

Regards

Ashok

[Former Member]

paste the log specified