Hyperion Reporting and Analysis server running of localhost at

gaoyiming

Applies to:
Hyperion BI+ - Version: 11.1.1.3.00 and later [Release: 11.1 and later ]

Symptoms
Unable to log into Oracle EPM Workspace Receiving error "Could not find a Hyperion Reporting and Analysis server running of localhost at port 6800. Please verify your server connect string and confirm that the server is up" error.

server_messages_SearchKeywordProvider.log shows
<event logger="com.hyperion.changemgmt.jdbc.PersistenceManager" timestamp="1279738044735" level="ERROR" thread="Foundation Server" sequence_no="282">
<time>21 Jul 2010 14:47:24,735</time>
<context originator_type="SearchKeywordProvider" originator_name="SK_00000129f65415b1-0000-36a3-0a03964c_jazz" host="jazz"/>
<message><![CDATA[SqlStatement('UPDATE V8_KPS_ACTION_QUEUE SET lock_owner=NULL, lock_time=NULL WHERE lock_owner=?', 'jazz')]]
</message>
</event>
<event logger="com.hyperion.wsearch.keywords.SearchKeywordProviderEngine" timestamp="1279738044742" level="ERROR" thread="Foundation Server" sequence_no="283">
<time>21 Jul 2010 14:47:24,742</time>
<context originator_type="SearchKeywordProvider" originator_name="SK_00000129f65415b1-0000-36a3-0a03964c_jazz" host="jazz"/>
<message><![CDATA[Exception in SearchKeywordProviderEngine.startService()]]></message>
<throwable><![CDATA[java.sql.SQLException: [Hyperion][DB2 JDBC Driver][DB2]The transaction log for the database is full.

Cause
V8_KPS_ACTION_QUEUE fills and exceeds the database quota for the Hyperion application. This prevents the service from completing its startup.

Solution
Truncate data from the table V8_KPS_ACTION_QUEUE or use utility resetSearchIndex.bat under the location Hyperion\common\workspacert\9.5.0.0\bin

该贴已经同步到 gaoyiming的微博

微博评论

[晕]神马呀！

来自 小花猫YC 的新浪微博