Unable to Start Web Analysis and Receive Error: "Could not start critical service..all services are being rolled back" (Doc ID 1497284.1)

Last updated on DECEMBER 13, 2016

Applies to:

Hyperion BI+ - Version 11.1.2.2.000 to 11.1.2.2.000 [Release 11.1]
Information in this document applies to any platform.
8.13.15

Symptoms

Unable to start Web Analysis and receive the following errors:

From Webanalysis0.log:

 ####<Sep 26, 2012 2:19:06 PM EDT> <Info> <Common>  <WebAnalysis0> <[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <0000Jc3nDjwEwGG5yzl3iW1GOoRJ000001> <1348683546487> <BEA-000628> <Created "1" resources for pool "EPMSystemRegistry", out of which "1" are available and "0" are unavailable.>
####<Sep 26, 2012 2:19:16 PM EDT> <Error> <HTTP> <WebAnalysis0> <[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <0000Jc3nDjwEwGG5yzl3iW1GOoRJ000001> <1348683556969> <BEA-101216> <Servlet: "InitServlet" failed to preload on startup in Web application: "WebAnalysis".
com.hyperion.atf.services.ServiceManager$ServiceRecursiveInitException: Could not start critical service: "assignable.admin", all services are being rolled back.

 

From WebAnalysisAtf.log:

[2012-09-26T14:19:13.301-04:00] [WebAnalysis0] [WARNING] [] [oracle.webanalysis.atf] [tid: 25] [userId: <anonymous>] [ecid: 0000Jc3nDjwEwGG5yzl3iW1GOoRJ000001,0] [APP: WEBANALYSIS#11.1.2.0] [SRC_METHOD: validateConnection] [SRC_CLASS: org.apache.ojb.broker.accesslayer.ConnectionFactoryPooledImpl$ConPoolFactory] Validation query for connection failed, discard connection. Query was select count(*) from ATF_APPS, Message was ORA-00942: table or view does not exist[[

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms