Skip to main content
Waters

Oracle errors when trying to restore old projects: "OCI INVALID HANDLE" and "ORA-00942: table or view does not exist" - WKB89987

Article number: 89987

SYMPTOMS

  • Oracle errors when trying to restore old projects:  "OCI_INVALID_HANDLE" and "ORA-00942: table or view does not exist"

ENVIRONMENT

  • Empower 3
  • Feature Release 4
  • Service Release 2

CAUSE

Unknown

FIX or WORKAROUND

Upgrade to Service Release 3.  

ADDITIONAL INFORMATION

Prior to Empower 3 Service Release 3, projects created in Empower software received a fixed tablespace quota. Now, projects do not receive quotas; instead, they utilize as much disk space as needed, up to the limit of available drive space. This increases processing capabilities, as tablespace quotas no longer constrain result collection. It also improves performance; Empower no longer inspects project quotas at login or when creating, restoring, or cloning projects. Existing projects also receive unlimited quotas.

id89987, EMP2LIC, EMP2OPT, EMP2SW, EMP3GC, EMP3LIC, EMP3OPT, EMP3SW, EMPGC, EMPGPC, EMPLIC, EMPOWER2, EMPOWER3, EMPSW, SUP

Not able to find a solution? Click here to request help.