We are excited to announce that the IIS.NET Forums are moving to the new Microsoft Q&A experience. Learn more >

HTTPErr input log format is not working when 'streamid' column is presentRSS

3 replies

Last post Feb 15, 2021 04:58 AM by fkkhan

‹ Previous Thread|Next Thread ›
  • HTTPErr input log format is not working when 'streamid' column is present

    Mar 09, 2019 12:46 PM|Pratyay|LINK

    Since streamid column is not supported in HTTPErr input log format, all the queries are failing even if I am specifically mentioning the column names. How to get around this problem ? Will you able to add support for streamid column in LogParser HTTPErr query handler ?

    #Software: Microsoft HTTP API 2.0
    #Version: 1.0
    #Date: 2019-03-02 09:06:31
    #Fields: date time c-ip c-port s-ip s-port cs-version cs-method cs-uri streamid sc-status s-siteid s-reason s-queuename
    2019-03-02 09:06:31 123.211.412.127 25144 10.0.0.4 80 - - - - - - Timer_ConnectionIdle -
    2019-03-02 09:07:36 123.211.412.127 38801 10.0.0.4 80 - - - - - - Timer_ConnectionIdle -
    2019-03-02 09:08:11 123.211.412.127 45184 10.0.0.4 80 - - - - - - Timer_ConnectionIdle -

    Error Details

    C:\Program Files (x86)\Log Parser 2.2>LogParser.exe -i:HTTPErr "SELECT top 5 date, time, cs-version, cs-method, cs-uri FROM 'D:\HTTPERR\httperr2.log'" -e 10

    date time cs-version cs-method cs-uri
    ---------- -------- ---------- --------- ------------------------------
    2019-03-02 09:06:31 - - - - - - Timer_ConnectionIdle -
    2019-03-02 09:07:36 - - - - - - Timer_ConnectionIdle -
    2019-03-02 09:08:11 - - - - - - Timer_ConnectionIdle -
    2019-03-02 19:21:26 - - - - 400 - Verb -
    2019-03-02 19:21:26 - - - - 400 - Verb -
    Task completed with parse errors.
    Parse errors:
    Unknown field streamid found in #Fields directive

  • Re: HTTPErr input log format is not working when 'streamid' column is present

    Oct 23, 2019 02:14 PM|caseee|LINK

    Same error here.

    Made something like this:


    . "C:\Program Files (x86)\Log Parser 2.2\LogParser.exe" "select * into 'C:\logs\errors.xml' from C:\Windows\System32\LogFiles\HTTPERR\*.*" -i:tsv -iseparator ''space'' -lineFilter +"#" -iheaderfile c:\logs\header.txt

    with header.txt:

    date time c-ip c-port s-ip s-port cs-version cs-method cs-uri streamid sc-status s-siteid s-reason s-queuename

  • Re: HTTPErr input log format is not working when 'streamid' column is present

    Dec 19, 2020 05:53 PM|M G|LINK

    Another option is to Change format of IIS HTTP Error logging by using ErrorLoggingFields registry key under HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\HTTP\Parameters to remove the streamid field.

  • Re: HTTPErr input log format is not working when 'streamid' column is present

    Feb 15, 2021 04:58 AM|fkkhan|LINK

    HTTPError 503 is a type of HTTPError, and so it's just as catchy as it is. It is given in the praw "requests" library, so you might not have seen it itself in the praw documentation.

    I've made a decorator for my bot for anything making reddit API calls; it's intended to log errors, but not to kill the bot.

    Even if you don't use the code explicitly, all the exceptions mentioned in the reddit API are the exceptions.

    A little while ago, PRAW began to configure all its exceptions. The 503 requests were captured in this case by the PRAW.exceptions. HTTPError.

    .................................................................................................................................................

    Hope This will helpful. Regards FahadKhan

‹ Previous Thread|Next Thread ›