on 04-29-2016 8:24 AM
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
Hi Anil,
Kindly paste the brconnect log file.
With Regards
Ashutosh Chaturvedi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
Hi Anil.
You can refer the SAP Note solution
1042182 - Secondary index is inconsistent for PSA tables
BR
SS
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
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?
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?
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:
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
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.
Hi Anil.
On your source system having free disk space? could you share the brconnect.log as mention in the screenshot?
BR
SS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.