| Event Id | 2037 |
| Source | NotificationServices |
| Description | The event schema specified for the EventLoader object is not valid. The event schema needs to contain a single urn:schemas-microsoft-com:mapping-schema:relation node. |
| Event Information | According to Microsoft: Explanation: A typical schema file looks like the following: <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sql="urn:schemas-microsoft-com:mapping-schema"><xsd:element name="event" sql:relation="MyEventClassName"><xsd:complextype><xsd:sequence><xsd:element name="StockSymbol" type="xsd:string" /><xsd:element name="StockPrice" type="xsd:float" /></xsd:sequence></xsd:complextype></xsd:element></xsd:schema> This error occurs when the XSD schema provided for use by the EventLoader class does not contain the sql:relation annotation, as shown in the example below: <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sql="urn:schemas-microsoft-com:mapping-schema"><xsd:element name="event"><xsd:complextype><xsd:sequence><xsd:element name="StockSymbol" type="xsd:string" /><xsd:element name="StockPrice" type="xsd:float" /></xsd:sequence></xsd:complextype></xsd:element></xsd:schema> The EventLoader class is used to bulk-load events from an XML file using SQL XML. The SQL XML bulk loader takes an annotated schema and an XML file to perform the data transfer to SQL Server tables. The sql:relation annotation specifies the name of the table into which the bulk loader needs to move the data. The Notification Services implementation requires that this annotation specify the event class name. The schema is internally manipulated to convert the event class name to the physical table name where events are stored. User Action: Make sure that sql:relation annotation is specified in the schema. |
| Reference Links | Event id 2037 from source Notification services |
Catch threats immediately
We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.