Pentaho

 View Only

 Pentaho BA Server 9.1.0.0-324 - Community Edition - Export Empty

  • Pentaho
  • Kettle
  • Pentaho
  • Pentaho Data Integration PDI
  • Pentaho Server
Harishankar Sekar's profile image
Harishankar Sekar posted 03-17-2021 10:50

Am using Pentaho BA Server 9.1.0.0-324 Community edition. Have setup Pivot 4J plugin in that BA server. Able to view data in pivot grid. But, when I export the data to either xls, xlsx or pdf, only blank file is getting exported. Is there any settings to be enabled for this?

 

The same is working fine in 7.1.0.0-12 Community edition.


#Kettle
#PentahoDataIntegrationPDI
#Pentaho
#PentahoServer
Attachment  View in library
Pentaho...0-324 - Community Edition - Export Empty 42 KB
Harishankar Sekar's profile image
Harishankar Sekar posted 03-18-2021 15:35

I found the solution.

 

Steps as follows,

 

  • Goto "pentaho-server\tomcat\webapps\pentaho\WEB-INF\lib" folder
  • Delete the following files,
    • poi-3.17.jar
    • poi-ooxml-3.17.jar
    • poi-ooxml-schemas-3.17.jar
    • poi-scratchpad-3.17.jar
    • xml-apis-1.4.01.jar
    • xmlgraphics-commons-2.2.jar
  • Copy the following files from Pentaho 7 and place in above folder path,
    • poi-3.15.jar
    • poi-ooxml-3.15.jar
    • poi-ooxml-schemas-3.15.jar
    • poi-scratchpad-3.15.jar
    • xml-apis-2.0.2.jar
    • xmlgraphics-commons-1.5.jar
  • Restart Pentaho BI server

 

It worked.

Related Content