Oracle Communities

Oracle Analytics and AI

Child Item

OBIEE 12214 to OAS6.4 Migration Error

Background:

We are upgrading our Safety System ( Oracle Argus Safety System from version 8.2.3.1 to 8.4.2). Analytics application connected to Argus Safety System 8.2.3.1 is OBIEE 12.2.1.3. Argus Safety 8.4.2 system supports only OAS 6.4 hence we have to upgrade and migrate OBIEE 12.2.1.3 to OAS 6.4.

Approach:

1. New OAS Instance of OAS: New Instance of OAS 6.4 was created in a separate server

2. In Place Upgrade of 12.2.1.3 to 12.2.1.4 following guidance in the following article

3. Out of Place Migration from 12.2.1.4 to OAS 6.4, When attempting this received error. Following article was followed

Issue:

When running ./exportarchive.sh ssi /opt/oracle/backup_dir/exportedarchive.sh give following error in log files

2024-05-18T08:19:43.882+02:00] [bi] [WARNING] [] [oracle.bi.web.datasetsvc] [tid: 10] [ecid: 0000OyAMkL73BDYVLqINOA1aI4Xn000002,0] Could not create config from property file[[

java.io.FileNotFoundException: /opt/oracle/middleware/user_projects/domains/bi/config/fmwconfig/biconfig/DSS/DatasetsvcConfig.properties (No such file or directory)

Logs: refer export_obiee_issue.zip , this folder contains following logs

1. ActionStoragePlugin.log

2. dss_storage_plugin.log

3.metadatalcm_op_run.log

4.webcat_content_plugin.0.0.log

5.webcat_storage_plugin.0.0.log

Screen Shot:

ExportArchive.jpg https://docs.oracle.com/middleware/bi12214/lcm/OBIUP/GUID-93B3A0DC-7546-4ABB-946E-593B3AAE444D.htm#OBIUP-GUID-93B3A0DC-7546-4ABB-946E-593B3AAE444D https://docs.oracle.com/en/middleware/bi/analytics-server/migrate-upgrade-oas/migrating-oracle-business-intelligence-12c-or-previous-release-oracle-analytics-server.html#GUID-526D3344-6CE6-448B-8DC4-7D5CB2F40FE4

dss_storage_plugin.log

ExportArchive.jpg

Find more posts tagged with

Upgrades

Accepted answers

All comments

Mallikarjuna Kuppauru-Oracle

Hi @User_ZBIH6

No specific Errors are recorded. Can you check below and see are you able to see any bad entries from OPSS schema table.

OBIEE 12c: Import / Export BAR File Fails With "Failed in migrateing policy store from stripe obi to file ... jazn-data.xml" (Doc ID 2518232.1)

Regards,

Arjun

User_ZBIH6

Hi @Mallikarjuna Kuppauru-Oracle , Thanks again for the response, I checked the article, No bad entries found.

no-bad-entry.jpg

Mallikarjuna Kuppauru-Oracle

Hi @User_ZBIH6 /

Can you try to restart the Services and see are you able to see any progress ? Including DB.

Attach the logs still if you see the Errors?

Regards,

Arjun

User_ZBIH6

Hi @Mallikarjuna Kuppauru-Oracle , Thanks again. I have restarted db then application using stop.sh and start.sh.

Export failed again with the same error.

Executed of operation preExportArchive FAILED for offlineJaznContentPlugin Status object: false

Attached following logs

metadatalcm_op_run.log

OfflineJaznContentPlugin.log

User_ZBIH6

Hi @Mallikarjuna Kuppauru-Oracle , Thanks again. I have rebooted the db and restarted weblogic using stop.sh and start.sh

Export failed again with same error :

Executed of operation preExportArchive FAILED for offlineJaznContentPlugin Status object: false.

Attached log files for the same.

metadatalcm_op_run.log

OfflineJaznContentPlugin.log

Prabhuram-Oracle

@User_ZBIH6 As discussed on SR 3-36803626391 you are having standalone BIP and from there you wants to take export catalog. See if this can help you: https://docs.oracle.com/cd/E23943_01/bi.1111/e22255/moving_objs.htm#BIPAD383