Cohort Report- Genomic Report in Subject Context Takes a Long Time to Retrieve Results (Doc ID 2184180.1)

Last updated on MARCH 26, 2017

Applies to:

Oracle Healthcare Translational Research - Version 3.1.0.2 and later
Information in this document applies to any platform.

Symptoms

ISSUE CLARIFICATION
==================
After upgrading from Oracle Healthcare Translational Research (TRC) 3.0.2.1 to 3.1.0.2,

ACTUAL BEHAVIOR  
---------------------
Running a Cohort Report in Subject context using Mutated Gene Frequency and Gene Expression
and clicking on "Show Variant Viewer" is causing the application to not responding after 40 minutes of waiting for it to complete.
The same query is completed in about 1 minute in case of Patient context.

EXPECTED BEHAVIOR
-----------------------
Expected to see the outcome of the Cohort Report at reasonable response time.

STEPS
-----------------------
The issue can be reproduced with the following steps:
1. Subject Context
2. Cohort size -361 subjects. There should be 722 samples, 1143 variants
3. Click on Genomic Reports- Gene Level Reports
4. Select Mutated Gene Frequency--> Adhoc list--> PIK3CA -- Submit
5. After 33 mins it says Fetching Data but no data is retrieved

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