NAS log throws Invalid Object Name errors

Document ID : KB000033963
Last Modified Date : 21/02/2019
Show Technical Document Details
Issue:
[Microsoft OLE DB Provider for SQL Server] Invalid object name 'NAS_TRANSACTION_LOG' and [Microsoft OLE DB Provider for SQL Server] Invalid object name 'NAS_ALARM_NOTE'  nas 4.20/4.34/4.36

 
Resolution:
1. Deactivate the nas probe

2. Using the SLM or SLM portlet DROP the nas tables (drop them again even if you did it previously)
DROP TABLE NAS_VERSION;
DROP TABLE NAS_ALARMS;
DROP TABLE NAS_TRANSACTION_SUMMARY;
DROP TABLE NAS_TRANSACTION_LOG;
DROP TABLE NAS_NOTES;
DROP TABLE NAS_ALARM_NOTE;

 
3. Activate nas
 
4. Check the logs to make sure the errors are gone.