cancel
Showing results for 
Search instead for 
Did you mean: 

ERROR WHILE SYSTEM EXPORT

anil_singh19
Participant
0 Kudos

while doing system export with swpm i am getting error on stage update database statics.

details

netweaver 7.0 ehp2 (bi system)

oracle 10.2.0.4.0

please find the error message

TRACE      2016-04-29 10:46:14.153

Using custom value flow_trace for property SAPINST_MESSAGE_DEVLOG_THRESHOLD.

TRACE      2016-04-29 10:46:14.153

Using custom value info for property SAPINST_MESSAGE_GUILOG_THRESHOLD.

TRACE      2016-04-29 10:45:45.169

The step fillContext with key |NW_ABAP_OneHost|ind|ind|ind|ind|0|0 has been executed successfully.

INFO       2016-04-29 10:45:45.169 [synxccuren.cpp:887]

           CSyCurrentProcessEnvironmentImpl::setWorkingDirectory(const CSyPath & C:/Program Files/sapinst_instdir/NW702/AS-ABAP/ORA/CENTRAL)

           lib=syslib module=syslib

Working directory changed to C:/Program Files/sapinst_instdir/NW702/AS-ABAP/ORA/CENTRAL.

TRACE      2016-04-29 10:45:45.169 [kdxxctaco.cpp:93]

           CKdbTableContainerImpl::syncToContainerFile

CKdbTableContainerImpl::syncToContainerFile start ...

TRACE      2016-04-29 10:45:45.169 [kdxxctaco.cpp:121]

           CKdbTableContainerImpl::syncToContainerFile

after creating out stream  for C:\Program Files\sapinst_instdir\NW702\AS-ABAP\ORA\CENTRAL\inifile.xml

TRACE      2016-04-29 10:45:45.169 [kdxxctaco.cpp:155]

           CKdbTableContainerImpl::syncToContainerFile

CKdbTableContainerImpl::syncToContainerFile stop ...

TRACE      2016-04-29 10:45:45.169 [kdxxctaco.cpp:93]

           CKdbTableContainerImpl::syncToContainerFile

CKdbTableContainerImpl::syncToContainerFile start ...

TRACE      2016-04-29 10:45:45.169 [kdxxctaco.cpp:121]

           CKdbTableContainerImpl::syncToContainerFile

after creating out stream  for C:\Program Files\sapinst_instdir\NW702\AS-ABAP\ORA\CENTRAL\inifile.xml

TRACE      2016-04-29 10:45:45.169 [kdxxctaco.cpp:155]

           CKdbTableContainerImpl::syncToContainerFile

CKdbTableContainerImpl::syncToContainerFile stop ...

TRACE      2016-04-29 10:45:45.169 [kdxxctaco.cpp:93]

           CKdbTableContainerImpl::syncToContainerFile

CKdbTableContainerImpl::syncToContainerFile start ...

TRACE      2016-04-29 10:45:45.185 [kdxxctaco.cpp:121]

           CKdbTableContainerImpl::syncToContainerFile

after creating out stream  for C:\Program Files\sapinst_instdir\NW702\AS-ABAP\ORA\CENTRAL\\keydb.xml

TRACE      2016-04-29 10:45:45.185 [kdxxctaco.cpp:155]

           CKdbTableContainerImpl::syncToContainerFile

CKdbTableContainerImpl::syncToContainerFile stop ...

TRACE      2016-04-29 10:45:45.185 [kdxxctaco.cpp:93]

           CKdbTableContainerImpl::syncToContainerFile

CKdbTableContainerImpl::syncToContainerFile start ...

TRACE      2016-04-29 10:45:45.185 [kdxxctaco.cpp:121]

           CKdbTableContainerImpl::syncToContainerFile

after creating out stream  for product.xml

TRACE      2016-04-29 10:45:45.185 [kdxxctaco.cpp:155]

           CKdbTableContainerImpl::syncToContainerFile

CKdbTableContainerImpl::syncToContainerFile stop ...

TRACE      2016-04-29 10:45:45.185 [kdxxctaco.cpp:93]

           CKdbTableContainerImpl::syncToContainerFile

CKdbTableContainerImpl::syncToContainerFile start ...

TRACE      2016-04-29 10:45:45.185 [kdxxctaco.cpp:121]

           CKdbTableContainerImpl::syncToContainerFile

after creating out stream  for C:\Program Files\sapinst_instdir\NW702\AS-ABAP\ORA\CENTRAL\statistic.xml

TRACE      2016-04-29 10:45:45.185 [kdxxctaco.cpp:155]

           CKdbTableContainerImpl::syncToContainerFile

CKdbTableContainerImpl::syncToContainerFile stop ...

TRACE      2016-04-29 10:45:45.185

Unload framework extensions ....

TRACE      2016-04-29 10:45:45.185 [iaxxclibmn.cpp:84]

           unloadLib()

Unload lib iamodos.dll

TRACE      2016-04-29 10:45:45.185 [iaxxclib.cpp:178]

           CLib::unload()

unload()

TRACE      2016-04-29 10:45:45.185 [iaxxcregst.cpp:62]

           unregisterClass()

Unregister class CIaOsAccount

TRACE      2016-04-29 10:45:45.185 [iaxxcregst.cpp:62]

           unregisterClass()

Unregister class CIaOsFile

TRACE      2016-04-29 10:45:45.185 [iaxxcregst.cpp:62]

           unregisterClass()

Unregister class CIaOsNetwork

TRACE      2016-04-29 10:45:45.185 [iaxxcregst.cpp:62]

           unregisterClass()

Unregister class CIaOsProcess

TRACE      2016-04-29 10:45:45.185 [iaxxcregst.cpp:62]

           unregisterClass()

Unregister class CIaOsSystem

TRACE      2016-04-29 10:45:45.185 [iaxxclib.cpp:206]

           CLib::unload()

Closed iamodos.dll

TRACE      2016-04-29 10:45:45.185 [iaxxclibmn.cpp:84]

           unloadLib()

