autobcpdp ended with ERROR ORA-39126

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

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.

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

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

Resolution:

Workaround is to  exclude these tables from the script

1) Open file $AUTOSYS/dbobj/ORA/autobcpORAdp.pl

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

 

For example:

..exclude=view,package,procedure,db_link,user,statistics

 

Additional Information:

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