Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Unable to locate the value column in the data set

  1. #1

    Default Unable to locate the value column in the data set

    Hi All,

    I m getting below error ,i am using report designer version 3.9

    "An error occurred while configuring the parameter UI: Unable to locate the value column in the data set"

    I am changing query and get this error
    if i rollback the changes then also error parsist.

    How to remove this error

    Thanks

  2. #2
    Join Date
    Feb 2012
    Posts
    4

    Default

    Quote Originally Posted by maria_india View Post
    Hi All,

    I m getting below error ,i am using report designer version 3.9

    "An error occurred while configuring the parameter UI: Unable to locate the value column in the data set"

    I am changing query and get this error
    if i rollback the changes then also error parsist.

    How to remove this error

    Thanks
    Hi,

    I know it has been a while since your post but maybe this can help others facing the same problem.

    I got the same error with rpd 3.8 and it took me a couple of hours to find out that RPD is case sensitive when linking the parameters with the query fields.

    So, for example, if your query is something like this:

    SELECT ID, description FROM tableX

    when editing/creating parametes, the fields "Value" and "Display Name" should be exactly like "ID" and "description" (not "id" or "Id" or "DESCRIPTION", etc).

    Hope this information can save someone's time.

  3. #3
    Join Date
    Nov 2009
    Posts
    8

    Default

    or another issue could be that you are using PRD to execute higher version report template, e.g. opening and running prd 5.0 report template in prd 3.9 editor.

  4. #4
    Join Date
    Aug 2015
    Posts
    1

    Default

    Thank you K01! I have just encountered this error message and your advice has helped me resove the issue i was getting and pondering over for a while! Much appreciated!

  5. #5
    Join Date
    Sep 2016
    Posts
    6

    Default

    Thank you! This helped me!!

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 - 2017 Pentaho Corporation. All Rights Reserved.