วันจันทร์ที่ 18 กันยายน พ.ศ. 2560

OBIEE 12.2.1.1.0 and 12.2.1.3.0 error during configuration (Repo on MS SQL)


We face issue when install and configure OBIEE12c 12.1.3.0 on Windows server and keep repository in MS SQL
Error occur when go to last step , during configuration.
Error in Windows will keep in > C:\Program Files\Oracle\Inventory\logs
And this's main message

failed with exit value 1[[
oracle.bi.exec.ExecutionStatusException: Execution of [cmd, /c, C:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\oracle_common\common\bin\wlst.cmd, C:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\bi\modules\oracle.bi.configassistant\essbase.py, C:\Oracle\Middleware\Oracle_Home\bi\bin\..\.., C:\Oracle\Middleware\Oracle_Home\bi\bin\..\..\user_projects\domains\bi12c, weblogic, Expanded, OCSBOCAPPSRV01, 9502, 9503, SQLSERVER, weblogic.jdbc.sqlserver.SQLServerDriver, "jdbc:weblogic:sqlserver://OCSBOCDBSRV01:1433;databaseName=BI_REPO_PROD", P, "jdbc:weblogic:sqlserver://OCSBOCDBSRV01:1433;databaseName=BI_REPO_PROD", ] failed with exit value 1
at oracle.bi.exec.StdinProcess.runProcess(StdinProcess.java:99)
at oracle.bi.exec.ExecScript.executeScript(ExecScript.java:191)
at oracle.bi.exec.ExecScript.executeSynchronousScript(ExecScript.java:95)
at oracle.bi.exec.ExecWLST.executeWLSTScript(ExecWLST.java:62)
at oracle.bi.install.config.steps.WLSTStep.executeSingleShot(WLSTStep.java:55)
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)

Main message you looking for below wording
failed with exit value 1[[
oracle.bi.exec.ExecutionStatusException: Execution of
oracle_common\common\bin\wlst.cmd, 
failed with exit value 1

The Cause it's from Java version, JAVA_HOME, Java path surely! , please review your configure.


วันอังคารที่ 12 กันยายน พ.ศ. 2560

Great OBIEE design best practice

This link is provide great detail for OBIEE design best practice, cover all RPD and report, prompt

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=257561774611961&parent=SrDetailText&sourceId=3-15449032691&id=2106183.1&_afrWindowMode=0&_adf.ctrl-state=rkiac2fph_405

Link of PDF document at the bottom of page.

วันอังคารที่ 5 กันยายน พ.ศ. 2560

Oracle Business Intelligence Enterprise Edition 12c Release 1 (12.2.1.3) available now

Oracle Business Intelligence Enterprise Edition 12c Release 1 (12.2.1.3) available now by this link