Error ORA-32319 from alert_ehealth.log

book

Article ID: 4518

calendar_today

Updated On:

Products

EHEALTH CA eHealth

Issue/Introduction

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 

Cause

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

 

 

Environment

ehealth 6.3.2 xxall Platforms

Resolution

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