Dataflow Failing with “User Exceeded Per File or Overall Quota Limit” Despite Low Storage Usage

Subhakara Netala-Oracle

Hi,

We are facing repeated failures when executing a Dataflow in Oracle Analytics Cloud (OAC).

The error message is as follows:

[nQSError: 46267] Failed to stream data in chunk through HTTP request - {"prefix":"DSS","code":400301,"message":"User exceeded per file or overall quota limit","subMessage":"User has exceeded maximum allowed quota limit"}[nQSError: 46275] Failed to send the last data chunk through HTTP request to Server.[nQSError: 43232] Failed to populate data through HTTP request.[nQSError: 43267] Failed to finish parquet data chunked transfer in HTTP request.[nQSError: 43224] The Dataflow "Candidate Conversion 12th Mar_Current status" failed during execution.[nQSError: 43204] Asynchronous Job Manager failed to execute the asynchronous job.

However, the user who has utilized s only 6 GB of data usage out of the 50 GB default user quota, so I think the quota should not have been exceeded.

Any suggestions to fix this issue?

Thanks in advance.

Regards,

Subhakara Netala

Sumanth V -Oracle

@Subhakara Netala-Oracle - If you have chosen "Data Set Storage" to save the output data in the "Save Data" step in the data flow editor. It stores the data on to a file.
File size limit is 250M to save the output data in a data set in Oracle Analytics Cloud.

Kindly verify the same as well. Hope this helps!
Reference: Create Datasets from Files

Subhakara Netala-Oracle

Thanks for your reply @Sumanth V -Oracle. File size is around 150MB, so I think file size is not an issue. Below screenshot from the last refresh time, a week back.

SteveF-Oracle

Are you merging rows (with a union)?

Subhakara Netala-Oracle

Hi @SteveF-Oracle

Yes, there is are unions in Dataflow.