Forum Stats

  • 3,851,353 Users
  • 2,263,966 Discussions
  • 7,904,686 Comments

Discussions

EPMHFM-66054 Unable to locate data source 11.1.2.4

YannisV
YannisV Member Posts: 130 Blue Ribbon
edited Jun 2, 2017 3:43PM in EPM System Infrastructure

Hi to all,

On our Windows 10 / Ora XE 11 HFM install , all works fine except the HFM module.

We can create the app but when trying to open we receive the message "EPMHFM-66054 Unable to locate data source 11.1.2.4."

We also installed the patch 21240419 to no avail. Also checked for tnsnames file and looks ok.

Please if you have experienced any similar advise.

Regards

yannis

From the logs:

EPMHFM-66054: O sistema não foi capaz de localizar o processo de Origem de dados para o aplicativo LEGAL.

Ocorreu um erro desconhecido em um objeto ODBC. [[1 record: SQLSTATE = 08001; NATIVE ERROR = -1; MSG = [DataDirect][ODBC Oracle Wire Protocol driver][Oracle]TNS-12519: TNS:no appropriate service handler found]]

Tagged:
Vikram VK

Best Answer

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Jun 2, 2017 3:00PM Answer ✓

    Raise an SR with Oracle then and see what they have to say as both Windows 10 and Oracle XE are not supported.

    You can try increasing the Oracle processes as that is a common error with XE.

    For example log into the database as sysdba and run

    ALTER SYSTEM SET processes=1000 SCOPE=SPFILE;

    Restart the database.

    Cheers

    John

    Vikram VK

Answers

  • Vikram VK
    Vikram VK Member Posts: 1,204
    edited Jun 2, 2017 2:27PM

    Although the error logs in other than English but it looks like you are getting connectivity issue with the DataSource.

    On our Windows 10 / Ora XE 11 HFM install

    -> I wondered because EPM is server based software you need to install on the Windows Server 2008 or 2012.

    However, with regards to your issue there are several KM's available in the metalink. You must review all of them for troubleshooting.

    Hyperion Financial Management (HFM) Error When Opening an Application: "HFM EPMHFM-66054: The System Was Unable To Find The Datasource Process For Application XXX" (Doc ID 1999915.1)

    Hyperion Financial Management (HFM) Error when Opening an Application: "EPMHFM-66054: The system was unable to find the Datasource process for Application XXX" (Doc ID 2015042.1)

    Hyperion Financial Management (HFM) Application Error: "EPMHFM-66054: The system was unable to find the datasource process for application" (Doc ID 1996889.1)

    Thanks.

  • YannisV
    YannisV Member Posts: 130 Blue Ribbon
    edited Jun 2, 2017 2:43PM

    Thanks Vikram for response, I have installed it in W 10 in the past with no issues.

    Have also reviewed the docs from KM base.

    Regards

    yannis

  • Vikram VK
    Vikram VK Member Posts: 1,204
    edited Jun 2, 2017 2:53PM

    Ok,

    What you have mentioned in the heading EPMHFM-66054 Unable to locate data source 11.1.2.4

    And pasted the error message (another language) is different because it shows ODBC Connectivity error.

    Can you provide some more info about:

    -What are EPM components are been installed

    -Database (hopefully it is Oracle) located where same server or another

    -When you say other components are working fine which are those?

    -Have you done any ODBC connection setup, if yes why?

    Share the HFM logs captured by errors in English.

    Thanks.

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Jun 2, 2017 3:00PM Answer ✓

    Raise an SR with Oracle then and see what they have to say as both Windows 10 and Oracle XE are not supported.

    You can try increasing the Oracle processes as that is a common error with XE.

    For example log into the database as sysdba and run

    ALTER SYSTEM SET processes=1000 SCOPE=SPFILE;

    Restart the database.

    Cheers

    John

    Vikram VK
  • YannisV
    YannisV Member Posts: 130 Blue Ribbon
    edited Jun 2, 2017 3:42PM

    Thanks John , nailed it!

    @aleksandro

This discussion has been closed.