Unload lib iajsmod.dll

TRACE      2016-04-29 10:45:45.185 [iaxxclib.cpp:178]

           CLib::unload()

unload()

TRACE      2016-04-29 10:45:45.185 [iaxxcregst.cpp:62]

           unregisterClass()

Unregister class CJSlibModule

TRACE      2016-04-29 10:45:45.185 [iaxxclib.cpp:206]

           CLib::unload()

Closed iajsmod.dll

INFO       2016-04-29 10:45:45.200 [synxcpath.cpp:799]

           CSyPath::createFile() lib=syslib module=syslib

Creating file D:\usr\sap\tmp\4\sapinst_exe.8688.1461906693\dev_sap_kernel_test_29_Apr_2016_10_45_45.

INFO       2016-04-29 10:45:45.200 [synxcfile.cpp:376]

           CSyFileImpl::removeEx(ISyFSErrorHandler * pErrorHandler)

           lib=syslib module=syslib

Removed file D:\usr\sap\tmp\4\sapinst_exe.8688.1461906693\dev_sap_kernel_test_29_Apr_2016_10_45_45.

TRACE      2016-04-29 10:45:45.200 [syxxcfile.cpp:85]

           CSyFileImpl::decideIfMoveCopyNode(const CopyMoveDestinationInfo & {m_nodeTypeForCombiCheck: ..., m_path: D:/usr/sap/tmp/4/sapinst_exe.8688.1461906693/dev_sap_kernel, m_realNodeType: 8}, ISyNode::CopyMoveMode_t 0x3, PSyNodeInt &) const

           lib=syslib module=syslib

Target node does not exist and (mode & ISyNode::MISSING) ==> I will copy/move.

TRACE      2016-04-29 10:45:45.200 [synxcfile.cpp:478]

           CSyFileImpl::copy(const CSyPath & D:/usr/sap/tmp/4/sapinst_exe.8688.1461906693, ISyNode::CopyMoveMode_t 0x3, ISyProgressObserver*) const

           lib=syslib module=syslib

Copying file C:/Program Files/sapinst_instdir/NW702/AS-ABAP/ORA/CENTRAL/dev_sap_kernel to D:/usr/sap/tmp/4/sapinst_exe.8688.1461906693

INFO       2016-04-29 10:45:45.200 [synxcfile.cpp:678]

           CSyFileImpl::copy(const CSyPath & D:/usr/sap/tmp/4/sapinst_exe.8688.1461906693, ISyNode::CopyMoveMode_t 0x3, ISyProgressObserver*) const

           lib=syslib module=syslib

Copied file 'C:/Program Files/sapinst_instdir/NW702/AS-ABAP/ORA/CENTRAL/dev_sap_kernel' to 'D:/usr/sap/tmp/4/sapinst_exe.8688.1461906693'.

INFO       2016-04-29 10:45:45.200 [synxcfile.cpp:376]

           CSyFileImpl::removeEx(ISyFSErrorHandler * pErrorHandler)

           lib=syslib module=syslib

Removed file C:\Program Files\sapinst_instdir\NW702\AS-ABAP\ORA\CENTRAL\dev_sap_kernel.

TRACE      2016-04-29 10:45:45.200 [syxxclogbook.cpp:215]

           PSyLogBook::initSAPKernelTracing(int traceLevel, const CSyPath & filePath)

           lib=syslib module=syslib

Initialized SAP kernel tracing to file D:\usr\sap\tmp\4\sapinst_exe.8688.1461906693\dev_sap_kernel

TRACE      2016-04-29 10:45:45.200 [kdxxctaco.cpp:93]

           CKdbTableContainerImpl::syncToContainerFile

CKdbTableContainerImpl::syncToContainerFile start ...

TRACE      2016-04-29 10:45:45.200 [kdxxctaco.cpp:121]

           CKdbTableContainerImpl::syncToContainerFile

after creating out stream  for C:\Program Files\sapinst_instdir\NW702\AS-ABAP\ORA\CENTRAL\statistic.xml

TRACE      2016-04-29 10:45:45.200 [kdxxctaco.cpp:155]

           CKdbTableContainerImpl::syncToContainerFile

CKdbTableContainerImpl::syncToContainerFile stop ...

TRACE      2016-04-29 10:45:45.372

27 objects of type 'CKdbAttributeClientImpl' have leaked

753 objects of type 'CKdbAttributeImpl' have leaked

4 objects of type 'CKdbClient' have leaked

4 objects of type 'CKdbClientTableNameMappingImpl' have leaked

4 objects of type 'CKdbContextParameterInterface' have leaked

4 objects of type 'CKdbParameterTableContainerImpl' have leaked

14 objects of type 'CKdbRowClientImpl' have leaked

10 objects of type 'CKdbRowContextImpl' have leaked

119 objects of type 'CKdbRowImpl' have leaked

139 objects of type 'CKdbTableClientImpl' have leaked

25 objects of type 'CKdbTableElementClientImpl' have leaked

392 objects of type 'CKdbTableElementImpl' have leaked

119 objects of type 'CKdbTableImpl' have leaked

4 objects of type 'CKdbTableListImpl' have leaked

393 objects of type 'CKdbValueBase' have leaked

Accepted Solutions (1)

Accepted Solutions (1)

former_member185239
Active Contributor
0 Kudos

Hi Anil,

Kindly paste the brconnect log file.

With Regards

Ashutosh Chaturvedi

anil_singh19
Participant
0 Kudos

BR0801I BRCONNECT 7.20 (1)

BR0805I Start of BRCONNECT processing: cetbdcee.sta 2016-04-29 14.30.12

BR0484I BRCONNECT log file: E:\oracle\sid\sapcheck\cetbdcee.sta

BR0101I Parameters

Name                           Value

oracle_sid                     sid

oracle_home                    E:\oracle\sid\102

oracle_profile                 E:\oracle\sid\102\database\initsid.ora

sapdata_home                   E:\oracle\sid

sap_profile                    E:\oracle\sid\102\database\initsid.sap

