You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Dataflow run in OAC fails with a configuration having 36CPUs, that is supposed to return about 3lakh

Received Response
14
Views
4
Comments
edited Nov 29, 2019 4:18AM in Oracle Analytics 4 comments

Summary

Dataflow run in OAC fails for a huge recordset with a highend configuration

Content

Hi,

I've created a dataflow that I am expecting to return 3lakhs of records from ADW. As this is a huge dataset, I have created an OAC instance with 36 OCPUs. As per the documentation @ https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsom/create-services-oracle-analytics-cloud.html#GUID-164D8568-9AE3-4A74-9F1A-0D87B78713C9, this configuration is supposed to support retrieval of about 22lakhs of records.

However, when I run the dataflow with this huge configuration, it runs for about 10min and then fails. When I click on "View Details", it says, "The user request exceeded the maximum query governing execution time." (attached this screenshot).

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!