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!

Hyperion Services are getting stopped

YSPNov 6 2012 — edited Nov 8 2012
Hi All,

This has happened so many times that only restarting the hyperion services solved the issue.
I have checked logs many times but dint get any clue.
Yesterday I faced the same.
I have got the complaint from client that Planning application is not working.
I just checked that services of Foundation services and planning services were down.
I just started those again and it worked.

The log of planning had this information
2012-11-01 21:10:13,463 WARN [ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)' com.hyperion.hbr.db.DBLocationTable - Unable to find Location with ID: 0



2012-11-05 00:10:47,724 WARN Timer-3 com.hyperion.hbr.db.BaseRepository - Error while executing Database update: delete from HBRPluginData where UPPER(PlanningServer) = 'HYPERIONAPP' and UPPER(PlanningAppName) = 'PSSL' and UPPER(PlanningRmiPort) = '11333'
2012-11-05 00:10:47,724 WARN Timer-3 com.hyperion.hbr.db.DBPluginDataTable - Error while executing query: delete from HBRPluginData where UPPER(PlanningServer) = 'HYPERIONAPP' and UPPER(PlanningAppName) = 'PSSL' and UPPER(PlanningRmiPort) = '11333'
2012-11-05 00:10:47,724 WARN Timer-3 com.hyperion.hbr.db.DBPluginDataTable - Error while executing query: insert into HBRPluginData (PlanningServer, PlanningRmiPort, PlanningAppName, OlapServerName, OlapUserName, OlapPassword) values(?, ?, ?, ?, ?, ?)
2012-11-05 00:10:47,724 FATAL Timer-3 com.hyperion.hbr.core.PluginDataManager - Error adding Plugin Data.
2012-11-05 00:10:54,635 WARN Thread-37 com.hyperion.hbr.db.DBPluginDataTable - Error while executing query: select PlanningServer, PlanningRmiPort, PlanningAppName, OlapServerName, OlapUserName, OlapPassword, EntryTime from HBRPluginData where EntryTime > ?
2012-11-05 00:10:54,635 FATAL Thread-37 com.hyperion.hbr.core.PluginDataManager - Error reading Plugin Data.
2012-11-05 00:11:12,732 WARN Timer-3 com.hyperion.hbr.db.BaseRepository - Error while executing Database update: delete from HBRPluginData where UPPER(PlanningServer) = 'HYPERIONAPP' and UPPER(PlanningAppName) = 'PSSL' and UPPER(PlanningRmiPort) = '11333'
2012-11-05 00:11:12,732 WARN Timer-3 com.hyperion.hbr.db.DBPluginDataTable - Error while executing query: delete from HBRPluginData where UPPER(PlanningServer) = 'HYPERIONAPP' and UPPER(PlanningAppName) = 'PSSL' and UPPER(PlanningRmiPort) = '11333'
2012-11-05 00:11:12,732 WARN Timer-3 com.hyperion.hbr.db.DBPluginDataTable - Error while executing query: insert into HBRPluginData (PlanningServer, PlanningRmiPort, PlanningAppName, OlapServerName, OlapUserName, OlapPassword) values(?, ?, ?, ?, ?, ?)
2012-11-05 00:11:12,732 FATAL Timer-3 com.hyperion.hbr.core.PluginDataManager - Error adding Plugin Data.
2012-11-05 00:11:24,651 WARN Thread-37 com.hyperion.hbr.db.DBPluginDataTable - Error while executing query: select PlanningServer, PlanningRmiPort, PlanningAppName, OlapServerName, OlapUserName, OlapPassword, EntryTime from HBRPluginData where EntryTime > ?
2012-11-05 00:11:24,651 FATAL Thread-37 com.hyperion.hbr.core.PluginDataManager - Error reading Plugin Data.
2012-11-05 00:11:37,741 WARN Timer-3 com.hyperion.hbr.db.BaseRepository - Error while executing Database update: delete from HBRPluginData where UPPER(PlanningServer) = 'HYPERIONAPP' and UPPER(PlanningAppName) = 'PSSL' and UPPER(PlanningRmiPort) = '11333'
2012-11-05 00:11:37,741 WARN Timer-3 com.hyperion.hbr.db.DBPluginDataTable - Error while executing query: delete from HBRPluginData where UPPER(PlanningServer) = 'HYPERIONAPP' and UPPER(PlanningAppName) = 'PSSL' and UPPER(PlanningRmiPort) = '11333'
2012-11-05 00:11:37,741 WARN Timer-3 com.hyperion.hbr.db.DBPluginDataTable - Error while executing query: insert into HBRPluginData (PlanningServer, PlanningRmiPort, PlanningAppName, OlapServerName, OlapUserName, OlapPassword) values(?, ?, ?, ?, ?, ?)
2012-11-05 00:11:37,741 FATAL Timer-3 com.hyperion.hbr.core.PluginDataManager - Error adding Plugin Data.
2012-11-05 00:11:55,666 WARN Thread-37 com.hyperion.hbr.db.DBConnectionManager - Unable to create a new connection for jdbc:oracle:thin:@pep-prd-dbs.shopzone.com:1521:HRPROD
2012-11-05 00:11:55,666 FATAL Thread-37 com.hyperion.hbr.core.PluginDataManager - Error reading Plugin Data.
2012-11-05 00:12:03,747 WARN Timer-3 com.hyperion.hbr.db.DBConnectionManager - Unable to create a new connection for jdbc:oracle:thin:@pep-prd-dbs.shopzone.com:1521:HRPROD
2012-11-05 00:12:03,747 FATAL Timer-3 com.hyperion.hbr.core.PluginDataManager - Error adding Plugin Data.
2012-11-05 00:12:04,777 WARN Thread-35 com.hyperion.hbr.db.DBConnectionManager - Unable to create a new connection for jdbc:oracle:thin:@pep-prd-dbs.shopzone.com:1521:HRPROD

2012-11-05 11:40:14,059 WARN [ACTIVE] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)' com.hyperion.hbr.security.HbrSecurityAPI - Error retrieving user by identity




At 11:30, Nov 6, I started the services and it worked fine.

Please let me know the reasons behind that.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 6 2012
Added on Nov 6 2012
#business-intelligence-applications, #epm, #hyperion, #performance-management-applications, #planning, #planning-and-budgeting, #services
10 comments
981 views