CMS Snapshot Analysis - Run Analyzer - Error - Oracle Forms with Core CAST AIP - File date not found in the Knowledge Base 25184933 0

Following error is encountered during the analysis

Error : File's date not found in the Knowledge Base (25184933,0).
Error while reading last modification date of module's file.Error : FmPrse_Get_CastDBApplication_ByName : While loading application's modulesError : CFmPrse_FullAnalysisAdapter::VerifyWithExistingResult : While getting application  MY_APP  in Knowledge BaseError :
Error while verifying existing result Error : CFmPrse_FullAnalysisAdapter::I_PreValidateOptions: Invalid common analysis job options. See before.Error : CFmsAnalysisInfoAN::CheckFullAnalysis: while validating full analysis optionsError : FormsRuns_RunFullAnalysis: while transmitting job's options.

All the above message is related to the first message (File's date not found in the Knowledge Base).

First message stipulates the failure of Reading of the date of last modification of file in the Knowledge Base. This error is related to a corruption of the Knowledge Base

1. Run the below query against the Knowledge Base.

   insert into ObjProDat 
   select k.IdKey, op.IdPro, 0, 0, sysdate, 0 from Keys k join ObjPro op on k.IdKey = op.IdObj
   where ObjTyp = 107
   and not exists(select 1 from ObjProDat where IdObj = IdKey) 
   

2. Run the analysis again