Topic Last Modified: 2012-09-28

The ErrorReport table stores information about errors that have occurred. Each record is one error occurrence. The errors are captured either by the CDR agent running on the front-end server or sent from the client.

Column Data Type Key/Index Details

ErrorTime

datetime

Primary

Date and time the error occurred.

ErrorReportSeq

int

Primary

ID number to identify the error report. Used in conjunction with ErrorTime to uniquely identify an error report.

ErrorId

int

Foreign

Unique ID of the error type. See the ErrorDef Table for more information.

FromUserId

int

Foreign

User who originated the request that caused the error. See the Users Table for more information.

ToUserId

int

Foreign

Destination user for the request that caused the error. See the Users Table for more information.

ConferenceUriId

int

Foreign

Conference URI related to the error. See the ConferenceUris Table for more information. Typically, if ConferenceUriId is not null, then either FromUserId or ToUserId will be null.

SessionIdTime

datetime

Foreign

Used in conjunction with SessionIdSeq to uniquely identify a session. See the Dialogs Table for more information.

SessionIdSeq

int

Foreign

ID number to identify the session. Used in conjunction with SessionIdTime to uniquely identify a session. See the Dialogs Table for more information.

SourceId

int

Foreign

Server that sent the error report (if the report is being sent from a server component). See the Servers Table for more information.

This field was introduced in Microsoft Lync Server 2013.

ApplicationId

int

Foreign

Server that sent the error report (if the report is being sent from a server component). See the Application Table for more information.

This field was introduced in Microsoft Lync Server 2013.

MsDiagHeader

image

 

More information about the error.

This data can be converted to text format by using this syntax:

cast(cast(Detail as varbinary(max)) as varchar(max))

ClientVersionId

int

Foreign

The client version of endpoint that sends the error report. See the ClientVersions Table for more information.

IsCapturedByServer

bit

Is the error report captured by the CDR agent running on the front-end server, or sent by the client.

Flag

smallint

Reserved for future use.

TelemetryId

uniqueIdentifier

Unique identifier correlating join time information for the different components involved in a conference.

This field was introduced in Microsoft Lync Server 2013.

SessionSetupTime

int

Time (in milliseconds) required for a specific component to join a conference.

This field was introduced in Microsoft Lync Server 2013.

ServerId

int

Foreign

Represents the fully qualified domain name of the server that generated the error report.

PoolId

int

Foreign

Represents the fully qualified domain name of the pool where the error report was generated.