ALM_BI_Transformation Fails With ORA-01652: unable to extend temp segment by 128 in tablespace TEMP Errors
(Doc ID 2475568.1)
Last updated on JULY 28, 2019
Applies to:Oracle Financial Services Asset Liability Management Analytics - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Business Intelligence Enterprise Edition (OBIEE)
Oracle Financial Services Asset Liability Management Analytics (ALMBI)
On ALMBI 8.0.5, the ALM_BI_TRANSFORMATION failed with ORA error in FSI_MESSAGE_LOG table. The environment has sufficient TEMP tablespace, around 14GB, and there is not much data for either of the FSI_ instrument tables (each with less than 10000 records only). However, the following error was reported:
Insert Failed from fsi_o_process_cash_flows to FCT_PROCESS_CASHFLOW: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
The issue can be reproduced at will with the following steps:
1. Run ALMBI Transformation
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