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)
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.
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