Oracle Analytics Publisher

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

Categories

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

Oracle BI Publisher Notification for Job History email content is having incorrect URL

Received Response
21
Views
3
Comments
Luis Ramos
Luis Ramos Rank 1 - Community Starter
in Oracle Analytics Publisher

We moved the platform on-prem from 12.2.1.4 to OAS 2023 and performed the xmlp migration script "/bip_12c_scheduler_migration.sql" .

The small problem is that the content of the job execution result email , the url is of the old 12.2.1.4 and not of the OAS.

Job Name : Population Job
Job Executed Date : August 7, 2024 9:08:14 AM EDT
Status : Job was successfully processed.

View History :

https://servername:9804/analytics/saw.dll?bipublisherEntry&Action=historyDetails&itemType=.xdo&bipParams=%7B%22jobid%22%3A%223342%22%7D

instead of https://servername:9804/analytics/saw.dll? it should be https://servername:9603/analytics/saw.dll?

Any ideas?

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist
    edited Aug 7, 2024 5:17PM

    Hi @Luis Ramos

    I don't think issue with your migration script . Is your 12c environment is up and running? If yes please stop the services and then see are you able to see the success history from BIP OAS server.

    The bip_12c_scheduler_migration.sql script requires the user ID, the password, and the connection string for Oracle Business Intelligence BIPLATFROM schema. The script creates a database link called BIP12c_DBLINK and imports all schedule objects using that link. You must have Database Administrator privileges to run the script

    Refer - Migrating Scheduler Jobs and Job History

    https://docs-uat.us.oracle.com/en/middleware/bi/analytics-server/migrate-upgrade-oas/migration-steps-oracle-bi-ee.html#GUID-CCC0A118-0AE4-47AE-89E0-473B5DAB6572

    Regards,

    Arjun

  • Luis Ramos
    Luis Ramos Rank 1 - Community Starter

    Thanks

    Question is:

    Why the email coming from the new environment has the url from the old environment.

    If I navigate to the wrong url page open with an error message

    If I change the url to new url the page opens as expected

  • User_Z2WA4
    User_Z2WA4 Rank 1 - Community Starter

    I'd like to know how to change it as well. After migrating the BIP Jobs from 12c to OAS, the Jobs run, but the Notification emails have incorrect server link in the "View History" section - the incorrect server link directs to the 12c environment.
    Newly scheduled jobs have correct link. It looks like the jobs transfer takes the History link with along.
    In the XMLP_SCHED_DELIVERY table, column DELIVERY_PARAMETERS (Blob) there are a lot of parameters visible, one of them "schurl", which has the 12c server name.