Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 6 1 2 3 4

Search Forums: Search took 0.02 seconds.

  1. 415 Error while trying to retrieve report content

    The Pentaho Rest API is a bit obtuse and not really documented as well as expected.

    Even working from the wadl it's not a pleasure.
  2. You need to use an intermediate file or database...

    You need to use an intermediate file or database table. That's the only solution I've found and for large datasets probably the best solution.
  3. Replies
    2
    Views
    1,210

    Could output multiple CSV files. Probably the...

    Could output multiple CSV files. Probably the easiest solution. Could setup a Mondrian server as an intermediary, should be able to pull from oracle to produce the cube then import to PDI.
  4. The kettle.properties solution does not work for...

    The kettle.properties solution does not work for Windows. I still had to rollback (6.1) JSCH to 1.44
  5. Replies
    3
    Views
    1,071

    Pentaho 7.0 and CSV Exports from Viewer

    I'm having a particular problem. I had any number of reports which I brought over from 5.4 to 7.0. They all run (save for a few issues with a beanscript datasource) and they export in every format...
  6. Replies
    2
    Views
    1,324

    You probably want to hook your auth up to an LDAP...

    You probably want to hook your auth up to an LDAP server if you are concerned about attacks or place it behind a firewall.
  7. This was an issue with (believe it or not) zoom...

    This was an issue with (believe it or not) zoom factor....make sure your zoom factor is not on 80% I believe? or was it 120%
  8. Get File Names Transformation Step and VFS

    PDI version 6.1 CE

    I've been trying to use this step to retrieve a list of SFTP files using a VFS sftp://name:pwd@blah.com:22/ URL

    There are no special characters in the name/password or host. ...
  9. Running Kettle to Generate Reports and Email

    I hope someone knows an easier way than I give below but at least I've found a work around for this though it is far more complicated than I'd wish.

    Maybe I need to create a repository in order to...
  10. Replies
    1
    Views
    644

    Nm, I found them. Under .kettle/shared.xml ...

    Nm, I found them. Under .kettle/shared.xml

    Just nothing to delete them from Spoon.
  11. Replies
    1
    Views
    644

    Removing Shared Steps

    I can't seem to find a way to remove shared steps. I don't even know where they are defined. Literally they are
    showing up in every transformation I create. I obviously must have configured them...
  12. Replies
    2
    Views
    1,267

    So the best I've been able to do is setup...

    So the best I've been able to do is setup different paths to executors with different logging levels set.

    I didn't want to have to specify an actual log file, but that's also apparently not an...
  13. Replies
    2
    Views
    1,267

    So it would seem that you should be able to pass...

    So it would seem that you should be able to pass /level:Basic in the arguments tab of the Job Executor inside a Job.

    But this doesn't seem to be working.

    I'm also having problems simply getting...
  14. Replies
    3
    Views
    1,822

    I found I needed /param:"FOO=value" at least...

    I found I needed /param:"FOO=value"

    at least in windows.
  15. Replies
    2
    Views
    1,267

    PDI Log Level Change

    Is there a way to modify the logging level of a sub job run within a job? I see arguments but those seem to be only user provided command line args.

    I'd like to control the logging level of a...
  16. I was having this issue also. Launching a rather...

    I was having this issue also. Launching a rather big sub-job for each 'row' which was a file path. This was with 6.0.1 and Java 1.7. I tried to tune the GC which at first seemed to
    be an issue. ...
  17. Oops, looks like Marker works in the dataset.

    Oops, looks like Marker works in the dataset.
  18. New Map Component Marker Mode Tooltip does not work

    In the Component Reference for the New Map Component the dataset column names do not seem to work as advertised. Even in the NewMapComponent.js
    it suggests they should be working in manner I've...
  19. Replies
    1
    Views
    731

    CDE Dashboard in new Window

    Pedro, et al,

    One of the workflows I find myself often in is when I need to examine elements of a dashboard in the developer environment of my browser.

    Because the preview is so heavily...
  20. Replies
    1
    Views
    1,676

    Going to try changing the...

    Going to try changing the mapreduce.application.classpath. That could be an issue. Not sure if it will fix the file not found however.
  21. Replies
    1
    Views
    1,676

    Hadoop 2.7.1 and PDI

    I was just minding my own business when my boss snuck in and pushed me down the Hadoop rabbit hole.

    I've configured HDP22 to work with my remote cluster. I have no problems moving files to HDFS...
  22. Replies
    3
    Views
    636

    Have you committed to Table A? If so then no. ...

    Have you committed to Table A? If so then no.

    For what you want to achieve with rollback functionality you're going to need to either
    create a stored procedure OR manually delete from Table A on...
  23. Replies
    2
    Views
    1,381

    Thank you so much. Was exactly the help I was...

    Thank you so much. Was exactly the help I was looking for.

    I guess I should have searched the JIRA on xls rather than Excel.
  24. Replies
    2
    Views
    1,381

    Excel Template Location for CDA Export

    I'm not having any luck using an xls template with the CDA export capability. It could be my bad, don't know.

    I get a fairly generic message in Tomcat:

    Caused by:...
  25. CDE Problem with moving column headers (and other table items)

    I'm having an issue with CDE.

    I'll create a table. Edit the Column Headers for the table.

    Ooops. I forgot a column, so I'll go back and add it. Then I'll try to drag and drop the column UP...
  26. If the reduced row commit point didn't work, then...

    If the reduced row commit point didn't work, then it's a data issue.

    I'd try to perform an insert manually on the table using

    [E080], [BOAO0010], [E0845E], [ 603], [], [Y], [CIFS0140], [], [I],...
  27. Depending on the number of columns and the size...

    Depending on the number of columns and the size of the data you are trying to transfer your commit size even at 1k could be too big.

    This isn't SQLDR, this is a buffered insert. Try to run it at...
  28. Are your server and local workstation configured...

    Are your server and local workstation configured with the same Java and ojdbc.jar?

    If you have Java 1.8 on your server you may be running into problems there....
  29. Replies
    8
    Views
    6,315

    Best bet for immediate relief is to use Kettle. ...

    Best bet for immediate relief is to use Kettle. You can generate and run dynamic sql from within.
  30. Replies
    1
    Views
    984

    If you are using the click event it will run...

    If you are using the click event it will run regardless of whether the drill down is open or closed. I think this is behavior is different than past versions. So if you are interpreting things to...
  31. Replies
    1
    Views
    1,137

    You can't unfortunately. I keep trying to get the...

    You can't unfortunately. I keep trying to get the autocomplete to act like a dropdown that just selects the text and a background value. Unfortunately I can never get it quite where I want it.
    ...
  32. Replies
    3
    Views
    824

    I put it in a bit differently but it's...

    I put it in a bit differently but it's http://jira.pentaho.com/browse/BISERVER-12623
  33. Replies
    3
    Views
    824

    I've pushed this as a bug along with the bug...

    I've pushed this as a bug along with the bug wherein files from hidden directories cannot be copied into non-hidden directories.
  34. Replies
    3
    Views
    824

    Users Writing To Directories

    I'm still at a loss as to why CREATE CONTENT is irrevocably linked to being able to any sort of copying, scheduling output, etc to user shared directories (even owned!)

    A user without...
  35. Replies
    1
    Views
    750

    http://forums.pentaho.com/showthread.php?187439-Ge...

    http://forums.pentaho.com/showthread.php?187439-Get-the-current-logged-in-user-and-his-role&highlight=xaction+user
  36. Replies
    3
    Views
    1,074

    Is it generating an error? Check your...

    Is it generating an error? Check your /pentaho-solutions/system/logs/audit
  37. Replies
    7
    Views
    1,845

    I would say you need to reinstall CDA.

    I would say you need to reinstall CDA.
  38. Replies
    7
    Views
    1,845

    There should be more information about the error...

    There should be more information about the error in the Tomcat logs. You'll need to post that.
  39. Yeah, I've been having similar issues. Generally...

    Yeah, I've been having similar issues. Generally I'll hide a column and show a column using jquery show() and hide(), which works fine for tables and other components.

    But it does not work for a...
  40. Replies
    10
    Views
    3,537

    You can get it in a CDE dashboard. However I've...

    You can get it in a CDE dashboard. However I've had no luck getting it outside of the CDE environment.

    Dashboards.context.roles (array)
    Dashboards.context.user
  41. Matt explained the way to do it. It's the same...

    Matt explained the way to do it. It's the same as joining two tables in SQL with the same column names.

    select a.a, b.a from (select 1 a, 0 b from dual) a, (select 2 a, 0 b from dual) b
    where...
  42. Replies
    7
    Views
    1,845

    Places to look: First, open the dashboard in a...

    Places to look:

    First, open the dashboard in a new window utilize the javascript inspection tools, particularly under the console tab. It will display the error(s). If you don't know how to do...
  43. Thread: 5.4 Release

    by flamierd
    Replies
    0
    Views
    753

    5.4 Release

    I have been waiting for the 5.4 release for a bit now, it has several fixes in it which will help me.

    I see on JIRA that it doesn't seem to have any blockers.

    My conundrum is whether to push...
  44. As I remember it's pretty much just a matrix...

    As I remember it's pretty much just a matrix array, ala yourvalue = result[rownumber][columnnumber]

    But you can check it out with whatever browser you use, all of them have some sort of element...
  45. Yes. Use a Query Component. You can define the...

    Yes. Use a Query Component. You can define the result var.

    Setup some Simple Parameters (or create the variables in the header of your dashboard)

    Use the Query -> Post Fetch event under...
  46. You need to use a Kettle transform.

    You need to use a Kettle transform.
  47. Replies
    0
    Views
    418

    Copy and Pasting to Hidden Directory

    This seems to be generating an Unavailable for me. Copy works fine, pasting into a hidden directory does not.

    Can someone verify this? Should be fairly simple to do.

    I've tested on the 5.1GA...
  48. Replies
    5
    Views
    4,326

    I had some issues with this as well. Took me a...

    I had some issues with this as well. Took me a bit to figure out what was going on.

    1. You need to have the parameters in your ktr, in general they should be blank, but I don't think default are...
  49. I had to rewrite the transform. I don't have...

    I had to rewrite the transform. I don't have file system access to my production server so updating through IT I think would eventually become nightmarish.

    It's not as elegant but it works. :) ...
  50. Referencing Sub-tranforms in a Kettle Transform run in CDA

    I'm having issues with the paths for sub-transforms inside a kettle transform which I'm referencing in a dashboard.

    The ${Internal.Transformation.Filename.Directory} seems to be referencing the...
Results 1 to 50 of 254
Page 1 of 6 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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