FT:Crawl Aborted Event Class


Applies To: SQL Server 2016

The FT:Crawl Aborted event class indicates that an exception has been encountered during a full-text crawl. The error usually causes the full-text crawl to stop. Check the Microsoft Windows event log or the crawl log for more detailed error information.

Data column nameData typeDescriptionColumn IDFilterable
DatabaseIDintID of the database in which the full-text crawl is running. Determine the value for a database by using the DB_ID function.3Yes
ErrorintError number of a given event. Often this is the error number stored in the sysmessages table.31Yes
EventClassintType of event = 157.27No
EventSequenceintSequence of a given event within the request.51No
IsSystemintIndicates whether the event occurred on a system process or a user process. 1 = system, 0 = user.60Yes
ObjectIDintSystem-assigned ID of the object on which the full-text crawl is running when the failure occurs.22Yes
SessionLoginNamenvarcharLogin name of the user who originated the session. For example, if you connect to SQL Server using Login1 and execute a statement as Login2, SessionLoginName shows Login1 and LoginName shows Login2. This column displays both SQL Server and Windows logins.64Yes
SPIDintID of the session on which the event occurred.12Yes
StartTimedatetimeTime at which the event started, if available.14Yes
StateintEquivalent to an error state code.30Yes
TransactionIDbigintSystem-assigned ID of the transaction.4Yes

sp_trace_setevent (Transact-SQL)

Community Additions