OLT session report generation fail with ORA-01652 unable to extend temp segment by 128 in tablespace TEMP
(Doc ID 2666209.1)
Last updated on AUGUST 26, 2024
Applies to:
Oracle Application Testing Suite - Version 12.5.0.3 and laterInformation in this document applies to any platform.
Symptoms
Unable to generate reports. The report generator displays data, but does not complete.
wls_oats.log
--------------------
2020-04-21 00:49:42,406 DEBUG [SessionReportPool] Session Report Key Generated: 182.20.2_BT20213_Reliability_18Apr2020.NoThinkTime.TimeFilterActive=false.en
2020-04-21 00:49:42,608 ERROR [Query] Query: Name: detail.last
Rule: null
Col names:
SQL: FileName: report_performance_stats.xml
Name: detail.last
EngineConfig: oracle.oats.reports.EngineConfig@6748d2d0
Parameter: sessionName=20.2_BT20213_Reliability_18Apr2020 (-1)
Parameter: thinkTime=false (-1)
Parameter: counterName=Avg Server Time (sec)% (0)
Parameter: col=2 (0)
Parameter: timeFilterActive=false (0)
Parameter: currentLocalTimestamp=2020/04/21 00:37:44 (0)
Parameter: scriptLevelOnly=false (0)
Parameter: database=oracle (0)
There are 8 parameters
[1]: Parameter: sessionName=20.2_BT20213_Reliability_18Apr2020 (-1)
[2]: Parameter: thinkTime=false (-1)
[3]: Parameter: counterName=Avg Server Time (sec)% (0)
[4]: Parameter: col=2 (0)
[5]: Parameter: timeFilterActive=false (0)
[6]: Parameter: currentLocalTimestamp=2020/04/21 00:37:44 (0)
[7]: Parameter: scriptLevelOnly=false (0)
[8]: Parameter: database=oracle (0)
2020-04-21 00:49:42,611 ERROR [ReportException]
java.sql.SQLException: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Changes
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 |
Changes |
Cause |
Solution |