Forum Stats

  • 3,828,041 Users
  • 2,260,848 Discussions
  • 7,897,436 Comments

Discussions

Categories

Does HFM using 32 bit or 64 bit client?

JanGLi
JanGLi Member Posts: 650 Bronze Badge
edited Jun 7, 2017 10:58PM in Financial Consolidation

hi,

Does HFM 11.1.2.4 use 64 bit database client or 32 bit? or both. which doesn't make sense.

I have installed external database client (not using the one that comes with HFM), which one should i install? 64 bit or 32 bit?

Plus about the TNS_ADMIN environment variable What it should be?

Kindly correct me if i am wrong.

1 - If i have used the default database client it's value would be... E:\Oracle\HFM\Middleware\user_projects\config\dbclient

2 - If i use external client it would be like this... E:\Oracle\DB_Client\product\12.2.0\client_1\network\admin

3 - Couldn't i just enter the required entries in my database tnsname.ora file and use this TNS_ADMIN entry... E:\Oracle\DB\product\12.2.0\dbhome_1\network\admin

or i can't because database doesn't get installed with database client. We have to install it separately.

Everything is installed on same machine.

Regards

Tagged:
· Share on TwitterShare on Facebook

Best Answer

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Jun 1, 2017 11:14AM Answer ✓

    Assuming you have installed 64bit which would be the norm nowadays then it should be using the 64 bit client.

    Did you follow - Using an Existing Oracle Database Client

    1. On the machine hosting Foundation Services, update the TNS_ADMIN environment variable to point to the location of the existing Oracle Database Client's tnsnames.ora file location.
    2. Move TNS entries from EPM_ORACLE_INSTANCE/user_projects/config/dbclient/tnsnames.ora (which is populated during database configuration) to the existing tnsnames.ora file. Copy the entire file contents and append to the existing contents of the tnsnames.ora file.

    Cheers

    John

    · Share on TwitterShare on Facebook
«1