system_info                    sidadm ROHABI Windows 5.2 Build 3790 Service Pack 2 AMD64

oracle_info                    sid 10.2.0.4.0 8192 20856 371727212 ROHABI UTF8 UTF8 4232686873

sap_info                       702 SAPSR3 0002LK0003sid0011K14433953010015Maintenance_ORA

make_info                      NTAMD64 OCI_10201_SHARE Mar 10 2010

command_line                   D:\usr\sap\sid\SYS\exe\uc\NTAMD64\brconnect.exe -p initsid.sap -l E -U -f stats -t all -p 1

stats_table                    ALL

stats_dbms_stats               ALL:R:0

stats_change_threshold         50

stats_parallel_degree          1

stats_dict_cycle               0

stats_system_cycle             0

BR0280I BRCONNECT time stamp: 2016-04-29 14.30.16

BR0813I Schema owner found in database sid: SAPSR3*

BR0280I BRCONNECT time stamp: 2016-04-29 14.30.17

BR0814I Number of tables/partitions in schema of owner SAPSR3: 27005/648

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

BR0280I BRCONNECT time stamp: 2016-04-29 14.30.20

BR0815I Number of indexes/partitions in schema of owner SAPSR3: 38879/1484

BR0280I BRCONNECT time stamp: 2016-04-29 14.30.21

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

BR1310W Oracle automatic statistics collection job GATHER_STATS_JOB is active - it can conflict with BRCONNECT statistics runs

BR0280I BRCONNECT time stamp: 2016-04-29 14.30.21

BR0807I Name of database instance: sid

BR0808I BRCONNECT action ID: cetbdcee

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

BR0280I BRCONNECT time stamp: 2016-04-29 14.30.21

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRCONNECT:

BR0280I BRCONNECT time stamp: 2016-04-29 14.30.24

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRCONNECT time stamp: 2016-04-29 14.30.25

BR0817I Number of monitored/modified tables in schema of owner SAPSR3: 27005/38

BR0280I BRCONNECT time stamp: 2016-04-29 14.30.26

BR0877I Checking and collecting table and index statistics...

BR0280I BRCONNECT time stamp: 2016-04-29 14.30.26

BR0879I Statistics checked for 27005 tables

BR0878I Number of tables selected to collect statistics after check: 0

BR0880I Statistics collected for 0/0 tables/indexes

BR0806I End of BRCONNECT processing: cetbdcee.sta 2016-04-29 14.30.26

BR0280I BRCONNECT time stamp: 2016-04-29 14.30.27

BR0803I BRCONNECT completed successfully with warnings

anil_singh19
Participant
0 Kudos

hi  ashutosh,

please find the log

anil_singh19
Participant
0 Kudos

BR0801I BRCONNECT 7.20 (1)

BR0805I Start of BRCONNECT processing: cetayour.sta 2016-04-28 16.27.53

BR0484I BRCONNECT log file: E:\oracle\RB1\sapcheck\cetayour.sta

BR0280I BRCONNECT time stamp: 2016-04-28 16.27.57

BR0813I Schema owner found in database RB1: SAPSR3*

BR0280I BRCONNECT time stamp: 2016-04-28 16.28.03

BR0814I Number of tables/partitions in schema of owner SAPSR3: 27005/648

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

BR0280I BRCONNECT time stamp: 2016-04-28 16.28.08

BR0815I Number of indexes/partitions in schema of owner SAPSR3: 38879/1484

BR0280I BRCONNECT time stamp: 2016-04-28 16.28.10

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

BR1310W Oracle automatic statistics collection job GATHER_STATS_JOB is active - it can conflict with BRCONNECT statistics runs

BR0280I BRCONNECT time stamp: 2016-04-28 16.28.10

BR0807I Name of database instance: RB1

BR0808I BRCONNECT action ID: cetayour

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

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: 2016-04-28 16.28.11

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: 2016-04-28 16.31.35

BR0850I 1262 of 27005 objects processed - 5.375 of 101.372 units done

BR0204I Percentage done: 5.30%, estimated end time: 17:32

BR0001I ***_______________________________________________

BR0280I BRCONNECT thread 3: time stamp: 2016-04-28 16.35.43

BR0850I 1756 of 27005 objects processed - 10.680 of 101.372 units done

BR0204I Percentage done: 10.54%, estimated end time: 17:39

BR0001I *****_____________________________________________

BR0280I BRCONNECT thread 4: time stamp: 2016-04-28 16.41.15

BR0850I 2855 of 27005 objects processed - 15.417 of 101.372 units done

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

BR0001I ********__________________________________________

BR0280I BRCONNECT thread 3: time stamp: 2016-04-28 16.47.02

BR0301E SQL error -20000 in thread 3 at location stats_tab_collect-21, SQL statement:

'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"/BIC/B0000732000"', ESTIMATE_PERCENT => 10, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, GRANULARITY => 'ALL', CASCADE => TRUE, NO_INVALIDATE => FALSE); END;'

ORA-20000: index "SAPSR3"."/BIC/B0000732000KE"  or partition of such index is in unusable state

ORA-06512: at "SYS.DBMS_STATS", line 13437

ORA-06512: at "SYS.DBMS_STATS", line 13457

ORA-06512: at line 1

BR0886E Collecting statistics failed for table SAPSR3./BIC/B0000732000

BR0280I BRCONNECT thread 1: time stamp: 2016-04-28 16.47.35

BR0850I 5604 of 27005 objects processed - 38.381 of 101.372 units done

BR0204I Percentage done: 37.86%, estimated end time: 17:19

BR0001I *******************_______________________________

BR0280I BRCONNECT thread 1: time stamp: 2016-04-28 16.49.15

BR0850I 5755 of 27005 objects processed - 40.596 of 101.372 units done

BR0204I Percentage done: 40.05%, estimated end time: 17:20

BR0001I ********************______________________________

BR0280I BRCONNECT thread 1: time stamp: 2016-04-28 16.52.50

