TR: ORA-00942 Table Of View AND "The File Was Not Downloaded Or Was Not Downloaded Correctly" Errors (Doc ID 2289822.1)

Last updated on AUGUST 21, 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.4 version, Performance

When attempting to export a cohort list after applying patch 3.1.04,
the following error occurs.

ERROR
-----------------------
 Error
 Messages to this page are listed below.
 ORA-00942: table or view does not exist
 The file was not downloaded or was not downloaded correctly.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Logon to Cohort
2) Cohort Viewer -> Cohort List ->Select 1 Query -> Click on Export
3) The export process will take sometime to complete Do you want to continue?
4) Click OK

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Customer cannot move patch TRC 3.1.0.4 patch to production.
Production is not being used due to TRC 3.1.0.2 issues.

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