topic Re: ERROR SocketOpenOfficeConnection disconnected unexpectedly in Alfresco Archive

ERROR SocketOpenOfficeConnection disconnected unexpectedly

danniemstanley — Mon, 06 Aug 2007 12:57:13 GMT

I am running Alfresco 2.1.0 stable release and OpenOffice 2.1 (the one bundled with the Alfresco 2.1 RC1).OpenOffice seems to die regularly causing transformations to not work correctly. Here is the only thing that shows up in the log:ERROR [openoffice.connection.SocketOpenOfficeConnection] discon

Re: ERROR SocketOpenOfficeConnection disconnected unexpectedly

derek — Mon, 06 Aug 2007 15:24:20 GMT

Hi,

You say transformations are not working correctly. Do you get any results in the Web Client if you search for "nitf" ?

Regards

Re: ERROR SocketOpenOfficeConnection disconnected unexpectedly

danniemstanley — Tue, 07 Aug 2007 13:44:43 GMT

BY the way I am running on RedHat if that makes any difference. Do I get a result back when I search for nitf? No. At least not when soffice.bin is running.

The way I know that the transformations aren't working because soffice.bin is dead is because I login to the server and the process isn't running. When I restart Alfresco the soffice.bin restarts and all is well.

By the way can you restart just OpenOffice or do you have to restart alfresco? In my experience simply starting OpenOffice from the shell start script doesn't work. It must not "get connected to the alfresco instance".

Thanks,
Dannie

Re: ERROR SocketOpenOfficeConnection disconnected unexpectedly

derek — Tue, 07 Aug 2007 14:37:05 GMT

Hi,
The OpenOffice connection will reconnect if the OO server is started again. However, the OO-related transformations require OO to be present when the server starts or they will just switch off. Once the transformation engine has initialized, OO can go up and down.
Regards

Re: ERROR SocketOpenOfficeConnection disconnected unexpectedly

sacco — Tue, 07 Aug 2007 15:41:23 GMT

Hi,
However, the OO-related transformations require OO to be present when the server starts or they will just switch off.

Does this mean that we should really have a check in the startup scripts to ensure that OO is up and accepting connections?

Re: ERROR SocketOpenOfficeConnection disconnected unexpectedly

derek — Tue, 07 Aug 2007 15:47:50 GMT

There is a check in the startup logs but it is non-fatal by default. Look at the javadocs for OpenOfficeConnectionTester and the bean in content-services-context.xml, which can be overridden.

Re: ERROR SocketOpenOfficeConnection disconnected unexpectedly

sacco — Tue, 07 Aug 2007 16:00:16 GMT

There is a check in the startup logs but it is non-fatal by default. Look at the javadocs for OpenOfficeConnectionTester and the bean in content-services-context.xml, which can be overridden.

Thanks.

Yes, I'd seen that. What I meant, though, is that I the start-up script
(alfresco.sh) starts Alfresco then starts OO. From what you said above,
this creates a race condition: if the Alfresco server performs its check
before OO is ready then transformations will be disabled, even if OO
is actually available.

In practice, of course, OO tends to be ready much faster than Alfresco,
but this may not necessarily remain so, and, for example, the supplied
alfresco.sh suggests starting the Virtualisation server before OO.

Re: ERROR SocketOpenOfficeConnection disconnected unexpectedly

derek — Tue, 07 Aug 2007 16:19:32 GMT

Yes. We're introducing a bootstrap bean to start the process as part of the Enterprise bug fix cycle for 2.1.0 Enterprise. Also, the transformers and extractors that use the OpenOffice connection will be allowed to go up and down regardless of the initial state of the connection.

Re: ERROR SocketOpenOfficeConnection disconnected unexpectedly

danniemstanley — Tue, 07 Aug 2007 18:15:29 GMT

I figured out the problem. The soffice.bin process was dying when I logged out of my SSH session. I have SSH configured to tunnel X sessions (which was convenient for registering OO). I did not have Xvfb configured. Once I installed Xvfb and configured virtual DISPLAY :1 the behavior stopped. So I assume that something was being tunneled to my desktop X server and when I killed the X tunnel it killed the soffice.bin process.