Ho to turn loglevel to all in xml?

[Wolfgang]

Hi,
having the following part in XML:

<logDownloader.filename>C:\Users\Public\(withpathtouser)\DBLog</logDownloader.filename>
<logging.logEventsToTrace>true</logging.logEventsToTrace>
<logging.logEvents>errors</logging.logEvents>
<logDownloader.eventText>true</logDownloader.eventText>
<checkModelConsistencyOnCommit>False</checkModelConsistencyOnCommit>

how could i set a loglevel to all?

Best regards,
Wolfgang

P.S: 

<logging.logEvents>all</logging.logEvents>

has not helped , still getting ? as values , tried to get more details for http://www.telerik.com/community/forums/orm/general-discussions/735886-system-accessviolationexception.aspx

[Ady]

Hello Wolfgang,

 I will look into the problem. In the meantime can you try specifying a value of '4' instead of 'all.

<logging.logEvents>4</logging.logEvents>

Do let me know if that helps.

Regards,
Ady
Telerik

[Wolfgang]

Hi Ady,

I still do not see it in the exception, I only see it in Output Window.

With the one in output window i have the followibg problem:

it is shown like:

... Values(:p0...) [p0: 0383...]

What I think is missing:

I do not know how the sql string really looks. For example is 0x added infront of a Guid? Are correct paranthesis set for DB? And so on.

Best regards

Wolfgang

[Ady]

Hi Wolfgang,

 Is the log file not created at 'C:\Users\Public\(withpathtouser)\DBLog' ?

Regards,
Ady
Telerik

[Wolfgang]

Hi Ady,

no there is nothing. I managed now to get the infromation i wanted in the OpenAccess.Profiler. But still did not find a logfile.

Best regards,
Wolfgang

[Boris Georgiev]

Hello Wolfgang,

Can you try to save the log file at different location, to test you could change the path for example to: "c:\"? Also if the transaction has a short duration, there is a possibility nothing to be logged in the file.. 

If you want to the log file to be opened with Telerik OpenAccess Profiler you should save the file as a binary.

Can you try with this settings:

<logDownloader.filename>C:\DBLog</logDownloader.filename>
<logging.logEventsToTrace>true</logging.logEventsToTrace>
<logging.logEvents>All</logging.logEvents>
<logging.stackTrace>true</logging.stackTrace>
<logDownloader.metricBinary>True</logDownloader.metricBinary>
<logDownloader.eventText>True</logDownloader.eventText>
<logDownloader.eventBinary>True</logDownloader.eventBinary>

I hope that helps.
 
Regards,
Boris Georgiev
Telerik

[Wolfgang]

Hello Boris,

solved a part of the problem (setting another directory, even all other logs from our program are in the directory i specified first).

I still see 3(4) problems:

In the log file (text file) i see commands like 
driver.con.prepareCall      7 INSERT INTO
driver.con.prepareCall      7 INSERT INTO
and a corresponding stack trace behind.

1. Problem: I only see SELECT statements if i use Open Access Profiler to open binary file, no inserts.
2. In the text file it looks like there is a stack trace after the command. If i try to search the same in OpenAccess Profiler there is only  a statement "Stack trace is not available. The selected event ..."
3 The metrics file has zero bytes
(4) Funilly the time in the txt file seems to be one hour before (07:01 instead of 08:01) the actual time, OpenAccessProfiler shows correct time

Best regards
Wolfgang

[Boris Georgiev]

Hi Wolfgang,

Unfortunately I was not able to reproduce the first and the second issues that you have described. Could you please send us a sample application to reproduce the issue on our side? I have converted the forum thread into a Product Feedback ticket, so you are now allowed to add attachments.

If the transaction has a short duration, you should change the default values for "Metrics Snapshot" and "Metrics Store Interval" properties. The "Metrics Snapshot" property controls the interval to perform metric snapshots in milliseconds and the "Metric Store Interval" property controls the time in seconds between polls of the metric snapshot ring buffer.

I successfully reproduce the forth issue, but I will need additional time to investigate the issue.

Please excuse us for the inconvenienced caused. 

I am looking forward to hearing from you.

Regards,
Boris Georgiev
Telerik