We are facing issue in our 8.2.2 environment after upgrade while purging the audit data.
We are getting below error while running the purging.
2014-03-25 16:22:21 CET [MOD.0120.0000I] com.wm.monitor.util.MonitorException: OTHER EXCEPTIONS OCCURRED!-942ORA-00942: table or view does not exist
at sun.reflect.GeneratedMethodAccessor401.invoke(Unknown Source)
We have done below steps as of now to resolve this issue as suggested by SAG.
- We droped and created archive database component again with latest version.
- We confirmed that Archive JDBC pool is connecting to the same schema where we recreated the archive component
- We updated Operations parameter table to have IS core audit and process audit schema names
After verifing these things we ran WmMonitor/pub.monitor.archive:serviceArchive and WmMonitor/pub.monitor.archive:processArchive services each time we are receiving error we have mentioned above.
We also checked that we are at current level of DB component archive , IS core Audit and Process Audit for our DCC version ( fix level). So Ideally there should not be any missing tables.
Even with increased logging level for monitor (Database) component we are not getting any specific pointer for the error we have mentioned.
Can you please let us know if we have missed any step which is causing this issue.
Also please share your thoughts on resolutionof this issue.
Thanks And Regards,
Ashish A Potnis