Installation of BI Publisher Standalone 12.2.1.4 seems to fail on all platforms

Question

Summary

Bug 28264679 - STANDALONE BI PUBLISHER INSTALLATION FAIL ON 12.2.1.4

Content

When installing BI Publisher Standalone 12.2.1.4 on Windows Server 2012 R2 I got the error below.

When searching in support.oracle.com I found bug 28264679 that describes the exact same error on all platforms.

Is there a workaround or planned solution to fix this problem ?

[2018-08-29T11:36:42.500+02:00] [bi] [ERROR] [] [oracle.bi.install.config.actions] [tid: 39] [ecid: 0000MM51IoZBx0xaw9IbMG1RXaPR000004,0] Non-skipped failure during configuration action: Execution of [cmd, /c, D: \oracle\Middleware\Oracle_Home_bip\bi\bin\..\..\user_projects\domains\bip_domain\bitools\bin\create_bi_service_instance.cmd, -d, "Default BI Service Instance", -b, D: \oracle\Middleware\Oracle_Home_bip\bi\bin\..\..\bi\modules\oracle.biee.application.sample\sample.bar, -o, weblogic, ssi] failed with exit value 1[[

oracle.bi.exec.ExecutionStatusException: Execution of [cmd, /c, D: \oracle\Middleware\Oracle_Home_bip\bi\bin\..\..\user_projects\domains\bip_domain\bitools\bin\create_bi_service_instance.cmd, -d, "Default BI Service Instance", -b, D: \oracle\Middleware\Oracle_Home_bip\bi\bin\..\..\bi\modules\oracle.biee.application.sample\sample.bar, -o, weblogic, ssi] failed with exit value 1

at oracle.bi.exec.StdinProcess.runProcess(StdinProcess.java:106)

at oracle.bi.exec.ExecScript.executeScript(ExecScript.java:191)

at oracle.bi.exec.ExecScript.executeSynchronousScript(ExecScript.java:95)

at oracle.bi.install.config.steps.application.AddDefaultServiceInstanceStep.createServiceInstance(AddDefaultServiceInstanceStep.java:136)

at oracle.bi.install.config.steps.application.AddDefaultServiceInstanceStep.executeSingleShot(AddDefaultServiceInstanceStep.java:76)

at oracle.bi.install.config.basesteps.SingleShotActionStep.execute(SingleShotActionStep.java:31)

at oracle.bi.install.config.basesteps.StepList.execute(StepList.java:85)

at oracle.bi.install.config.actions.BIConfigAction.doExecute(BIConfigAction.java:127)

at oracle.as.install.engine.modules.configuration.client.ConfigAction.execute(ConfigAction.java:405)

at oracle.as.install.engine.modules.configuration.action.TaskPerformer.run(TaskPerformer.java:88)

at oracle.as.install.engine.modules.configuration.action.TaskPerformer.startConfigAction(TaskPerformer.java:108)

at oracle.as.install.engine.modules.configuration.action.ActionRequest.perform(ActionRequest.java:15)

at oracle.as.install.engine.modules.configuration.action.RequestQueue.performSequentialExecution(RequestQueue.java:284)

at oracle.as.install.engine.modules.configuration.action.RequestQueue.perform(RequestQueue.java:260)

at oracle.as.install.engine.modules.configuration.standard.StandardConfigActionManager.start(StandardConfigActionManager.java:185)

at oracle.as.install.engine.modules.configuration.boot.ConfigurationExtension.kickstart(ConfigurationExtension.java:82)

at oracle.as.install.engine.modules.configuration.ConfigurationModule.run(ConfigurationModule.java:87)

at java.lang.Thread.run(Thread.java:748)

jonathan.johnson · Answer

I thought I found a possible solution.  I edited the file %Oracle_Home%\bi\modules\oracle.bi.sysman\syscomp\create_bi_service_instance.cmd.  I took out the last "..". I thought that this directed it to the correct Oracle_Home directory.  I was wrong.  Instead the BI Service couldn't find what it was looking for and failed.  That was only according to the logs.  According to the installer it had a green check and seemed liked it installed correctly.  I'm now more suspect of the BI Publisher database.  It seems when I attempt to drop the RCU I run into an issue with the IAU portion which also happens to be in the error.  It's frustrating the install works on Linux if you fix like Saresh commented above, but not on Windows....yet.

Thanks,

Jonathan Johnson

Mike Gray · Answer

Thanks Sareesh - this worked for me - but I have a full OBIEE 12.2.1.3 installation that I copied the metadata/config.xml file from.

Started the BI Publisher configuration and then kept trying to copy in the file until the install had got far enough through for the copy to succeed.

MiKe

Saresh-Oracle · Answer

Hi Juergen,

Spotted an internal Note with below workaround:

A. After the install finishes with the above error navigate to /oracleApps/Middleware/user_projects/domains/bi/config/fmwconfig/biconfig/.

B. Compressed the metadata folder with tar -zcvf, and move the tar.gz off to a separate directory.

C. Stop OBIEE and remove the bi folders in /user_projects/domains and /user_projects/applications .

D. Now drop and recreate the RCU, and then reinstall BI Publisher standalone.

E. Once the wizard is on the BI Publisher (BIP) step refresh the folders and confirm successful drill down to /oracleApps/Middleware/user_projects/domains/bi/config/fmwconfig/biconfig/.

F. Copy the metadata.tar.gz there and unzip the file so /metadata/config.xml is present.

G. Confirm the BI Standalone install will now progress past the normal failure point and into the BI Startup portion of the wizard.

Thanks,

Sareesh