Preview says 'Document URL not provided or invalid'

[raviskiran]

I have installed openkm 5 on my system and I have encountered a few issues.

1. Preview is working for only PDF files and for rest it says 'Document URL not provided or invalid'
2. System is not indexing XLS files.
3. Sometimes when I login I get an 'error getuserworkspace' and execution would stop there but on refreshing it would work well. Any reasons why its happening so.

Hope someone clears these issues.
I am including the screenshot of preview bug.

[jllort]

You've got a bad configuration, take a look at your server look, you'll see some error.

You must have pdf2swf installed to enable for all preview file types

About login error put in other threat, and take a look at server log ( some error when you're login ? )

[raviskiran]

I have pdf2swf enabled thats why I am able to see PDF preview.
I think my Main problem is converting openoffice docs to pdf....when I tried to download .odt files as pdf I am getting this error.

Application error

Class: java.lang.NoClassDefFoundError
Message: com/sun/star/io/IOException

[raviskiran]

When I tried to download .xlsx document as pdf I get this error in error.log

Code: Select all

DEBUG [com.openkm.util.DocConverter] convert(/tmp/okm3697589123753272006.doc, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet, /home/ravi/Downloads/softwares/JBoss-4.2.3.GA/cache/pdf/07fec77f-8d6e-4043-9a48-e317daf9182c.pdf)
2010-09-24 16:36:49,614 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/OpenKM].[OKMDownloadServlet]] Servlet.service() for servlet OKMDownloadServlet threw exception
java.lang.ClassNotFoundException: com.sun.star.io.IOException
	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1358)
	at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1204)
	at org.artofsolving.jodconverter.OfficeDocumentConverter.convert(OfficeDocumentConverter.java:72)
	at org.artofsolving.jodconverter.OfficeDocumentConverter.convert(OfficeDocumentConverter.java:66)
	at com.openkm.util.DocConverter.convert(DocConverter.java:161)
	at com.openkm.util.DocConverter.doc2pdf(DocConverter.java:181)
	at com.openkm.frontend.server.OKMDownloadServlet.service(OKMDownloadServlet.java:145)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
	at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
	at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
	at java.lang.Thread.run(Thread.java:619)

[jllort]

Which OpenKM version are you using ?

[raviskiran]

I am using openkm 5

[jllort]

Do you've got openoffice installed and configured. Can converting documents to pdf ? you can preview pdf documents because openoffice in that case don't needs to be installed.

[raviskiran]

Yes I have Openoffice installed on my system....but I did not configure anything there as I am using openkm 5 and this is what documentation says.

Starting from OpenKM 5.0 you don't need to start OpenOffice.org as a service because OpenKM will take case of this. You only need to set the system.openoffice configuration property in OpenKM.cfg to the path of a working OpenOffice.org installation.

If you still think i need to configure it...can you tell where I can find the configuration.
Note: I am a subscribed member..so I have access to all the documentation.

[jllort]

Take a look here:
http://wiki.openkm.com/index.php/OpenOffice.org

[raviskiran]

Well the problem is ..on that page it says u dont need to configure anything for openkm5 ..thts what i did ..did not configure anything and I get that error.
My openoffice is running...i am able to search through all kinds of documents...just not able to preview or download them as pdf. Please help

[jllort]

When you try donwloading as pdf which error message appears in your server.log file ?

[merlin81]

Maybe I can help you with my configuration:

Code: Select all

restrict.file.mime=off
restrict.file.extension=*~,*.bak,._*
max.file.size=25
system.ocr=/usr/bin/tesseract
system.pdf2swf=/usr/bin/pdf2swf_wrapper.sh
system.img2pdf=/usr/bin/img2pdfjava
system.antivir=/usr/bin/clamscan
system.openoffice= /usr/lib/openoffice
hibernate.hbm2ddl=none
schedule.repository.info=10
schedule.mail.importer=10
schedule.dashboard.refresh=10
subscription.message.subject=OpenKM - {0} - {1};
subscription.message.body=Document: <a href=\"{0}\">{1}</a>
notify.message.subject=OpenKM - NOTIFICATION - {0}
notify.message.body=Document: <a href=\"{0}\">{1}</a>
chat.enabled=on
chat.autologin=on
default.lang=de
system.previewer=flexpaper

Check that openoffice is listening, this should be somewhere in the start output from jboss, openoffice will listen at port 2022

Code: Select all

12:31:06,339 ERROR [STDERR] 29.09.2010 12:31:06 org.artofsolving.jodconverter.office.ProcessPoolOfficeManager <init>
INFO: ProcessManager implementation is UnixProcessManager
12:31:06,662 ERROR [STDERR] 29.09.2010 12:31:06 org.artofsolving.jodconverter.office.OfficeProcess start
INFO: starting process with acceptString 'socket,host=127.0.0.1,port=2002,tcpNoDelay=1' and profileDir '/tmp/.jodconverter_socket_host-127.0.0.1_port-2002'
12:31:07,128 ERROR [STDERR] 29.09.2010 12:31:07 org.artofsolving.jodconverter.office.OfficeProcess start
INFO: started process; pid = 4099
12:31:07,578 ERROR [STDERR] 29.09.2010 12:31:07 org.artofsolving.jodconverter.office.OfficeConnection connect
INFO: connected: 'socket,host=127.0.0.1,port=2002,tcpNoDelay=1'

I've had similar problems with older svn, updated head today and so far all is fine until now.

[jllort]

is you're using last head OpenKM there's no need to use pdf2wsf_wrapper.sh parameters are set by application, return to /usr/lib/pdf2swf

Really strange OfficeConnection connect but not appears a Disconnect

On which os are you ?

[merlin81]

I'm using the wrapper at the moment to view program output, there are no more parameters, but an 2>&1 /tmp/pdf2swf to debug output.
Had several problems...
Running on debian lenny amd64, openoffice is from backports. Office connection works fine and I can view and index all documents.

[jllort]

The problem is on script. Flexpaper need conversion to SWF must be done with some parameters ( if you've compiled OpenKM 5.X from actual head, it's not necessary we call pdf2swf with params, and scripts is not needed )

Code: Select all

#!/bin/bash
 
/usr/bin/pdf2swf $* -f -T 9 -t -G -s storeallcharacters

It solves to you the problem ?