66244: DeviceLock DLP: Various issues with DeviceLock SQL database

use Google Translate

Applies to: 

Last update: Tue, 2020-11-17 09:53

Description

Experiencing various issues with DeviceLock SQL database? We will need some outputs to research. This article contains instructions on gathering the necessary information.

How-to

lockinfo.zip

Run the attached script (lockinfo.sql).

Instead of "DeviceLockDB" you should enter the name of your current DeviceLock database.

Send the output to us.

Then,Install SQL Server Management Studio, create a new Query and execute:

DBCC TRACEON (1222,-1)

Wait until you find a new Error about Deadlock in the Server log and execute:

DBCC TRACEOFF (1222,-1)

In the SQL Server Management Studio go to Management-> SQL Server Logs-> double click on Current -> choose Export=> export the log and send it to us.

*See attached screenshot "sqlsms.jpg" for the how-to.