It's took about 20-30 minutes migrating a single aol menu. Below is the error from the migration.log:
SYK_DEPOT_REPAIR_SUPERUSER::SYK_DEPOT_REPAIR_SUPERUSER-US
227 4159 7/11/2011 15:35:49 -2 [EBS.121..Error] - An error occurred in migrating OA objects.
227 4160 7/11/2011 15:35:49 0 Migration [227] completed with 1 Errors, 0 Warnings.
Using the same FNDLOAD command outside of Stat took about the same amount of time. When looking at the stat oa log, it seems that even though FNDLOAD ran successfully, it took a long time for it to come back with a status code, and so the Stat Agent timed out waiting for the Oracle agent. You can try to increase the 'OA Agent Wait Multiplier' by doing the following steps:
1. Go to Maintenance | General | System Maintenance | Parameters tab
2. The default OA Agent Wait Multiplier is set to 1, which means we wait for 20 seconds per object and so on.
NOTE: Depending on how big the object is, you can try to increase the value. If you are going to change the 'OA Agent Wait Multiplier' then make sure to bounce the stat central agent and stat oa. Increasing the value for the 'OA Agent Wait Multiplier' might cause the csr to stay in read-only for a long time if not all your stat oa are up and running.
