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

Question

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?

User_Z2WA4 · Answer

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.

Luis Ramos · Answer

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

Mallikarjuna Kuppauru-Oracle · Answer

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