Ho to turn loglevel to all in xml?

8 posts, 0 answers
  1. Wolfgang
    Wolfgang avatar
    98 posts
    Member since:
    Oct 2012

    Posted 11 Sep 2013 Link to this post

    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
  2. Ady
    Admin
    Ady avatar
    589 posts

    Posted 13 Sep 2013 Link to this post

    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.
  3. DevCraft banner
  4. Wolfgang
    Wolfgang avatar
    98 posts
    Member since:
    Oct 2012

    Posted 14 Sep 2013 Link to this post

    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

  5. Ady
    Admin
    Ady avatar
    589 posts

    Posted 18 Sep 2013 Link to this post

    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.
  6. Wolfgang
    Wolfgang avatar
    98 posts
    Member since:
    Oct 2012

    Posted 13 Nov 2013 Link to this post

    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
  7. Boris Georgiev
    Admin
    Boris Georgiev avatar
    190 posts

    Posted 18 Nov 2013 Link to this post

    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!
  8. Wolfgang
    Wolfgang avatar
    98 posts
    Member since:
    Oct 2012

    Posted 19 Nov 2013 Link to this post

    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
  9. Boris Georgiev
    Admin
    Boris Georgiev avatar
    190 posts

    Posted 22 Nov 2013 Link to this post

    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!
Back to Top
DevCraft banner