autobcpdp ended with ERROR ORA-39126

Document ID : KB000004599
Last Modified Date : 14/02/2018
Show Technical Document Details

When running autobcpORAdp perl script to synchronize Autosys databases, I am getting below errors: 

ORA-39126: Worker unexpected fatal error in KUPW$WORKER.STATS_LOAD [TABLE_STATISTICS] MARKER 

ORA-30926: unable to get a stable set of rows in the source tables 

Job "AEDBADMIN"."SYS_IMPORT_SCHEMA_05" stopped due to fatal error 

autobcpORAdp: Impdp - Import of table information failed. 

autobcpORAdp: Cannot proceed.

CA WAAE 11.3.6 on Unix/Linux Oracle databaseApplicable Releases-------------------CA WAAE r11.3.5 CA WAAE r11.3.6

The ExpDp command that is used in the script does not exclude statistics.                                                                  


Workaround is to  exclude these tables from the script

1) Open file $AUTOSYS/dbobj/ORA/

2) Locate "exclude=" in the perl script and add literal "statistics" at the end of this exclude list


For example:



Additional Information:

This change will be implemented in next service pack ( CA WAAE 11.3.6 SP6 )