autobcpdp ended with ERROR ORA-39126
search cancel

autobcpdp ended with ERROR ORA-39126


Article ID: 4599


Updated On:


CA Workload Automation AE - Business Agents (AutoSys) CA Workload Automation AE - Scheduler (AutoSys) Workload Automation Agent


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 )