BSP Initialization Failing With "Balance Sheet Planning Initialization Failed. Please Refer the Log File" Error in UI (Doc ID 2082699.1)

Last updated on DECEMBER 29, 2016

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 6.0.1 and later
Information in this document applies to any platform.
Oracle Financial Services Balance Sheet Planning (BSP)
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

While doing BSP initialization, the process is failing with error "Balance Sheet Planning Initialization failed. Please refer the log file" in UI and additional errors in the following log files:

ERROR

In bsplog.log :

2015-10-05 15:05:27,012 [INFO] [[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] com.hyperion.planning.utils.HspBSPInitializer - Exception :Checkerror: [Ljava.lang.StackTraceElement;@1cd24157
2015-10-05 15:05:27,013 [ERROR] [[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] com.hyperion.planning.utils.HspBSPInitializer - com.hyperion.planning.HspRuntimeException: The form failed to import. Please see log for details.
com.hyperion.planning.HspRuntimeException: The form failed to import. Please see log for details.
at com.hyperion.planning.utils.HspFormDefUtil.ImportForm(HspFormDefUtil.java:69)
at com.hyperion.planning.utils.HspFormDefUtil.ImportForm(HspFormDefUtil.java:45)
at com.hyperion.planning.HspFormLoader.load(HspFormLoader.java:28)
at com.hyperion.planning.utils.HspBSPInitializer.initialize(HspBSPInitializer.java:1502)
at com.oracle.bsp.ui.configuration.servlet.UserConfiguration.doPost(UserConfiguration.java:251)
......................................
2015-10-05 15:05:27,063 [INFO] [[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] com.hyperion.planning.utils.HspBSPInitializer - Following artifacts could not be loaded: [Year.xml, Financial Plan_C2.xml, Loan Fees_C2.xml, Financial Plan Delinquency Expense_C2.xml, Financial Plan Average Bal_C2.xml, Deposit Service Charges_C2.xml, Loan Fee Annual_C2.xml, Deposit Service Charge Annual_C2.xml, Delinquencies Expense_C2.xml, Financial Plan Default_C2.xml, Chart of Account Characteristics_C2.xml, Version Attribute Definition_C2.xml, Scenario Attribute Definition_C2.xml, Intercompany Accounts and Eliminations_C2.xml, Chart of Account Characteristics - Single COA_C2.xml, Waiver COA Mapping_C2.xml, Synchronization for Expense Accounts_C2.xml, Synchronization for Balance Accounts_C2.xml, Modeling Delinquencies_C2.xml, Master Maintenance_C2.xml, Counterparty Entity Mapping_C2.xml, Offset COA Mapping_C2.xml, Non-Interest Income COA Mapping_C2.xml, Balance Function_C2.xml, Balance Spread_C2.xml, Balance Function Default_C2.xml, Maturity Mix Default_C2.xml, Maturity Mix Override_C2.xml, Interest Rate Scenario_C2.xml, Economic Indicator Scenario_C2.xml, Currency Rate Scenario_C2.xml, Calculate Deliquencies Expenses_C2.xml, Process Attributes_C2.xml]
2015-10-05 15:05:27,063 [INFO] [[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] com.hyperion.planning.utils.HspBSPInitializer - checkErrors: [Year.xml, Financial Plan_C2.xml, Loan Fees_C2.xml, Financial Plan Delinquency Expense_C2.xml, Financial Plan Average Bal_C2.xml, Deposit Service Charges_C2.xml, Loan Fee Annual_C2.xml, Deposit Service Charge Annual_C2.xml, Delinquencies Expense_C2.xml, Financial Plan Default_C2.xml, Chart of Account Characteristics_C2.xml, Version Attribute Definition_C2.xml, Scenario Attribute Definition_C2.xml, Intercompany Accounts and Eliminations_C2.xml, Chart of Account Characteristics - Single COA_C2.xml, Waiver COA Mapping_C2.xml, Synchronization for Expense Accounts_C2.xml, Synchronization for Balance Accounts_C2.xml, Modeling Delinquencies_C2.xml, Master Maintenance_C2.xml, Counterparty Entity Mapping_C2.xml, Offset COA Mapping_C2.xml, Non-Interest Income COA Mapping_C2.xml, Balance Function_C2.xml, Balance Spread_C2.xml, Balance Function Default_C2.xml, Maturity Mix Default_C2.xml, Maturity Mix Override_C2.xml, Interest Rate Scenario_C2.xml, Economic Indicator Scenario_C2.xml, Currency Rate Scenario_C2.xml, Calculate Deliquencies Expenses_C2.xml, Process Attributes_C2.xml]
2015-10-05 15:05:27,064 [INFO] [[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] com.oracle.bsp.ui.configuration.servlet.UserConfiguration - Exception occured com.hyperion.planning.HspRuntimeException: Failed to enable Human Capital Planning. Please see log for details
2015-10-05 15:05:27,064 [INFO] [[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] com.oracle.bsp.ui.configuration.servlet.UserConfiguration - Exception occured [Ljava.lang.StackTraceElement;@1cde0278
2015-10-05 15:05:27,064 [ERROR] [[ACTIVE] ExecuteThread: '4' for queue: 'weblogic.kernel.Default (self-tuning)'] com.oracle.bsp.ui.configuration.servlet.UserConfiguration - com.hyperion.planning.HspRuntimeException: Failed to enable Human Capital Planning. Please see log for details
com.hyperion.planning.HspRuntimeException: Failed to enable Human Capital Planning. Please see log for details
at com.hyperion.planning.utils.HspBSPInitializer.checkErrors(HspBSPInitializer.java:1670)
at com.hyperion.planning.utils.HspBSPInitializer.initialize(HspBSPInitializer.java:1530)
at com.oracle.bsp.ui.configuration.servlet.UserConfiguration.doPost(UserConfiguration.java:250)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

 

In Planning.log:

####<Oct 9, 2015 2:36:21 PM IST> <Info> <JDBC> <hypap501> <Planning0> <[ACTIVE] ExecuteThread: '2' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1444381581327> <BEA-001128> <Connection for pool "EPMSystemRegistry" has been closed.>
####<Oct 9, 2015 2:53:39 PM IST> <Error> <HTTP> <hypap501> <Planning0> <[ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <0058QY8ju8J7a6GWQxw0zt00020^000CZD> <1444382619077> <BEA-101020> <[ServletContext@473891916[app:HyperionPlanning module:HyperionPlanning path:/HyperionPlanning spec-version:2.5]] Servlet failed with Exception
javax.el.PropertyNotFoundException: Target Unreachable, 'SysAdminBean' returned null
    at com.sun.el.parser.AstValue.getTarget(AstValue.java:108)
    at com.sun.el.parser.AstValue.setValue(AstValue.java:160)
    at com.sun.el.ValueExpressionImpl.setValue(ValueExpressionImpl.java:273)
    at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executeBindings(LifecycleImpl.java:780)
    at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executeBindings(LifecycleImpl.java:851)
    at oracle.adfinternal.view.faces.lifecycle.LifecycleImpl._executeBindings(LifecycleImpl.java:851)

.............................

####<Oct 9, 2015 2:53:39 PM IST> <Notice> <Diagnostics> <hypap501> <Planning0> <[STANDBY] ExecuteThread: '3' for queue: 'weblogic.kernel.Default (self-tuning)'> <<WLS Kernel>> <> <> <1444382619132> <BEA-320068> <Watch 'UncheckedException' with severity 'Notice' on server 'Planning0' has triggered at Oct 9, 2015 2:53:39 PM IST. Notification details:
WatchRuleType: Log
WatchRule: (SEVERITY = 'Error') AND ((MSGID = 'WL-101020') OR (MSGID = 'WL-101017') OR (MSGID = 'WL-000802') OR (MSGID = 'BEA-101020') OR (MSGID = 'BEA-101017') OR (MSGID = 'BEA-000802'))
WatchData: DATE = Oct 9, 2015 2:53:39 PM IST SERVER = Planning0 MESSAGE = [ServletContext@473891916[app:HyperionPlanning module:HyperionPlanning path:/HyperionPlanning spec-version:2.5]] Servlet failed with Exception
javax.el.PropertyNotFoundException: Target Unreachable, 'SysAdminBean' returned null
    at com.sun.el.parser.AstValue.getTarget(AstValue.java:108)
    at com.sun.el.parser.AstValue.setValue(AstValue.java:160)
    at com.sun.el.ValueExpressionImpl.setValue(ValueExpressionImpl.java:273)

................................

SUBSYSTEM = HTTP USERID = <WLS Kernel> SEVERITY = Error THREAD = [ACTIVE] ExecuteThread: '5' for queue: 'weblogic.kernel.Default (self-tuning)' MSGID = BEA-101020 MACHINE = hypap501 TXID =  CONTEXTID = 0058QY8ju8J7a6GWQxw0zt00020^000CZD TIMESTAMP = 1444382619077  
WatchAlarmType: AutomaticReset
WatchAlarmResetPeriod: 30000


The issue can be reproduced at will with the following steps:

1. Application was deleted from Planning administration->Manage applications.
2. The BSP data-source was deleted from Weblogic data-sources, dropped and recreated new schemas for Planning application and for BSP.
3. Restarted the services
4. The new planning Application was created with the same name and with newly created schema
5. Re-initialize BSP it failed with error.

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