Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Unable to end processing by writing log record to table

  1. #1
    Join Date
    Aug 2008
    Posts
    9

    Unhappy Unable to end processing by writing log record to table

    Pls help..iam a newbie to kettle. I have created tansformations and use that transformation in the job.
    I tried to run the job at the command line but I got some errors:
    Here it is:


    A serious error occured :
    org.pentaho.di.core.exception.KettleJobException:

    Unable to end processing by writing log record to table

    Unable to write log record to log table
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '( JOBNAME, STATUS, LINES_READ, LINES_WRITTEN, LINES_UPDATED, LINES_INPUT, LINES_' at line 1

    Unable to end processing by writing log record to table

    Unable to write log record to log table
    You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '( JOBNAME, STATUS, LINES_READ, LINES_WRITTEN, LINES_UPDATED, LINES_INPUT, LINES_' at line 1

    Pls help.

  2. #2
    Join Date
    May 2006
    Posts
    4,882

    Default

    Do you have a log table?

    Regards,
    Sven

  3. #3
    Join Date
    Aug 2008
    Posts
    9

    Default

    no, i dont have

  4. #4
    Join Date
    Nov 1999
    Posts
    9,729

    Default

    Well, you configured a logging table. So you should create one in the specified database connection. Use the SQL button.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.