My Oracle Support Banner

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 and later
Information in this document applies to any platform.


After upgrading from Oracle Healthcare Translational Research (TRC) to,

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 to see the outcome of the Cohort Report at reasonable response time.

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


To view full details, 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 a vibrant support community of peers and Oracle experts.