Error ORA-32319 from alert_ehealth.log

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

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 

Environment:
ehealth 6.3.2 xxall Platforms
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

 

 

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