Answers

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Jun 1, 2017 11:14AM Answer ✓

    Assuming you have installed 64bit which would be the norm nowadays then it should be using the 64 bit client.

    Did you follow - Using an Existing Oracle Database Client

    1. On the machine hosting Foundation Services, update the TNS_ADMIN environment variable to point to the location of the existing Oracle Database Client's tnsnames.ora file location.
    2. Move TNS entries from EPM_ORACLE_INSTANCE/user_projects/config/dbclient/tnsnames.ora (which is populated during database configuration) to the existing tnsnames.ora file. Copy the entire file contents and append to the existing contents of the tnsnames.ora file.

    Cheers

    John

    · Share on TwitterShare on Facebook
  • JanGLi
    JanGLi Member Posts: 650 Bronze Badge
    edited Jun 1, 2017 11:32AM

    I exactly did that.

    I have installed 64 bit db client and changed my TNS_ADMIN variable to client's tnsname.ora file folder. Plus added the EPM system tnsname.ora file entries in my db client's tnsname.ora file.


    But still when i try to create application i am getting this error: EPMHFM-66054: The system was unable to find the Datasource process for application NEWAPP.

    This is what i am getting in my log files...

    [2017-06-01T19:42:18.531+05:00] [HFMWeb0] [ERROR] [EPMHFM-65925] [oracle.FM.FMCOMMON.oracle.epm.fm.beans.appcreationwizard.AppCreationWizardBean] [tid: 11] [userId: <anonymous>] [ecid: 00ifrnujchmFw00Fzzw0w00001s800001X,0:1:3:3] [APP: FMADFWEB#11.1.2.0] [SRC_CLASS: oracle.epm.fm.beans.appcreationwizard.AppCreationWizardBean] [SRC_METHOD: createApplicationAction] An unexpected error has occurred. Message: The system was unable to find the Datasource process for application NEWAPP.[[

    Regards

    · Share on TwitterShare on Facebook
  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Jun 1, 2017 11:40AM

    Is there anything additional in xfm.odl.<APPNAME>.log

    Does <MIDDLWARE_HOME>\user_projects\config\dbclient exist and tnsnames.ora

    Do you have an entry in tnsnames.ora called HFMTNS

    JanGLi
    · Share on TwitterShare on Facebook
  • JanGLi
    JanGLi Member Posts: 650 Bronze Badge
    edited Jun 1, 2017 11:46AM

    Is there anything additional in xfm.odl.<APPNAME>.log

    [2017-06-01T19:42:17.701155+05:00] [XFM] [ERROR:1] [EPMHFM-07392] [XFM] [ecid: XDS.0000.0000.0000.0001] [File: XfmODBC.cpp] [Line: 203] [userId: ] [appName: NEWAPP] [pid: 6876] [tid: 7568] [host: hyperion] [nwaddr: 192.168.6.155:0;] [errorCode: 800402B5] [srcException: NotSpec] [errType: 1] [dbUpdate: 2] [11.1.2.4.204.5264] An unknown error occurred in an ODBC object. [[1 record: SQLSTATE = HY000; NATIVE ERROR = 28040; MSG = [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-28040: No matching authentication protocol]]

    [2017-06-01T19:42:17.703155+05:00] [XFM] [ERROR:1] [EPMHFM-07406] [XFM] [ecid: XDS.0000.0000.0000.0001] [File: XfmODBC.cpp] [Line: 615] [userId: ] [appName: NEWAPP] [pid: 6876] [tid: 7568] [host: hyperion] [nwaddr: 192.168.6.155:0;] [errorCode: 800402C3] [srcException: XfmExc] [errType: 1] [dbUpdate: 1] [11.1.2.4.204.5264] An error occurred in creating an ODBC connection. [[HY000]]

    [2017-06-01T19:42:17.703155+05:00] [XFM] [ERROR:1] [EPMHFM-07406] [XFM] [ecid: XDS.0000.0000.0000.0001] [File: XfmODBC.cpp] [Line: 700] [userId: ] [appName: NEWAPP] [pid: 6876] [tid: 7568] [host: hyperion] [nwaddr: 192.168.6.155:0;] [errorCode: 800402C3] [srcException: XfmExc] [errType: 1] [dbUpdate: 1] [11.1.2.4.204.5264] An error occurred in creating an ODBC connection. [[Failed to create DB connection.]]

    [2017-06-01T19:42:17.705157+05:00] [XFM] [TRACE:1] [EPMHFM-00000] [XFM] [ecid: ] [File: XFMDataSource.cpp] [Line: 499] [userId: ] [appName: NEWAPP] [pid: 6876] [tid: 7568] [host: hyperion] [nwaddr: 192.168.6.155:0;] [errorCode: 0] [srcException: NotSpec] [errType: 1] [dbUpdate: 2] [11.1.2.4.204.5264]  [[XDS: XFMDataSource process exiting with unknown exception ...]]

    [2017-06-01T19:42:17.706154+05:00] [XFM] [TRACE:1] [EPMHFM-00000] [XFM] [ecid: ] [File: XFMDataSource.cpp] [Line: 508] [userId: ] [appName: NEWAPP] [pid: 6876] [tid: 7568] [host: hyperion] [nwaddr: 192.168.6.155:0;] [errorCode: 0] [srcException: NotSpec] [errType: 1] [dbUpdate: 2] [11.1.2.4.204.5264]  [[XDS: XFMDataSource process exiting now ...]]

    Does <MIDDLWARE_HOME>\user_projects\config\dbclient exist and tnsnames.ora YES

    Do you have an entry in tnsnames.ora called HFMTNS YES

    · Share on TwitterShare on Facebook
  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Jun 1, 2017 11:57AM

    Maybe have a search for the error you are receiving - ORA-28040: No matching authentication protocol

    Also have a look at Client / Server Interoperability Support Matrix for Different Oracle Versions (Doc ID 207303.1)

    JanGLi
    · Share on TwitterShare on Facebook
  • JanGLi
    JanGLi Member Posts: 650 Bronze Badge
    edited Jun 1, 2017 12:07PM

    I found this... on google...

    http://christian-hoekstra.blogspot.com/2017/03/geekstuff-epm-oracle-epm-hfm-11124-and.html

    · Share on TwitterShare on Facebook
  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Jun 1, 2017 12:17PM

    Well maybe try out the solution as maybe it is also related to the Oracle client you installed or database version as the support matrix states 12.1.0.1+ and I see you have 12.2 which is not yet supported.

    JanGLi
    · Share on TwitterShare on Facebook
  • JanGLi
    JanGLi Member Posts: 650 Bronze Badge
    edited Jun 1, 2017 12:17PM

    DB and client version are compatible.

    DB version 12.2.0.1.0

    Client version 12.2.0

    · Share on TwitterShare on Facebook
  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Jun 1, 2017 12:20PM

    Yes but EPM is not supported with 12.2 check the support matrix Supported Platforms Matrices - Oracle Enterprise Performance Management System

    pastedImage_2.png

    JanGLi
    · Share on TwitterShare on Facebook
  • JanGLi
    JanGLi Member Posts: 650 Bronze Badge
    edited Jun 1, 2017 12:23PM

    I didn't bother to check the DB support compatibilty with HFM.

    Thanks for pointing it....

    Now i have to clean everything again

    3rd re-installation 

    Regards

    · Share on TwitterShare on Facebook
This discussion has been closed.