You may see the following error message displayed in the Importer log:
2018-01-16 05:42:34,348 [INFO ] Failed to execute Writer 'DeleteUnrequiredInstalledFileEvidence' from file E:\FNMSProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Writer\FileEvidence.xml, at step line 13 Error: The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to check the lock and memory configuration for this instance, or to check for long-running transactions. 2018-01-16 05:42:34,348 [INFO ] All retries have been attempted for Writer 'DeleteUnrequiredInstalledFileEvidence' 2018-01-16 05:42:34,363 [ERROR] System.Data.SqlClient.SqlException (0x80131904): The instance of the SQL Server Database Engine cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users. Ask the database administrator to check the lock and memory configuration for this instance, or to check for long-running transactions.?
SELECT * FROM sys.dm_exec_requests CROSS APPLY sys.dm_exec_sql_text(sql_handle) SELECT * FROM sys.sysprocesses WHERE open_tran = 1 SELECT * FROM sys.databases DBCC SQLPERF(logspace)
Firstly, re-run the reconcile and confirm if the issue can be reproduced. It may be advisable to run this when the system is expected to be idle and to change the scheduled job as necessary. If the issue reoccurs it will need further investigation by engineering. For Cloud customers, there can be limited troubleshooting beyond attempting to re-run a reconcile - so contact support for assistance if still continuing issues.
Nov 15, 2018 07:42 PM