VERIFIED SOLUTION i
X

Saving reports in PDF does not work in Emessaging

Issue

While viewing the reports for Global or individual in E-messaging 1.2 version ,we are able to view but although when we try to save the global or individual report as PDF its showing 'The file is still being generated. Please try again...' we are able to save the file as CSV but not as PDF

Following message is displayed on the UI:


The file is generating, please try again...

Cause

While viewing the reports for Global or individual in E-messaging 1.2 version ,we are able to view but although when we try to save the global or individual report as PDF its showing 'The file is still being generated. Please try again...' we are able to save the file as CSV but not as PDF

User-added image

Resolution

UPDATED: October 26, 2017


Cause

System is unable to connect with Open Office (Windows) or Star Office (Solaris)Verify that the Open Office has been configured correctly in the openoffice.properties file located in \\{Install_Dir}\core.war\WEB-INF\classes directory.
 

Check the emsglog4j.log for the following information:


2012-10-19 12:09:18,144 [EM] ERROR [http-8180-1] FileDownload.convertToPdf(122) | com.g1.emessaging.converter.HtmlToPdfConversionException: com.artofsolving.jodconverter.openoffice.connection.OpenOfficeException: conversion failed
2012-10-19 12:09:18,144 [EM] DEBUG [http-8180-1] SimplifiedOutboundProfileReportGenerator.exportReportToPdf(1338) | Is PDF file C:\Group1\e-Messaging1.4\core.war\pages\report\downloads/MessageSentGlobalByOutprofileReport_20121019120913_12.pdf exists? false


 
1. E-messaging and Openoffice should be installed/running on same server. 
In this case, server automatically picks the OpenOffice process running on 8100 port (refer example mentioned below to start OpenOfiice ) 
 
2. E-messaging is running on different server, whereas OpenOffice is installed/running on different machine which can be remotely accessed 
In this case, manually update the openoffice.properties file, here are few steps 
 
a. Backup openoffice.properties file 
b. Change value of “openoffice.servers” property to “Remote machine IPAddress:port”  e.g. 192.168.204.155:8100 (remote machine is where OpenOffice is running. 
c. Restart server 
 
Command to run the OpenOffice on remote machine. 
Command: soffice -headless -accept="socket,host=0,port=8100;urp;" 
 
Note: Make sure you run this command from same location where OpenOffice is installed e.g. "C:\Program Files\OpenOffice.org 3\program" 


IN CASE OF SOLARIS ( E-MESSAGING IS INSTALLED) -things to be considered

 
1. Check Star Office UI tool first and accept T&C for staroffice in the initial startup prior to running the command (soffice -headless "-accept=socket,host=0,port=8200;urp" & )? 
2. User who is doing the work in solaris should have the full admin rights.
3. Make sure that you are running the command (soffice -headless "-accept=socket,host=0,port=8100;urp" &) from same location where StarofficeOffice is installed e.g. "C:\Program Files\OpenOffice.org 3\program" i.e. its like user\bin\ soffice -headless "-accept=socket,host=0,port=8200;urp" & 
4. Check that if there any other Staroffice.exe instance is running or not in task manager, if yes then manually kill it then re -run the command for port 8100. 

Environment Details

Product Feature: Installation / Upgrade

Operating System: Solaris

Database: Not stated

Configuration: Not stated
 

Downloads

  • No Downloads