TRC 3.1.0.2 Genomic Query Slow (Doc ID 2280271.1)

Last updated on JUNE 25, 2017

Applies to:

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

Symptoms

On : 3.1.0.2 version, Performance

ACTUAL BEHAVIOR
---------------
When attempting to run a Cohort Query under Genomic Data selecting Copy Number Variation and using ALL in Gene Region, the application does not respond and the hour glass just continue to appear.

EXPECTED BEHAVIOR
-----------------------
Customer expect the the process to complete successfully.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Logon to Cohort
2) Select Cohort Query
3) Select Genomic Data
4) Select Copy Number Variation
5) In CNV location
  Select Adhoc then select BRAF
  Click on Count Unique Genes and will give 1 Gene
  In Gene Region - within Start to End
  Submit
  Save Query - VC_Q1
  Run Query
  Completed successfully

6) Edit the Query
  Change Gene Region to ALL
  Submit
  Save Query - VC_q2
  Run Query
  The hour glass just continue on.



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