Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Audit log does not work if the db collation is case sensitive #121

Closed
tusmester opened this issue Jun 27, 2017 · 1 comment
Closed

Audit log does not work if the db collation is case sensitive #121

tusmester opened this issue Jun 27, 2017 · 1 comment
Assignees
Labels
Milestone

Comments

@tusmester
Copy link
Member

When EntLib tries to write an Audit event to the db, a SQL exception is thrown about not receiving the EventId parameter.

Procedure or function 'proc_LogWrite' expects parameter '@EventId', which was not supplied.

This does not happen if the db collation is case insensitive (CI), only if it is case sensitive (CS), so this is probably related to a column/property name somewhere with a different casing (EventID or Eventid).

Classes to inspect: EntLibLoggerAdapter, SnXmlFormatter

Repro steps:

  1. create an empty db manually
  2. set the collation on the db to a case sensitive one (e.g. in SQL Management Studio)
  3. install sensenet Services into this db with forcedreinstall:true parameter
  4. log in --> this should trigger an audit log event (or create a content)
@kavics
Copy link
Contributor

kavics commented Jan 8, 2018

Additionally:
Enterprise library calls with these:
eventID, priority, severity, title, timestamp, machineName, AppDomainName, ProcessID, ProcessName, ThreadName, Win32ThreadId, message, formattedmessage, LogId

proc_LogWrite expects these:
EventId, Priority, Severity, Title, Timestamp, MachineName, AppDomainName, ProcessID, ProcessName, ThreadName, Win32ThreadId, Message, FormattedMessage, LogId

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

4 participants