An Oracle article was referenced in a previous blog post of this blog. This document appears to contradict Oracle's OBIEE 184.108.40.206 Administrator documentation which states what seems to be an incorrect parameter list. It looks like this article is referring to the deprecated WLST scripts which were replaced in previous OBIEE 12c versions with the bitools/bin scripts as this Oracle document confirms - Oracle Support Document 2463087.1 (OBIEE 12c: PROBLEM_EXPORTING_BAR_FILE error when exporting BAR file).
The export script calls an LCM (life cycle management) script. Rather than calling the export script in the bitools/bin directory, calling the lcm script directly worked when the bitools script didn't. To fix the bitools script, set the BI_PRODUCT_HOME variable to:
You will need to restart the OBIEE services to ensure that the new environment variable is picked up before running the export BAR script in the bitools/bin directory.
The export BAR file script log files can be found here:
If your Windows OS has a non English locale, you are likely to have issues with the export failing with errors related to the security metadata held in the jazn-data.xml file:
Oracle Support Document 2565111.1 (OBIEE 220.127.116.11: Running exportarchive Failed with "Invalid byte 1 of 1-byte UTF-8 sequence" Error in OfflineJaznContentPlugin.log)
This document suggests that the encoding needs to be explicitly defined as an environment variable before the call to the export BAR file script. This unfortunately didn't work and the workaround was to set the value of this variable in the LCM export BAR file script which is located in the $ORACLE_HOME/bi/modules/oracle.bi.servicelcm/scripts directory (not in the java call of this script):
As you'll notice from above, the user experience of an OBIEE 18.104.22.168 Windows OS installation isn't the greatest. We live in hope that the imminent release of Oracle Analytics Server will rectify these issues highlighted above in this blog post with much easier installations less prone to these kind of issues.
A bit about me. I am an Oracle ACE Pro, Oracle Cloud Infrastructure 2023 Enterprise Analytics Professional, Oracle Cloud Fusion Analytics Warehouse 2023 Certified Implementation Professional, Oracle Cloud Platform Enterprise Analytics 2022 Certified Professional, Oracle Cloud Platform Enterprise Analytics 2019 Certified Associate and a certified OBIEE 11g implementation specialist.