Installing database from install-tool.cmd

JanGLi

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

JohnGoodwin

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

JohnGoodwin

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

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

User_7EQ9Q

@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.