Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: What am I going wrong here?

  1. #1
    Join Date
    Sep 2005
    Posts
    1,403

    Default What am I going wrong here?

    I originally posted this question:

    http://forums.pentaho.org/showthread.php?t=48440

    I tried to take the advice but I guess I am not understanding the answer. BTW, is there some documentation that can provide some real world examples on how to use the tools?

    The script blow produces this error:

    2006/04/21 10:56:40 - be.ibridge.kettle.trans.Trans - Transformation is in preview mode...
    2006/04/21 10:56:40 - be.ibridge.kettle.trans.Trans - Dispatching started for filename [C:\ItemspecLoad.ktr]
    2006/04/21 10:56:40 - be.ibridge.kettle.trans.Trans - Nr of arguments detected:10
    2006/04/21 10:56:40 - be.ibridge.kettle.trans.Trans - This is not a replay transformation
    2006/04/21 10:56:40 - be.ibridge.kettle.trans.Trans - This transformation can be replayed with replay date: 2006/04/21 10:56:40
    2006/04/21 10:58:47 - Table output.0 - Connected to database [GOMDWMXD] (commit=0)
    2006/04/21 10:58:47 - Itemspec Input File.0 - Starting to run...
    2006/04/21 10:58:47 - Select values.0 - Starting to run...
    2006/04/21 10:58:47 - Java Script Value.0 - Starting to run...
    2006/04/21 10:58:47 - Table output.0 - Starting to run...
    2006/04/21 10:58:51 - Java Script Value.0 - ERROR : Javascript error: org.mozilla.javascript.WrappedException: WrappedException of null
    2006/04/21 10:58:51 - Java Script Value.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1
    2006/04/21 10:58:51 - be.ibridge.kettle.trans.Trans - ERROR : Errors detected!
    2006/04/21 10:58:51 - be.ibridge.kettle.trans.Trans - Looking at step: Itemspec Input File
    2006/04/21 10:58:52 - Table output.0 - Finished processing (I=0, O=0, R=0, W=0, U=0, E=0
    2006/04/21 10:58:52 - Itemspec Input File.0 - Finished processing (I=0, O=0, R=0, W=702, U=0, E=0
    2006/04/21 10:58:52 - be.ibridge.kettle.trans.Trans - Looking at step: Select values
    2006/04/21 10:58:52 - Select values.0 - Finished processing (I=0, O=0, R=352, W=351, U=0, E=0
    2006/04/21 10:58:52 - be.ibridge.kettle.trans.Trans - Looking at step: Java Script Value
    2006/04/21 10:58:52 - be.ibridge.kettle.trans.Trans - Looking at step: Table output
    2006/04/21 10:58:52 - Spoon - Step: Itemspec Input File --> 10 rows
    2006/04/21 10:58:52 - Spoon - Step: Select values --> 10 rows
    2006/04/21 10:58:52 - Spoon - Step: Java Script Value --> 0 rows
    2006/04/21 10:58:52 - Spoon - Step: Table output --> 0 rows
    2006/04/21 11:01:38 - Spoon - The transformation has finished!!


    *******Seperator not included in script********************
    if ( ITEMNUM.length() > ITEMNUM.getLength() )
    {
    ITEMNUM.substr(0,ITEMNUM.getLength() );
    }

    if ( CLASSSTRUCTUREID.length() > CLASSSTRUCTUREID.getLength())
    {
    CLASSSTRUCTUREID.substr(0, CLASSSTRUCTUREID.getLength() );
    }

    if ( ATTRIBUTE1.length() > ATTRIBUTE1.getLength() )
    {
    ATTRIBUTE1.substr(0, ATTRIBUTE1.getLength() );
    }

    if ( ATTRIBUTE2.length() > ATTRIBUTE2.getLength() )
    {
    ATTRIBUTE2.substr(0, ATTRIBUTE2.getLength() );
    }

    if ( ATTRIBUTE3.length() > ATTRIBUTE3.getLength() )
    {
    ATTRIBUTE3.substr(0, ATTRIBUTE3.getLength() );
    }

    if ( ATTRIBUTE4.length() > ATTRIBUTE4.getLength() )
    {
    ATTRIBUTE4.substr(0, ATTRIBUTE4.getLength() );
    }

    if ( ATTRIBUTE5.length() > ATTRIBUTE5.getLength() )
    {
    ATTRIBUTE5.substr(0, ATTRIBUTE5.getLength() );
    }

    if ( ATTRIBUTE6.length() > ATTRIBUTE6.getLength() )
    {
    ATTRIBUTE6.substr(0, ATTRIBUTE6.getLength() );
    }

    if ( ATTRIBUTE7.length() > ATTRIBUTE7.getLength() )
    {
    ATTRIBUTE7.substr(0, ATTRIBUTE7.getLength() );
    }

    if ( ATTRIBUTE8.length() > ATTRIBUTE8.getLength() )
    {
    ATTRIBUTE8.substr(0, ATTRIBUTE8.getLength() );
    }

    if ( ATTRIBUTE9.length() > ATTRIBUTE9.getLength() )
    {
    ATTRIBUTE9.substr(0, ATTRIBUTE9.getLength() );
    }

    if ( ATTRIBUTE10.length() > ATTRIBUTE10.getLength() )
    {
    ATTRIBUTE10.substr(0, ATTRIBUTE10.getLength() );
    }

    if ( ATTRIBUTE11.length() > ATTRIBUTE11.getLength() )
    {
    ATTRIBUTE11.substr(0, ATTRIBUTE11.getLength() );
    }

    if ( ATTRIBUTE12.length() > ATTRIBUTE12.getLength() )
    {
    ATTRIBUTE12.substr(0, ATTRIBUTE12.getLength() );
    }

    if ( ATTRIBUTE13.length() > ATTRIBUTE13.getLength() )
    {
    ATTRIBUTE13.substr(0, ATTRIBUTE13.getLength() );
    }

    if ( ATTRIBUTE14.length() > ATTRIBUTE14.getLength() )
    {
    ATTRIBUTE14.substr(0, ATTRIBUTE14.getLength() );
    }

    if ( ATTRIBUTE15.length() > ATTRIBUTE15.getLength() )
    {
    ATTRIBUTE15.substr(0, ATTRIBUTE15.getLength() );
    }

    if ( ATTRIBUTE16.length() > ATTRIBUTE16.getLength() )
    {
    ATTRIBUTE16.substr(0, ATTRIBUTE16.getLength() );
    }

    if ( ATTRIBUTE17.length() > ATTRIBUTE17.getLength() )
    {
    ATTRIBUTE17.substr(0, ATTRIBUTE17.getLength() );
    }

    if ( ATTRIBUTE18.length() > ATTRIBUTE18.getLength() )
    {
    ATTRIBUTE18.substr(0, ATTRIBUTE18.getLength() );
    }

    if ( ATTRIBUTE19.length() > ATTRIBUTE19.getLength() )
    {
    ATTRIBUTE19.substr(0, ATTRIBUTE19.getLength() );
    }

    if ( ATTRIBUTE20.length() > ATTRIBUTE20.getLength() )
    {
    ATTRIBUTE20.substr(0, ATTRIBUTE20.getLength() );
    }
    *******Seperator not included in script********************

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

    Default RE: What am I going wrong here?

    Dear Mr/Mrs Anonymous,


    We're getting close to 1000 messages on this Forum, I'm posting weekly tips, there IS documentation, there are plenty of examples so your remarks are not taken very well on this end of the line. Maybe I'm tired, it's Friday.



    I'm not going to solve any and every simple javascript problem that you might have. If that is what you were expecting, then perhaps you can opt for a professional support contract. There is information on this on the Pentaho homepage.



    Please note, that although this remark might seem over the top, I did give you an alternative solution that you chose to ignore.



    Thanks for your understanding,



    Matt

  3. #3
    Join Date
    Nov 1999
    Posts
    459

    Default RE: What am I going wrong here?

    A similar case (searched for 'substr&#39 that was working:

    http://forums.pentaho.org/showthread.php?t=48330

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.