BR0850I 5880 of 27005 objects processed - 46.354 of 101.372 units done

BR0204I Percentage done: 45.73%, estimated end time: 17:22

BR0001I ***********************___________________________

BR0280I BRCONNECT thread 4: time stamp: 2016-04-28 16.56.50

BR0850I 6011 of 27005 objects processed - 50.914 of 101.372 units done

BR0204I Percentage done: 50.23%, estimated end time: 17:25

BR0001I *************************_________________________

BR0280I BRCONNECT thread 4: time stamp: 2016-04-28 16.58.12

BR0850I 6068 of 27005 objects processed - 56.175 of 101.372 units done

BR0204I Percentage done: 55.42%, estimated end time: 17:22

BR0001I ****************************______________________

BR0280I BRCONNECT thread 3: time stamp: 2016-04-28 17.09.49

BR0850I 15834 of 27005 objects processed - 60.922 of 101.372 units done

BR0204I Percentage done: 60.10%, estimated end time: 17:37

BR0001I ******************************____________________

BR0280I BRCONNECT thread 2: time stamp: 2016-04-28 17.09.58

BR0850I 16137 of 27005 objects processed - 93.304 of 101.372 units done

BR0204I Percentage done: 92.04%, estimated end time: 17:13

BR0001I **********************************************____

BR0280I BRCONNECT thread 1: time stamp: 2016-04-28 17.14.01

BR0850I 19426 of 27005 objects processed - 96.353 of 101.372 units done

BR0204I Percentage done: 95.05%, estimated end time: 17:16

BR0001I ************************************************__

BR0280I BRCONNECT thread 1: time stamp: 2016-04-28 17.18.52

BR0850I 27001 of 27005 objects processed - 100.155 of 101.372 units done

BR0204I Percentage done: 98.80%, estimated end time: 17:19

BR0001I *************************************************_

BR0280I BRCONNECT time stamp: 2016-04-28 17.18.52

BR0848I Thread 1 finished with return code 0

BR0280I BRCONNECT thread 2: time stamp: 2016-04-28 17.18.52

BR0850I 27002 of 27005 objects processed - 100.155 of 101.372 units done

BR0204I Percentage done: 98.80%, estimated end time: 17:19

BR0001I *************************************************_

BR0280I BRCONNECT time stamp: 2016-04-28 17.18.52

BR0848I Thread 2 finished with return code 0

BR0280I BRCONNECT thread 4: time stamp: 2016-04-28 17.18.52

BR0850I 27003 of 27005 objects processed - 100.155 of 101.372 units done

BR0204I Percentage done: 98.80%, estimated end time: 17:19

BR0001I *************************************************_

BR0280I BRCONNECT time stamp: 2016-04-28 17.18.52

BR0848I Thread 4 finished with return code 0

BR0280I BRCONNECT thread 3: time stamp: 2016-04-28 17.18.59

BR0850I 27004 of 27005 objects processed - 101.372 of 101.372 units done

BR0204I Percentage done: 100.00%, estimated end time: 17:18

BR0001I **************************************************

BR0280I BRCONNECT time stamp: 2016-04-28 17.18.59

BR0848I Thread 3 finished with return code -1

BR0280I BRCONNECT time stamp: 2016-04-28 17.18.59

BR0879I Statistics checked for 0 tables

BR0878I Number of tables selected to collect statistics after check: 0

BR0880I Statistics collected for 27004/0 tables/indexes

BR0889I Structure validated for 0/38877/0 tables/indexes/clusters

BR1308E Collection of statistics failed for 1/0 tables/indexes

BR0806I End of BRCONNECT processing: cetayour.sta 2016-04-28 17.18.59

BR0280I BRCONNECT time stamp: 2016-04-28 17.19.00

BR0804I BRCONNECT terminated with errors

Former Member
0 Kudos

Hi,

Check if the index exists /BIC/B0000732000KE, if yes try to re-build.

And repeat the steps.

Regards,

Prithviraj.

Sriram2009
Active Contributor
0 Kudos

Hi Anil.

You can refer the SAP Note solution

1042182 - Secondary index is inconsistent for PSA tables

BR

SS

former_member185239
Active Contributor
0 Kudos

Hi Anil,

You have to run the stats for the particular /BIC/B0000732000KE

'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"/BIC/B0000732000"', ESTIMATE_PERCENT => 10, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, GRANULARITY => 'ALL', CASCADE => TRUE, NO_INVALIDATE => FALSE); END;'

ORA-20000: index "SAPSR3"."/BIC/B0000732000KE"  or partition of such index is in unusable state

With Regards

Ashutosh Chaturvedi

anil_singh19
Participant
0 Kudos

hi Sriram,

i have ran the statistics for particular table /BIC/B0000732000 but it showing error for this table error is showing



BR0301E SQL error -20000 in thread 3 at location stats_tab_collect-21, SQL statement:

'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"/BIC/B0000732000"', ESTIMATE_PERCENT => 10, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, GRANULARITY =

ORA-20000: index "SAPSR3"."/BIC/B0000732000KE"  or partition of such index is in unusable state

ORA-06512: at "SYS.DBMS_STATS", line 13437

ORA-06512: at "SYS.DBMS_STATS", line 13457

ORA-06512: at line 1

BR0886E Collecting statistics failed for table SAPSR3./BIC/B0000732000

can u please help me out this

if i rebuilt the index data will delete or not?

anil_singh19
Participant
0 Kudos

hi Ashutosh,

i have ran the statistics for particular table /BIC/B0000732000 but it showing error for this table error is showing



BR0301E SQL error -20000 in thread 3 at location stats_tab_collect-21, SQL statement:

'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"/BIC/B0000732000"', ESTIMATE_PERCENT => 10, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, GRANULARITY =

ORA-20000: index "SAPSR3"."/BIC/B0000732000KE"  or partition of such index is in unusable state

ORA-06512: at "SYS.DBMS_STATS", line 13437

ORA-06512: at "SYS.DBMS_STATS", line 13457

