We are getting the following error when trying to migrate any sql and pkb object type:
An error occurred in migrating OA objects.
This issue was resolved after the stat oracle agents was bounced. Here something to keep in mind. Although the Tools | Stat Oracle agent status might show that the stat oa is up and running, but it would not function properly until you restart your stat oa. The reason for this is if the Oracle Ebiz database goes down while Oracle Agent is running, the connection we are using becomes stale, and since we don't flush our connections, Stat Oracle Agent needs to be restarted. (This is something we will fix in 5.6.1).