DX Infrastructure Management

  • Private Community
 View Only
Back to Library

Tech Tip : NAS will not write UIM alarm into database after upgrade. 

Sep 07, 2016 08:28 PM

Document ID:  TEC000005312
Last Modified Date:  10/21/2015
Hide Technical Document Details

Products

  • CA Unified Infrastructure Management

Components

  • UIM NAS:UIMNAS
Issue:
The NIS Bridge thread will not start after a NAS probe upgrade to 4.73.

Symptoms:
The new alarms (Alarms happened after NAS probe upgrade) are visible in IM tool (Alarm Window in Infrastructure Manager). However, no new UIM alarms are visible in UMP - USM.

You may see SQL errors in nas.log

 

nas: sqlserver-nis-create.sql:65 - Query timeout expired
nas: sqlserver-nis-create.sql:65 - [0x80040e31] IDispatch error #3121 - [Microsoft OLE DB Provider for SQL Server] Query timeout expired, statement: --#NIS_BRIDGE_UPDATE_V8 SECTION START
ALTER TABLE NAS_TRANSACTION_SUMMARY ADD insert_count bigint constraint defaultzero default (0) not null
nas: sqlserver-nis-create.sql:68 - Column name 'insert_count' does not exist in the target table or view.
nas: sqlserver-nis-create.sql:68 - [0x80040e14] IDispatch error #3092 - [Microsoft OLE DB Provider for SQL Server] Column name 'insert_count' does not exist in the target table or view., statement:
CREATE NONCLUSTERED INDEX [NAS_IDX_TRANS_SUMMARY_03]    ON [dbo].[NAS_TRANSACTION_SUMMARY]    ([insert_count])
nas: COM Error [0x80040e14] IDispatch error #3092 - [Microsoft OLE DB Provider for SQL Server] Invalid column name 'insert_count'.
nas: Update to schema version 9 failed. Reverting schema version to 8 to try again
nas: NiS Bridge is unable to start, retrying: XX

 

Environment:
- Windows 2008 R2
- NAS 4.73
- CA UIM version 8.2
- Microsoft SQL Server 2008 R2

 

Cause:
The NAS probe has "schema versioning" information in NAS_VERSION table.
Since NAS 4.73 has schema versioning "9", the probe checks the versioning first, and if a lower version is detected, it runs some SQL to update the schema. The SQL statement is described in <NAS>/<Database>-nis-create.sql

In this case, the previous NAS versioning was "8", and NAS 4.73 runs statements in NIS_BRIDGE_UPDATE_V8 SECTION

 

However, in a large UIM environment, NAS_TRANSACTION_SUMMARY table with large size, SQL statements (such as ALTER TABLE) may take an extremely long time to finish.

The problem is that NAS probe runs SQL through Microsoft OLE DB Provider (a.k.a ADO) which has a default 30 seconds for its timeout.  If a query takes an extremely long time, it fails with a timeout. As a result, schema update fails, then NIS Bridge not start.

Resolution:

http://www.ca.com/us/support/ca-support-online/product-content/knowledgebase-articles/tec000005312.aspx 

Statistics
0 Favorited
3 Views
0 Files
0 Shares
0 Downloads

Tags and Keywords

Related Entries and Links

No Related Resource entered.