Hello:
Regarding my lasat post, I have been trying out
log4net.Layout.RawPropertyLayout as the layout type for my Guid
parameter, like so:
<parameter>
<parameterName value="@messageID" />
<dbType value="Guid" />
<size value="36" />
<layout type="log4net.Layout.RawPropertyLayout"
value="7d32ea24-289c-48d7-9037-7c3caa75a87c" />
</parameter>
I have also tried setting my <layout ... value="%property{messageID}" />
too...in both cases I am getting this message from internal debugging:
log4net:WARN XmlHierarchyConfigurator: Unable to set property [layout]
on object [log4net.Appender.AdoNetAppenderParameter] using value
[7d32ea24-289c-48d7-9037-7c3caa75a87c] (with acceptable conversion
types).
...and I have also tried wrapping the Guid value like
Guid(7d32ea24-289c-48d7-9037-7c3caa75a87c).
Anyone have any ideas or feedback? Thanks!
From: Kevin Parkinson [mailto:[EMAIL PROTECTED]
Sent: June-20-07 10:29 AM
To: [email protected]
Subject: Custom Parameters Not Working
Hello Everyone:
I am having a problem getting Log4Net to log because a
particular Guid parameter I am using.
Here is what I have in my config file:
<parameter>
<parameterName value="@messageID" />
<dbType value="Guid" />
<size value="10" />
<layout type="log4net.Layout.PatternLayout"
value="%property{QueryServiceMessageID}" />
</parameter>
Here is my property in code:
Guid messageID = new Guid("7d32ea24-289c-48d7-9037-7c3caa75a87c");
log4net.GlobalContext.Properties["QueryServiceMessageID"] =
messageID;
Here is the stack trace I am getting through internal debugging:
log4net:ERROR [AdoNetAppender] Exception while writing to database
System.InvalidCastException: Failed to convert parameter value from a
String to a Guid. ---> System.InvalidCastException: Invalid cast from
'System.String' to 'System.Guid'.
at System.Convert.DefaultToType(IConvertible value, Type targetType,
IFormatProvider provider)
at System.String.System.IConvertible.ToType(Type type,
IFormatProvider provider)
at System.Convert.ChangeType(Object value, Type conversionType,
IFormatProvider provider)
at System.Data.SqlClient.SqlParameter.CoerceValue(Object value,
MetaType destinationType)
--- End of inner exception stack trace ---
at System.Data.SqlClient.SqlParameter.CoerceValue(Object value,
MetaType destinationType)
at System.Data.SqlClient.SqlParameter.GetCoercedValue()
at System.Data.SqlClient.SqlParameter.Validate(Int32 index)
at System.Data.SqlClient.SqlCommand.BuildParamList(TdsParser parser,
SqlParameterCollection parameters)
at System.Data.SqlClient.SqlCommand.BuildPrepExec(CommandBehavior
behavior)
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 log4net.Appender.AdoNetAppender.SendBuffer(IDbTransaction dbTran,
LoggingEvent[] events)
Can anyone make any recommendations or point out any errors? Any help is
much appreciated.
Kevin Parkinson
<<image001.jpg>>
BEGIN:VCARD VERSION:2.1 X-MS-SIGNATURE:YES N;LANGUAGE=en-us:Parkinson;Kevin FN:Kevin Parkinson TITLE:.NET Developer TEL;WORK;VOICE:(780) 409-8180 TEL;CELL;VOICE:(780) 405-6118 ADR;WORK;PREF:;;1150 10180 - 101 Street;Edmonton;AB Canada;T5J3S4;Canada LABEL;WORK;PREF;ENCODING=QUOTED-PRINTABLE:1150 10180 - 101 Street=0D=0A= Edmonton, AB Canada T5J3S4 X-MS-OL-DEFAULT-POSTAL-ADDRESS:2 URL;WORK:www.quercussolutions.com EMAIL;PREF;INTERNET:[EMAIL PROTECTED] X-MS-TEXT;CUSTOM1:Consultant X-MS-CARDPICTURE;TYPE=JPEG;ENCODING=BASE64: /9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAYEBQYFBAYGBQYHBwYIChAKCgkJChQODwwQFxQY GBcUFhYaHSUfGhsjHBYWICwgIyYnKSopGR8tMC0oMCUoKSj/2wBDAQcHBwoIChMKChMoGhYa KCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCgoKCj/wAAR CAAsACwDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAA AgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkK FhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWG h4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl 5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREA AgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYk NOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOE hYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk 5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD6orL8QarHpVg07jc3RV9TWnzXGfEeOQ2l pIATEshDD6jj+Rrjx1WVKhKcN0b4WEalWMJbMp248S6sn2qKbyYzygztB+gq5oWvXkGojTtZ XEjHar+9dJpFzDc6dBJbMDGUGMdvauT8YqZ/EmnRwofNyuWx/tevtXlzpyw8Y16c3Jtq+uju d8aka8pUpwSWuy1VjuwadUaDGOKkr3keSFVb+0hvbV4LhN8b8EVXh1S1luWt45cyjIwVIBI6 gHGCR3xR/atobYz+cDGIhNkKfuHoacqfMuVolVYrVM52DwrPZyXBtLs+VJGyqjEjBI4NUtOs dQ07UbS2uZjvllDhlG8FR1GT0rqpNYs47eKZ2lVJCQuYXycdTjGR9TUh1G2E0Ue8tJIAy7EL AA9CSBgA+pxXA8rgmnG6sdazFu6k07mgD060+qKX9uzhFlBYsy9O69fyplpqMN3CssDu0Z6E qRn6ZHI969HlfY4/aR7lSPRYIb9bsSzZUsVjLfIpbOTjHufzqNNGso7a5tzNIyPGIjuYHYg6 AcdB75rUv7WO6jCSg4B4wcVR/sm1cHcrdT3rVNtXuc8oxi7KKI7jRrKazhhndnjjDFW3Beo6 8YqX7FALqKeO5dH2IpCsMSKp4yMep7Y60+bTLZ5S7K3OMjPH3f8A6wpv9k2pByHPRPvdt3Sj V7sOWz0SCDTLeO9a4WV8sWIQsCqlupH1pbDR4bOJ0jlmwzl+cf4e1CaVaKVcId28PnPfj/AV rDpUybWzLhCL3R//2Q== X-MS-OL-DESIGN;CHARSET=utf-8:<card xmlns="http://schemas.microsoft.com/office/outlook/12/electronicbusinesscards"; ver="1.0" layout="right" bgcolor="ffffff"><img xmlns="" align="tleft" area="21" use="cardpicture"/><fld xmlns="" prop="name" align="left" dir="ltr" style="b" color="218cff" size="10"/><fld xmlns="" prop="text1" align="left" dir="ltr" color="dead00" size="8"/><fld xmlns="" prop="title" align="left" dir="ltr" color="dead00" size="8"/><fld xmlns="" prop="telcell" align="left" dir="ltr" color="dead00" size="8"><label align="left" color="dead00">Direct</label></fld><fld xmlns="" prop="blank" size="8"/><fld xmlns="" prop="addrwork" align="left" dir="ltr" color="dead00" size="8"/><fld xmlns="" prop="telwork" align="left" dir="ltr" color="dead00" size="7"><label align="left" color="dead00">Tel +1</label></fld><fld xmlns="" prop="email" align="left" dir="ltr" color="dead00" size="8"/><fld xmlns="" prop="webwork" align="left" dir="ltr" color="dead00" size="8"/><fld xmlns="" prop="blank" size="8"/><fld xmlns="" prop="blank" size="8"/><fld xmlns="" prop="blank" size="8"/><fld xmlns="" prop="blank" size="8"/><fld xmlns="" prop="blank" size="8"/><fld xmlns="" prop="blank" size="8"/><fld xmlns="" prop="blank" size="8"/></card> REV:20070410T221713Z END:VCARD