ORA-06512: at line 1

BR0886E Collecting statistics failed for table SAPSR3./BIC/B0000732000

can u please help me out this

if i rebuilt the index data will delete or not?

Former Member
0 Kudos

Hi Anil,

Try to rebuild the index "SAPSR3"."/BIC/B0000732000KE" and check.

Rebuilding an index does have any adverse effect other than system resource being used. No data will be lost during this process.

Regards,

Prithviraj.

anil_singh19
Participant
0 Kudos

hi prithviraj

error is showing

BR0280I BRSPACE time stamp: 2016-05-02 12.00.06

BR1039I Selecting information about tables and indexes...

BR0285I This function can take several seconds/minutes - be patient...

BR0280I BRSPACE time stamp: 2016-05-02 12.00.19

BR0814I Number of tables/partitions in schema of owner SAPSR3: 27005/648

BR0280I BRSPACE time stamp: 2016-05-02 12.00.24

BR0815I Number of indexes/partitions in schema of owner SAPSR3: 38879/1484

BR1107E Table(s) '/BIC/B0000732000KE' not found

BR0182E Checking parameter/option '-t|-table' failed

BR0280I BRSPACE time stamp: 2016-05-02 12.00.24

BR0669I Cannot continue due to previous warnings or errors - you can go back to

repeat the last action

BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

Former Member
0 Kudos

Hi Anil,

From the error reported... abject /BIC/B0000732000KE seems to be index and in brtools it is searching the object as table, is the error.


Go to Db02 in sap systems and search for the segment to see if this is /BIC/B0000732000KE index or table.


and try to rebuild.


Regards,

Prithviraj.

anil_singh19
Participant
0 Kudos

hi prithviraj,

/BIC/B0000732000KE this is index only but this unusable

former_member185239
Active Contributor
0 Kudos

Hi Anil,

You have to rebuild the index and there will be no data loss.

With Regards

Ashutosh Chaturvedi

anil_singh19
Participant
0 Kudos

hi ashutosh,

i have rebuild the index for that table the issue has gone thanq for that.

but again one issue have getting error while export abap

see the log file

D:\usr\sap\RB1\DVEBMGS00\exe\R3load.exe: version R7.20/V1.4 [UNICODE]

Compiled May  7 2010 03:19:51

D:\usr\sap\RB1\DVEBMGS00\exe\R3load.exe -ctf E I:\RB1EXPORT\ABAP\DATA\SAPAPPL0_1.STR I:\RB1EXPORT\ABAP\DB\DDLORA_LRG.TPL SAPAPPL0_1.TSK ORA -l SAPAPPL0_1.log

(RTF) ########## WARNING ###########

  Without ORDER BY PRIMARY KEY the exported data may be unusable for some databases

D:\usr\sap\RB1\DVEBMGS00\exe\R3load.exe: job completed

D:\usr\sap\RB1\DVEBMGS00\exe\R3load.exe: END OF LOG: 20160502160114

D:\usr\sap\RB1\DVEBMGS00\exe\R3load.exe: START OF LOG: 20160502160114

