search cancel

autobcpdp ended with ERROR ORA-39126

book

Article ID: 4599

calendar_today

Updated On:

Products

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

Issue/Introduction

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 )