My Oracle Support Banner

Allocation Hangs During Batch Processing & ORA-1652 Found in Database Alert Log (Doc ID 1538437.1)

Last updated on NOVEMBER 13, 2019

Applies to:

Oracle Financial Services Profitability Management - Version 6.0 to 6.0.2 [Release 6]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Profitability Management (PFT) 6.x, when running a batch of Allocations, one or more of the Allocations hangs and gets stuck in the "Ongoing" status.  If you check the server where the $FIC_DB_HOME is located, you see an ofspa process on the server (using the command 'ps -ef|grep ofspa') but it does not appear to be processing any records.  If you kill the process manually and re-start the Allocation, it runs successfully the second time.  The issue occurs at random and not during every process run.

When you check the Oracle Database Alert log, you find the following error at approximately the same time the Allocation started to hang:

ORA-1652: unable to extend temp segment by 128 in tablespace   TEMP

It appears this error caused the Allocation to hang.

Note: You are using the Parallel Execution option available in the FSI_PARALLEL_PARAMETERS table to run multiple Allocation queries in parallel.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.