US and Worldwide: +1 (866) 660-7555
Results 1 to 4 of 4

Thread: Endless loop detected for substitution of variable:

  1. #1
    Join Date
    Jul 2009
    Posts
    6

    Angry Endless loop detected for substitution of variable:

    Hi,
    I have a job with two transformations and it execute fine with spoon but when I try to execute it from java (inside Jboss 4.2.2) I have the following error :

    2009-08-07 12:48:14,984 INFO [STDOUT] ERROR 07-08 12:48:14,984 - Thread[Imp (Imp (Thread-19)),5,jboss] - java.lang.RuntimeException: Endless loop detected for substitution of variable: ${OPERATORE_NAME}
    at org.pentaho.di.core.util.StringUtil.substitute(StringUtil.java:180)
    at org.pentaho.di.core.util.StringUtil.substitute(StringUtil.java:183)
    at org.pentaho.di.core.util.StringUtil.substitute(StringUtil.java:183)
    at org.pentaho.di.core.util.StringUtil.substitute(StringUtil.java:183)
    at org.pentaho.di.core.util.StringUtil.substitute(StringUtil.java:183)
    at org.pentaho.di.core.util.StringUtil.substitute(StringUtil.java:183)
    at org.pentaho.di.core.util.StringUtil.substitute(StringUtil.java:183)
    at org.pentaho.di.core.util.StringUtil.substitute(StringUtil.java:183)
    at org.pentaho.di.core.util.StringUtil.substitute(StringUtil.java:183)
    at org.pentaho.di.core.util.StringUtil.substitute(StringUtil.java:183)
    at org.pentaho.di.core.util.StringUtil.substitute(StringUtil.java:183)
    at org.pentaho.di.core.util.StringUtil.substitute(StringUtil.java:183)
    at org.pentaho.di.core.util.StringUtil.substitute(StringUtil.java:183)
    at org.pentaho.di.core.util.StringUtil.substitute(StringUtil.java:183)
    at org.pentaho.di.core.util.StringUtil.substitute(StringUtil.java:183)
    at org.pentaho.di.core.util.StringUtil.substitute(StringUtil.java:183)

    Can any one help me please ??
    Thanks

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

    Default

    So you set the value of OPERATORE_NAME to ${OPERATORE_NAME}.
    It tries to resolve it, but ends up in an endless loop.
    Matt Casters, Chief Data Integration
    Pentaho, Open Source Business Intelligence
    http://www.pentaho.org -- mcasters@pentaho.org

    Author of the book Pentaho Kettle Solutions by Wiley. Also available as e-Book and on the Kindle reading applications (iPhone, iPad, Android, Kindle devices, ...)

    Join us on IRC server Freenode.net, channel ##pentaho

  3. #3
    Join Date
    Jul 2009
    Posts
    6

    Default

    Thanks for the quick reply
    Yes I did and here is the log I print to make sure is setted :

    13:19:53,866 DEBUG [KettleEngine] Filling job variables
    13:19:53,866 DEBUG [KettleEngine] Varibale : OPERATORE_NAME Value : MIG
    13:19:53,866 DEBUG [KettleEngine] Varibale : TIPO_OPERAZIONE Value : Migrazione
    13:19:53,866 DEBUG [KettleEngine] Varibale : NUMERO_OPERAZIONE Value : 1
    13:19:53,866 DEBUG [KettleEngine] Varibale : ID_OPERAZIONE Value : 1
    13:19:53,866 DEBUG [KettleEngine] Varibale : NOTE Value : test

    Best regards

  4. #4
    Join Date
    Jul 2009
    Posts
    6

    Default

    Hi Matt
    u r right, I did have a logic error in my program and the variable was not setted
    Thanks a lot

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
  •