Hyland Connect

gdinfo · ‎01-07-2008

Hi All,

my configuration is:
Alfresco 2.9B, Tomcat, Mysql
CentOS 4.5
OpenOffice 2.3

with a new installation I receive an error (0) during an upload of a MS Word file in a space with a simple transformation rule to PDF. The application stops after the upload with the "red" error:

Correggere gli errori riportati di seguito e premere OK.
Loperazione ha generato un errore di sistema: {0}

Neither the doc file nor the pdf have been created in the space. No errors reported in the Catalina log file.

Using CIFS the doc file has been uploaded in the space without generating the PDF and the stack error in the log is:

7-gen-2008 8.20.50 org.apache.coyote.http11.Http11BaseProtocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
7-gen-2008 8.20.50 org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 3232 ms
7-gen-2008 8.20.50 org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
7-gen-2008 8.20.50 org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/5.5.23
7-gen-2008 8.20.51 org.apache.catalina.core.StandardHost start
INFO: XML validation disabled
7-gen-2008 8.20.52 org.apache.catalina.startup.HostConfig deployWAR
INFO: Deploying web application archive alfresco.war
08:21:48,246 Userystem WARN [remoting.rmi.RmiRegistryFactoryBean] Could not detect RMI registry - creating new one
08:21:58,839 Userystem INFO [domain.schema.SchemaBootstrap] Schema managed by database dialect org.hibernate.dialect.MySQLInnoDBDialect.
08:22:03,269 Userystem INFO [domain.schema.SchemaBootstrap] No changes were made to the schema.
08:22:12,211 Userystem INFO [repo.admin.ConfigurationChecker] The Alfresco root data directory ('dir.root') is: /opt/alfresco/alf_data
08:22:12,427 Userystem INFO [admin.patch.PatchExecuter] Checking for patches to apply …
08:22:14,432 Userystem INFO [repo.module.ModuleServiceImpl] Found 0 module(s).
08:22:14,788 Userystem ERROR [alfresco.smb.protocol] Failed to get local domain/workgroup name, using default of WORKGROUP
08:22:14,789 Userystem ERROR [alfresco.smb.protocol] (This may be due to firewall settings or incorrect <broadcast> setting)
08:22:15,423 Userystem WARN [alfresco.util.OpenOfficeConnectionTester] A connection to OpenOffice could not be established.
08:22:15,439 Userystem INFO [service.descriptor.DescriptorService] Alfresco JVM - v1.5.0_13-b05; maximum heap size 506,313MB
08:22:15,441 Userystem INFO [service.descriptor.DescriptorService] Alfresco started (Community Network): Current version 2.9.0 (B 698) schema 116 - Installed version 2.9.0 (B 698) schema 116
7-gen-2008 8.22.29 org.apache.coyote.http11.Http11BaseProtocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
7-gen-2008 8.22.29 org.apache.catalina.storeconfig.StoreLoader load
INFO: Find registry server-registry.xml at classpath resource
7-gen-2008 8.22.29 org.apache.catalina.startup.Catalina start
INFO: Server startup in 99392 ms
javax.transaction.RollbackException: Transaction didn't commit: No transformation exists between mimetypes application/msword and application/pdf
   at org.alfresco.util.transaction.SpringAwareUserTransaction.commit(SpringAwareUserTransaction.java:430)
   at org.alfresco.filesys.server.SrvSession.endTransaction(SrvSession.java:684)
   at org.alfresco.filesys.smb.server.SMBSrvSession.run(SMBSrvSession.java:1401)
   at java.lang.Thread.run(Thread.java:595)
