Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

load metadata into HFM application error:Opening HFM application failed

user10893221Mar 18 2013 — edited Mar 18 2013
there is something wrong with my HFM demo,I want to load metadata into HFM Application using Informatica 8.1.1(without upgrade SP3).but it doesn't work，
the system Environment is : windows server 2003+Hyperion 11.1.1.3+Informaica 8.1.1+Oracle 11g
this is the log:

2013-03-18 10:07:46 : INFO : (548 | WRITER_1_*_1) : (IS | PowerCenter_Integration_Service) : node01_EPMpeng : HFM Writer_1762 : [DEBUG] Partition init(). Starting Target #0, Group #0, Partition #0...
2013-03-18 10:07:46 : INFO : (548 | READER_1_1_1) : (IS | PowerCenter_Integration_Service) : node01_EPMpeng : RR_4050 : RR_4050 First row returned from database to reader : (Mon Mar 18 10:07:46 2013)
2013-03-18 10:07:46 : INFO : (548 | READER_1_1_1) : (IS | PowerCenter_Integration_Service) : node01_EPMpeng : BLKR_16019 : Read [1] rows, read [0] error rows for source table [ETL] instance name [ETL]
2013-03-18 10:07:46 : INFO : (548 | READER_1_1_1) : (IS | PowerCenter_Integration_Service) : node01_EPMpeng : BLKR_16008 : Reader run completed.
2013-03-18 10:07:46 : DEBUG : (548 | TRANSF_1_1_1) : (IS | PowerCenter_Integration_Service) : node01_EPMpeng : EP_13249 : DLL Debug Msg: [HFM_LoadAccounts] An input group received an EOF notification. Sending <EOF> string to Target...
2013-03-18 10:07:46 : INFO : (548 | TRANSF_1_1_1) : (IS | PowerCenter_Integration_Service) : node01_EPMpeng : DBG_21216 : Finished transformations for Source Qualifier [SQ_ETL]. Total errors [0]
2013-03-18 10:07:46 : INFO : (548 | WRITER_1_*_1) : (IS | PowerCenter_Integration_Service) : node01_EPMpeng : HFM Writer_1762 : [INFO] 'Behavior' parameter value: [Commit]
2013-03-18 10:07:46 : INFO : (548 | WRITER_1_*_1) : (IS | PowerCenter_Integration_Service) : node01_EPMpeng : HFM Writer_1762 : [DEBUG] HFM method used: [Commit]
2013-03-18 10:07:46 : INFO : (548 | WRITER_1_*_1) : (IS | PowerCenter_Integration_Service) : node01_EPMpeng : HFM Writer_1762 : [INFO] 'Clear Currencies' parameter value: [false]
2013-03-18 10:07:46 : INFO : (548 | WRITER_1_*_1) : (IS | PowerCenter_Integration_Service) : node01_EPMpeng : HFM Writer_1762 : [INFO] 'Clear Scenarios' parameter value: [false]
2013-03-18 10:07:46 : INFO : (548 | WRITER_1_*_1) : (IS | PowerCenter_Integration_Service) : node01_EPMpeng : HFM Writer_1762 : [INFO] 'Clear Entities' parameter value: [false]
2013-03-18 10:07:46 : INFO : (548 | WRITER_1_*_1) : (IS | PowerCenter_Integration_Service) : node01_EPMpeng : HFM Writer_1762 : [INFO] 'Clear Accounts' parameter value: [false]
2013-03-18 10:07:46 : INFO : (548 | WRITER_1_*_1) : (IS | PowerCenter_Integration_Service) : node01_EPMpeng : HFM Writer_1762 : [INFO] 'Clear Custom1' parameter value: [false]
2013-03-18 10:07:46 : INFO : (548 | WRITER_1_*_1) : (IS | PowerCenter_Integration_Service) : node01_EPMpeng : HFM Writer_1762 : [INFO] 'Clear Custom2' parameter value: [false]
2013-03-18 10:07:46 : INFO : (548 | WRITER_1_*_1) : (IS | PowerCenter_Integration_Service) : node01_EPMpeng : HFM Writer_1762 : [INFO] 'Clear Custom3' parameter value: [false]
2013-03-18 10:07:46 : INFO : (548 | WRITER_1_*_1) : (IS | PowerCenter_Integration_Service) : node01_EPMpeng : HFM Writer_1762 : [INFO] 'Clear Custom4' parameter value: [false]
2013-03-18 10:07:46 : INFO : (548 | WRITER_1_*_1) : (IS | PowerCenter_Integration_Service) : node01_EPMpeng : HFM Writer_1762 : [INFO] 'Replace Mode' parameter value: [false]
2013-03-18 10:07:46 : INFO : (548 | WRITER_1_*_1) : (IS | PowerCenter_Integration_Service) : node01_EPMpeng : HFM Writer_1762 : [DEBUG] Target table 'Trainning:Commit' has 8 columns, 8 input columns, 1 linked columns
2013-03-18 10:07:46 : INFO : (548 | WRITER_1_*_1) : (IS | PowerCenter_Integration_Service) : node01_EPMpeng : HFM Writer_1762 : [INFO] Opening HFM application: [Trainning]. Cluster: [EPMpeng]. User: [admin]
2013-03-18 10:08:09 : ERROR : (548 | WRITER_1_*_1) : (IS | PowerCenter_Integration_Service) : node01_EPMpeng : HFM Writer_1762 : [ERROR] Opening HFM application failed. Error code: 0xC0000005 []
2013-03-18 10:08:09 : INFO : (548 | WRITER_1_*_1) : (IS | PowerCenter_Integration_Service) : node01_EPMpeng : HFM Writer_1762 : [DEBUG] Decimal separator is . Thousands separator is ,
2013-03-18 10:08:09 : INFO : (548 | WRITER_1_*_1) : (IS | PowerCenter_Integration_Service) : node01_EPMpeng : HFM Writer_1762 : [INFO] Releasing HFM resources (closeApplication)
2013-03-18 10:08:09 : ERROR : (548 | WRITER_1_*_1) : (IS | PowerCenter_Integration_Service) : node01_EPMpeng : HFM Writer_1762 : [ERROR] Closing HFM application failed. Error code: 0x800706F4
2013-03-18 10:08:09 : INFO : (548 | WRITER_1_*_1) : (IS | PowerCenter_Integration_Service) : node01_EPMpeng : WRT_8167 : Start loading table [Trainning:Commit: Partition 1] at: Mon Mar 18 10:08:09 2013
2013-03-18 10:08:09 : INFO : (548 | WRITER_1_*_1) : (IS | PowerCenter_Integration_Service) : node01_EPMpeng : WRT_8168 : End loading table [Trainning:Commit: Partition 1] at: Mon Mar 18 10:08:09 2013
2013-03-18 10:08:09 : ERROR : (548 | WRITER_1_*_1) : (IS | PowerCenter_Integration_Service) : node01_EPMpeng : HFM Writer_1762 : [ERROR] HFM application 'Trainning' is not opened

ps: the information about the HFM application is right：HFM application: [Trainning]. Cluster: [EPMpeng]. User: [admin],and the password is also right.

please help me!
Best regards,
Jason
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 15 2013
Added on Mar 18 2013
#business-intelligence-applications, #financial-consolidation, #performance-management-applications
2 comments
248 views