Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: lucas.c.rezende; Keyword(s):

Page 1 of 2 1 2

Search Forums: Search took 0.02 seconds.

  1. Saiku timeout after 30 seconds running

    Hi there.

    I am trying to find out why Saiku raises a timeout 30 seconds after an analysis begin if not finished. When the timeout occurs usually I press the "play" button and then the analysis...
  2. Not really. After all I upgraded to Pentaho 8 and...

    Not really. After all I upgraded to Pentaho 8 and the latest version of Saiku and finally this problem is not happening anymore.
  3. How to change default admin password on BI Server?

    Hi there.

    I am trying to update admin's password through PUC Administration area but changes have no effect after all. I am using version 8.0 and couldn't find an answer on Google for newer...
  4. Replies
    3
    Views
    1,361

    There is an update on this issue. After I had...

    There is an update on this issue.

    After I had downloaded PDI on Mac I had to remove Data Integration.app from Apples quarantine using this command: sudo xattr -dr com.apple.quarantine...
  5. Replies
    3
    Views
    1,361

    Thank you for the answer! Do you know if there...

    Thank you for the answer!
    Do you know if there is somewhere I can check if Marketplace is where it is supposed to be (inside any folder), and if there is some kind of a flag in any configuration...
  6. Replies
    3
    Views
    1,361

    Where is Marketplace in PDI 8.0?

    Hi all.

    I just downloaded PDI 8.0 for Mac and I can't find Marketplace in Tools menu as it was in previous version.

    Does anybody know where it is, if there is still this resource within PDI...
  7. Cannot properly set and get variables among Jobs and Transformations

    I want to pass the Job name to a transformation in order to create a data loading control. I set a variable in the job with the job name and use a Get Variables in the transformation to get the job...
  8. Query Timeout in Saiku - Where to change it?

    Hi all. I am trying to find where I can change Saiku query timeout but I had no success.

    Sometimes I have to press the "play" button two or three times in order to retrieve data from the cube but...
  9. Replies
    0
    Views
    607

    How to fix three-times login?

    I open BI-Server on the browser and type in my username and password. When I click "Login" BI-Server shows me a pop-up saying my login is invalid. Then I have to click login again (without changing...
  10. Replies
    4
    Views
    1,636

    It works perfectly when I run from my Windows 10...

    It works perfectly when I run from my Windows 10 machine. When upload to EC2 running Linux and run it, no file is generated.
    No secret. Was my mistake. In both machines 6.1.0.1-169 is running.
  11. Replies
    4
    Views
    1,636

    Hi marabu. This is what happens: 17401 ...

    Hi marabu.

    This is what happens:

    17401

    Yet no file is create in S3...
  12. Replies
    4
    Views
    1,636

    S3 Output does not produce Output

    I am trying to create a data file in S3 using the S3 Output step. When I run the transformation it does not show any error but I see 0 rows in the Output metric of the step as shown in the image...
  13. Replies
    7
    Views
    3,651

    I am also having the same problem.

    I am also having the same problem.
  14. Set default schema in Pentaho Schema Workbench for Redshift

    When I open Pentaho Schema-Workbench it seem to be reading all the catalog for all the schemas in my Redshift database, but I only need one.
    When I check the workbench.log it shows it reading all...
  15. Hi, Robj. Thanks for the reply. I have no float...

    Hi, Robj. Thanks for the reply. I have no float on the dimension, but I have few on the source table. Might this be a problem as well?

    UPDATE: I forced the source data to be integer but the same...
  16. Dimension Lookup / Update versioning rows with no changes at all

    Hi. I am using the step Dimension Lookup / Update to deal with a SCD dimension.
    Problem is that it is versioning rows that hadn't any change. You can see the example record below (last 3 columns are...
  17. S3 File Output not working when providing Access and Secret Keys out of the Filename

    Hi all. I am having an issue with the step S3 File Output.

    I can generate the files in S3 only when I use the filename string like:...
  18. Cube visibility based on logged user

    Hi all. I tried to Google for some simple solution but couldn't find any.

    I have a Sales cube and a Commercial Structure dimension: Director > Manager > Team > Sales Executive

    This Commercial...
  19. Best option/practice to add a new field to a Fact table

    Hi all.

    I would like like to know what is the best option/practice to add a new field to a Fact table without having to reprocess everything.

    Could someone one point me to the right...
  20. Get e-mail attachment from e-mails with specific Subject

    Hi all.

    I need to download attachment from e-mails with an specific Subject. I fulfilled the field "Subject" in the Filter tab but doesn't work and instead it starts downloading every attachment...
  21. I haven't tried Saiku Forum yet. Is it the one on...

    I haven't tried Saiku Forum yet. Is it the one on Google Groups? Could only find this one...
    About the log files, as I don't which one I should use I uploaded both with data here:
    ...
  22. SEVERE [http-apr-8080-exec-3] on SAIKU (or Mondrian configuration)

    Hi all. I am trying to load Account names in lines and gross sales as measure in Saiku, but it returns me the following log:


    10-Feb-2016 18:58:43.858 SEVERE [http-apr-8080-exec-1] null.null The...
  23. Duplicate entry for key 'PRIMARY' error on empty table

    Hi all. I have the transformation below:

    1606316064

    When I run it i get the following error: Duplicate entry '2211-94683-43' for key 'PRIMARY'

    Problem is that my table FT_VENDA_DIARIA is...
  24. Update Excel Sheet and Pivot table and Charts in another Sheet

    Hi all.

    I have an Excel file with two sheets: Sheet 1) Data table updated based on SQL configured in Data Connection; and Sheet 2) A Pivot table and some charts that are updated based on the date...
  25. Recursive Google Places API Call Using PDI

    Hi all.

    I have the Job below that first gets a list of coordinates and sends to Google Maps API using 400 meters as radius. It returns me JSON files and for those with more than 20 establishments...
  26. Alright, maybe someone else passes here and can...

    Alright, maybe someone else passes here and can help. By now I had to use the Delay Row within the transformation.
    I don't know if I can use fraction of seconds in this step, but for the Delay Row...
  27. Hi Mick. I edited my previous reply because...

    Hi Mick.

    I edited my previous reply because now I think I figured out what you meant. If I setup 1/5 seconds this means I can send 1 row each 0,2 seconds => 5 rows/second. I tried to do it but...
  28. How to pass at most 5 lines per second to the next step

    Hi all.

    I have a job with 2 steps which one step passes lines to the next one, and this one is executed one for each entry. The problem is that this process is too fast for the number of available...
  29. Hi Maria. Your first suggestion was what I needed...

    Hi Maria. Your first suggestion was what I needed to do to make this happen. Thank you for your help! :)
  30. How to set field in previous step as JASON Output File Name?

    Hi all.

    I have this transformation:

    14984

    And I want this field called FullPath2Jason in the step Concat Fields...

    14985
  31. Hi @gutlez! Thanks a lok for your help. This...

    Hi @gutlez! Thanks a lok for your help. This solved my problem at the first try.
    All the best for u!
  32. How to use Select Values Output as Text File Output filename part?

    Hi guys,

    I have this transformation below:

    14971

    I wan to use the field FileName from the Replace in String step as part of the filename in the Text File Output:

    14972
  33. I tried both using the built-in and the file...

    I tried both using the built-in and the file system repository and worked fine. Can you provide a screen shot and paste here the content of your PENTAHO_JAVA_HOME ?
  34. Sorry to have forgotten this post I opened. The...

    Sorry to have forgotten this post I opened. The first level support couldn't help me because they said Pentaho is not approved for Windows 8.1 ... urgh... needed to figure this out by myself.

    What...
  35. I had a similar problem when implemented Pentaho...

    I had a similar problem when implemented Pentaho in my company and what I needed to do was to increase (not so much) the memory allocation within the startup script and ran the transformation through...
  36. Replies
    2
    Views
    825

    I think you can use the Select Values' Meta tab...

    I think you can use the Select Values' Meta tab to set up the input format and then use another Select Values step to set up the output format.
  37. Can't view Schedule perspective in Kettle (Enterprise Version)

    Hi all.

    I am using Pentaho Enterprise 5.1 on Windows 8.1 and when I open Kettle I can't find the Schedule Perspective neither the Schedule option in the Action menu.

    Could somebody help me?
    ...
  38. Too much number crunching error when running analyzer

    Hi all.

    I am facing this erros when I start playing with Analyzer:


    Oops. There is too much number crunching required to run your report. If you are using an "Excludes" or "Doesn't Contain"...
  39. Using PL/SQL I cannot INSERT a value of 9,6...

    Using PL/SQL I cannot INSERT a value of 9,6
    Using PL/SQL I can INSERT a value of 9,580 or even 9,600

    What I did as a test was to put a Calculator after the table input, created a generic field as...
  40. Even the PL/SQL doesn't accept this format as...

    Even the PL/SQL doesn't accept this format as both source and target tables are equal. I used the source DDL to create the target.
    When I click on "Show output field" I see the mask is "#.#;#.#"...
  41. That is what I tried to discover the problem....

    That is what I tried to discover the problem. When I try to insert this row manually PL/SQL says that the format of the data is incorrect. It is expecting NUMBER(12,3) and instead is receiving with 1...
  42. The output fields are with the correct datatype....

    The output fields are with the correct datatype. See the screenshots below:

    Query executed on the PL/SQL Developer:

    SELECT
    DT_MOVIMENTO
    , NU_ANO
    , NU_SEMESTRE
    , NU_TRIMESTRE
    , NU_BIMESTRE
  43. I think I have discovered what could be the...

    I think I have discovered what could be the problem.

    When I filter the row that is returning the error in PL/SQL Developer, a field which format is NUMBER(12,3) returns me '9,580', what is right...
  44. Think I will have to prepare more coffee for...

    Think I will have to prepare more coffee for today... :(
  45. Nothing appears when I verify. :( Also I already...

    Nothing appears when I verify. :(
    Also I already tried to copy the DDL of my source table and only change the name of the table. I get the same thing as well... Really don't have any clue about what...
  46. Unexpected error inserting row - 32293 - When moving data between equal tables

    Hi all.

    I am facing a problem that is: there is a table in my Oracle source that is loaded through a procedure. This works fine.
    Then I created a transformation that simply SELECT * FROM this...
  47. Workbench Cube Table doesn't show column after table update

    Hi all.

    I created a cube in Mondrian and it is working. Then I included one column to my table and deleted and added again the table in the cube level in Workbench, but even though this column...
  48. Gutlez, thanks for the answer. That is exactly...

    Gutlez, thanks for the answer. That is exactly what I was looking for! Take care. :D
  49. Transformation implementing SCD with effective date

    Hi all.

    I want to create a process that verify if a row exists in a table based on its unique identifier.

    If the unique identifier is already within the table and some of the other fields is...
  50. Replies
    1
    Views
    1,107

    Scheduled Job not running

    Hi all!

    I create a job that basically calls two other jobs. When I run it manually through Kitchen.bat it works fine.

    When I open my Job in PDI and go to Action -> Schedule, configure it to...
Results 1 to 50 of 58
Page 1 of 2 1 2
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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