GetDatabaseFreeSpace error or timeout in the data_engine log
search cancel

GetDatabaseFreeSpace error or timeout in the data_engine log

book

Article ID: 235107

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

de: [Monitor] GetDatabaseFreeSpace - 1 errors 
de: (1) GetDatabaseFreeSpace [Microsoft OLE DB Provider for SQL Server] Query timeout expired 
de: COM Error [0x80040e31] IDispatch error #3121 - [Microsoft OLE DB Provider for SQL Server] Query timeout expired

Environment

Version: All
Component: data_engine

Resolution

The user that is used for the data_engine connection would need to have permission to run the following:

   use ca_uim
   exec sp_spacesused

within the SQL Management studio as that user.

Evaluate any other messages around the message, this could also be a case where the database server is busy and is unable to respond in the allotted time, or is in the process of increasing the size of the database:

   Jun 30 23:02:11:320 [9332] 0 de: [Monitor] GetDatabaseFreeSpace - 1 errors
   Jun 30 23:02:11:320 [9332] 0 de: (1) GetDatabaseFreeSpace [Microsoft OLE DB Driver for SQL Server] Query timeout expired
   Jun 30 23:02:11:320 [9332] 0 de: COM Error [0x80040e31] IDispatch error #3121 - [Microsoft OLE DB Driver for SQL Server] Query timeout expired
   Jun 30 23:02:11:367 [9332] 1 de: Monitor - CA_UIM has -1 MB free space and disk F: has 990 MB free space

This could be a case for reviewing what mode the database is in, Full or Simple, and if in Full mode are there regular log backups happening with log truncation? Is the natural increase amount of the database too small, as to have to increase frequently etc...