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

Document created by Yu_Ishitani Employee on Sep 8, 2016Last modified by Melissa Potvin on Dec 17, 2016
Version 4Show Document
  • View in full screen mode

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 

Attachments

    Outcomes