Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Does any one know how to bring the obiee12c scheduled jobs from ACS to OAS?

Received Response
56
Views
9
Comments
User_27DEY
User_27DEY Rank 6 - Analytics Lead
edited Aug 13, 2024 7:30PM in Oracle Analytics Cloud and Server

Does any one know how to migrate the obiee12c scheduled jobs from ACS to OAS? we have a lot of jobs in ACS, now we need to migrate to OAS. thanks a lot!!

Answers

  • SteveF-Oracle
    SteveF-Oracle Mod
    edited Jul 22, 2024 7:11PM

    I believe you are referring to Publisher scheduled jobs (although it is not all that clear from the post). The acronym "ACS" is not defined in your post.

    If you are referring to Publisher, see:

    If you are referring to something else, then please clarify your post.

    Also, please update your profile name, so we know with whom we are communicating.

  • User_27DEY
    User_27DEY Rank 6 - Analytics Lead

    Thanks a lot!! Yes, we just migrated OBIEE 12.2.4 suite from ACS to OAS, both in OCI, during the migration, all the schedule jobs (belong to individual users, not just Publisher job) were disabled, do u know if there is any way we can enable them back instead of asking each user to enable them from the application (enable under my folder) since there are so many of them. please let me know if it is still clear, thanks again!

  • SteveF-Oracle
    SteveF-Oracle Mod

    Hi @User_27DEY

    You must enable them after an out-of-place migration

    After Migrating A Snapshot To Oracle Analytics, The Agents Are Disabled (Doc ID 2627357.1)

    Restore and Enable Delivery Schedules

    I will make sure this is added to the post-migration steps

  • User_27DEY
    User_27DEY Rank 6 - Analytics Lead

    Thanks! we tried that option, but it still requires individual users to enable on their own since the agent is under "My Folder" which the user herself/himself has access to.

  • Gianni Ceresa
    Gianni Ceresa Mod
    edited Jul 23, 2024 3:50PM

    I did click on that restore option not long ago during a 12c to OAS migration. While it didn't work for a number of reasons (corrupted catalog etc.), a number of the 600 agents in the catalog have been successfully enabled, including those that were in private folders.

    There are other ways to do the job, but aren't officially supported and require to do things in a very precise way (copying the scheduler tables content over, but must be done before the tool has the chance to update the JobID of the various agents because otherwise it's gone and nothing can be done).

  • User_27DEY
    User_27DEY Rank 6 - Analytics Lead

    Thanks! the catalog is fine, but there are lot of agents might be that is why it does not work.

    what the tables are needed to copy? do we have any constrain? thanks again!

  • Gianni Ceresa
    Gianni Ceresa Mod

    When you did the process (the official one posted by Steve), did it take a long time? Did it return you a success message? Did you do it from an administrative account?

    If you want the "not officially supported" way (sorry to stress this point, but you should know what you get yourself into), the process can be seen as this. Import the BAR with the catalog in OAS and shutdown OAS fully (don't do anything else). Copy the content of the S_NQ_JOB, S_NQ_JOB_PARAM, S_NQ_INSTANCE and S_NQ_ERR_MSG tables from your OBIEE12c to your OAS BIPLATFORM schema. Cross your fingers and restart OAS.

    It can work (it did for me), it can fail… If you know the details of how agents are defined in OBIEE/OAS you can see why it's not an officially supported method, and why it could fail for a number of reasons.

  • SteveF-Oracle
    SteveF-Oracle Mod

    Thanks! we tried that option, but it still requires individual users to enable on their own since the agent is under "My Folder" which the user herself/himself has access to.

    As mentioned, did you perform it as a user with BIServiceAdministration role?

    Did you test enabling a few at a time?

    I would attempt to utilize the supported method first (as you did), but the administrator should be able to enable these. We are unable to see your screen or steps precisely unless you share.

    We are also unable to view your logs.

    In the past, there have been some issues; wherein, a timeout needs to be increased when enabling a large number of agents. The error needs to be matched in the logs for the solution to be applicable.

    After Upgrade, Restoring Deliveries Fails With 'An error occurred whilst attempting to restore scheduled deliveries ECID:XXXX' (Doc ID 2946154.1)

    If you are unable to resolve it with the solutions provided here, then a service request may be in order to obtain logs, steps, precise details.

  • User_27DEY
    User_27DEY Rank 6 - Analytics Lead

    Thanks

    Yes, we login as the built-in admin. but only did once, and it does not work, so we gave up and asked the users to enable themselves which seems a nightmare. thanks again, if it still does not work, i will paste the errors, thanks

    again!