Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Issue Element (ssbdiagnose)

Reports an issue that was found by the ssbdiagnose utility. The ssbdiagnose XML output file has one Issue element per issue reported.


<Issue
    type="..." 
    code="..." 
    server="..." 
    database="..." 
    object="..."> 
    ... 
</Issue>

Attribute

Description

type

Identifies which category of problem the Issue element is reporting.

Value

Description

"Diagnosis"

Reports a configuration issue found when you analyze a Service Broker configuration.

"Problem"

Reports an issue that has prevented ssbdiagnose from completing its analysis. Correct the problem and rerun ssbdiagnose.

"Event"

Reports a SQL Server Profiler event found when you run a -RUNTIME check. Events are only reported if -SHOWEVENTS is specified.

code

Identifies the error number for the message.

server

Identifies the instance of the Database Engine in which the problem was found. If the problem was in a default instance, the server attribute only has the computer name. If the problem was in a named instance, the server attribute is in the form ComputerName\InstanceName.

database

Identifies the name of the database in which the problem was found.

object

Identifies the name of the object in which the problem was found. If the problem was an instance or database level issue, the object attribute repeats the instance or database name.

Characteristic

Description

Data type and length

string , length is unlimited.

Value

Returns the text of the error message.

Occurrence

Once per reported error.

Relationship

Elements

Parent element

DiagnosticInformation Element (ssbdiagnose)

Child elements

None

This element reports an 1102 error for a database that does not have a master key, where the error was found when you analyzed a Service Broker configuration.

<Issue type="Diagnosis" code="1102" server="TestComputer" database="TargetDB" object="TargetDB">The master key was not found</diagnostic>
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.