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


On : version, Performance

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

 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.

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

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


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