"No space left on device" Error When Running GW simple Web Total and GW Simple Store

(Doc ID 2367267.1)

Last updated on APRIL 17, 2018

Applies to:

Oracle Warehouse Management Enterprise Edition Cloud Service - Version 8.0.2 and later
Information in this document applies to any platform.

Symptoms

While manually running the web report GW simple Web Total and GW Simple Store the following error occurs:

 

ERROR

DbConnect Exception: could not write to hash-join temporary file: No space left on device
at WebReports.Api.Data.DbConnect.Execute(String sqlStmt, ActiveLocalExecution execution, DataObjectCallType callType, SqlProcedureInfo sqlProcInfo)
at WebReports.Api.Data.SqlObject.Execute(ActiveLocalExecution execution, Boolean sortAndFilter)
at WebReports.Api.ExecuteData.ExecuteDataBuilder.Execute()
at WebReports.Api.Execute.ExecuteReport.GetExecuteDataTable()
at WebReports.Api.Execute.ExecuteReport.GetIntermediateData()
at WebReports.Api.Execute.ExecuteReport.GetExecutionData()
at WebReports.Api.Execute.ExecuteReport.CreateDownloadFile(wrExportType exportType)
at WebReports.Api.Execute.ExecuteReport.Process()

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