Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: Trouble-this is not a replay transformation

  1. #1
    Join Date
    May 2014
    Posts
    5

    Unhappy Trouble-this is not a replay transformation

    today i find log something is worng ,the log is :
    2014/05/13 12:50:11 - F_PAYMENT_LOGS_2_TRIG - Loading transformation from XML file [file:///home/etl/ETL_TEST/DW/KTR/F_PAYMENT_LOGS_2_TRIG.ktr]
    2014/05/13 12:50:12 - F_PAYMENT_LOGS_2_TRIG - Dispatching started for transformation [F_PAYMENT_LOGS_2_TRIG]
    2014/05/13 12:50:13 - Table output.0 - Connected to database [ORCL_ODW] (commit=10000)
    2014/05/13 12:50:13 - Get rows from result.0 - Finished processing (I=0, O=0, R=16, W=16, U=0, E=0)
    2014/05/13 12:50:13 - Get sysdate 3 2.0 - Finished processing (I=0, O=0, R=16, W=16, U=0, E=0)
    2014/05/13 12:50:13 - Add col 2 2.0 - Finished processing (I=0, O=0, R=16, W=32, U=0, E=0)
    2014/05/13 12:50:13 - game .0 - Finished processing (I=16, O=0, R=16, W=0, U=0, E=0) it's wrong ,the data is lost to the next
    2014/05/13 12:50:16 - Update.0 - Finished processing (I=16, O=0, R=16, W=16, U=16, E=0)

    the trans like Name:  1244.jpg
Views: 111
Size:  15.6 KB,
    the data is lost which is unbelieveable;

    so i check the trans,then i find
    2014/05/14 16:46:11 - Transformation metadata - Looking at hop #107
    2014/05/14 16:46:11 - Transformation metadata - Looking at hop #108
    2014/05/14 16:46:11 - Transformation metadata - Looking at hop #109
    2014/05/14 16:46:11 - Transformation metadata - nr of steps read : 90
    2014/05/14 16:46:11 - Transformation metadata - nr of hops read : 110
    2014/05/14 16:46:11 - F_PAYMENT_LOGS_2_TRIG - Transformation is pre-loaded.
    2014/05/14 16:46:11 - F_PAYMENT_LOGS_2_TRIG - nr of steps to run : 90 , nr of hops : 110
    2014/05/14 16:46:11 - Spoon - Transformation opened.
    2014/05/14 16:46:11 - Spoon - Launching transformation [F_PAYMENT_LOGS_2_TRIG]...
    2014/05/14 16:46:11 - Spoon - Started the transformation execution.
    2014/05/14 16:46:11 - F_PAYMENT_LOGS_2_TRIG - Dispatching started for transformation [F_PAYMENT_LOGS_2_TRIG]
    2014/05/14 16:46:11 - F_PAYMENT_LOGS_2_TRIG - Nr of arguments detected:0
    2014/05/14 16:46:11 - F_PAYMENT_LOGS_2_TRIG - This is not a replay transformation

    Name:  1234.jpg
Views: 111
Size:  11.7 KB

    if i delete the red ,the trans can work,

    also i find somthing in the forums like http://forums.pentaho.com/showthread...formation-quot and http://forums.pentaho.com/showthread...transformation

    but it seems no useful.

  2. #2
    Join Date
    Apr 2008
    Posts
    4,696

    Default

    So you are showing two potentially different issues.

    My initial guess:
    Issue 1) game.0 is an inner DB join, and none of the rows being fed into it match anything, and so they don't continue through the stream.
    Issue 2) There is something wrong with how the "Insert or Update 2" step is defined. The message "This is not a replay transformation" is INFO only - it is not an error.

    Notes: 90 steps within a transformation is A LOT. You should look at what you are doing and try to determine how to break the work down into smaller chunks.

  3. #3
    Join Date
    May 2014
    Posts
    5

    Default

    thanks for u answer;
    Issue 1) the DB join is left join and return something, so it is not the problem;
    Issue 2) the filter is simple ,Name:  1234.jpg
Views: 107
Size:  14.3 KB,also work

    when i check it again today,i found it success which i cann't understand,because i do nothing.
    this is the pic:Name:  12345.jpg
Views: 97
Size:  30.1 KB

    at the end ,this ktr has many steps,because it is complex.

Tags for this Thread

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.