Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: ERROR_TRANSFORMATION sometimes not working

  1. #1
    Join Date
    Mar 2009
    Posts
    137

    Default ERROR_TRANSFORMATION sometimes not working

    Hi everybody,

    did someone realize the same?

    Usint the trans_status ERROR_TRANSFORMATION sometimes not leads to an failure for the transformation?

    If I check the logs, it shows the errors
    2009/08/04 11:43:34 - check settings.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : setting 'test.value' needed
    2009/08/04 11:43:34 - check settings.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : setting 'test2.value' needed
    2009/08/04 11:43:34 - check settings.0 - setting 'core.debug' checked successfully
    2009/08/04 11:43:34 - check settings.0 - ERROR (version 3.2.0-GA, build 10572 from 2009-05-12 08.45.26 by buildguy) : value invalid

    but looking at the job metrics the transformation's result is "Success", and the whole integration did not stop because of an error.

    The JavaScript looks like this:

    Code:
    writeToLog("e", "setting '" + varName + "' needed")
    trans_Status = ERROR_TRANSFORMATION;
    or

    Code:
    writeToLog("e", "value invalid")
    trans_Status = ERROR_TRANSFORMATION;
    Thanks!
    Last edited by Jogilein; 08-04-2009 at 05:52 AM.

  2. #2
    Join Date
    Feb 2009
    Posts
    296

    Default

    What is "trans_Status" supposed to do? Never seen that before.
    Fabian,
    doing ETL with his hands bound on his back

  3. #3
    Join Date
    Mar 2009
    Posts
    137

    Default

    Well, it should controll the status of the row... you have three possible status:

    - ERROR_TRANSFORMATION
    - CONTINUE_TRANSFORMATION
    - SKIP_TRANSFORMATION

    (see the Transform_Constants using the JavaScript Step)... the default value of trans_Status is CONTINUE_TRANSFORMATION, but if the input row should be skipped you can set it to SKIP_TRANSFORMATION and it would be skipped... if you want to raise an error normally you set it to ERROR_TRANSFORMATION.

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.