OFSA-43003: Insufficient freespace to create table or index in tablespace Error Running Transformation ID
(Doc ID 287044.1)
Last updated on MARCH 25, 2019
Applies to:Oracle Financial Data Manager - Version 4.5.39 and later
Information in this document applies to any platform.
Oracle Financial Data Manager - Version: 4.5.39
This problem can occur on any platform.
Running a Transformation ID results in an 'Internal Error' in Server Status and the following error is received in the server ofste.XXXXX log file :
Connect to database OFSA45 was successful.
Running --- Process ID: 101201, Configuration ID: 90004
Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:
OCI Function:  - oexec(), oexn()
SQL Function:  - PL/SQL EXECUTE
Oracle Error: ORA-20000: OFSA-44309: Error in block: Table Extents and Space
ORA-20000: OFSA-43003: Insufficient freespace to create table or index in tablespace: DATA_TS
ORA-06512: at "OFSAPPS.OFSA_DBA", line 5770
ORA-06512: at "OFSAPPS.OFSA_SQL", line 616
ORA-06512: at line 1
Driver Function: drv_oci::Execute()
SQL Statement: BEGIN OFSA_SQL.IA_CREATE_TABLE('OFSAPPS',101201,0,0,'LEDGER_STAT
','(((LEDGER_STAT.FINANCIAL_ELEM_ID = 100) OR (LEDGER_STAT.FINANCIAL_ELEM_ID = 4
20) OR ....
AUTOEXTENSIBLE='YES' for the datafiles which contain the DATA_TS and INDEX_TS tablespaces. Running a query on DBA_FREE_SPACE which does not take into account the "autofree" amounts returns very low space amounts.
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