Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Installing database from install-tool.cmd

JanGLiMay 31 2017 — edited Jun 7 2017

Hi,

I have installed HFM 11.1.2.4 on windows server 2012 R2. After application creation i am getting this error "EPMHFM-66054: The system was unable to find the Datasource process for application HFMCRP". I have tired all the solutions provided by SR and experts on community. I have applied the latest HFM patch but still getting the same issue.

What i found is that i didn't installed db clients when i was installing HFM using install-tool.cmd.

Could this be the reason?

If yes... how can i install db clients using install-tool.cmd?

I did tried installing them but it is failing. Following are the logs shown in logs files E:\Oracle\HFM\Middleware\EPMSystem11R1\diagnostics\logs\install\installTool-install-Thu-06.01.2017- 8.18.14.log

[2017-06-01T08:20:06.167+05:00] [EPMINS] [TRACE] [EPMINS-00639] [oracle.EPMINS] [tid: 24] [SRC_CLASS: com.hyperion.cis.OUIInstallAction] [arg: 0] Exited with error code 0

[2017-06-01T08:20:06.183+05:00] [EPMINS] [TRACE] [EPMINS-00501] [oracle.EPMINS] [tid: 24] [SRC_CLASS: com.hyperion.cis.OUIInstallAction] [arg:  Done with install, OUI_LOCKED = false]  Done with install, OUI_LOCKED = false

2017-06-01T08:22:35.428+05:00] [EPMINS] [ERROR] [EPMINS-00697] [oracle.EPMINS] [tid: 27] [SRC_CLASS: com.hyperion.install.action.impl.OUIExecAction] [arg: null] Completed postInstallPatch script execution.

[2017-06-01T08:22:35.428+05:00] [EPMINS] [ERROR] [EPMINS-00697] [oracle.EPMINS] [tid: 28] [SRC_CLASS: com.hyperion.install.action.impl.OUIExecAction] [arg: null] Completed postInstallPatch script execution

[Location:E:\Oracle\DB\product\12.2.0\dbhome_1:Name:OraDB12Home1:Index:1:Is CRS:false:ARUID:233:ARUID Desc:Microsoft Windows (64-bit AMD)[[

                :Local node:null:Nodes:[]:isRemoved:false, Location:E:\Oracle\HFM\Middleware\oracle_common:Name:OH1775148510:Index:2:Is CRS:false:ARUID:233:ARUID Desc:Microsoft Windows Server 2003 (64-bit AMD):Local node:null:Nodes:[]:isRemoved:false, Location:E:\Oracle\HFM\Middleware\ohs:Name:OH463649904:Index:3:Is CRS:false:ARUID:233:ARUID Desc:Microsoft Windows Server 2003 (64-bit AMD):Local node:null:Nodes:[]:isRemoved:false, Location:E:\Oracle\HFM\Middleware\odi:Name:OH463650038:Index:4:Is CRS:false:ARUID:233:ARUID Desc:Microsoft Windows Server 2003 (64-bit AMD):Local node:null:Nodes:[]:isRemoved:false, Location:E:\Oracle\HFM\Middleware\EPMSystem11R1:Name:EpmSystem_nfl.hyperion:Index:5:Is CRS:false:ARUID:233:ARUID Desc:Microsoft Windows x64 (64-bit):Local node:null:Nodes:[]:isRemoved:false]

]]

Kindly guide.

Regards
This post has been answered by JohnGoodwin on Jun 1 2017
Jump to Answer

Comments

JohnGoodwin
Answer

When installing if you select "Financial Management Server" it will automatically select the database clients so you must have deselected them, they are selected for a reason, obviously if you were connecting to SQL Server you would not need them selected.

It is also possible to use an existing Oracle client - Using an Existing Oracle Database Client

Cheers

John

Marked as Answer by JanGLi · Sep 27 2020
JanGLi

Damn i even searched the shared document for database client maybe i didn't searched property.

Well any way i have already started the re-installation

Thanks for always helping

QA

@John Goodwin

Do we still need DB client, when we use/specify jdbc connection string during config?

Thanks

A

JohnGoodwin 
1002763 wrote:
Do we still need DB client, when we use/specify jdbc connection string during config?

No you don't need a database client for the configuration.

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 1 2017
Added on May 31 2017
#business-intelligence-applications, #client, #database, #db, #financial-consolidation, #hfm, #install, #performance-management-applications
4 comments
462 views