Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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
Answers
-
@User_ZBIH6 - Please share the metadatalcm_history.log from the below path:
DOMAIN_HOME/bi/bilogs/metadata
The one highlighted from dss_storage_plugin.log is more of an warning and not an error. We need to identify which plugin might be failing first for which we need the log I mentioned above. Thanks.0 -
Hi @Sumanth V -Oracle , Thanks for checking the query, I have added all log files from DOMAIN_HOME/bi/bilogs/metadata
0 -
@User_ZBIH6 - The error seems to be this:
[2024-05-18T08:19:43.885+02:00] [bi] [ERROR] [] [oracle.bi.web.datasetsvc] [tid: 10] [ecid: 0000OyAMkL73BDYVLqINOA1aI4Xn000002,0] Cannot find data source jdbc/BIPlatformDatasource specified by oracle.bi.dss.datasourcename.metadata
But it is looking for the details in DatasetsvcConfig.properties. Please check if the file exists if not, place the attached file in the below location and retry export command and let us know the feedback./opt/oracle/middleware/user_projects/domains/bi/config/fmwconfig/biconfig/DSS/
0 -
Thank you. I placed the file /opt/oracle/middleware/user_projects/domains/bi/config/fmwconfig/biconfig/DSS/DatasetsvcConfig.properties and ran the export.
I received following error upon running the export (attached dss_storage_plugin.log).
Error streaming archive for service[[
java.sql.SQLException: No details returned for stripe ssiI checked BI_BIPLATFORM.S_NQ_DSS_SERVICE_STRIPES table and I see only one row , attached the screen shot of the same(missing_ssi_info.jpg).
0 -
Hi @User_ZBIH6
As per uploaded screenshot , S_NQ_DSS_SERVICE_STRIPES table should have 2 Entries.
It should have two records in it:
STRIPE_ID, "100" STRIPE_NAME, "DEFAULT" ...
and
STRIPE_ID, "101" STRIPE_NAME, "SSI" ...
Insert manually another record to fix the issue.
Regards,
Arjun
1 -
Thanks @Mallikarjuna Kuppauru-Oracle,
I did entered the value and triggered dss_storage_plugin export was successful however it failed in another point(i.e., OfflineJaznContentPlugin)
I tried to find the error message in all log files. though metadatalcm_op_run.log state OfflineJaznContentPlugin.log. states the failure but it did not show the reason for failure.
Attached
OfflineJaznContentPlugin.log.
0 -
Hi @User_ZBIH6
Can you try below and let me know the result?
Check customization_order.xml exists and the contents
$DOMAN_HOME/bidata/service_instances/ssi/metadata/datamodel/customizations/customization_order.xml
$DOMAIN_HOME/tmp/ssi/datamodel/customizations/customization_order.xml
If they exist, do the following:
1. Make a back up and delete the filesRe-run the process and let me know the result?
Regards,
Arjun
1 -
Hi @Mallikarjuna Kuppauru-Oracle , Thanks again.
customization_order.xml file is not exist.
1, This directory exists $DOMAN_HOME/bidata/service_instances/ssi/metadata/datamodel/customizations/ but customization_order.xml file does not exist.
2. This directory does not exist $DOMAIN_HOME/tmp/ssi/datamodel/customizations/
I have attached jazn-data.xml file from
$DOMAIN_HOME/bidata/service_instances/ssi/metadata/authmodel/jazn
Not sure something in this config file is causing export error.
0 -
@User_ZBIH6 - Please let us know which error or warning makes you think issue is with jazn-data.xml. Also, did the in place upgrade from 12.2.1.3 to 12.2.1.4 go smoothly or were there issues. Thanks.
1 -
@Sumanth V -Oracle , Thanks for the response.
12.2.1.3 to 12.2.14 upgrade went smoothly without any issue, Application is running in 12.2.1.4 version.
With respect to the errors related to jazn-data.xml,
- Please find the following error which shows failure of export due to JAZN.
- I checked in all export logs , I couldn't find any specific errors associated with the failure.
- metadatalcm_op_run.log shows the JAZN plugin export failed but it did not show any specific error.
- OfflineJaznContentPlugin.log shows no error
Please find the attached plugin export logs
0
