Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Storing reports on server filesystem instead of DB

  1. #1

    Default Storing reports on server filesystem instead of DB

    Hello guys. We are using pentaho CE on several independent installations. Now we are switching from 3.8 to new 7.1 version.

    However, I have become quite used to fix/change my reports as *.prpt files and than just update those directories.

    With new 7.1 pentaho, I however switched to postgresql databases, but now, all reports are stored in DB, where I cant just svn update direcories to have newest versions of them. Is there any possibility to store *.prpt files in file system while having postgres database for pentaho data?

  2. #2
    Join Date
    Nov 2009
    Posts
    688

    Default

    From within the BI server you can download and upload reports. There is also a plugin available to synchronise a file repository with the server repository.
    Another option. You can access the reports from within the bi-server directly with the report designer and after changes made save those changes

  3. #3

    Default

    Quote Originally Posted by johanhammink View Post
    From within the BI server you can download and upload reports. There is also a plugin available to synchronise a file repository with the server repository.
    Another option. You can access the reports from within the bi-server directly with the report designer and after changes made save those changes
    Thank you,but I am aware of those possibilities, however what I am trying to achieve is, to have filesystem folder with reports, that can be maintained outside of pentaho enviroment.

  4. #4

    Default

    As I have switched "jackrabbit" back to default (had it on "postgres" at the beginning) and left "quartz" and "hibernate" still in "postgres", I am getting this error when trying to access repository through Report-designer:

    Could not post it all cuz it would be too long, but whole message consists of:
    • 6x "Could not list the contents of folder"
    • 1x "The File exists and override has not been specified."
    • 5x "Could not list the contents of folder"


    Here is the log:
    Code:
    org.apache.commons.vfs2.FileSystemException: Could not list the contents of folder "jcr-solution:http://kapa.villapro.eu:8080/pentaho!/".
        at org.apache.commons.vfs2.provider.AbstractFileObject.getChildren(AbstractFileObject.java:1193)
        at org.pentaho.reporting.designer.extensions.pentaho.repository.model.RepositoryTableModel.getRowCount(RepositoryTableModel.java:82)
        at javax.swing.table.TableRowSorter$TableRowSorterModelWrapper.getRowCount(TableRowSorter.java:265)
        at javax.swing.DefaultRowSorter.getViewRowCount(DefaultRowSorter.java:815)
        at javax.swing.JTable.getRowCount(JTable.java:2660)
        at javax.swing.plaf.basic.BasicTableUI.createTableSize(BasicTableUI.java:1692)
        at javax.swing.plaf.basic.BasicTableUI.getPreferredSize(BasicTableUI.java:1733)
        at javax.swing.JComponent.getPreferredSize(JComponent.java:1662)
        at javax.swing.JTable.setWidthsFromPreferredWidths(JTable.java:3214)
        at javax.swing.JTable.doLayout(JTable.java:3128)
        at java.awt.Container.validateTree(Container.java:1695)
        at java.awt.Container.validateTree(Container.java:1704)
        at java.awt.Container.validateTree(Container.java:1704)
        at java.awt.Container.validateTree(Container.java:1704)
        at java.awt.Container.validateTree(Container.java:1704)
        at java.awt.Container.validateTree(Container.java:1704)
        at java.awt.Container.validateTree(Container.java:1704)
        at java.awt.Container.validateTree(Container.java:1704)
        at java.awt.Container.validateTree(Container.java:1704)
        at java.awt.Container.validate(Container.java:1630)
        at java.awt.Container.validateUnconditionally(Container.java:1667)
        at java.awt.Dialog.conditionalShow(Dialog.java:908)
        at java.awt.Dialog.show(Dialog.java:1045)
        at java.awt.Component.show(Component.java:1671)
        at java.awt.Component.setVisible(Component.java:1623)
        at java.awt.Window.setVisible(Window.java:1014)
        at java.awt.Dialog.setVisible(Dialog.java:1005)
        at org.pentaho.reporting.libraries.designtime.swing.CommonDialog.setVisible(CommonDialog.java:230)
        at org.pentaho.reporting.libraries.designtime.swing.CommonDialog.performEdit(CommonDialog.java:158)
        at org.pentaho.reporting.designer.extensions.pentaho.repository.dialogs.RepositoryOpenDialog.performOpen(RepositoryOpenDialog.java:476)
        at org.pentaho.reporting.designer.extensions.pentaho.repository.actions.SelectFileFromRepositoryTask.selectFile(SelectFileFromRepositoryTask.java:65)
        at org.pentaho.reporting.designer.extensions.pentaho.repository.actions.OpenFileFromRepositoryTask.run(OpenFileFromRepositoryTask.java:63)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
        at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756)
        at java.awt.EventQueue.access$500(EventQueue.java:97)
        at java.awt.EventQueue$3.run(EventQueue.java:709)
        at java.awt.EventQueue$3.run(EventQueue.java:703)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:726)
        at org.GNOME.Accessibility.AtkWrapper$5.dispatchEvent(AtkWrapper.java:700)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
    Caused by: com.sun.jersey.api.client.UniformInterfaceException: GET http://kapa.villapro.eu:8080/pentaho/api/repo/files/tree?depth=1&filter=*&showHidden=true returned a response status of 401 Unauthorized
        at com.sun.jersey.api.client.WebResource.handle(WebResource.java:688)
        at com.sun.jersey.api.client.WebResource.access$200(WebResource.java:74)
        at com.sun.jersey.api.client.WebResource$Builder.get(WebResource.java:509)
        at org.pentaho.reporting.libraries.pensol.JCRSolutionFileModel.refresh(JCRSolutionFileModel.java:133)
        at org.pentaho.reporting.libraries.pensol.JCRSolutionFileModel.lookupNode(JCRSolutionFileModel.java:318)
        at org.pentaho.reporting.libraries.pensol.JCRSolutionFileModel.getChildren(JCRSolutionFileModel.java:306)
        at org.pentaho.reporting.libraries.pensol.JCRSolutionFileModel.getChilds(JCRSolutionFileModel.java:438)
        at org.pentaho.reporting.libraries.pensol.WebSolutionFileObject.doListChildren(WebSolutionFileObject.java:88)
        at org.apache.commons.vfs2.provider.AbstractFileObject.getChildren(AbstractFileObject.java:1184)
        ... 46 more
    
    
    
    
    java.lang.RuntimeException: org.pentaho.reporting.designer.extensions.pentaho.repository.util.PublishException: The File exists and override has not been specified.
        at org.pentaho.reporting.designer.extensions.pentaho.repository.actions.UpdateReservedCharsTask.run(UpdateReservedCharsTask.java:81)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
        at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756)
        at java.awt.EventQueue.access$500(EventQueue.java:97)
        at java.awt.EventQueue$3.run(EventQueue.java:709)
        at java.awt.EventQueue$3.run(EventQueue.java:703)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:726)
        at org.GNOME.Accessibility.AtkWrapper$5.dispatchEvent(AtkWrapper.java:700)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:109)
        at java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:184)
        at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:229)
        at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:227)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:227)
        at java.awt.Dialog.show(Dialog.java:1084)
        at java.awt.Component.show(Component.java:1671)
        at java.awt.Component.setVisible(Component.java:1623)
        at java.awt.Window.setVisible(Window.java:1014)
        at java.awt.Dialog.setVisible(Dialog.java:1005)
        at org.pentaho.reporting.libraries.designtime.swing.CommonDialog.setVisible(CommonDialog.java:230)
        at org.pentaho.reporting.libraries.designtime.swing.CommonDialog.performEdit(CommonDialog.java:158)
        at org.pentaho.reporting.designer.extensions.pentaho.repository.dialogs.RepositoryOpenDialog.performOpen(RepositoryOpenDialog.java:476)
        at org.pentaho.reporting.designer.extensions.pentaho.repository.actions.SelectFileFromRepositoryTask.selectFile(SelectFileFromRepositoryTask.java:65)
        at org.pentaho.reporting.designer.extensions.pentaho.repository.actions.OpenFileFromRepositoryTask.run(OpenFileFromRepositoryTask.java:63)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
        at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756)
        at java.awt.EventQueue.access$500(EventQueue.java:97)
        at java.awt.EventQueue$3.run(EventQueue.java:709)
        at java.awt.EventQueue$3.run(EventQueue.java:703)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:726)
        at org.GNOME.Accessibility.AtkWrapper$5.dispatchEvent(AtkWrapper.java:700)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
    Caused by: org.pentaho.reporting.designer.extensions.pentaho.repository.util.PublishException: The File exists and override has not been specified.
        at org.pentaho.reporting.designer.extensions.pentaho.repository.actions.UpdateReservedCharsTask.run(UpdateReservedCharsTask.java:77)
        ... 42 more
    
    
    
    
    org.apache.commons.vfs2.FileSystemException: Could not list the contents of folder "jcr-solution:http://kapa.villapro.eu:8080/pentaho!/".
        at org.apache.commons.vfs2.provider.AbstractFileObject.getChildren(AbstractFileObject.java:1193)
        at org.pentaho.reporting.designer.extensions.pentaho.repository.model.RepositoryTableModel.getRowCount(RepositoryTableModel.java:82)
        at javax.swing.table.TableRowSorter$TableRowSorterModelWrapper.getRowCount(TableRowSorter.java:265)
        at javax.swing.DefaultRowSorter.getViewRowCount(DefaultRowSorter.java:815)
        at javax.swing.JTable.getRowCount(JTable.java:2660)
        at javax.swing.plaf.basic.BasicTableUI.createTableSize(BasicTableUI.java:1692)
        at javax.swing.plaf.basic.BasicTableUI.getPreferredSize(BasicTableUI.java:1733)
        at javax.swing.JComponent.getPreferredSize(JComponent.java:1662)
        at javax.swing.ScrollPaneLayout.layoutContainer(ScrollPaneLayout.java:791)
        at java.awt.Container.layout(Container.java:1510)
        at java.awt.Container.doLayout(Container.java:1499)
        at java.awt.Container.validateTree(Container.java:1695)
        at java.awt.Container.validateTree(Container.java:1704)
        at java.awt.Container.validateTree(Container.java:1704)
        at java.awt.Container.validateTree(Container.java:1704)
        at java.awt.Container.validateTree(Container.java:1704)
        at java.awt.Container.validateTree(Container.java:1704)
        at java.awt.Container.validateTree(Container.java:1704)
        at java.awt.Container.validate(Container.java:1630)
        at java.awt.Window.dispatchEventImpl(Window.java:2744)
        at java.awt.Component.dispatchEvent(Component.java:4711)
        at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
        at java.awt.EventQueue.access$500(EventQueue.java:97)
        at java.awt.EventQueue$3.run(EventQueue.java:709)
        at java.awt.EventQueue$3.run(EventQueue.java:703)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
        at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
        at java.awt.EventQueue$4.run(EventQueue.java:731)
        at java.awt.EventQueue$4.run(EventQueue.java:729)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
        at org.GNOME.Accessibility.AtkWrapper$5.dispatchEvent(AtkWrapper.java:700)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:109)
        at java.awt.WaitDispatchSupport$2.run(WaitDispatchSupport.java:184)
        at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:229)
        at java.awt.WaitDispatchSupport$4.run(WaitDispatchSupport.java:227)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.awt.WaitDispatchSupport.enter(WaitDispatchSupport.java:227)
        at java.awt.Dialog.show(Dialog.java:1084)
        at java.awt.Component.show(Component.java:1671)
        at java.awt.Component.setVisible(Component.java:1623)
        at java.awt.Window.setVisible(Window.java:1014)
        at java.awt.Dialog.setVisible(Dialog.java:1005)
        at org.pentaho.reporting.libraries.designtime.swing.CommonDialog.setVisible(CommonDialog.java:230)
        at org.pentaho.reporting.libraries.designtime.swing.CommonDialog.performEdit(CommonDialog.java:158)
        at org.pentaho.reporting.designer.extensions.pentaho.repository.dialogs.RepositoryOpenDialog.performOpen(RepositoryOpenDialog.java:476)
        at org.pentaho.reporting.designer.extensions.pentaho.repository.actions.SelectFileFromRepositoryTask.selectFile(SelectFileFromRepositoryTask.java:65)
        at org.pentaho.reporting.designer.extensions.pentaho.repository.actions.OpenFileFromRepositoryTask.run(OpenFileFromRepositoryTask.java:63)
        at java.awt.event.InvocationEvent.dispatch(InvocationEvent.java:311)
        at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:756)
        at java.awt.EventQueue.access$500(EventQueue.java:97)
        at java.awt.EventQueue$3.run(EventQueue.java:709)
        at java.awt.EventQueue$3.run(EventQueue.java:703)
        at java.security.AccessController.doPrivileged(Native Method)
        at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
        at java.awt.EventQueue.dispatchEvent(EventQueue.java:726)
        at org.GNOME.Accessibility.AtkWrapper$5.dispatchEvent(AtkWrapper.java:700)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
        at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
        at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
        at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
    Caused by: com.sun.jersey.api.client.UniformInterfaceException: GET http://kapa.villapro.eu:8080/pentaho/api/repo/files/tree?depth=1&filter=*&showHidden=true returned a response status of 401 Unauthorized
        at com.sun.jersey.api.client.WebResource.handle(WebResource.java:688)
        at com.sun.jersey.api.client.WebResource.access$200(WebResource.java:74)
        at com.sun.jersey.api.client.WebResource$Builder.get(WebResource.java:509)
        at org.pentaho.reporting.libraries.pensol.JCRSolutionFileModel.refresh(JCRSolutionFileModel.java:133)
        at org.pentaho.reporting.libraries.pensol.JCRSolutionFileModel.lookupNode(JCRSolutionFileModel.java:318)
        at org.pentaho.reporting.libraries.pensol.JCRSolutionFileModel.getChildren(JCRSolutionFileModel.java:306)
        at org.pentaho.reporting.libraries.pensol.JCRSolutionFileModel.getChilds(JCRSolutionFileModel.java:438)
        at org.pentaho.reporting.libraries.pensol.WebSolutionFileObject.doListChildren(WebSolutionFileObject.java:88)
        at org.apache.commons.vfs2.provider.AbstractFileObject.getChildren(AbstractFileObject.java:1184)
        ... 66 more

  5. #5
    Join Date
    May 2016
    Posts
    282

    Default

    Sorry to disappoint you, but I don't think that's possible, the server has its own system to store the objects published, so you can maintain your reports in a filesystem outside Pentaho BI (that's what I do, I have a git repository for the reports), but you must have the discipline to publish the reports to the server from your file system.
    It may be possible to create some script to automatically publish the reports, I don't know, you can investigate that.
    Regards
    OS: Ubuntu 16.04 64 bits
    Java: Openjdk 1.8.0_131
    Pentaho 6.1 CE

Tags for this Thread

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 - 2019 Hitachi Vantara Corporation. All Rights Reserved.