Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Search Forums: Search took 0.02 seconds.

  1. Scenario 1 first

    SUMMARY
    Scenario 1: The is the best solution overall, it is the most flexible and valuable but more complicated than your description suggests. See notes below.
    Scenario 2: We do have this type of...
  2. Replies
    5
    Views
    4,542

    File Based vs DB Based

    What is the advantage of moving to DB Based repository? I have made the switch from file to Oracle with the latest 1.6RC2 but startup is very, very slow. When I go to 'solutions' -

    06:54:47,944...
  3. Replies
    4
    Views
    5,657

    This is difficult for me as well

    Our build and deploy procedures make this a very bad problem. Does anybody have any ideas?
  4. Replies
    2
    Views
    1,975

    Resolved

    Looks like maybe I did not clean out my build. The hibernate3.jar in my build directory and war was smaller than the one in the PCI and I was getting Oracle10g class not found errors.

    Everything...
  5. Replies
    2
    Views
    1,975

    Hibernate3.jar different in deployment_build

    The oracle10gDialect and possibly other classes are not included in the hibernate3.jar when using the deployment_build in pentaho (this is for 1.6RC2)
  6. Removed Tidy - New Error

    I removed Tidy entirely and no more linkage error. I did get the following error which i will post in a separate thread.

    java.lang.NoClassDefFoundError: net/sf/ehcache/CacheException

    thanks for...
  7. Tidy is there

    Tidy is there. I tried removing the sax files in the Tidy jar, as suggested below, but then got a NoClassDefFoundError for or3/w3c/dom/Document.
  8. Can you tell me what you changed?

    Maybe I can get up and running if I know what you changed to fix the problem in the PCI.
  9. I still have this issue

    I am using the latest code a of Sept 11th. I still have the linkage error when deploying to JBoss 4.2.1 GA I am running the deployment_build and producing a "no portal" war

    Any help is appreciated.
  10. Replies
    1
    Views
    1,189

    Error trying to deploy wars in JBOSS 4.2

    16:40:15,232 INFO [XmlBeanDefinitionReader] Loading XML bean definitions from ServletContext resource [/WEB-INF/applicationContext-acegi-se
    curity.xml]
    16:40:15,254 ERROR [ContextLoader] Context...
  11. Replies
    1
    Views
    3,207

    Sorry!

    The instructions clearly say to generate the quartz tables see quartz. The scripts are in the downloaded zip.

    Its working now! On to the deployment build.
  12. Replies
    1
    Views
    1,189

    Deployment Build with Oracle

    My goal is to get the repository working with Oracle but using the eclipse project to build my war.

    Right now oracle is not even an option in the buid script. I have attempted to add oracle to the...
  13. Replies
    1
    Views
    3,207

    Oracle Repository

    I am following the article in the wiki

    http://wiki.pentaho.org/display/PentahoDoc/Configuring+for+Oracle+10g

    During startup I am able to see some tables being created but when I it gets to...
  14. Replies
    0
    Views
    1,138

    Content Repository

    I see in the Latest BI Platform documentation (1.6) a method getOutputStream
    http://wiki.pentaho.org/display/PentahoDoc/getOutputStream%28%29

    that appears to no longer exist but...
  15. Replies
    0
    Views
    930

    Custom Exception Handling

    Currently when a step in my Action Sequence throws an error it looks like the error is logged, further processing stops, and the error is returned in the html response.

    In this scenario I would...
  16. Thread: Result Type?

    by bpair
    Replies
    0
    Views
    1,124

    Result Type?

    Can anybody explain what are valid entries in the Result Type dropdown and how does it affect the Action Sequence?

    I would like to be able to write or use a different Output Handler than the HTTP...
  17. Replies
    1
    Views
    1,300

    Return large CSV file AdHocQuery

    I am using the release candidate 1.5.6 - I cannot seem to return more than a few thousand records with the AdHocQuery interface. I run out of memory or it grinds to a halt.

    At first I was using...
  18. Replies
    3
    Views
    2,370

    Runtime Context

    I have not returned anything from my custom class so i am not the best person to answer, but I believe by extending componentBase you have access to the runtime context and can do this:
    ...
  19. Replies
    3
    Views
    2,370

    Wiki

    The wiki has some documentation

    http://wiki.pentaho.org/display/PentahoDoc/Building+Components

    and more specifically here.

    http://wiki.pentaho.org/display/PentahoDoc/BI+Component+APIs

    I...
  20. Replies
    1
    Views
    1,217

    Scrollable Resultset

    I am using WAQR which uses the JFreeReport Engine and requires the resultset be scrollable. This means the entire resultset will eventually be stored in memory and therefore limits the amount of data...
  21. Thread: AdHoc Reporting

    by bpair
    Replies
    3
    Views
    46,328

    Follow Up

    The only additional piece would be attributes.
    kcruzada>> Can you expand on this? I not clear on what you are asking for.
    The attributes I mentioned are not needed if xml is an output format...
  22. Live resultset postpones memory consumption

    Just a follow up to the previous posts. The 'live' resultset option postpones the storing of the data in memory but it still ultimately does because the type of resultset is scrollable.

    The number...
  23. Replies
    0
    Views
    2,641

    max_rows not working ing WAQR

    It seems like I should be able to add a <max_rows> element in the

    pentaho_solutions\system\waqr\mql-template.xaction

    and it would be passed in to all reports run or created. However it is not...
  24. Thread: Performance

    by bpair
    Replies
    2
    Views
    1,252

    Scrollable Resultset

    The limit is due to the scrollable resultset. If I switch to forward_only I can process millions of rows without a large increase in memory.

    I created a feature request to allow specifying...
  25. Replies
    2
    Views
    1,696

    Non Reporting Scenario

    I understand why the current setting is scrollable/read-only. I am saying I have business use cases that need large amounts of data and I cannot have my server crash because of out-of-memory errors....
  26. Replies
    2
    Views
    1,696

    Control Resultset Configuration

    There are some scenarios where the data retrieved will be very large. Currently the resultset is scrollable causing all of the data to eventually be stored in memory even with the 'live' resultset...
  27. Replies
    1
    Views
    1,983

    Max_rows

    It looks like there is a variable called MAX_ROWS which will try to limit the number of rows returned. I imagine the driver determines how this is handled in the database.

    I would like to be able...
  28. Thread: Performance

    by bpair
    Replies
    2
    Views
    1,252

    Was using OCI not JNDI

    I noticed my xmi was pointing to Oracle OCI not my JNDI. it also had some default MYSQL parameters (fetch size = 500)

    I am using JNDI now and bumped up the fetch count to 20000. Much faster now...
  29. Thread: Performance

    by bpair
    Replies
    2
    Views
    1,252

    Performance

    I am still having performance issues and would love some help.

    I am running Java 1.4 with 1GB allocated. I am connecting to an Oracle 10g RAC using the ojdbc14 driver.

    I am retrieving 180,000...
  30. Live Resultset is working

    This looks like it is working with the 'Live Resultset' option. I will do some more testing. Stepping through the code has helped quite a bit.

    Seems to be some undocumented features.

    For...
  31. Replies
    1
    Views
    1,217

    Stream large results via HTTP

    I can handle large results inside an action sequence. This lets me create a file locally or via ftp. This works because of the 'live resultset'.

    However if I want to return the data to the caller...
  32. Replies
    5
    Views
    2,651

    Proxy Issue

    I am behind a proxy and needed to pass info into the JBoss AS.

    -Dhttp.proxyHost=proxy.url -Dhttp.proxyPort=portnumber -DproxySet=true

    So it is working, but having a dependency on SourceForge...
  33. Thread: AdHoc Reporting

    by bpair
    Replies
    3
    Views
    46,328

    AdHoc Reporting

    AdHoc reporting will be used for more than just reports, especially with the 'save' functionality. Therefore the output formats need to be more customizable. CSV is currently the most friendly for...
  34. Replies
    3
    Views
    2,467

    Thanks it is working now!

    http://source.pentaho.org/svnroot/

    is now working.

    thank you.
  35. Replies
    3
    Views
    2,467

    Subversion via HTTP not SVN

    I am trying to figure out why I can connect to other subversion projects (Apache) but not Pentaho. I am behind a coprorate firewall and it appears the svn protocol is not supported. I can connect to...
  36. Replies
    5
    Views
    2,651

    Release 1.5.4 AdHoc Query Error

    I cannot run any AdHoc queries in this release. The problem seems to be with parsing the XML. I tried this in my XML editor and got a connection refused from SourceForge JFree Report. Is the code...
  37. Out of Memory Error

    Ran a query returning 1.8 million rows. The CPU stayed very low but memory grew by a 100MB every 10 minutes. I am connecting to a Oracle 10G RAC using the 'Live Resultset option'.

    I am taking the...
  38. Replies
    8
    Views
    5,583

    Most clients would expect to send SOAP as well as...

    Most clients would expect to send SOAP as well as receive SOAP. How would I pass in my Action Sequence Input parameters?

    My posts are here to get a good understanding of the product capabilities...
  39. Replies
    2
    Views
    1,154

    Unfortunately - no real web service for Actions Sequences

    It appears this is an issue defined in JIRA

    http://jira.pentaho.org/browse/PLATFORM-38

    So for now the claim that Pentaho exposes Action sequences as a web service is very misleading.

    This is...
  40. Replies
    8
    Views
    5,583

    No real Web Service Exposure

    It appears this is an issue defined in JIRA

    http://jira.pentaho.org/browse/PLATFORM-38

    So for now the claim that Pentaho exposes Action sequences as a web service is very misleading.

    This is...
  41. Replies
    8
    Views
    5,583

    I am investigating this as well, but with no...

    I am investigating this as well, but with no success.
  42. Replies
    2
    Views
    1,154

    Difficult question?

    If there is anybody out there that can help me I would appreciate it. We are evaluating pentaho (reporting) and need to know if there is support for Web Services or not.

    If I create an XAction,...
  43. That does help me get the column names - thanks....

    That does help me get the column names - thanks. Unfortunately i need to know the column data types as well. The Pentaho MetaData class returns an Object[][] but the only data is column name. So I...
  44. Pentaho SQLResultSet?

    It appears the resultset is passed as a pentaho class

    org.pentaho.data.connection.sql.SQLResultSet

    Are there any JavaDocs on these classes or an example on how to use it?

    It looks like some...
  45. Replies
    2
    Views
    1,154

    Web Service Parameters

    I created an XAction and can kick it off via the ServiceAction call but how do I pass my inputs into the web service? I want to point my client at a WSDL and generate the appropriate call. Is this...
  46. Pass large resultset between processes in xaction

    I am creating a prototype and looking for advice on how best to implement.

    I have an XAction (using 1.5.3 version) that runs a Relational Query and creates a resultset.

    The next process in the...
  47. Thread: Oracle Issues

    by bpair
    Replies
    1
    Views
    1,723

    Oracle Issues

    I am not able to connect to our Oracle RAC unless I connect to a specific instance in the cluster.

    After I connect to that instance I cannot import any tables. Using the explorer I can see all of...
  48. Thread: Oracle Rac

    by bpair
    Replies
    0
    Views
    936

    Oracle Rac

    Can I connect to an Oracle RAC with Kettle, Metdata Editor, Platform, AdHoc Query builder?

    Is there any documentation you can point me too?

    thanks.
Results 1 to 48 of 48
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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