Custom Log File unknown format

akentanaka — Thu, 11 Sep 2008 08:48:48 GMT

Hi,

I have no luck with the log that I'm trying to parse. I'm new to this world of log parsing and my initial thought to parse our custom log (below) is to use TSV but I can't seem to understand how EXTRACT_TOKEN works.

Below is a sample of our log file.

10 Sep 2008 03:09:46,571 [Current Time=Wed Sep 10 03:09:46 BST 2008] [Process Name=:Module1:Module-Utilities:Utilities1:MyAlerts] [Root Job Id=2ad6505aff2ebcfa:182fe42d:11c4132e476:-80002-1221012586509] [Job Id=2ad6505aff2ebcfa:182fe42d:11c4132e476:-80002-1221012586509]
An error occurred that triggered compensation:
Summary: Execution failed.

Caused by:
   Summary: no peer with a running instance of WorkFlowAnalyzer found
10 Sep 2008 03:09:46,571 [Current Time=Wed Sep 10 03:09:46 BST 2008] [Process Name=:Module1:Module-Utilities:Utilities1:MyAlerts:Module[3]:SubModule[2]:Utilities:MyModule[7]] [Root Job Id=2ad6505aff2ebcfa:182fe42d:11c4132e476:-80002-1221012586509] [Job Id=2ad6505aff2ebcfa:182fe42d:11c4132e476:-80002-1221012586509]
The process started.
10 Sep 2008 03:09:46,571 [Current Time=Wed Sep 10 03:09:46 BST 2008] [Process Name=:Module1:Module-Utilities:Utilities1:MyAlerts] [Root Job Id=2ad6505aff2ebcfa:182fe42d:11c4132e476:-80002-1221012586509] [Job Id=2ad6505aff2ebcfa:182fe42d:11c4132e476:-80002-1221012586509]
Adapter request
[adapter request=
<request-data>
<my-action>
    <fields>
      <field>Description</field>
      <field>Detailed_Description</field>
      <field>Reported Source</field>
      <field>Requester Full Name</field>
    </fields>
</my-action>
</request-data>]

It appears that it has 6 parts

1) The date part

2) [Current Time=

3) [Process Name=

4) [Root Job Id=

5) [Job Id=

6) Log message

How can I break the log into 6 columns? I might use Log Parser Lizard to analyze the log file.

Thanks for your help!

Re: RE: Error: Log row too long

ffmatyas — Tue, 04 Mar 2008 15:38:45 GMT

Hi,

Read this thread http://www.codeplex.com/PAL/Thread/View.aspx?ThreadId=22876 . And credit the author.

Cheers

Ferenc

Search results matching tag 'log parser max row size CSV and TSV input formats'

Custom Log File unknown format

Re: RE: Error: Log row too long