My Oracle Support Banner

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

Symptoms

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:

ERROR
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

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.