D:\usr\sap\RB1\DVEBMGS00\exe\R3load.exe: sccsid @(#) $Id: //bas/720_REL/src/R3ld/R3load/R3ldmain.c#3 $ SAP

D:\usr\sap\RB1\DVEBMGS00\exe\R3load.exe: version R7.20/V1.4 [UNICODE]

Compiled May  7 2010 03:19:51

D:\usr\sap\RB1\DVEBMGS00\exe\R3load.exe -e SAPAPPL0_1.cmd -datacodepage 4103 -l SAPAPPL0_1.log -stop_on_error

anil_singh19
Participant
0 Kudos

Export Monitor jobs: running 1, waiting 40, completed 0, failed 0, total 41.

Export Monitor jobs: running 2, waiting 39, completed 0, failed 0, total 41.

Export Monitor jobs: running 3, waiting 38, completed 0, failed 0, total 41.

Export Monitor jobs: running 4, waiting 37, completed 0, failed 0, total 41.

Export Monitor jobs: running 5, waiting 36, completed 0, failed 0, total 41.

Export Monitor jobs: running 5, waiting 35, completed 1, failed 0, total 41.

Export Monitor jobs: running 6, waiting 34, completed 1, failed 0, total 41.

Export Monitor jobs: running 6, waiting 33, completed 2, failed 0, total 41.

Unloading of 'DDLOG' export package: OK

Export Monitor jobs: running 5, waiting 33, completed 3, failed 0, total 41.

Export Monitor jobs: running 6, waiting 32, completed 3, failed 0, total 41.

Unloading of 'OCSCMPLOBJ' export package: OK

Export Monitor jobs: running 5, waiting 32, completed 4, failed 0, total 41.

Export Monitor jobs: running 6, waiting 31, completed 4, failed 0, total 41.

Unloading of 'D010TAB' export package: OK

Export Monitor jobs: running 5, waiting 31, completed 5, failed 0, total 41.

Export Monitor jobs: running 6, waiting 30, completed 5, failed 0, total 41.

Unloading of 'SAPAPPL0_1' export package: ERROR

Export Monitor jobs: running 5, waiting 30, completed 5, failed 1, total 41.

Export Monitor jobs: running 6, waiting 29, completed 5, failed 1, total 41.

Unloading of 'SAPAPPL1_1' export package: OK

Export Monitor jobs: running 5, waiting 29, completed 6, failed 1, total 41.

Export Monitor jobs: running 6, waiting 28, completed 6, failed 1, total 41.

Unloading of 'SAPAPPL1_2' export package: OK

Export Monitor jobs: running 5, waiting 28, completed 7, failed 1, total 41.

Unloading of 'SAPAPPL0_2' export package: OK

Export Monitor jobs: running 4, waiting 28, completed 8, failed 1, total 41.

Export Monitor jobs: running 5, waiting 27, completed 8, failed 1, total 41.

Export Monitor jobs: running 6, waiting 26, completed 8, failed 1, total 41.

Unloading of 'SAPAPPL1_4' export package: OK

Export Monitor jobs: running 5, waiting 26, completed 9, failed 1, total 41.

Export Monitor jobs: running 6, waiting 25, completed 9, failed 1, total 41.

Unloading of 'SAPAPPL1_3' export package: OK

Export Monitor jobs: running 5, waiting 25, completed 10, failed 1, total 41.

Unloading of 'SAPAPPL2_2' export package: OK

Export Monitor jobs: running 4, waiting 25, completed 11, failed 1, total 41.

Export Monitor jobs: running 5, waiting 24, completed 11, failed 1, total 41.

Export Monitor jobs: running 6, waiting 23, completed 11, failed 1, total 41.

Unloading of 'SAPCLUST' export package: OK

Export Monitor jobs: running 5, waiting 23, completed 12, failed 1, total 41.

Export Monitor jobs: running 6, waiting 22, completed 12, failed 1, total 41.

Unloading of 'SAPDDIM' export package: OK

Export Monitor jobs: running 5, waiting 22, completed 13, failed 1, total 41.

Export Monitor jobs: running 6, waiting 21, completed 13, failed 1, total 41.

Unloading of 'SAPDFACT_2' export package: OK

Export Monitor jobs: running 5, waiting 21, completed 14, failed 1, total 41.

Export Monitor jobs: running 6, waiting 20, completed 14, failed 1, total 41.

Unloading of 'SAPAPPL2_1' export package: OK

Export Monitor jobs: running 5, waiting 20, completed 15, failed 1, total 41.

Export Monitor jobs: running 6, waiting 19, completed 15, failed 1, total 41.

Unloading of 'SAPDFACT_1' export package: OK

Export Monitor jobs: running 5, waiting 19, completed 16, failed 1, total 41.

Export Monitor jobs: running 6, waiting 18, completed 16, failed 1, total 41.

Unloading of 'SAPDODS_1' export package: OK

Export Monitor jobs: running 5, waiting 18, completed 17, failed 1, total 41.

Export Monitor jobs: running 6, waiting 17, completed 17, failed 1, total 41.

Unloading of 'SAPDODS_2' export package: OK

Export Monitor jobs: running 5, waiting 17, completed 18, failed 1, total 41.

Export Monitor jobs: running 6, waiting 16, completed 18, failed 1, total 41.

Unloading of 'SAPDODS_4' export package: OK

Export Monitor jobs: running 5, waiting 16, completed 19, failed 1, total 41.

Export Monitor jobs: running 6, waiting 15, completed 19, failed 1, total 41.

Unloading of 'SAPDODS_3' export package: OK

Export Monitor jobs: running 5, waiting 15, completed 20, failed 1, total 41.

Unloading of 'SAPAPPL0_3' export package: OK

Export Monitor jobs: running 4, waiting 15, completed 21, failed 1, total 41.

Unloading of 'SAPPOOL' export package: OK

Export Monitor jobs: running 3, waiting 15, completed 22, failed 1, total 41.

Export Monitor jobs: running 4, waiting 14, completed 22, failed 1, total 41.

Export Monitor jobs: running 5, waiting 13, completed 22, failed 1, total 41.

Export Monitor jobs: running 6, waiting 12, completed 22, failed 1, total 41.

Unloading of 'SAPSDOCU' export package: OK

Export Monitor jobs: running 5, waiting 12, completed 23, failed 1, total 41.

Export Monitor jobs: running 6, waiting 11, completed 23, failed 1, total 41.

Unloading of 'SAPSLOAD' export package: OK

Export Monitor jobs: running 5, waiting 11, completed 24, failed 1, total 41.

Export Monitor jobs: running 6, waiting 10, completed 24, failed 1, total 41.

Unloading of 'SAPSDIC' export package: OK

Export Monitor jobs: running 5, waiting 10, completed 25, failed 1, total 41.

Unloading of 'SAPSPROT' export package: OK

Export Monitor jobs: running 4, waiting 10, completed 26, failed 1, total 41.

Export Monitor jobs: running 5, waiting 9, completed 26, failed 1, total 41.

Export Monitor jobs: running 6, waiting 8, completed 26, failed 1, total 41.

Unloading of 'SAPNTAB' export package: OK

Export Monitor jobs: running 5, waiting 8, completed 27, failed 1, total 41.

Export Monitor jobs: running 6, waiting 7, completed 27, failed 1, total 41.

Unloading of 'SAPSSEXC_3' export package: OK

Export Monitor jobs: running 5, waiting 7, completed 28, failed 1, total 41.

Export Monitor jobs: running 6, waiting 6, completed 28, failed 1, total 41.

Unloading of 'SAPSSEXC_1' export package: OK

Export Monitor jobs: running 5, waiting 6, completed 29, failed 1, total 41.

Export Monitor jobs: running 6, waiting 5, completed 29, failed 1, total 41.

Unloading of 'SAPUSER' export package: OK

Export Monitor jobs: running 5, waiting 5, completed 30, failed 1, total 41.

Unloading of 'SAPSSRC' export package: OK

Export Monitor jobs: running 4, waiting 5, completed 31, failed 1, total 41.

Unloading of 'SAPSLEXC' export package: OK

Export Monitor jobs: running 3, waiting 5, completed 32, failed 1, total 41.

Export Monitor jobs: running 4, waiting 4, completed 32, failed 1, total 41.

Export Monitor jobs: running 5, waiting 3, completed 32, failed 1, total 41.

Export Monitor jobs: running 6, waiting 2, completed 32, failed 1, total 41.

Unloading of '_BIC_B0000890000' export package: OK

Export Monitor jobs: running 5, waiting 2, completed 33, failed 1, total 41.

Unloading of '_BIC_B0000611000' export package: OK

Export Monitor jobs: running 4, waiting 2, completed 34, failed 1, total 41.

Export Monitor jobs: running 5, waiting 1, completed 34, failed 1, total 41.

Export Monitor jobs: running 6, waiting 0, completed 34, failed 1, total 41.

Unloading of '_BIC_B0000716000' export package: OK

Export Monitor jobs: running 5, waiting 0, completed 35, failed 1, total 41.

Unloading of '_BIC_B0001084000' export package: OK

Export Monitor jobs: running 4, waiting 0, completed 36, failed 1, total 41.

Unloading of '_BIC_B0001018000' export package: OK

Export Monitor jobs: running 3, waiting 0, completed 37, failed 1, total 41.

Unloading of 'SAPSSEXC_2' export package: OK

Export Monitor jobs: running 2, waiting 0, completed 38, failed 1, total 41.

Unloading of 'REPOSRC' export package: OK

Export Monitor jobs: running 1, waiting 0, completed 39, failed 1, total 41.

Unloading of 'DYNPSOURCE' export package: OK

Export Monitor jobs: running 0, waiting 0, completed 40, failed 1, total 41.

TRACE      2016-05-02 16:33:13.653

Function setMessageIdOfExceptionMessage: nw.programError

ERROR      2016-05-02 16:33:13.653

           CJSlibModule::writeError_impl()

CJS-30022  Program 'Migration Monitor' exits with error code 103. For details see log file(s) export_monitor.java.log, export_monitor.log.

Answers (1)

Answers (1)

Sriram2009
Active Contributor
0 Kudos

Hi Anil.

On your source system having free disk space? could you share the brconnect.log as mention in the screenshot?

BR

SS

anil_singh19
Participant
0 Kudos

BR0801I BRCONNECT 7.20 (1)

BR0805I Start of BRCONNECT processing: cetbdcee.sta 2016-04-29 14.30.12

BR0484I BRCONNECT log file: E:\oracle\sid\sapcheck\cetbdcee.sta

BR0101I Parameters

Name                           Value

oracle_sid                     sid

oracle_home                    E:\oracle\sid\102

oracle_profile                 E:\oracle\sid\102\database\initsid.ora

sapdata_home                   E:\oracle\sid

sap_profile                    E:\oracle\sid\102\database\initsid.sap

system_info                    sidadm ROHABI Windows 5.2 Build 3790 Service Pack 2 AMD64

oracle_info                    sid 10.2.0.4.0 8192 20856 371727212 ROHABI UTF8 UTF8 4232686873

sap_info                       702 SAPSR3 0002LK0003sid0011K14433953010015Maintenance_ORA

make_info                      NTAMD64 OCI_10201_SHARE Mar 10 2010

command_line                   D:\usr\sap\sid\SYS\exe\uc\NTAMD64\brconnect.exe -p initsid.sap -l E -U -f stats -t all -p 1

stats_table                    ALL

stats_dbms_stats               ALL:R:0

stats_change_threshold         50

stats_parallel_degree          1

stats_dict_cycle               0

stats_system_cycle             0

BR0280I BRCONNECT time stamp: 2016-04-29 14.30.16

BR0813I Schema owner found in database sid: SAPSR3*

BR0280I BRCONNECT time stamp: 2016-04-29 14.30.17

BR0814I Number of tables/partitions in schema of owner SAPSR3: 27005/648

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

BR0280I BRCONNECT time stamp: 2016-04-29 14.30.20

BR0815I Number of indexes/partitions in schema of owner SAPSR3: 38879/1484

BR0280I BRCONNECT time stamp: 2016-04-29 14.30.21

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

BR1310W Oracle automatic statistics collection job GATHER_STATS_JOB is active - it can conflict with BRCONNECT statistics runs

BR0280I BRCONNECT time stamp: 2016-04-29 14.30.21

BR0807I Name of database instance: sid

BR0808I BRCONNECT action ID: cetbdcee

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

BR0280I BRCONNECT time stamp: 2016-04-29 14.30.21

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRCONNECT:

BR0280I BRCONNECT time stamp: 2016-04-29 14.30.24

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRCONNECT time stamp: 2016-04-29 14.30.25

BR0817I Number of monitored/modified tables in schema of owner SAPSR3: 27005/38

BR0280I BRCONNECT time stamp: 2016-04-29 14.30.26

BR0877I Checking and collecting table and index statistics...

BR0280I BRCONNECT time stamp: 2016-04-29 14.30.26

BR0879I Statistics checked for 27005 tables

BR0878I Number of tables selected to collect statistics after check: 0

BR0880I Statistics collected for 0/0 tables/indexes

BR0806I End of BRCONNECT processing: cetbdcee.sta 2016-04-29 14.30.26

BR0280I BRCONNECT time stamp: 2016-04-29 14.30.27

BR0803I BRCONNECT completed successfully with warnings

former_member185239
Active Contributor
0 Kudos

Hi Anil,

Can you paste the latest 4 logs from the sapinst directory.

With Regards

Ashutosh Chaturvedi

anil_singh19
Participant
0 Kudos

hi ashutosh

please tell me what are the files

anil_singh19
Participant
0 Kudos

Hi sriram please find the log

BR0801I BRCONNECT 7.20 (1)

BR0805I Start of BRCONNECT processing: cetayour.sta 2016-04-28 16.27.53

BR0484I BRCONNECT log file: E:\oracle\RB1\sapcheck\cetayour.sta

BR0280I BRCONNECT time stamp: 2016-04-28 16.27.57

BR0813I Schema owner found in database RB1: SAPSR3*

BR0280I BRCONNECT time stamp: 2016-04-28 16.28.03

BR0814I Number of tables/partitions in schema of owner SAPSR3: 27005/648

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

BR0280I BRCONNECT time stamp: 2016-04-28 16.28.08

BR0815I Number of indexes/partitions in schema of owner SAPSR3: 38879/1484

BR0280I BRCONNECT time stamp: 2016-04-28 16.28.10

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

BR1310W Oracle automatic statistics collection job GATHER_STATS_JOB is active - it can conflict with BRCONNECT statistics runs

BR0280I BRCONNECT time stamp: 2016-04-28 16.28.10

BR0807I Name of database instance: RB1

BR0808I BRCONNECT action ID: cetayour

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

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: 2016-04-28 16.28.11

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: 2016-04-28 16.31.35

BR0850I 1262 of 27005 objects processed - 5.375 of 101.372 units done

BR0204I Percentage done: 5.30%, estimated end time: 17:32

BR0001I ***_______________________________________________

BR0280I BRCONNECT thread 3: time stamp: 2016-04-28 16.35.43

BR0850I 1756 of 27005 objects processed - 10.680 of 101.372 units done

BR0204I Percentage done: 10.54%, estimated end time: 17:39

BR0001I *****_____________________________________________

BR0280I BRCONNECT thread 4: time stamp: 2016-04-28 16.41.15

BR0850I 2855 of 27005 objects processed - 15.417 of 101.372 units done

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

BR0001I ********__________________________________________

BR0280I BRCONNECT thread 3: time stamp: 2016-04-28 16.47.02

BR0301E SQL error -20000 in thread 3 at location stats_tab_collect-21, SQL statement:

'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"SAPSR3"', TABNAME => '"/BIC/B0000732000"', ESTIMATE_PERCENT => 10, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, GRANULARITY => 'ALL', CASCADE => TRUE, NO_INVALIDATE => FALSE); END;'

