Forum Stats

  • 3,837,490 Users
  • 2,262,264 Discussions
  • 7,900,301 Comments

Discussions

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

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

«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

  • 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

  • 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
  • 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

  • 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
  • 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
  • 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

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Jun 1, 2017 12:20PM
  • 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

This discussion has been closed.