Caused by: org.alfresco.service.cmr.repository.NoTransformerException: No transformation exists between mimetypes application/msword and application/pdf
   at org.alfresco.repo.action.executer.TransformActionExecuter.executeImpl(TransformActionExecuter.java:189)
   at org.alfresco.repo.action.executer.ActionExecuterAbstractBase.execute(ActionExecuterAbstractBase.java:120)
   at org.alfresco.repo.action.ActionServiceImpl.directActionExecution(ActionServiceImpl.java:537)
   at org.alfresco.repo.action.executer.CompositeActionExecuter.executeImpl(CompositeActionExecuter.java:72)
   at org.alfresco.repo.action.executer.ActionExecuterAbstractBase.execute(ActionExecuterAbstractBase.java:120)
   at org.alfresco.repo.action.ActionServiceImpl.directActionExecution(ActionServiceImpl.java:537)
   at org.alfresco.repo.action.ActionServiceImpl.executeActionImpl(ActionServiceImpl.java:472)
   at org.alfresco.repo.action.ActionServiceImpl.executeAction(ActionServiceImpl.java:399)
   at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
   at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:585)
   at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154)
   at org.alfresco.repo.security.permissions.impl.AlwaysProceedMethodInterceptor.invoke(AlwaysProceedMethodInterceptor.java:40)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
   at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:49)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
   at org.alfresco.repo.audit.AuditComponentImpl.audit(AuditComponentImpl.java:241)
   at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:69)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210)
   at $Proxy18.executeAction(Unknown Source)
   at org.alfresco.repo.rule.RuleServiceImpl.executeRule(RuleServiceImpl.java:922)
   at org.alfresco.repo.rule.RuleServiceImpl.executePendingRule(RuleServiceImpl.java:890)
   at org.alfresco.repo.rule.RuleServiceImpl.executePendingRulesImpl(RuleServiceImpl.java:861)
   at org.alfresco.repo.rule.RuleServiceImpl.executePendingRules(RuleServiceImpl.java:834)
   at org.alfresco.repo.rule.RuleTransactionListener.beforeCommit(RuleTransactionListener.java:69)
   at org.alfresco.repo.transaction.AlfrescoTransactionSupport$TransactionSynchronizationImpl.doBeforeCommit(AlfrescoTransactionSupport.java:638)
   at org.alfresco.repo.transaction.AlfrescoTransactionSupport$TransactionSynchronizationImpl.doBeforeCommit(AlfrescoTransactionSupport.java:620)
   at org.alfresco.repo.transaction.AlfrescoTransactionSupport$TransactionSynchronizationImpl.beforeCommit(AlfrescoTransactionSupport.java:592)
   at org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCommit(TransactionSynchronizationUtils.java:48)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCommit(AbstractPlatformTransactionManager.java:821)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:637)
   at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:624)
   at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:307)
   at org.alfresco.util.transaction.SpringAwareUserTransaction.commit(SpringAwareUserTransaction.java:420)
   … 3 more

(I reported also the bootstrap lines that appear to be correct.)

Whith a plain TXT file, all works fine.

rivarola · ‎01-07-2008

08:22:15,423 Userystem WARN [alfresco.util.OpenOfficeConnectionTester] A connection to OpenOffice could not be established.

Doc -> PDF transformation needs an OpenOffice instance running. Are you sure you have launched it ?

gdinfo · ‎01-07-2008

Right but the plain text files have been regularly uploaded and converted to PDF. I tryed with one .txt and two .sql (text) files without problems. Only msword and excel have this kind of problem.

Anyway, I think I'm doing a stupid installation error without realize it.
Could you suggest me the simplest way to test the correct configuration of OO 2.3?

After OO 2.3 installation, I launched ./configure.bin -mode Console giving the correct path (/opt/openoffice.org2.3.1). Have I to do anything else?

Thanks and Best Regards.

P.S. I have installed another new istance of R2.9B with OO 2.3 on Windows 2003 Server environment with the same results.

rivarola · ‎01-08-2008

Hello,

I'm not an expert in OO configuration but I know that you have to launch the UI at least once to register it before you can launch it in headless or service mode.

Could you suggest me the simplest way to test the correct configuration of OO 2.3?

-> The WARN A connection to OpenOffice could not be established should not appear during Alfresco startup…

gdinfo · ‎01-08-2008

Hi rivarola,
after your response:

you have to launch the UI at least once

I have manually launced soffice.exe (in windows environment). Leaving the program open, the conversion worked fine but closing it the WARN returned when launching Alfresco.

The problem was the PORTABLE version of OO I used! (in Windows).

I have substituted the Portable Version with the regular (installed) one 2.3 and the WARN has definitively disappeared. The conversion now works fine.

I have to verify now the Linux environment where the OO installed is the regular one.

Thanks.