Memory Link error/Enterprise Library backup Sink RRS feed

  • Question

  • Hi,


    Can someone help me please, because I have this error on our application server which is connected to our DB server.

    I don't know if this is the right forum to ask, but for me i think, there something to do with our SQL server too. Below is the error i found on our event viewer log.


    An error occurred while the Distributor was processing the message. Please check your configuration files for errors or typos. Verify that your sinks are reachable (queues exist, permissions are set, database exists, etc...)

    Sink failed because: System.Security.SecurityException: Requested registry access is not allowed.

    at Microsoft.Win32.RegistryKey.OpenSubKey(String name, Boolean writable)

    at System.Diagnostics.EventLog.CreateEventSource(String source, String logName, String machineName, Boolean useMutex)

    at System.Diagnostics.EventLog.WriteEntry(String message, EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData)

    at System.Diagnostics.EventLog.WriteEntry(String message, EventLogEntryType type, Int32 eventID, Int16 category)

    at Microsoft.Practices.EnterpriseLibrary.Logging.Sinks.EventLogSink.SendMessageCore(LogEntry logEntry).


    Timestamp: 1/10/2008 10:08:30 AM

    Message: HandlingInstanceID: f625136b-bc39-475e-a12d-4aacd84108aa

    An exception of type 'System.Data.SqlClient.SqlException' occurred and was caught.


    01/10/2008 10:08:30

    Type : System.Data.SqlClient.SqlException, System.Data, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089

    Message : Too many expressions are specified in the GROUP BY clause. The maximum number is 10 when either CUBE or ROLLUP is specified.

    Source : .Net SqlClient Data Provider

    Help link :

    Errors : System.Data.SqlClient.SqlErrorCollection

    Class : 15

    LineNumber : 1

    Number : 1027

    Procedure :

    Server : SAMCSSQLDB (DBServer)

    State : 1

    TargetSite : System.Data.DataTable Sales_Report_Query(System.String[])

    Stack Trace : at NSCSI.Biz.Analysis.ReportDBModule.Sales_Report_Query(String[] Parameter)

    at NSCSI.Web.Analysis.SelloutReport.Load_Data(Int32 dCount, Int32 cCount)

    Additional Info:

    MachineName : SAMCSWEB01 (Application Server)

    TimeStamp : 1/10/2008 2:08:30 AM

    FullName : Microsoft.Practices.EnterpriseLibrary.ExceptionHandling, Version=, Culture=neutral, PublicKeyToken=null

    AppDomainName : /LM/W3SVC/1760467242/Root/NSCSI-1-128443678251406250

    ThreadIdentity :


    Category: NSCSIEventLog

    Priority: 0

    EventId: 1000

    Severity: Error

    Title:NSCSI Exception Log

    Machine: SAMCSWEB01

    App Domain: /LM/W3SVC/1760467242/Root/NSCSI-1-128443678251406250

    ProcessId: 2992

    Process Name: c:\windows\system32\inetsrv\w3wp.exe

    Thread Name:

    Win32 ThreadId:332

    Extended Properties:

    Thursday, January 10, 2008 3:57 AM