Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: logging to table

  1. #1
    Join Date
    Sep 2011
    Posts
    2

    Default logging to table

    Hi,
    i'm trieing to do the logging on a table in my DB. So into the transformation (with the dimesion lookup/update) i do dx mouse click and on Log i insert DB connection, table name "LOG_ERROR" and schema. I'm without repository.
    So i have this error:

    - there was an error calculating data capture date range, it probably involvedlog table
    -select top 0 * from LOG_ERROR with (TABLOCKX, HOLDLOCK)
    - the object name LOG ERROR is not valid

    What i must do to view log into LOG_ERROR table into my DB?

  2. #2
    Join Date
    Sep 2011
    Posts
    2

    Default

    In addition, when i do the verify of the transormation, i have an error:

    Stepname Result Remark
    <global> 4 - Error The logging table doesn't exist on the logging connection

    What i can do to write the log into a table of my DB?

  3. #3
    Join Date
    Sep 2011
    Posts
    190

    Default

    If you go to the Job Properties -> Log tab and then click on the type of logging (Transformation, Step, ...) you will see an SQL button in the bottom of the dialog window. If you click on it, it suggests the CREATE TABLE statement for the logging table, which you can execute.

    When the logging tables are created, you should be able to use the logging.

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.