ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Error ORA-32319 from alert_ehealth.log


Article ID: 4518


Updated On:


CA eHealth


Unable to Add or delete an element using oneclick. Oracle alert log file contains 

On commit 

MV EHEALTH.NH_GROUP_CONTENT_TYPES was not refreshed successfully.

On commit 

MV EHEALTH.NH_GROUP_ALL_MEMBERS_GM was not refreshed successfully.

Number of MV refresh failures: 2.

Encountered error 


Error code: ORA-32319

Cannot use direct Oracle loader log to FAST REFRESH materialized view "string"."string"

due to the fact that the direct Oracle loader log might have been dropped




ehealth 6.3.2 xxall Platforms


Take a Backup of the eHealth Database : nhSaveDb -p < Path where the Backup needs to be saved.tdb> -ascii

Run the command : nhiDbTasks -recreateMViews all