1 Reply Latest reply on Dec 3, 2016 2:14 PM by Tom W

    How to analyse Java log txt file in Tableau?

    Steve Solun

      Given a txt file of Java log (I have a program that generates such logs) - for example scheduler log like this:

       

      2016-12-01 05:13:57,290+0200 INFO  [com.calypso.SYSTEM.ScheduledTaskSpecificLogCategory] (Thread-3983) [-] 2016-12-01 05:13:57,290+0200 ERROR [com.calypso.RISK] (main) [-] com.calypso.tk.risk.AnalysisException: Can't convert to ILS on 01/12/16 23:30:00.000 o'clock IST  Cannot convert amount: No curve for adjusting FX in CurrencyUtil For trade kind FXSwap
      2016-12-01 05:13:57,290+0200 INFO  [com.calypso.SYSTEM.ScheduledTaskSpecificLogCategory] (Thread-3983) [-] 2016-12-01 05:13:57,290+0200 ERROR [com.calypso.RISK] (main) [-] com.calypso.tk.risk.AnalysisException: Can't convert to ILS on 01/12/16 23:30:00.000 o'clock IST  Cannot convert amount: No curve for adjusting FX in CurrencyUtil For trade kind FXSwap
      2016-12-01 05:13:57,290+0200 INFO  [com.calypso.SYSTEM.ScheduledTaskSpecificLogCategory] (Thread-3983) [-] 2016-12-01 05:13:57,290+0200 ERROR [com.calypso.RISK] (main) [-] 
      
      com.calypso.tk.risk.AnalysisException: Can't convert to ILS on 01/12/16 23:30:00.000 o'clock IST  Cannot convert amount: No curve for adjusting FX in CurrencyUtil For trade kind FXSwap
      2016-12-01 05:13:57,290+0200 INFO  [com.calypso.SYSTEM.ScheduledTaskSpecificLogCategory] (Thread-3983) [-] 2016-12-01 05:13:57,290+0200 ERROR [com.calypso.RISK] (main) [-] com.calypso.tk.risk.AnalysisException: Can't convert to ILS on 01/12/16 23:30:00.000 o'clock IST  Cannot convert amount: No curve for adjusting FX in CurrencyUtil For trade kind FXSwap
      2016-12-01 05:13:57,290+0200 INFO  [com.calypso.SYSTEM.ScheduledTaskSpecificLogCategory] (Thread-3983) [-] 2016-12-01 05:13:57,290+0200 ERROR [com.calypso.RISK] (main) [-] com.calypso.tk.risk.AnalysisException: Can't convert to ILS on 01/12/16 23:30:00.000 o'clock IST  Cannot convert amount: No curve for adjusting FX in CurrencyUtil For trade kind FXSwap
      2016-12-01 05:13:57,290+0200 INFO  [com.calypso.SYSTEM.ScheduledTaskSpecificLogCategory] (Thread-3983) [-] 2016-12-01 05:13:57,290+0200 ERROR [com.calypso.RISK] (main) [-] com.calypso.tk.risk.AnalysisException: Can't convert to ILS on 01/12/16 23:30:00.000 o'clock IST  Cannot convert amount: No curve for adjusting FX in CurrencyUtil For trade kind FXSwap
      2016-12-01 05:13:57,290+0200 INFO  [com.calypso.SYSTEM.ScheduledTaskSpecificLogCategory] (Thread-3983) [-] 2016-12-01 05:13:57,290+0200 ERROR [com.calypso.RISK] (main) [-] com.calypso.tk.risk.AnalysisException: Can't convert to ILS on 01/12/16 23:30:00.000 o'clock IST  Cannot convert amount: No curve for adjusting FX in CurrencyUtil For trade kind FXSwap
      2016-12-01 05:13:57,290+0200 INFO  [com.calypso.SYSTEM.ScheduledTaskSpecificLogCategory] (Thread-3983) [-] 2016-12-01 05:13:57,290+0200 ERROR [com.calypso.RISK] (main) [-] com.calypso.tk.risk.AnalysisException: Can't convert to ILS on 01/12/16 23:30:00.000 o'clock IST  Cannot convert amount: No curve for adjusting FX in CurrencyUtil For trade kind FXSwap
      2016-12-01 05:13:57,290+0200 INFO  [com.calypso.SYSTEM.ScheduledTaskSpecificLogCategory] (Thread-3983) [-] 2016-12-01 05:13:57,290+0200 ERROR [com.calypso.RISK] (main) [-] com.calypso.tk.risk.AnalysisException: Can't convert to ILS on 01/12/16 23:30:00.000 o'clock IST  Cannot convert amount: No curve for adjusting FX in CurrencyUtil For trade kind FXSwap
      2016-12-01 05:13:57,290+0200 INFO  [com.calypso.SYSTEM.ScheduledTaskSpecificLogCategory] (Thread-3983) [-] 2016-12-01 05:13:57,290+0200 ERROR [com.calypso.RISK] (main) [-] com.calypso.tk.risk.AnalysisException: Can't convert to ILS on 01/12/16 23:30:00.000 o'clock IST  Cannot convert amount: No curve for adjusting FX in CurrencyUtil For trade kind FXSwap
      2016-12-01 05:13:57,290+0200 INFO  [com.calypso.SYSTEM.ScheduledTaskSpecificLogCategory] (Thread-3983) [-] 2016-12-01 05:13:57,290+0200 ERROR [com.calypso.RISK] (main) [-] com.calypso.tk.risk.AnalysisException: Can't convert to ILS on 01/12/16 23:30:00.000 o'clock IST  Cannot convert amount: No curve for adjusting FX in CurrencyUtil For trade kind FXSwap
      2016-12-01 05:13:57,290+0200 INFO  [com.calypso.SYSTEM.ScheduledTaskSpecificLogCategory] (Thread-3983) [-] 2016-12-01 05:13:57,290+0200 ERROR [com.calypso.RISK] (main) [-] com.calypso.tk.risk.AnalysisException: Can't convert to ILS on 01/12/16 23:30:00.000 o'clock IST  Cannot convert amount: No curve for adjusting FX in CurrencyUtil For trade kind FXSwap
      2016-12-01 05:13:57,290+0200 INFO  [com.calypso.SYSTEM.ScheduledTaskSpecificLogCategory] (Thread-3983) [-] 2016-12-01 05:13:57,290+0200 ERROR [com.calypso.RISK] (main) [-] com.calypso.tk.risk.AnalysisException: Can't convert to ILS on 01/12/16 23:30:00.000 o'clock IST  Cannot convert amount: No curve for adjusting FX in CurrencyUtil For trade kind FXSwap
      2016-12-01 05:13:57,290+0200 INFO  [com.calypso.SYSTEM.ScheduledTaskSpecificLogCategory] (Thread-3983) [-] 2016-12-01 05:13:57,290+0200 ERROR [com.calypso.RISK] (main) [-] com.calypso.tk.risk.AnalysisException: Can't convert to ILS on 01/12/16 23:30:00.000 o'clock IST  Cannot convert amount: No curve for adjusting FX in CurrencyUtil For trade kind FXSwap
      2016-12-01 05:13:57,290+0200 INFO  [com.calypso.SYSTEM.ScheduledTaskSpecificLogCategory] (Thread-3983) [-] 2016-12-01 05:13:57,290+0200 ERROR [com.calypso.RISK] (main) [-] com.calypso.tk.risk.AnalysisException: Can't convert to ILS on 01/12/16 23:30:00.000 o'clock IST  Cannot convert amount: No curve for adjusting FX in CurrencyUtil For trade kind FXSwap
      2016-12-01 05:13:57,290+0200 INFO  [com.calypso.SYSTEM.ScheduledTaskSpecificLogCategory] (Thread-3983) [-] 2016-12-01 05:13:57,290+0200 ERROR [com.calypso.RISK] (main) [-] com.calypso.tk.risk.AnalysisException: Can't convert to ILS on 01/12/16 23:30:00.000 o'clock IST  Cannot convert amount: No curve for adjusting FX in CurrencyUtil For trade kind FXSwap
      2016-12-01 05:13:57,290+0200 INFO  [com.calypso.SYSTEM.ScheduledTaskSpecificLogCategory] (Thread-3983) [-] 2016-12-01 05:13:57,290+0200 ERROR [com.calypso.RISK] (main) [-] com.calypso.tk.risk.AnalysisException: Can't convert to ILS on 01/12/16 23:30:00.000 o'clock IST  Cannot convert amount: No curve for adjusting FX in CurrencyUtil For trade kind FXSwap
      2016-12-01 05:13:57,290+0200 INFO  [com.calypso.SYSTEM.ScheduledTaskSpecificLogCategory] (Thread-3983) [-] 2016-12-01 05:13:57,290+0200 ERROR [com.calypso.RISK] (main) [-] com.calypso.tk.risk.AnalysisException: Can't convert to ILS on 01/12/16 23:30:00.000 o'clock IST  Cannot convert amount: No curve for adjusting FX in CurrencyUtil For trade kind FXSwap
      2016-12-01 05:13:57,290+0200 INFO  [com.calypso.SYSTEM.ScheduledTaskSpecificLogCategory] (Thread-3983) [-] 2016-12-01 05:13:57,290+0200 ERROR [com.calypso.RISK] (main) [-] com.calypso.tk.risk.AnalysisException: Can't convert to ILS on 01/12/16 23:30:00.000 o'clock IST  Cannot convert amount: No curve for adjusting FX in CurrencyUtil For trade kind FXSwap
      2016-12-01 05:13:57,290+0200 INFO  [com.calypso.SYSTEM.ScheduledTaskSpecificLogCategory] (Thread-3983) [-] 2016-12-01 05:13:57,290+0200 ERROR [com.calypso.RISK] (main) [-] com.calypso.tk.risk.AnalysisException: Can't convert to ILS on 01/12/16 23:30:00.000 o'clock IST  Cannot convert amount: No curve for adjusting FX in CurrencyUtil For trade kind FX
      

       

       

       

      I need to parse it in a smart way to fit excel:

       

       

      timestamp, error level, message keywords.

       

       

      Please suggest me a best practice to analyse this kind of log.

      Can I do this in Tableau?