HFM: Hyperion Financial Management Import Application Source Application List Is Blank even though Database Link is Valid
(Doc ID 3023264.1)
Last updated on JUNE 23, 2024
Applies to:
Hyperion Financial Management - Version 11.2.8.0.000 and laterInformation in this document applies to any platform.
Symptoms
When attempting to use Import Application the Source Application drop-down list is blank even though the Database Link tests successfully.
oracle-epm-fm.log shows errors:
[HFMWeb0] [NOTIFICATION] [] [oracle.FM.ADMIN.oracle.jbo.server.ApplicationModuleImpl] [tid: 133] [userId: <anonymous>] [ecid: ] [APP: FMADFWEB] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SRC_CLASS: oracle.epm.fm.bc4j.services.AdministrationAMImpl] [SRC_METHOD: getListOfDBLinks] select * from all_db_links
[HFMWeb0] [NOTIFICATION] [] [oracle.FM.ADMIN.oracle.jbo.server.ApplicationModuleImpl] [tid: 133] [userId: <anonymous>] [ecid: ] [APP: FMADFWEB] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SRC_CLASS: oracle.epm.fm.bc4j.services.AdministrationAMImpl] [SRC_METHOD: getListOfDBLinks] dbLinks: [LOOPBACK.IN.CORP.COM - HFM_112,LOOPBACK - HFM_112,LOOPBACK.ON.CORP.COM - HFM_112]
[HFMWeb0] [NOTIFICATION] [] [oracle.FM.ADMIN.oracle.jbo.server.ApplicationModuleImpl] [tid: 133] [userId: <anonymous>] [ecid: ] [APP: FMADFWEB] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SRC_CLASS: oracle.epm.fm.bc4j.services.AdministrationAMImpl] [SRC_METHOD: getListOfAppsInDBLink] {? = call HFMUTIL_PKG.ListAppNames(?)}
[HFMWeb0] [ERROR] [EPMHFM-66152] [oracle.FM.ADMIN.oracle.jbo.server.ApplicationModuleImpl] [tid: 133] [userId: <anonymous>] [ecid: ] [APP: FMADFWEB] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SRC_CLASS: oracle.epm.fm.bc4j.services.AdministrationAMImpl] [SRC_METHOD: getListOfAppsInDBLink] An error occurred in executing the query.[[
java.sql.SQLSyntaxErrorException: ORA-02084: database name is missing a component
ORA-06512: at "HFM_112.HFMUTIL_PKG", line 1
ORA-06512: at line 1
[HFMWeb0] [NOTIFICATION] [] [oracle.FM.ADMIN.oracle.jbo.server.ApplicationModuleImpl] [tid: 133] [userId: <anonymous>] [ecid: ] [APP: FMADFWEB] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SRC_CLASS: oracle.epm.fm.bc4j.services.AdministrationAMImpl] [SRC_METHOD: getListOfDBLinks] dbLinks: [LOOPBACK.IN.CORP.COM - HFM_112,LOOPBACK - HFM_112,LOOPBACK.ON.CORP.COM - HFM_112]
[HFMWeb0] [NOTIFICATION] [] [oracle.FM.ADMIN.oracle.jbo.server.ApplicationModuleImpl] [tid: 133] [userId: <anonymous>] [ecid: ] [APP: FMADFWEB] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SRC_CLASS: oracle.epm.fm.bc4j.services.AdministrationAMImpl] [SRC_METHOD: getListOfAppsInDBLink] {? = call HFMUTIL_PKG.ListAppNames(?)}
[HFMWeb0] [ERROR] [EPMHFM-66152] [oracle.FM.ADMIN.oracle.jbo.server.ApplicationModuleImpl] [tid: 133] [userId: <anonymous>] [ecid: ] [APP: FMADFWEB] [partition-name: DOMAIN] [tenant-name: GLOBAL] [SRC_CLASS: oracle.epm.fm.bc4j.services.AdministrationAMImpl] [SRC_METHOD: getListOfAppsInDBLink] An error occurred in executing the query.[[
java.sql.SQLSyntaxErrorException: ORA-02084: database name is missing a component
ORA-06512: at "HFM_112.HFMUTIL_PKG", line 1
ORA-06512: at line 1
Changes
New environment or changes to database link name.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |