Fatal Error 9001

<< Click to Display Table of Contents >>

Navigation:  EDP > Troubleshooting >

Fatal Error 9001

During the EDP create process, the following error may occur:


System.Data.SqlClient.SqlException: Warning: Fatal error 9001 occurred at DATETIME. Note the error and time, and contact your system administrator.

 at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

 at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

 at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

 at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

 at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

 at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

 at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

 at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

 at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

 at EarthSoft.Common.Data.Connection.CreateEddBatch(String Filename, String EddType)


Solution: In some instances when this error occurred, it was related to the database log files. It may be possible that the log files are getting locked in another process (such as an AntiVirus software). A client has reported the issue was eradicated by adding *.ldf to their virus protection excluded files list.


See also: The Log for the Database is Not Available