Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: RegEx Evaluation step errors

  1. #1
    Join Date
    Jun 2011
    Posts
    12

    Default RegEx Evaluation step errors

    Goodmorning,

    I'm running into some problems with one of my transformations.

    These transformations receive some rows, do a join. And towards the end comes a RegEx evaluation step.

    This step looks at an url field (http://www.pentaho.com/etc...) which can be basicly anything of any lenght.

    The RegEx is supposed to pick out the www.xxx.xxx part and create a new column for it.

    Now comes te problem, sometimes the RegEx evaluation goes according to plan, no errors whatsoever.. But a couple of times a day (the transformation runs every hour) it returns errors.

    Below are the error logs, but I have no idea what the RegEx errors mean. First I thought maybe because there are no input rows at the time the transformation runs (which is possible) but if I look at the log there are input rows.

    If anyone could help me with this that would be appreciated

    Thank you.

    Error transformation 1:
    Code:
    2011/11/03 09:50:30 - PS27 Boekingen 2 - Loading transformation from repository [PS27 Boekingen 2] in directory [/Production/Boekingen/PS27]
    2011/11/03 09:50:30 - PS27 Boekingen 2 - Dispatching started for transformation [PS27 Boekingen 2]
    2011/11/03 09:50:57 - PS27 Output.0 - Connected to database [PS27 TUI Results] (commit=1000)
    2011/11/03 09:50:57 - Get Variables.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
    2011/11/03 09:50:57 - PS27 Input.0 - Finished reading query, closing connection.
    2011/11/03 09:50:57 - PS27 Input.0 - Finished processing (I=2, O=0, R=0, W=2, U=0, E=0)
    2011/11/03 09:50:57 - Delete 27.0 - Finished processing (I=0, O=0, R=2, W=2, U=2, E=0)
    2011/11/03 09:50:57 - Select values 2.0 - Finished processing (I=0, O=0, R=2, W=2, U=0, E=0)
    2011/11/03 09:50:57 - Sort rows.0 - Finished processing (I=0, O=0, R=2, W=2, U=0, E=0)
    2011/11/03 09:50:57 - Blocking Step 2.0 - Finished processing (I=0, O=0, R=2, W=2, U=0, E=0)
    2011/11/03 09:53:23 - ps27 ns_url_fact.0 - Finished reading query, closing connection.
    2011/11/03 09:53:23 - ps27 ns_url_fact.0 - Finished processing (I=843, O=0, R=0, W=843, U=0, E=0)
    2011/11/03 09:53:23 - Blocking Step.0 - Finished processing (I=0, O=0, R=843, W=843, U=0, E=0)
    2011/11/03 09:53:23 - Sort rows 2.0 - Finished processing (I=0, O=0, R=843, W=843, U=0, E=0)
    2011/11/03 09:53:23 - Blocking Step 3.0 - Finished processing (I=0, O=0, R=843, W=843, U=0, E=0)
    2011/11/03 09:53:23 - Merge Join.0 - Finished processing (I=0, O=0, R=845, W=2, U=0, E=0)
    2011/11/03 09:53:23 - blocking join.0 - Finished processing (I=0, O=0, R=2, W=2, U=0, E=0)
    2011/11/03 09:53:23 - Sort rows 3.0 - Finished processing (I=0, O=0, R=2, W=2, U=0, E=0)
    2011/11/03 09:53:23 - Regex Evaluation.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Unexpected error
    2011/11/03 09:53:23 - Regex Evaluation.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : java.lang.ArrayIndexOutOfBoundsException: 52
    2011/11/03 09:53:23 - Regex Evaluation.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 	at org.pentaho.di.trans.steps.regexeval.RegexEval.processRow(RegexEval.java:144)
    2011/11/03 09:53:23 - Regex Evaluation.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 	at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
    2011/11/03 09:53:23 - Regex Evaluation.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 	at java.lang.Thread.run(Unknown Source)
    2011/11/03 09:53:23 - Regex Evaluation.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
    2011/11/03 09:53:23 - Unique rows.0 - Finished processing (I=0, O=0, R=2, W=1, U=0, E=0)
    2011/11/03 09:53:23 - PS27 Boekingen 2 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Errors detected!
    2011/11/03 09:53:23 - PS27 Boekingen 2 - PS27 Boekingen 2
    2011/11/03 09:53:23 - PS27 Boekingen 2 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Errors detected!
    2011/11/03 09:53:23 - PS27 Boekingen 2 - PS27 Boekingen 2
    Error transformation 2:
    Code:
    2011/11/03 09:53:51 - PS28 Boekingen 2 - Loading transformation from repository [PS28 Boekingen 2] in directory [/Production/Boekingen/PS28]
    2011/11/03 09:53:52 - PS28 Boekingen 2 - Dispatching started for transformation [PS28 Boekingen 2]
    2011/11/03 09:54:06 - PS28 Output.0 - Connected to database [PS28 TUI Results] (commit=1000)
    2011/11/03 09:54:10 - Get Variables.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
    2011/11/03 09:54:10 - PS28 Input.0 - Finished reading query, closing connection.
    2011/11/03 09:54:10 - PS28 Input.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
    2011/11/03 09:54:10 - Delete 28.0 - Finished processing (I=0, O=0, R=1, W=1, U=1, E=0)
    2011/11/03 09:54:10 - Select values 2.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
    2011/11/03 09:54:10 - Sort rows.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
    2011/11/03 09:54:10 - Blocking Step 2.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
    2011/11/03 09:56:28 - ps28 ns_url_fact.0 - Finished reading query, closing connection.
    2011/11/03 09:56:28 - Blocking Step 4.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
    2011/11/03 09:56:28 - ps28 ns_url_fact.0 - Finished processing (I=1, O=0, R=0, W=1, U=0, E=0)
    2011/11/03 09:56:28 - Sort rows 2.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
    2011/11/03 09:56:28 - Blocking Step 3.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
    2011/11/03 09:56:28 - Merge Join.0 - Finished processing (I=0, O=0, R=2, W=1, U=0, E=0)
    2011/11/03 09:56:28 - Blocking Step.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
    2011/11/03 09:56:28 - Sort rows 3.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
    2011/11/03 09:56:28 - Unique rows.0 - Finished processing (I=0, O=0, R=1, W=1, U=0, E=0)
    2011/11/03 09:56:28 - Regex Evaluation.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Unexpected error
    2011/11/03 09:56:28 - Regex Evaluation.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : java.lang.ArrayIndexOutOfBoundsException: 52
    2011/11/03 09:56:28 - Regex Evaluation.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 	at org.pentaho.di.trans.steps.regexeval.RegexEval.processRow(RegexEval.java:144)
    2011/11/03 09:56:28 - Regex Evaluation.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 	at org.pentaho.di.trans.step.RunThread.run(RunThread.java:40)
    2011/11/03 09:56:28 - Regex Evaluation.0 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : 	at java.lang.Thread.run(Unknown Source)
    2011/11/03 09:56:28 - Regex Evaluation.0 - Finished processing (I=0, O=0, R=1, W=0, U=0, E=1)
    2011/11/03 09:56:28 - PS28 Boekingen 2 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Errors detected!
    2011/11/03 09:56:28 - PS28 Boekingen 2 - PS28 Boekingen 2
    2011/11/03 09:56:28 - PS28 Boekingen 2 - PS28 Boekingen 2
    2011/11/03 09:56:28 - PS28 Boekingen 2 - ERROR (version 4.2.0-stable, build 15748 from 2011-09-08 13.11.42 by buildguy) : Errors detected!

  2. #2
    Join Date
    Sep 2009
    Posts
    810

    Default

    Hi vincentk,

    please file a jira for this, including the log, and provide a reproduction path if you can (the data and the regex that would cause the error). This exception should never happen.

    Cheers
    Slawo

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.