NAS log throws Invalid Object Name errors

book

Article ID: 33963

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

[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

 

Environment

Release:
Component: UIMNAS

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.