sqlserver probe is missing message text

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

When looking at the status in the IM GUI or for any alarms generated by the probe, there is no message text.

Checking the sqlserver_monitor.cfg file, we see the following in the messages section:

<messages>
</messages>

Environment

• UIM 20.4+
• sqlserver 5.62

Cause

The messages section of the sqlserver_monitor.cfg file was removed (possibly due to some corruption or mistake).

Resolution

Do one of the following:

• Copy the messages from another server
  • Open the config of a working sqlserver probe
  • Copy the messages section  (a default messages section can also be found in the Additional Information below)
  • Paste these messages into the non-working configuration file
  • Deactivate/Activate the probe
    
    ---or---
    
    
• Downgrade the probe and then upgrade probe to update these keys

Additional Information

The below text can be used as a replacement:

<messages>
   default_1 = Profile $profile, alarm for checkpoint '$check' cleared, no message text found, default used
   default_2 = Profile $profile, alarm for checkpoint '$check' raised, no message text found, default used
   default_3 = Profile $profile, instance $instance, object: $object - alarm cleared
   query_error_1 = Profile $profile, checkpoint $check, query returns data in unsupported format, error msg: $errmsg
   query_error_2 = Profile $profile, checkpoint $check, unauthorized query change, checkpoint deactivated
   query_error_3 = Profile $profile, checkpoint $check, query execution did not run successfully, error msg: $errmsg
   sql_timeout_1 = Profile $profile, instance $instance, checkpoint '$check' - query timed out!
   p_timeout_1 = Profile $profile timed out, the probe may be hanging!
   timeout_clear_1 = Profile $profile, instance $instance, timeout condition has been cleared.
   check_dbalive_1 = Profile $profile, instance $instance, is ONLINE!
   check_dbalive_2 = Profile $profile, Cannot connect to database instance $instance: ($errmsg).
   database_size_1 = Profile $profile, instance $instance, database $object is examined and cleared (db-size $database_size)
   database_size_2 = Profile $profile, instance $instance, database $object has $database_size allocated (free space $free_space/$free_pct%)
   buf_cachehit_ratio_1 = Profile $profile, instance $instance, buffer cache hit-ratio ($hit_ratio%) is examined and cleared
   buf_cachehit_ratio_2 = Profile $profile, instance $instance, buffer cache hit-ratio ($hit_ratio%) is too low
   lock_requests_1 = Profile $profile, instance $instance, object '$object' lock requests have been examined and cleared
   lock_requests_2 = Profile $profile, instance $instance, object '$object' has $count_sec lock requests per second
   database_state_1 = Profile $profile, instance $instance, database $object state have been examined and cleared
   database_state_2 = Profile $profile, instance $instance, database $object state is $state_desc
   log_cachehit_ratio_1 = Profile $profile, instance $instance, database $object log cache hit-ratio ($hit_ratio%) is examined and cleared
   log_cachehit_ratio_2 = Profile $profile, instance $instance, database $object log cache hit-ratio ($hit_ratio%) is too low
   login_count_1 = Profile $profile, instance $instance, login count is examined and cleared
   login_count_2 = Profile $profile, instance $instance, login count is $connections
   active_users_1 = Profile $profile, instance $instance, number of active user in database $object is examined and cleared
   active_users_2 = Profile $profile, instance $instance, number of active user in database $object is $active_connections
   deadlocks_1 = Profile $profile [$check], instance $instance, object '$object' deadlocks have been examined and cleared
   deadlocks_2 = Profile $profile [$check], instance $instance, object '$object' has $count_sec lock requests per second
   lock_timeouts_1 = Profile $profile [$check], instance $instance, object '$object' lock timeout have been examined and cleared
   lock_timeouts_2 = Profile $profile [$check], instance $instance, object '$object' has $count_sec lock timeouts per second
   lock_waits_1 = Profile $profile [$check], instance $instance, object '$object' lock waits have been examined and cleared
   lock_waits_2 = Profile $profile [$check], instance $instance, object '$object' has $count_sec lock waits per second
   transactions_1 = Profile $profile, instance $instance, object '$object' transactions have been examined and cleared
   transactions_2 = Profile $profile, instance $instance, object '$object' has $count_sec transactions per second
   log_flush_waits_1 = Profile $profile, instance $instance, object '$object' log flush waits have been examined and cleared
   log_flush_waits_2 = Profile $profile, instance $instance, object '$object' has $count_sec log flush waits per second
   page_reads_1 = Profile $profile, instance $instance, page reads have been examined and cleared
   page_reads_2 = Profile $profile, instance $instance has $count_sec page reads per second
   page_writes_1 = Profile $profile, instance $instance, page writes have been examined and cleared
   page_writes_2 = Profile $profile, instance $instance has $count_sec page writes per second
   latch_waits_1 = Profile $profile, instance $instance, latch waits have been examined and cleared
   latch_waits_2 = Profile $profile, instance $instance has $count_sec latch waits per second
   full_scans_1 = Profile $profile, instance $instance, full scans have been examined and cleared
   full_scans_2 = Profile $profile, instance $instance has $count_sec full scans per second
   database_count_1 = Profile $profile, instance $instance, database count have been examined and cleared
   database_count_2 = Profile $profile, instance $instance has $count databases
   server_startup_1 = Profile $profile, instance $instance is examined and has been running for $count days (started $date)
   server_startup_2 = Profile $profile, instance $instance has been running for $count days (started $date)
   log_file_growths_1 = Profile $profile, instance $instance, database $object has expanded the transaction log $interval_value times in the interval, alarm cleared
   log_file_growths_2 = Profile $profile, instance $instance, database $object has expanded the transaction log $interval_value times in the interval ($count times since startup)
   log_file_shrinks_1 = Profile $profile, instance $instance, database $object has shrunken the transaction log $interval_value times in the interval, alarm cleared
   log_file_shrinks_2 = Profile $profile, instance $instance, database $object has shrunken the transaction log $interval_value times in the interval ($count times since startup)
   lock_memory_1 = Profile $profile, instance $instance has $count lock memory allocated, alarm cleared
   lock_memory_2 = Profile $profile, instance $instance has $count lock memory allocated
   connection_memory_1 = Profile $profile, instance $instance has $count connection memory allocated, alarm cleared
   connection_memory_2 = Profile $profile, instance $instance has $count connection memory allocated
   optimizer_memory_1 = Profile $profile, instance $instance has $count optimizer memory allocated, alarm cleared
   optimizer_memory_2 = Profile $profile, instance $instance has $count optimizer memory allocated
   sqlcache_memory_1 = Profile $profile, instance $instance has $count sqlcache memory allocated, alarm cleared
   sqlcache_memory_2 = Profile $profile, instance $instance has $count sqlcache memory allocated
   total_memory_1 = Profile $profile, instance $instance has $count total memory allocated (target $target), alarm cleared
   total_memory_2 = Profile $profile, instance $instance has $count total memory allocated (target $target)
   locks_used_1 = Profile $profile, instance $instance, % locks used have been examined and cleared
   locks_used_2 = Profile $profile, instance $instance has $pct_locks % lock blocks used
   workspace_memory_1 = Profile $profile, instance $instance, % workspace memory used have been examined and cleared
   workspace_memory_2 = Profile $profile, instance $instance has $pct_mem % workspace memory used
   average_waittime_1 = Profile $profile, instance $instance, $object average lock waittime have been examined and cleared
   average_waittime_2 = Profile $profile, instance $instance, $object has average lock wait time $avg_wait ms
   server_cpu_1 = Profile $profile, instance $instance, % CPU used by instance have been examined and cleared
   server_cpu_2 = Profile $profile, instance $instance used $cpu_busy_pct % CPU in interval
   server_io_1 = Profile $profile, instance $instance, % I/O busy have been examined and cleared
   server_io_2 = Profile $profile, instance $instance has $io_busy_pct % I/O busy in interval
   sql_error_1 = Profile: $profile/$check/$pchWhere - DB Provider: Code=0x$hresult Source=$source Description=$desc
   sql_error_2 = Profile: $profile/$check/$pchWhere - COM Error: Code=0x$hresult Source=$source Description=$desc
   free_connections_1 = Profile $profile, instance $instance, free connections have been examined and cleared
   free_connections_2 = Profile $profile, instance $instance has only $pct_connections % connections available ($connections of $config_connections)
   user_cpu_1 = Profile $profile, instance $instance, user CPU for user spid $spid [$loginname] have been examined and cleared
   user_cpu_2 = Profile $profile, instance $instance, user spid $spid [$loginname] used $cpu_busy_pct % CPU in interval
   user_waits_1 = Profile $profile, instance $instance, lock waits has been examined and cleared
   user_waits_2 = Profile $profile, instance $instance, database $db_name, session $sid_blocked ($uid_blocked, host id: $hid_blocked) is blocked for $waittime sec by session $sid_blocker ($uid_blocker, host id $hid_blocked), sql command: $sql_blocked
   locked_users_1 = Profile $profile, instance $instance, locked users have been examined and cleared
   locked_users_2 = Profile $profile, instance $instance has $count user(s) waiting for a resource
   blocked_users_1 = Profile $profile, instance $instance, blocked users have been examined and cleared
   blocked_users_2 = Profile $profile, instance $instance has $count user(s) blocked for a resource
   av_fragmentation_1 = Profile $profile, instance $instance, database $db_name, table $tablename, index $indexname, allocation unit $alloc_unit have been examined and cleared
   av_fragmentation_2 = Profile $profile, instance $instance, database $db_name, table $tablename, index $indexname, allocation unit $alloc_unit has average fragmentation $fragmentation %
   av_fragmentation_3 = Profile $profile, instance $instance, average fragmentation is not available for version $version
   logic_fragment_1 = Profile $profile, instance $instance, database $db_name, index $indexname have been examined and cleared
   logic_fragment_2 = Profile $profile, instance $instance, database $db_name, index $indexname has logical fragmentation $logicalfrag %
   logic_fragment_3 = Profile $profile, instance $instance, logical fragmentation is not available for version $version
   scan_density_1 = Profile $profile, instance $instance, database $db_name, object $object have been examined and cleared
   scan_density_2 = Profile $profile, instance $instance, database $db_name, object $object has density $scandensity %
   scan_density_3 = Profile $profile, instance $instance, scan density is not available for version $version
   free_space_1 = Profile $profile, instance $instance, database $db_name is examined and cleared ($free_pct% free space, db-size $allocated)
   free_space_2 = Profile $profile, instance $instance, database $db_name has only $free_pct% free space available (db-size $allocated)
   alloc_space_1 = Profile $profile, instance $instance, database $db_name is examined and cleared ($free_pct% free space, db-size $allocated)
   alloc_space_2 = Profile $profile, instance $instance, database $db_name has only $free_pct% free space available in allocated files (db-size $allocated)
   fg_free_space_1 = Profile $profile, instance $instance, database $db_name, file group $fg_name is examined and cleared ($free_pct% free space, fg-size $allocated)
   fg_free_space_2 = Profile $profile, instance $instance, database $db_name, file group $fg_name has only $free_pct% free space available (fg-size $allocated)
   table_space_1 = Profile $profile, instance $instance, database $db_name, table $table_name is examined and cleared ($table_size allocated)
   table_space_2 = Profile $profile, instance $instance, database $db_name, table $table_name has $table_size allocated
   logfile_usage_1 = Profile $profile, instance $instance, database $db_name log file use is examined and cleared ($free_pct% free space, allocated $allocated)
   logfile_usage_2 = Profile $profile, instance $instance, database $db_name log file has only $free_pct% free space (allocated $allocated)
   logfile_size_1 = Profile $profile, instance $instance, database $db_name log file use is examined and cleared ($log_size MB log file size)
   logfile_size_2 = Profile $profile, instance $instance, database $db_name log file has reached $log_size MB log file size
   backup_status_1 = Profile $profile, instance $instance, checkpoint $check, database $db_name,  backup status is examined and cleared (last backup $last_backup)
   backup_status_2 = Profile $profile, instance $instance, checkpoint $check, database $db_name has last backup taken before $minutes minutes ($last_backup)
   long_queries_1 = Profile $profile, instance $instance, user $spid ($loginname), queries have been examined and cleared
   long_queries_2 = Profile $profile, instance $instance, user $spid ($loginname) runs query for $elapsed_time sec, sql text: $sql_text
   long_queries_3 = Profile $profile, instance $instance, long queries is not available for version $version
   long_jobs_1 = Profile $profile,$category_name,instance $instance, job $jobname (spid $spid) has been examined and cleared
   long_jobs_2 = Profile $profile,$category_name ,instance $instance, job $jobname (spid $spid) is running for $elapsed_time sec, sql text: $sql_text
   long_jobs_3 = Profile $profile, instance $instance, long jobs is not available for version $version
   active_connection_ratio_1 = Profile $profile, instance $instance, active connection ratio ($con_ratio%) is examined and cleared
   active_connection_ratio_2 = Profile $profile, instance $instance, active connection ratio ($con_ratio%) is too high
   mirror_state_1 = Profile $profile, instance $instance, database $object mirroring state have been examined and cleared
   mirror_state_2 = Profile $profile, instance $instance, state of mirroring database $object is $mirroring_state_desc
   mirror_state_3 = Profile $profile, instance $instance, mirror state is not available for version $version
   mirror_witness_server_1 = Profile $profile, instance $instance, witness server $object state have been examined and cleared
   mirror_witness_server_2 = Profile $profile, instance $instance, state of the witness $mirroring_witness_name server in the database mirroring session of the database $object is $state
   mirror_witness_server_3 = Profile $profile, instance $instance, mirror witness server is not available for version $version
   mirror_sqlinstance_1 = Profile $profile, instance $instance, SQL server instance hosting the mirror database $object have been examined and cleared
   mirror_sqlinstance_2 = Profile $profile, instance $instance, status of SQL server instance $mirroring_partner_instance hosting the mirror database $object is $status (0-unavailable, 1-available)
   mirror_sqlinstance_3 = Profile $profile, instance $instance, mirror sqlinstance is not available for version $version
   suspect_pages_1 = Profile $profile, instance $instance, database $object suspect pages have been examined and cleared
   suspect_pages_2 = Profile $profile, instance $instance, database $object has $pdcount suspect pages
   suspect_pages_3 = Profile $profile, instance $instance, suspect pages is not available for version $version
   failed_jobs_1 = Profile $profile, instance $instance, job $job_name (jobid $job_id) has been examined and cleared
   failed_jobs_2 = Profile $profile, instance $instance, job $job_name (category $category_name), has failed. Run time of job: $rundate
   ls_primary_status_1 = Profile $profile, instance $instance, log shipping primary server status ($primary_status) has been examined and cleared
   ls_primary_status_2 = Profile $profile, instance $instance, log shipping primary server $primary_server, primary database $primary_database has status $primary_status
   ls_primary_status_3 = profile $profile, instance $instance, log shipping primary server status is not available for version $version
   ls_secondary_status_1 = Profile $profile, instance $instance, log shipping secondary server status ($secondary_status) has been examined and cleared
   ls_secondary_status_2 = Profile $profile, instance $instance, log shipping secondary server $secondary_server, secondary database $secondary_database has status $secondary_status
   ls_secondary_status_3 = profile $profile, instance $instance, log shipping secondary server status is not available for version $version
   ls_lastbackup_1 = Profile $profile, instance $instance, log shipping primary server, time since last backup($time_since_last_backup min) has been examined and cleared
   ls_lastbackup_2 = Profile $profile, instance $instance, log shipping primary server $primary_server, primary database $primary_database, time since last backup is $time_since_last_backup minutes
   ls_lastbackup_3 = profile $profile, instance $instance, log shipping primary server, time since last backup is not available for version $version
   ls_lastcopy_1 = Profile $profile, instance $instance, log shipping secondary server, time since last copy($time_since_last_copy min) has been examined and cleared
   ls_lastcopy_2 = Profile $profile, instance $instance, log shipping secondary server $secondary_server, secondary database $secondary_database, time since last copy is $time_since_last_copy minutes
   ls_lastcopy_3 = profile $profile, instance $instance, log shipping secondary server, time since last copy is not available for version $version
   ls_lastrestore_1 = Profile $profile, instance $instance, log shipping secondary server, time since last restore($time_since_last_restore min) has been examined and cleared
   ls_lastrestore_2 = Profile $profile, instance $instance, log shipping secondary server $secondary_server, secondary database $secondary_database, time since last restore is $time_since_last_restore minutes
   ls_lastrestore_3 = profile $profile, instance $instance, log shipping secondary server, time since last restore is not available for version $version
   ls_restored_latency_1 = Profile $profile, instance $instance, log shipping secondary server, last restored latency($last_restored_latency min) has been examined and cleared
   ls_restored_latency_2 = Profile $profile, instance $instance, log shipping secondary server $secondary_server, secondary database $secondary_database, last restored latency is $last_restored_latency minutes
   ls_restored_latency_3 = profile $profile, instance $instance, log shipping secondary server, last restored latency is not available for version $version
   fg_freeSpace_with_avail_disk_1 = Profile $profile, instance $instance, database $db_name, file group $fg_name is examined and cleared ($free_pct% free space after considering the available disk size, fg-size $allocated)
   fg_freeSpace_with_avail_disk_2 = Profile $profile, instance $instance, database $db_name, file group $fg_name has only $free_pct% free space available after considering the available disk size(fg-size $allocated)
   logfile_usage_with_avail_disk_1 = Profile $profile, instance $instance, database $db_name, logfile usage is examined and cleared ($free_pct% free space after considering the available disk size, allocated $allocated)
   logfile_usage_with_avail_disk_2 = Profile $profile, instance $instance, database $db_name, logfile has only $free_pct% free space available after considering the available disk size(allocated $allocated)
   aag_cluster_quorum_state_1 = Profile $profile, instance $instance, $cluster_name quorum state has been examined and cleared
   aag_cluster_quorum_state_2 = Profile $profile, instance $instance, cluster ($cluster_name) has $quorum_state_desc($quorum_state) state
   aag_cluster_members_state_1 = Profile $profile, instance $instance, object '$object' state have been examined and cleared
   aag_cluster_members_state_2 = Profile $profile, instance $instance, object '$object' is $member_state_desc($member_state)
   aag_synchronization_health_1 = Profile $profile, instance $instance, synchronization health of availability replicas in the availability group($name) has been examined and cleared
   aag_synchronization_health_2 = Profile $profile, instance $instance, synchronization health of availability replicas in the availability group($name) is $synchronization_health_desc($synchronization_health)
   aag_replica_synchronization_health_1 = Profile $profile, instance $instance, availability group($name), object '$object'($role_desc) synchronization health of an availability replica has been examined and cleared
   aag_replica_synchronization_health_2 = Profile $profile, instance $instance, availability group($name), object '$object'($role_desc) synchronization health of an availability replica is $synchronization_health_desc($synchronization_health)
   aag_replica_connected_state_1 = Profile $profile, instance $instance, availability group($name), object '$object'($role_desc) connected state of an availability replica has been examined and cleared
   aag_replica_connected_state_2 = Profile $profile, instance $instance, availability group($name), object '$object'($role_desc) availability replica has  $connected_state_desc($connected_state)
   aag_replica_recovery_health_1 = Profile $profile, instance $instance, availability group($name), object '$object'($role_desc) recovery health has been examined and cleared
   aag_replica_recovery_health_2 = Profile $profile, instance $instance, availability group($name), object '$object'($role_desc) recovery health is $recovery_health_desc($recovery_health)
   aag_replica_operational_state_1 = Profile $profile, instance $instance, availability group($name), object '$object'($role_desc) operational state has been examined and cleared
   aag_replica_operational_state_2 = Profile $profile, instance $instance, availability group($name), object '$object'($role_desc) operational state is $operational_state_desc($operational_state)
   aag_db_replica_synchronization_state_1 = Profile $profile, instance $instance, availability group($name), object '$object'($database_name) synchronization state of an availability database replica has been examined and cleared
   aag_db_replica_synchronization_state_2 = Profile $profile, instance $instance, availability group($name), object '$object' synchronization state of an availability database replica($database_name) is $synchronization_state_desc($synchronization_state)
   aag_db_page_status_1 = Profile $profile, instance $instance, availability group($name), object '$object', database $database_name page status has been examined and cleared
   aag_db_page_status_2 = Profile $profile, instance $instance, availability group($name), object '$object', database $database_name page status is $page_status
   aag_listener_state_1 = Profile $profile, instance $instance, availability group($name), object '$object'($role_desc) dns name '$dns_name' listener state has been examined and cleared
   aag_listener_state_2 = Profile $profile, instance $instance, availability group($name), object '$object'($role_desc) dns name '$dns_name' listener state is $state_desc($state)
   wait_stats_count_1 = Profile $profile, instance $instance, $wait_type wait type has $interval_value counts in the interval, alarm cleared
   wait_stats_count_2 = Profile $profile, instance $instance, $wait_type wait type has $interval_value Waits Count in the interval
   wait_stats_time_1 = Profile $profile, instance $instance, $wait_type wait type has $interval_value ms in the interval, alarm cleared
   wait_stats_time_2 = Profile $profile, instance $instance, Total wait time is $interval_value ms for $wait_type wait type in the interval
</messages>