Categories
Reports Job Not working after migration
Hi All,
Plan Upgrade Version: 7.6
Previous Version: 5.5
Product: Oracle Analytic Server BI Publisher
Migrating from Oracle Business Intelligence 12c or the Previous Release of Oracle Analytics Server
Recently i review and follow the document to perform migration and upgrade.
Target to use back the production data as a stimulation on this testing server.
1. Setup New Binary (FMW12.2.1.4) + (OAS5.5) + Patch
2. Create RCU
3. Create Domain using Config Assistant
4. Then Follow migrate configuration, user roles to follow back the production server setup.
5. And want migrate scheduler job report follow below document using script, but network segment different unable to use the dblink. so i choose to use expdp and impdp method to migrate the schema table mention in the script.
Post-Migration Tasks for Oracle Analytics Publisher
6. Migration successful
7. go in /xmlpserver download catalog folder 1by1 and upload back same path to the new target server.
8. Start Back Server
9. The Process all smooth but here the problem. The scheduler job is on time running, but stuck there, example 10am running, it really run but after that no any update until few hour in same status, and causing more and more job in waiting status.
Noted: I want to make sure migrate production data able work on OAS 5.5 version then only upgrade to OAS7.6 version. But after migrate the scheduler job is not running as production. Is it download/upload catalog folder will causing the scheduler job path not tally? or any step i miss up do wrong?
Hope someone can help solve the issue.
Thanks.
Best Answer
-
After migrating to a new Oracle Analytics Server (OAS) environment, you must also migrate the scheduler jobs and job history data from the Oracle Business Intelligence BIPLATFORM schema to the new BIPLATFORM schema.
To do this:
- Connect to the BIPLATFORM schema using SQL*Plus or any other database tool.
- Run the
bip_12c_scheduler_migration.sqlscript to complete the migration process.
Reference :
2
Answers
-
Hi, due to network segment different , im not able to use dblink and run script, Method have to use which is export and import method to migrate the scheduler job anda job history data to the new target schema server. It migrateable and i able to view the scheduler job and history data, but somehow when it running, it will hang very long and look like no process at all. example 3am auto run scheduler job but until morning 10am also no finish. Not only 1 report happen , there multiple of job report happen hang there.
0 -
Very helpful information.
Thanks for sharing @Sumanth V -Oracle!
0
