Workbook Keeps Spinning And Eventually Timing Out When Referring To Big Volume Tables In Dataset (Doc ID 2958930.1)

Last updated on JULY 05, 2023

Applies to:

Symptoms

A connection is setup to connect to cloud database.

A dataset is setup with above connection by pulling four entire tables from Connection -> Database -> Schemas, and join them together. The four tables have data volume as below -

Table 1: 2M records
Table 2: 161.5M
Table 3: 23.7M
Table 4: 1.5M

Connection and dataset can be accessed and edit, but while creating workbook to refer to the dataset, screen keeps spinning and eventually timing out, even after trying to setup some additional filters to the workbook.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.