Upgrade fails with ORA-00942: table or view does not exist error

Document ID : KB000049778
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Upgrading eHealth 6.0 P04/D04 on Solaris 9 to eHealth 6.2.0 fails with the following error:

Received error "Database error: DbuDbApiApp::dbApiDropTypeViews (ORA-00942: table or view does not exist ORA-06512: at "EH.NH_DBAPI", l)."

Problem ticket: PRD00054264

Solution:

The issue documented above has been resolved in the following release(s):

eHealth 6.2.2

eHealth Service Packs are available for download from support.ca.com. Please review the README file for each Service Pack prior to installing. CA recommends that users always keep eHealth current by installing the latest Service Pack available.