Upgrade Hangs During Sandbox Resave Step at Message 'Triggering update for all SANDBOXES' (Doc ID 2290165.1)

Last updated on JULY 31, 2017

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.4 and later
Oracle Financial Services Hedge Management and IFRS Valuations - Version 8.0.4 and later
Oracle Financial Services Profitability Management - Version 8.0.4 and later
Oracle Financial Services Asset Liability Management - Version 8.0.4 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

When installing Oracle Financial Services Hedge Management and IFRS Valuations (HM) 8.0.4, the installation process hangs on the Sandbox Resave utility:

Triggering the sandbox re-save utility to update the constraint names in sandbox definition xmls
Triggering update for all SANDBOXES.


The following messages exist in the Update.log from $FIC_HOME/utility/sandboxutil/logs:

[MF][SandboxUtil][regenerateSandboxXML]Inside regenerateSandboxXML
[MF][SandboxUtil][regenerateSandboxXML]XML regeneration started for sandbox code -> 1499804874921, infodom -> SANDBXINFO
[MF][SandboxUtil][createConstraintsXML]Inside createConstraintsXML
[MF][SandboxUtil][createConstraintsXML]Get sandbox object for sandbox infodom -> SANDBXINFO
[MF][SandboxUtil][getSandbox]Inside getSandbox
[MF][SandboxUtil][getSandbox]Firing query to get details for sandbox infodom -> SANDBXINFO
[MF][SandboxUtil][getSandbox]Getting sandbox object for sandbox code -> 1499804874921
[MF][SandboxUtil][getSandbox]Retrieved sandbox object for sandbox code -> 1499804874921
[MF][SandboxUtil][createConstraintsXML]Calling generate query xmls

The process hangs at this point.

Additionally, the nohup.out from $FIC_APP_HOME/common/FICServer/bin contains the following error during the time when the install is running:

Exception in thread "JSockConn Thread #2" Exception in thread "Thread-1" java.lang.OutOfMemoryError: Java heap space

The error's stack trace references "SandboxServiceHandler" and "DatabaseModelReader".

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