This is a migrated thread and some comments may be shown as answers.

Ho to turn loglevel to all in xml?

7 Answers 28 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Wolfgang
Top achievements
Rank 1
Wolfgang asked on 11 Sep 2013, 03:09 PM
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

7 Answers, 1 is accepted

Sort by
0
Ady
Telerik team
answered on 13 Sep 2013, 02:21 PM
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
OpenAccess ORM Q2 2013 brings you a more powerful code generation and a unique Bulk Operations support with LINQ syntax. Check out the list of new functionality and improvements shipped with this release.
0
Wolfgang
Top achievements
Rank 1
answered on 14 Sep 2013, 06:33 AM

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

0
Ady
Telerik team
answered on 18 Sep 2013, 03:46 PM
Hi Wolfgang,

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

Regards,
Ady
Telerik
OpenAccess ORM Q2 2013 brings you a more powerful code generation and a unique Bulk Operations support with LINQ syntax. Check out the list of new functionality and improvements shipped with this release.
0
Wolfgang
Top achievements
Rank 1
answered on 13 Nov 2013, 04:25 PM
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
0
Boris Georgiev
Telerik team
answered on 18 Nov 2013, 05:31 PM
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
OpenAccess ORM Q3 2013 simplifies your model operations even further providing you with greater flexibility. Check out the list of new features shipped with our latest release!
0
Wolfgang
Top achievements
Rank 1
answered on 19 Nov 2013, 07:21 AM
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
0
Boris Georgiev
Telerik team
answered on 22 Nov 2013, 06:20 AM
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
OpenAccess ORM Q3 2013 simplifies your model operations even further providing you with greater flexibility. Check out the list of new features shipped with our latest release!
Tags
General Discussions
Asked by
Wolfgang
Top achievements
Rank 1
Answers by
Ady
Telerik team
Wolfgang
Top achievements
Rank 1
Boris Georgiev
Telerik team
Share this question
or