Forum Stats

  • 3,853,380 Users
  • 2,264,214 Discussions
  • 7,905,332 Comments

Discussions

EPMA : Not able to Open HFM APP

2725111
2725111 Member Posts: 21
edited Sep 6, 2017 1:13AM in EPM System Infrastructure

Hi Experts,

I have installed  EPMA on  my system [  windows server 2008  64 bit ] and all services are running but  getting data process error  when trying to open HFM APP,

In   xfm.odl.HFMAPP-1 logs  I see  'TNS-12518: TNS:listener could not hand off client connection

any suggestion ?

pastedImage_0.png

[2017-09-02T03:48:47.344414+08:00] [XFM] [TRACE:1] [EPMHFM-00000] [XFM] [ecid: XDS.0000.0000.0000.0001] [File: XFMDataSource.cpp] [Line: 462] [userId: ] [appName: HFMAPP] [pid: 10644] [tid: 6208] [host: hysetup] [nwaddr: 10.0.200.133:0;] [errorCode: 0] [srcException: NotSpec] [errType: 1] [dbUpdate: 2] [11.1.2.4.000.4847]  [[XDS: XFMDataSource process starting...]]

[2017-09-02T03:50:20.205725+08:00] [XFM] [TRACE:1] [EPMHFM-00000] [XFM] [ecid: XDS.0000.0000.0000.0001] [File: CHsvDataSourceImpl.cpp] [Line: 442] [userId: ] [appName: HFMAPP] [pid: 10644] [tid: 6208] [host: hysetup] [nwaddr: 10.0.200.133:0;] [errorCode: 0] [srcException: NotSpec] [errType: 1] [dbUpdate: 2] [11.1.2.4.000.4847]  [[Hsv: Initializing HsvDSSQL]]

[2017-09-02T03:50:21.801816+08:00] [XFM] [TRACE:1] [EPMHFM-00000] [XFM] [ecid: XDS.0000.0000.0000.0001] [File: CHsvDataSourceImpl.cpp] [Line: 486] [userId: ] [appName: HFMAPP] [pid: 10644] [tid: 6208] [host: hysetup] [nwaddr: 10.0.200.133:0;] [errorCode: 0] [srcException: NotSpec] [errType: 1] [dbUpdate: 2] [11.1.2.4.000.4847]  [[Hsv: Initializing XfmDSSQL]]

[2017-09-02T03:50:38.574776+08:00] [XFM] [ERROR:1] [EPMHFM-07392] [XFM] [ecid: XDS.0000.0000.0000.0001] [File: XfmODBC.cpp] [Line: 189] [userId: ] [appName: HFMAPP] [pid: 10644] [tid: 6208] [host: hysetup] [nwaddr: 10.0.200.133:0;] [errorCode: 800402B5] [srcException: NotSpec] [errType: 1] [dbUpdate: 1] [11.1.2.4.000.4847] An unknown error occurred in an ODBC object. [[1 record: SQLSTATE = 08001; NATIVE ERROR = -1; MSG = [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]TNS-12518: TNS:listener could not hand off client connection]]

[2017-09-02T03:50:38.744785+08:00] [XFM] [ERROR:1] [EPMHFM-07407] [XFM] [ecid: XDS.0000.0000.0000.0001] [File: XfmODBC.cpp] [Line: 532] [userId: ] [appName: HFMAPP] [pid: 10644] [tid: 6208] [host: hysetup] [nwaddr: 10.0.200.133:0;] [errorCode: 800402C4] [srcException: XfmExc] [errType: 1] [dbUpdate: 1] [11.1.2.4.000.4847]  [[]]

[2017-09-02T03:50:38.757786+08:00] [XFM] [ERROR:1] [EPMHFM-07406] [XFM] [ecid: XDS.0000.0000.0000.0001] [File: XfmODBC.cpp] [Line: 617] [userId: ] [appName: HFMAPP] [pid: 10644] [tid: 6208] [host: hysetup] [nwaddr: 10.0.200.133:0;] [errorCode: 800402C3] [srcException: XfmExc] [errType: 1] [dbUpdate: 1] [11.1.2.4.000.4847] An error occurred in creating an ODBC connection. [[]]

[2017-09-02T03:50:38.823790+08:00] [XFM] [ERROR:1] [EPMHFM-07406] [XFM] [ecid: XDS.0000.0000.0000.0001] [File: CSQLConnectionPool.cpp] [Line: 142] [userId: ] [appName: HFMAPP] [pid: 10644] [tid: 6208] [host: hysetup] [nwaddr: 10.0.200.133:0;] [errorCode: 800402C3] [srcException: XfmExc] [errType: 0] [dbUpdate: 0] [11.1.2.4.000.4847] An error occurred in creating an ODBC connection. [[]]

----------------------------------------------listener.ora  -----------

# listener.ora Network Configuration File: C:\app\ankit\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora

# Generated by Oracle configuration tools.

SID_LIST_LISTENER =

  (SID_LIST =

    (SID_DESC =

      (SID_NAME = CLRExtProc)

      (ORACLE_HOME = C:\app\ankit\product\11.2.0\dbhome_1)

      (PROGRAM = extproc)

      (ENVS = "EXTPROC_DLLS=ONLY:C:\app\ankit\product\11.2.0\dbhome_1\bin\oraclr11.dll")

    )

    (SID_DESC =

      (GLOBAL_DBNAME = Oracle8)

      (SID_NAME = ORCL)

    )

    (SID_DESC =

      (SID_NAME = CLRExtProc)

      (ORACLE_HOME = C:\app\ankit\product\11.2.0\dbhome_1)

      (PROGRAM = extproc)

      (ENVS = "EXTPROC_DLLS=ONLY:C:\app\ankit\product\11.2.0\dbhome_1\bin\oraclr11.dll")

    )

  )

LISTENER =

  (DESCRIPTION_LIST =

    (DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = hysetup)(PORT = 1521))

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

    )

  )

ADR_BASE_LISTENER = C:\app\ankit

DIRECT_HANDOFF_TTC_LISTENER=OFF

----------------------------tnsnames.ora--------------------------------------------------------------------------------------------------------------------------

# tnsnames.ora Network Configuration File: C:\app\ankit\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora

# Generated by Oracle configuration tools.

ORACLR_CONNECTION_DATA =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

    )

    (CONNECT_DATA =

      (SID = CLRExtProc)

      (PRESENTATION = RO)

    )

  )

LISTENER_ORCL =

  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORCL =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = LOCALHOST)(PORT = 1521))

      (ADDRESS = (PROTOCOL = TCP)(HOST = HYSETUP)(PORT = 1521))

      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.200.133)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SID = orcl)

      (SERVER = DEDICATED)

    )

  )

HFMTNS =

(DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = LOCALHOST)(PORT = 1521))

      (ADDRESS = (PROTOCOL = TCP)(HOST = HYSETUP)(PORT = 1521))

      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.200.133)(PORT = 1521))

    )

    (CONNECT_DATA =

      (SID = orcl)

      (SERVER = DEDICATED)

    )

  )

pastedImage_6.png

Tagged:
Vikram VK

Answers

This discussion has been closed.