ORA-20000: index "SAPSR3"."/BIC/B0000732000KE"  or partition of such index is in unusable state

ORA-06512: at "SYS.DBMS_STATS", line 13437

ORA-06512: at "SYS.DBMS_STATS", line 13457

ORA-06512: at line 1

BR0886E Collecting statistics failed for table SAPSR3./BIC/B0000732000

BR0280I BRCONNECT thread 1: time stamp: 2016-04-28 16.47.35

BR0850I 5604 of 27005 objects processed - 38.381 of 101.372 units done

BR0204I Percentage done: 37.86%, estimated end time: 17:19

BR0001I *******************_______________________________

BR0280I BRCONNECT thread 1: time stamp: 2016-04-28 16.49.15

BR0850I 5755 of 27005 objects processed - 40.596 of 101.372 units done

BR0204I Percentage done: 40.05%, estimated end time: 17:20

BR0001I ********************______________________________

BR0280I BRCONNECT thread 1: time stamp: 2016-04-28 16.52.50

BR0850I 5880 of 27005 objects processed - 46.354 of 101.372 units done

BR0204I Percentage done: 45.73%, estimated end time: 17:22

BR0001I ***********************___________________________

BR0280I BRCONNECT thread 4: time stamp: 2016-04-28 16.56.50

BR0850I 6011 of 27005 objects processed - 50.914 of 101.372 units done

