My Oracle Support Banner

OHF 7.3 Installation Fails with 'ORA-04063: view "CDM.W_EHA_OBSV_PATIENT_H_VB" has errors Rule pragma err forever ^ORA-.*' (Doc ID 2717930.1)

Last updated on OCTOBER 14, 2020

Applies to:

Oracle Healthcare Foundation - Version 7.3 and later
Information in this document applies to any platform.

Symptoms

Oracle Healthcare Foundation - Version 7.3 and later

When upgrading from OHF 7.1.1 to OHF 7.3, the following error occurs.

ERROR
-----------------------
5 Errors

*********************************************************************************************************************
Line 936982: FAIL 124: 'ORA-04063: view "CDM.W_EHA_OBSV_PATIENT_H_VB" has errors', Rule 'pragma err forever ^ORA-.*'
*********************************************************************************************************************
new 31: C.TABLE_NAME||' from cga';
old 36: C.TABLE_NAME||' from &&application_user; error: '||SQLERRM(SQLCODE));
new 36: C.TABLE_NAME||' from cga; error: '||SQLERRM(SQLCODE));
old 53: grantee=upper('&&application_role')
new 53: grantee=upper('OHF_APPLICATION_ROLE')
old 66: C.TABLE_NAME||' to &&application_user';
new 66: C.TABLE_NAME||' to cga';
old 71: C.TABLE_NAME||' to &&application_user; error: '||SQLERRM(SQLCODE));
new 71: C.TABLE_NAME||' to cga; error: '||SQLERRM(SQLCODE));
ERROR executing revoke SELECT ON W_EHA_OBSV_PATIENT_H_VB from cga; error:
ORA-04063: view "CDM.W_EHA_OBSV_PATIENT_H_VB" has errors
BEGIN
*
ERROR at line 1:
ORA-04063: view "CDM.W_EHA_OBSV_PATIENT_H_VB" has errors

*********************************************************************************************************************
Line 936986: FAIL 128: 'ORA-04063: view "CDM.W_EHA_OBSV_PATIENT_H_VB" has errors', Rule 'pragma err forever ^ORA-.*'
*********************************************************************************************************************
new 53: grantee=upper('OHF_APPLICATION_ROLE')
old 66: C.TABLE_NAME||' to &&application_user';
new 66: C.TABLE_NAME||' to cga';
old 71: C.TABLE_NAME||' to &&application_user; error: '||SQLERRM(SQLCODE));
new 71: C.TABLE_NAME||' to cga; error: '||SQLERRM(SQLCODE));
ERROR executing revoke SELECT ON W_EHA_OBSV_PATIENT_H_VB from cga; error:
ORA-04063: view "CDM.W_EHA_OBSV_PATIENT_H_VB" has errors
BEGIN
*
ERROR at line 1:
ORA-04063: view "CDM.W_EHA_OBSV_PATIENT_H_VB" has errors
ORA-06512: at line 38
ORA-06512: at line 38

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run the installer
2. Error occurred.

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.