Could not find stored procedure 'WriteLog'.

Topics: Building and extending application blocks, Logging Application Block
Nov 7, 2008 at 9:05 PM

Event Type:       Error<o:p></o:p>

Event Source:   Enterprise Library Logging<o:p></o:p>

EventCategory:               None<o:p></o:p>

EventID:             6352<o:p></o:p>

Date:                    11/7/2008<o:p></o:p>

Time:                    12:19:25 PM<o:p></o:p>

User:                    N/A<o:p></o:p>

Computer:         (SystemName)<o:p></o:p>

Description:<o:p></o:p>

Timestamp: 11/7/2008 7:19:25 PM<o:p></o:p>

Message: Tracing to LogSource failed. Processing for other sources will continue. Seesummary information below for more information. Should this problem persist,stop the service and check the configuration file(s) for possible error(s) inthe configuration of the categories and sinks.<o:p></o:p>

<o:p> </o:p>

<o:p> </o:p>

Summary for Enterprise LibraryDistributor Service:<o:p></o:p>

======================================<o:p></o:p>

--> <o:p></o:p>

Message: <o:p></o:p>

Timestamp: 11/7/2008 7:19:23 PM<o:p></o:p>

Message: Logon failure: unknownuser name or bad password.<o:p></o:p>

<o:p> </o:p>

Category: CategoryName<o:p></o:p>

Priority: -1<o:p></o:p>

EventId: 0<o:p></o:p>

Severity: Information<o:p></o:p>

Title:<o:p></o:p>

Machine: <o:p>(SystemName)</o:p>

App Domain:/LM/W3SVC/998577302/Root/Website-1-128705591255985222<o:p></o:p>

ProcessId: 1376<o:p></o:p>

Process Name:c:\windows\system32\inetsrv\w3wp.exe<o:p></o:p>

Thread Name: <o:p></o:p>

Win32 ThreadId:3524<o:p></o:p>

Extended Properties: <o:p></o:p>

--> MachineName:<o:p>(SystemName)</o:p>

--> TimeStamp: 11/7/20087:19:25 PM<o:p></o:p>

--> FullName:Microsoft.Practices.EnterpriseLibrary.Logging, Version=4.0.0.0, Culture=neutral,PublicKeyToken=31bf3856ad364e35<o:p></o:p>

--> AppDomainName:/LM/W3SVC/998577302/Root/ADAM_webSite-1-128705591255985222<o:p></o:p>

--> WindowsIdentity: <o:p></o:p>

<o:p> </o:p>

Exception Information Details:<o:p></o:p>

======================================<o:p></o:p>

Exception Type: System.Data.SqlClient.SqlException<o:p></o:p>

Errors:System.Data.SqlClient.SqlErrorCollection<o:p></o:p>

Class: 16<o:p></o:p>

LineNumber: 1<o:p></o:p>

Number: 2812<o:p></o:p>

Procedure: <o:p></o:p>

Server: (SystemName)\SQLEXPRESS<o:p></o:p>

State: 62<o:p></o:p>

Source: .Net SqlClient DataProvider<o:p></o:p>

ErrorCode: -2146232060<o:p></o:p>

Message: Could not find stored procedure 'WriteLog'.<o:p></o:p>

Data:System.Collections.ListDictionaryInternal<o:p></o:p>

TargetSite: VoidOnError(System.Data.SqlClient.SqlException, Boolean)<o:p></o:p>

HelpLink: NULL<o:p></o:p>

<o:p> </o:p>

StackTrace Information Details: <o:p></o:p>

======================================<o:p></o:p>

   at System.Data.SqlClient.SqlConnection.OnError(SqlExceptionexception, Boolean breakConnection)<o:p></o:p>

   atSystem.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjectstateObj)<o:p></o:p>

   atSystem.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommandcmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler,TdsParserStateObject stateObj)<o:p></o:p>

   atSystem.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds,RunBehavior runBehavior, String resetOptionsString)<o:p></o:p>

   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehaviorcmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)<o:p></o:p>

   atSystem.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior,RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResultresult)<o:p></o:p>

   atSystem.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result,String methodName, Boolean sendToPipe)<o:p></o:p>

   atSystem.Data.SqlClient.SqlCommand.ExecuteNonQuery()<o:p></o:p>

   at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoExecuteNonQuery(DbCommandcommand)<o:p></o:p>

   atMicrosoft.Practices.EnterpriseLibrary.Logging.Database.FormattedDatabaseTraceListener.ExecuteWriteLogStoredProcedure(LogEntrylogEntry, Database db, DbTransaction transaction)<o:p></o:p>

   atMicrosoft.Practices.EnterpriseLibrary.Logging.Database.FormattedDatabaseTraceListener.ExecuteStoredProcedure(LogEntrylogEntry)<o:p></o:p>

   atMicrosoft.Practices.EnterpriseLibrary.Logging.Database.FormattedDatabaseTraceListener.TraceData(TraceEventCacheeventCache, String source, TraceEventType eventType, Int32 id, Object data)<o:p></o:p>

   atMicrosoft.Practices.EnterpriseLibrary.Logging.LogSource.TraceData(TraceEventTypeeventType, Int32 id, LogEntry logEntry, TraceListenerFiltertraceListenerFilter)<o:p></o:p>

   at Microsoft.Practices.EnterpriseLibrary.Logging.LogWriter.ProcessLog(LogEntrylog)<o:p></o:p>

Category: <o:p></o:p>

Priority: -1<o:p></o:p>

EventId: 6352<o:p></o:p>

Severity: Error<o:p></o:p>

Title:<o:p></o:p>

Machine:<o:p>(SystemName)</o:p>

Application Domain:/LM/W3SVC/998577302/Root/ADAM_webSite-1-128705591255985222<o:p></o:p>

Process Id: 1376<o:p></o:p>

Process Name:c:\windows\system32\inetsrv\w3wp.exe<o:p></o:p>

Win32 Thread Id: 3524<o:p></o:p>

Thread Name: <o:p></o:p>

Extended Properties: <o:p></o:p>

<o:p> </o:p>

For more information, see Helpand Support Center at http://go.microsoft.com/fwlink/events.asp.<o:p></o:p>

Nov 8, 2008 at 2:50 AM
Did you run CreateLoggingDb.cmd? It would create the Logging database for you containing the WriteLog stored procedure.  WriteLog is the stored procedure which will be used for writing log entries to your databse.  If you are using your own database, make sure to set this property to the correct name of your stored procedure.


Sarah Urmeneta
Global Technology & Solutions
Avanade, Inc.
entlib.support@avanade.com