BR0204I Percentage done: 50.23%, estimated end time: 17:25

BR0001I *************************_________________________

BR0280I BRCONNECT thread 4: time stamp: 2016-04-28 16.58.12

BR0850I 6068 of 27005 objects processed - 56.175 of 101.372 units done

BR0204I Percentage done: 55.42%, estimated end time: 17:22

BR0001I ****************************______________________

BR0280I BRCONNECT thread 3: time stamp: 2016-04-28 17.09.49

BR0850I 15834 of 27005 objects processed - 60.922 of 101.372 units done

BR0204I Percentage done: 60.10%, estimated end time: 17:37

BR0001I ******************************____________________

BR0280I BRCONNECT thread 2: time stamp: 2016-04-28 17.09.58

BR0850I 16137 of 27005 objects processed - 93.304 of 101.372 units done

BR0204I Percentage done: 92.04%, estimated end time: 17:13

BR0001I **********************************************____

BR0280I BRCONNECT thread 1: time stamp: 2016-04-28 17.14.01

BR0850I 19426 of 27005 objects processed - 96.353 of 101.372 units done

BR0204I Percentage done: 95.05%, estimated end time: 17:16

BR0001I ************************************************__

BR0280I BRCONNECT thread 1: time stamp: 2016-04-28 17.18.52

BR0850I 27001 of 27005 objects processed - 100.155 of 101.372 units done

BR0204I Percentage done: 98.80%, estimated end time: 17:19

BR0001I *************************************************_

BR0280I BRCONNECT time stamp: 2016-04-28 17.18.52

BR0848I Thread 1 finished with return code 0

BR0280I BRCONNECT thread 2: time stamp: 2016-04-28 17.18.52

BR0850I 27002 of 27005 objects processed - 100.155 of 101.372 units done

BR0204I Percentage done: 98.80%, estimated end time: 17:19

BR0001I *************************************************_

BR0280I BRCONNECT time stamp: 2016-04-28 17.18.52

BR0848I Thread 2 finished with return code 0

BR0280I BRCONNECT thread 4: time stamp: 2016-04-28 17.18.52

BR0850I 27003 of 27005 objects processed - 100.155 of 101.372 units done

BR0204I Percentage done: 98.80%, estimated end time: 17:19

BR0001I *************************************************_

BR0280I BRCONNECT time stamp: 2016-04-28 17.18.52

BR0848I Thread 4 finished with return code 0

BR0280I BRCONNECT thread 3: time stamp: 2016-04-28 17.18.59

BR0850I 27004 of 27005 objects processed - 101.372 of 101.372 units done

BR0204I Percentage done: 100.00%, estimated end time: 17:18

BR0001I **************************************************

BR0280I BRCONNECT time stamp: 2016-04-28 17.18.59

BR0848I Thread 3 finished with return code -1

BR0280I BRCONNECT time stamp: 2016-04-28 17.18.59

BR0879I Statistics checked for 0 tables

BR0878I Number of tables selected to collect statistics after check: 0

BR0880I Statistics collected for 27004/0 tables/indexes

BR0889I Structure validated for 0/38877/0 tables/indexes/clusters

BR1308E Collection of statistics failed for 1/0 tables/indexes

BR0806I End of BRCONNECT processing: cetayour.sta 2016-04-28 17.18.59

BR0280I BRCONNECT time stamp: 2016-04-28 17.19.00

BR0804I BRCONNECT terminated with errors