The "Object reference not set to an instance of an object." error is encountered within the ApexSQL Audit log files when trying to pull back auditing information (4373207)
The "Object reference not set to an instance of an object." error is encountered within the ApexSQL Audit log files when trying to pull back auditing information
说明
The following error is encountered within the ApexSQL Audit log files when no data is retrieved and no trace events can be found in the queues:
2023-01-10 14:59:11.012 ERROR [GUI ]: Sending message failed: type ApexSQL.Audit.Shared.Messages.CommReportEventsListMessage id bbb1eae0-9a17-46dc-a176-d3e67d2f84ea - Message of type ApexSQL.Audit.Shared.Messages.CommReportEventsListMessage timeouted - 2023-01-10 14:59:11.012 INFO [GUI ]: Preview report unsuccessful 2023-01-10 14:59:11.012 INFO [GUI ]: Preview report finished 2023-01-10 14:59:11.012 ERROR [GUI ]: An exception occurred Object reference not set to an instance of an object. Type: System.NullReferenceException Stack trace at ApexSQL.Audit.UI.Shared.Classes.ViewModel.ReportsViewModel.LoadReportPreview()
解决办法
There are 2 steps that needs to be performed in this situation: 1. Restart the SQL Server instance you are pulling auditing information from 2. Increase the Global timeout setting by doing the following steps: Start ApexSQL Audit GUI -> Home -> Options -> General -> Advanced -> put Global timeout on 300 seconds