TECH TIP: discovery server issues - data not populating - Invalid object name 'NAS_CS_STATE_MONITOR'

Document created by casph02 Employee on Oct 11, 2016Last modified by casph02 Employee on Oct 15, 2018
Version 5Show Document
  • View in full screen mode

In very rare circumstances, a nas table becomes corrupted or otherwise inaccessible.

This article discusses the steps needed to correct this scenario.



Article Contents:



After an upgrade of UIM, we noticed several symptoms related to discovery server:

  1. discovery_server queue is empty
  2. (new) devices are not appearing in UMP
  3. (new) devices are not being inserted to the database
  4. see discovery_server complaining about 'NAS_CS_STATE_MONITOR' in the logs:

10 Oct 2016 13:58:46,383 [probeDiscovery-1] ERROR com.nimsoft.discovery.common.util.ExceptionUtil - Error importing device: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar []; nested exception is Invalid object name 'NAS_CS_STATE_MONITOR'.



This issue was found after upgrading from UIM 8.2 --> UIM 8.42.

This information is generally applicable to most versions of UIM.



This was found to be related to corrupted data being stored in the NAS tables that causes issue during the upgrade process.







Additional Information:


This issue has only been seen in a few environments - it's very rare.

The steps above provide a permanent resolution.

1 person found this helpful