Temp And EDW_Data Table Space Issues (Doc ID 2133163.1)

Last updated on AUGUST 12, 2016

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.4 and later
Information in this document applies to any platform.

Symptoms

On : 7.9.6.4 version, BIAPPS Version 7x Transfers Only
Attempting to perform Full or incremental Load using SDE_ORA_APTransactionFact_Paymentsometimes cause Temp, temp1 and EDW_Data Table space issues on


W_AP_XACT_FS
W_AP_XACT_F
W_AR_XACT_F
W_ORA_GL_LINKAGE_INFO_AP_TMP

ERROR
-----------------------
SDE_ORA_APTransactionFact_Payment_log.txt:

)
Oracle Fatal Error].
2016-03-19 10:07:30 : ERROR : (8166 | READER_1_1_1) : (IS | HNI_OBIA_QA2_INTSVC) : node01_hniobiapp401.honi.com : BLKR_16004 : ERROR: Prepare failed.
2016-03-19 10:07:30 : INFO : (8166 | WRITER_1_*_1) : (IS | HNI_OBIA_QA2_INTSVC) : node01_hniobiapp401.honi.com : WRT_8333 : Rolling back all the targets due to fatal session error.
2016-03-19 10:07:30 : INFO : (8166 | WRITER_1_*_1) : (IS | HNI_OBIA_QA2_INTSVC) : node01_hniobiapp401.honi.com : WRT_8325 : Final rollback executed for the target [W_AP_XACT_FS] at end of load
2016-03-19 10:07:30 : INFO : (8166 | WRITER_1_*_1) : (IS | HNI_OBIA_QA2_INTSVC) : node01_hniobiapp401.honi.com : WRT_8035 : Load complete time: Sat Mar 19 10:07:30 2016


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Perform ETL using SDE_ORA_APTransactionFact_Payment
2. ETL fails at some point with the error above in the log


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, cannot load data into data warehouse to report against and analyze.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms