Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Undeclared variable: $ issue in pdi-ce.5.3

  1. #1
    Join Date
    Aug 2015
    Posts
    313

    Default Undeclared variable: $ issue in pdi-ce.5.3

    Hi all,

    I am trying to run my assets using PDI-CE-5.3 version in my local machine which is windows 8 without any issues. the same assets was copied to server (windows server 2008 R2) and trying to run but getting error like : Undeclared variable: $ .

    I used one syntax in my Table input step and enabled "Replace variables in script" option as well (startrange,endrange) variables defined in job level set variables step.
    I hope you understand limit is MySQL syntax.

    select 'product' as table
    ,'prod_serial_key' as column
    from product
    limit ${startrange},${endrange}

    in both machines using the java 1.7, MySQL database, same jdbc drivers. How can i achieve issue in (windows server 2008 R2) ? please help me.
    Please ask me of you need more input from my end..
    Thank you
    Last edited by santhi; 10-29-2015 at 08:29 AM.

  2. #2
    Join Date
    Aug 2015
    Posts
    313

    Default

    Hi all,

    I enabled " Copy previous results to parameters " on Transformation setting then it worked fine in all windows machines.

    Thank you

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.