DX Infrastructure Management

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

10-11-2016 11:25 AM

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

This article discusses the steps needed to correct this scenario.

 

 

Article Contents:

 

Problem: 

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 com.microsoft.sqlserver.jdbc.SQLServerException: Invalid object name 'NAS_CS_STATE_MONITOR'.

 

Environment:  

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

This information is generally applicable to most versions of UIM.

 

Cause: 

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

 

Resolution:

 

 

DIRECT LINK TO ARTICLE

 

Additional Information:

 

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

The steps above provide a permanent resolution.

Statistics
0 Favorited
0 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Comments

10-15-2018 01:27 PM

I have updated the link.

Let me know if you see any issues accessing it!

 

Phil

10-12-2018 03:05 PM

Could we get the correct url for the direct link, the current one opens up as not found?

10-12-2016 02:32 AM

Very interesting post.

Does someone know how this could be applied to MySQL ?
Thanks

Daniel

Related Entries and Links

No Related Resource entered.