Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: Deanicus; Keyword(s):

Page 1 of 3 1 2 3

Search Forums: Search took 0.02 seconds.

  1. I think you need to change "-Xms1024m" too ...

    I think you need to change "-Xms1024m" too

    Also, 5000 in this case is not 5GB but rather you need to change to 5120

    So in total it should read:

    "%PENTAHO_DI_JAVA_OPTIONS%"=="" set...
  2. Go to Edit-Preferences and on the first screen...

    Go to Edit-Preferences and on the first screen tick the Show Deprecated Options

    JDBC custom will now show in the Add Datasource menu under advanced
  3. Replies
    1
    Views
    725

    For number 1 I would suggest the easiest thing to...

    For number 1 I would suggest the easiest thing to do is to put a filter step into the transformation itself and use it in the datasource

    For number 2, I don't think you can use jobs as datasources...
  4. I had known about the issue with task scheduler...

    I had known about the issue with task scheduler and mapped drives but didn't connect the dots

    I had tried your suggestion to put the variable in the body (with a test transformation) and it worked...
  5. So it turns out I'm an idiot! I missed...

    So it turns out I'm an idiot!

    I missed something in the log that showed that the variable was not actually being set because it was not receiving a row

    I since narrowed that down to the fact...
  6. Mail step: Using variable as destination address causes Invalid Address error

    Posted this on the Vantara community page but thought it would be worth a shot here too

    Just wondering if anyone else has come across this problem

    I have a job that generates a user's email by...
  7. Can you call the kitchen.bat file and open the...

    Can you call the kitchen.bat file and open the job from there?

    All of mine are setup that way and the task runs until the job is finished

    Example:

    cd "C:\pdi_folder_path\data-integration"...
  8. Replies
    5
    Views
    1,508

    Apologies for my delay in replying. Another...

    Apologies for my delay in replying. Another project became the priority and I have only revisited this recently

    I hate coming across old threads with no resolution!

    It turns out the error was...
  9. Probably don't need to resurrect an ancient...

    Probably don't need to resurrect an ancient thread but it is very simple to do this

    Select your cell and in Style go to the text-colour option. Click the plus symbol

    Paste something like this...
  10. No worries!

    No worries!
  11. Replies
    2
    Views
    679

    You shouldn't need another parameter to format a...

    You shouldn't need another parameter to format a date. Just enter your format into the "Data Format" section of the parameter.

    Based on the names of your parameters I don't think it will work...
  12. Are you sure its the ortho2Axis you want to...

    Are you sure its the ortho2Axis you want to change?

    I just tried it there and it worked fine for me (orthoAxis as the test chart only had 1 axis)

    19097
  13. In the query options try setting the parameter to...

    In the query options try setting the parameter to type string

    Any parameters I have used, whether the value is a string or integer, has always worked with the parameter set as a string
  14. Replies
    5
    Views
    1,508

    Yeah I'm using a JNDI connection for all reports....

    Yeah I'm using a JNDI connection for all reports. Other reports work fine, it seems the server just doesn't like this one report!

    I'm going to ask our engineers to check the log on the server
  15. Replies
    5
    Views
    1,508

    Report runs in designer but fails on server

    Just wondering if anyone has come across this before?

    I have a report that runs perfectly in Report Designer but when I try to run it on the server I am getting a failed at query error

    I know...
  16. I'm using 5.4 Perhaps there is a bug in 3.8 or...

    I'm using 5.4

    Perhaps there is a bug in 3.8 or the feature for row layout was not implemented in that version?
  17. I've never been able to browse the schema in PDI...

    I've never been able to browse the schema in PDI so I have just typed the name of the table directly and it works.
  18. Hmm Very strange. I had to make a couple of...

    Hmm

    Very strange.

    I had to make a couple of changes to the PRPT for it to run but when I did, the X field disappears as expected

    See attached
  19. Try setting it to false on the details band itself

    Try setting it to false on the details band itself
  20. Replies
    0
    Views
    764

    Adding totals to stacked bar chart

    Hi

    I was looking at the great duarte.leao's JSFiddle demo here: http://jsfiddle.net/duarteleao/e2Qfd/ and I want to apply it to a horizontal stacked bar chart but I am unable to get it to work
    ...
  21. Replies
    0
    Views
    409

    Downloading reports/data from AdWords?

    Hi,

    I'm hoping someone out there can point me in the right direction. I am looking at connecting to our AdWords account and downloading some reports (or at least the data contained within them)....
  22. I haven't had to do this for awhile myself but I...

    I haven't had to do this for awhile myself but I think if you open it from Terminal it will work so try creating a terminal script to do it
  23. In the task properties, in the General tab you...

    In the task properties, in the General tab you could also try selecting Run whether user is logged on or not. That coupled with what Marabu said should allow automatic execution after a restart...
  24. I have found that for particular folders (for me...

    I have found that for particular folders (for me it was desktop) you need to add the path to the folder where the bat file is located to the "Start In (optional)" box in the Actions tab of the task....
  25. You are missing a jar file for your database ...

    You are missing a jar file for your database

    Go to where your installation is. You need to copy the MS SQL Server JDBC Driver into this folder (the first bit is dependent on what version of PRD...
  26. Replies
    4
    Views
    1,514

    Have you tried using the official MS JDBC driver?...

    Have you tried using the official MS JDBC driver?

    Might be worth a shot
  27. Replies
    2
    Views
    584

    Something like this should do it, just modify the...

    Something like this should do it, just modify the directory in both "Get File Names" steps: 18711
  28. Replies
    4
    Views
    1,514

    Could it be a driver issue? Might also be...

    Could it be a driver issue?

    Might also be worthwhile putting in some redundancies in case it is due to an unstable network connection or something.

    e.g. take this particular step out of the...
  29. Replies
    2
    Views
    1,080

    I don't know how to do it myself but the reply in...

    I don't know how to do it myself but the reply in this old thread suggests you can use a shell script to open the folder first
    ...
  30. Replies
    2
    Views
    1,153

    I think USER_NAME= '?' needs to be changed to...

    I think USER_NAME= '?' needs to be changed to USER_NAME='${CF}'
  31. Replies
    3
    Views
    700

    Yeah that's it Just click the tick box in...

    Yeah that's it

    Just click the tick box in order to change it
  32. Replies
    3
    Views
    700

    Open your report and go to File-Configuration ...

    Open your report and go to File-Configuration

    In the next screen you can configure the separator in the output-table-csv option
  33. You cannot replace structural elements of a query...

    You cannot replace structural elements of a query using the normal parameter syntax as it leaves it open to SQL injection

    You can however use query scripting to do this

    See my reply in this...
  34. Replies
    5
    Views
    811

    Based on the other thread you commented on, it...

    Based on the other thread you commented on, it appears you need to specify the database in the query

    So your query should be something like

    SELECT *
    FROM DB2ADMIN.TB_SALE
  35. Replies
    2
    Views
    486

    Might be a driver issue Are you using the JDBC...

    Might be a driver issue

    Are you using the JDBC driver that came with your version of MySQL? Is it in the lib folder?
  36. I have found the issue I was using parameters...

    I have found the issue

    I was using parameters that were simply type date. It appears MySQL needs them as type date (SQL)

    It's the obvious solution but I didn't consider it as I have always used...
  37. You can't use a parameter value in the way you...

    You can't use a parameter value in the way you have suggested

    However it works if you use this format

    DATE(NOW()- INTERVAL ${p_day} DAY)

    Then just create a parameter with the name p_day and...
  38. In your query use a convert_tz function on the...

    In your query use a convert_tz function on the table timestamp in combination with some query scripting

    So in your query use something like this

    CONVERT_TZ...
  39. PDI Datasource: MySQL and date parameter passthrough issues

    Hi,

    I've come across an unusual circumstance and I hope someone can help me

    I rarely use PDI as a datasource but when I do it is usually in order to join data from two different databases (in...
  40. I think the error is that the query is expecting...

    I think the error is that the query is expecting a list of integers but is receiving a string

    I found the CSVARRAY trick for multivalue parameters to be very slow so I use query scripting instead...
  41. Replies
    8
    Views
    1,013

    Any time that has happened to me I have just...

    Any time that has happened to me I have just manually typed the name into the field attribute
  42. Replies
    0
    Views
    427

    MySQL Drivers failing to load correctly

    Hi

    Just wondering if anyone has come across this before?

    We are using v5.4. We have a schedule setup to restart the server every couple of hours during working hours (due to some users running...
  43. Replies
    1
    Views
    485

    Hi kidwispa I've attached an example report...

    Hi kidwispa

    I've attached an example report which should show you how to do it

    Particularly you are interested in the url section of an element. This can be found in style/links of an element
    ...
  44. Replies
    3
    Views
    701

    You can use the Community File Repository feature...

    You can use the Community File Repository feature and create a CDE dashboard to upload the files to the repository

    We upload CSV files that way (not sure if it is file restricted or any file can...
  45. I was just thinking, does it have to be a plain...

    I was just thinking, does it have to be a plain text file?

    Could you use RTF?
  46. I tried various things and couldn't get it it to...

    I tried various things and couldn't get it it to work.

    After a little more research it appears that this is the form feed character. It appears that PRD outputs this information with every text...
  47. This appears to be a page break I copied the...

    This appears to be a page break

    I copied the character from the file and pasted it into a word document and it was the same result as a page break

    Perhaps look at your page-behaviour settings...
  48. Here is a quick snip of my tester file and the...

    Here is a quick snip of my tester file and the attributes tab for a number_field

    I literally just typed customer_id here and it worked fine despite no fields showing on the Data tab

    18400
  49. Hmmm. That's odd I just looked at a report I...

    Hmmm. That's odd

    I just looked at a report I created with a variable and like you, the columns don't show if I click select query but if I type them in, it does work. I just tested by manually...
  50. I thought that was normal for PDI datasource?...

    I thought that was normal for PDI datasource? Always has been like that for me

    Run the preview and screenshot it for the column names. Add your relevant fields to the report (number, date, label...
Results 1 to 50 of 142
Page 1 of 3 1 2 3
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.