Docs preview unavailable for .ppt, .doc & .xls in Connections 6.5 CR1 || preview available for .pdf,.docx,.xlsx,.pptx || Docs 2.0 CR3 ifix9

anon-825 · May 22, 2020, 1:56pm

Hello,

I have installed HCL Connections 6.5 CR1 and integrated Connections Docs 2.0 CR3 ifix9 ( Viewer application, viewer extension, Conversion). This is the single Linux - RHEL 7.8 OS environment. Preview for PDF and Docx is working but the preview is not appearing for PPT and Excel documents.

Any advice and suggestions will be greatly appreciated. Thank you!

Error appearing in Connections:

Conversion service is not available. Viewer conversion service is not available. Your request cannot be processed at this time. Try again later or contact your system administrator.

The following errors are reported in the Conversion server log:

[5/22/20 19:11:30:220 IST] 000000d6 SymphonyConve I Soffice convert fail, port: 8105, return error code: 496
[5/22/20 19:11:30:221 IST] 000000d6 SymphonyConve I return doConvert, idle symphony count: 3
[5/22/20 19:11:30:221 IST] 000000d6 SymphonyConve I Soffice convert fail, port: 8102, return error code: 496
[5/22/20 19:11:30:221 IST] 000000d6 SymphonyConve I return doConvert, idle symphony count: 3
[5/22/20 19:11:30:222 IST] 000000d6 SymphonyConve I Soffice convert fail, port: 8100, return error code: 496
[5/22/20 19:11:30:224 IST] 000000d6 SymphonyConve I return doConvert, idle symphony count: 3
[5/22/20 19:11:30:224 IST] 000000d6 SymphonyConve I Soffice convert fail, port: 8103, return error code: 496
[5/22/20 19:11:30:224 IST] 000000d6 SymphonyConve I return doConvert, idle symphony count: 4
[5/22/20 19:11:30:225 IST] 000000d6 ODPCommonUtil I Presentation PPT to ODP conversion (Symphony) ends in 21 ms
[5/22/20 19:11:30:225 IST] 000000d6 ODPCommonUtil W java.net.ConnectException: Connection refused (Connection refused):
[5/22/20 19:11:30:225 IST] 000000d6 ODPCommonUtil I Presentation PPT to HTML conversion ends in 21 ms
[5/22/20 19:11:30:226 IST] 000000d6 ConversionWor I copy target result file from local: /connectdata/IBM/IBMConversion/data/temp/target-b71db736-e5d2-4da4-84bf-1d5b94e3da6a to shared storage: /connectdata/IBM/viewer_data/default_org/331/301/6990d8c7-4f57-49c2-86ac-7b272c984de0/media/html
[5/22/20 19:11:30:226 IST] 000000d6 ConversionWor I conversion completed, false cost 23ms, application/vnd.ms-powerpoint, text/html, /connectdata/IBM/viewer_data/default_org/331/301/6990d8c7-4f57-49c2-86ac-7b272c984de0/temp/contentfile
[5/22/20 19:11:30:227 IST] 000000d6 ConversionWor I Current thread number is 0 and task number remained is 0
[5/22/20 19:11:37:319 IST] 000000b5 S2SCallHelper I verifying request principal in On-Premise...
[5/22/20 19:11:37:320 IST] 000000b5 ConversionSer I CLFAE1221I: Submit conversion job: the sourceFilePath after transform: /connectdata/IBM/viewer_data/default_org/476/454/7e7eeb14-1cdc-4eb0-b400-b330197c8e7d/temp/contentfile
[5/22/20 19:11:37:321 IST] 000000b5 ConversionSer I CLFAE1221I: Submit conversion job: the targetFolderPath after transform: /connectdata/IBM/viewer_data/default_org/476/454/7e7eeb14-1cdc-4eb0-b400-b330197c8e7d/media/html
[5/22/20 19:11:37:321 IST] 000000b5 ConversionSer I Request on IBM Docs Component : request U7zKJj4qu4WJ1/2nX8Ka0gTlYKPcf5fTPYbmn8s2+x/QGdslSxM3st42tb7beRY3 with information { Set into paramater }
[5/22/20 19:11:37:322 IST] 000000b5 ConversionWor I Start convert work with jobId 19efe3dd-a227-422a-a587-426e6787a48f and current thread number is 1 and task number remained is 1
[5/22/20 19:11:37:324 IST] 000000d6 ConversionWor I conversion started, application/vnd.ms-excel, application/json, /connectdata/IBM/viewer_data/default_org/476/454/7e7eeb14-1cdc-4eb0-b400-b330197c8e7d/temp/contentfile
[5/22/20 19:11:37:325 IST] 000000d6 ConversionWor I copy source file from shared storage: /connectdata/IBM/viewer_data/default_org/476/454/7e7eeb14-1cdc-4eb0-b400-b330197c8e7d/temp/contentfile to local temp path: /connectdata/IBM/IBMConversion/data/temp/source-880d3d34-ca59-4b7e-801d-3c992ed64906/contentfile cost time: 0 ms
[5/22/20 19:11:37:328 IST] 000000d6 SymphonyConve E NoConnectException - soffice connection is unavailable : /connectdata/IBM/IBMConversion/data/temp/source-880d3d34-ca59-4b7e-801d-3c992ed64906/contentfile
com.sun.star.connection.NoConnectException: java.net.ConnectException: Connection refused (Connection refused)
at com.sun.star.lib.connections.socket.socketConnector.connect(socketConnector.java:166)
at com.sun.star.comp.connections.Connector.connect(Connector.java:141)

at com.sun.star.comp.urlresolver.UrlResolver$_UrlResolver.resolve(UrlResolver.java:128)
at com.ibm.symphony.conversion.converter.sym.impl.SymFileConvert.getRemoteServiceManager(SymFileConvert.java:154)
at com.ibm.symphony.conversion.converter.sym.impl.SymFileConvert.openFile(SymFileConvert.java:218)
at com.ibm.symphony.conversion.converter.sym.impl.SymFileConvert.exportToODS(SymFileConvert.java:716)
at com.ibm.symphony.conversion.converter.sym.impl.SymFileConvert.convert(SymFileConvert.java:1066)
at com.ibm.symphony.conversion.converter.sym.impl.SymphonyConversionManager.doConvert(SymphonyConversionManager.java:201)
at com.ibm.symphony.conversion.converter.sym.impl.SymphonyConversionManager.convert(SymphonyConversionManager.java:92)
at com.ibm.symphony.conversion.converter.sym.impl.SymphonyConverterImpl.convert(SymphonyConverterImpl.java:43)
at com.ibm.symphony.conversion.converter.xls2json.XLS2JSONConverter.convert(XLS2JSONConverter.java:46)
at com.ibm.symphony.conversion.converter.xls2json.XLS2JSONConverter.convert(XLS2JSONConverter.java:100)
at com.ibm.conversion.service.rest.servlet.ConversionWork.run(ConversionWork.java:654)
at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:271)
at java.security.AccessController.doPrivileged(AccessController.java:673)
at javax.security.auth.Subject.doAs(Subject.java:490)
at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:133)
at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:91)
at com.ibm.ws.asynchbeans.J2EEContext$DoAsProxy.run(J2EEContext.java:338)
at java.security.AccessController.doPrivileged(AccessController.java:703)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:806)
at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:222)
at com.ibm.ws.asynchbeans.ABWorkItemImpl.run(ABWorkItemImpl.java:206)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892)

[5/22/20 19:11:37:329 IST] 000000d6 SymphonyConve W retry to connect to another available soffice because the current soffice may be in recovery phase
[5/22/20 19:11:37:334 IST] 000000d6 SymphonyConve E NoConnectException - soffice connection is unavailable : /connectdata/IBM/IBMConversion/data/temp/source-880d3d34-ca59-4b7e-801d-3c992ed64906/contentfile
com.sun.star.connection.NoConnectException: java.net.ConnectException: Connection refused (Connection refused)
at com.sun.star.lib.connections.socket.socketConnector.connect(socketConnector.java:166)
at com.sun.star.comp.connections.Connector.connect(Connector.java:141)
at com.sun.star.comp.urlresolver.UrlResolver$_UrlResolver.resolve(UrlResolver.java:128)
at com.ibm.symphony.conversion.converter.sym.impl.SymFileConvert.getRemoteServiceManager(SymFileConvert.java:154)
at com.ibm.symphony.conversion.converter.sym.impl.SymFileConvert.openFile(SymFileConvert.java:218)
at com.ibm.symphony.conversion.converter.sym.impl.SymFileConvert.exportToODS(SymFileConvert.java:716)
at com.ibm.symphony.conversion.converter.sym.impl.SymFileConvert.convert(SymFileConvert.java:1066)
at com.ibm.symphony.conversion.converter.sym.impl.SymphonyConversionManager.doConvert(SymphonyConversionManager.java:201)
at com.ibm.symphony.conversion.converter.sym.impl.SymphonyConversionManager.doConvert(SymphonyConversionManager.java:210)
at com.ibm.symphony.conversion.converter.sym.impl.SymphonyConversionManager.convert(SymphonyConversionManager.java:92)
at com.ibm.symphony.conversion.converter.sym.impl.SymphonyConverterImpl.convert(SymphonyConverterImpl.java:43)
at com.ibm.symphony.conversion.converter.xls2json.XLS2JSONConverter.convert(XLS2JSONConverter.java:46)

at com.ibm.symphony.conversion.converter.xls2json.XLS2JSONConverter.convert(XLS2JSONConverter.java:100)
at com.ibm.conversion.service.rest.servlet.ConversionWork.run(ConversionWork.java:654)
at com.ibm.ws.asynchbeans.J2EEContext$RunProxy.run(J2EEContext.java:271)
at java.security.AccessController.doPrivileged(AccessController.java:673)
at javax.security.auth.Subject.doAs(Subject.java:490)
at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:133)
at com.ibm.websphere.security.auth.WSSubject.doAs(WSSubject.java:91)
at com.ibm.ws.asynchbeans.J2EEContext$DoAsProxy.run(J2EEContext.java:338)
at java.security.AccessController.doPrivileged(AccessController.java:703)
at com.ibm.ws.asynchbeans.J2EEContext.run(J2EEContext.java:806)
at com.ibm.ws.asynchbeans.WorkWithExecutionContextImpl.go(WorkWithExecutionContextImpl.java:222)
at com.ibm.ws.asynchbeans.ABWorkItemImpl.run(ABWorkItemImpl.java:206)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1892)

[5/22/20 19:11:37:336 IST] 000000d6 SymphonyConve W retry to connect to another available soffice because the current soffice may be in recovery phase
[5/22/20 19:11:37:337 IST] 000000d6 SymphonyConve E NoConnectException - soffice connection is unavailable : /connectdata/IBM/IBMConversion/data/temp/source-880d3d34-ca59-4b7e-801d-3c992ed64906/contentfile
com.sun.star.connection.NoConnectException: java.net.ConnectException: Connection refused (Connection refused)
at com.sun.star.lib.connections.socket.socketConnector.connect(socketConnector.java:166)
at com.sun.star.comp.connections.Connector.connect(Connector.java:141)
at com.sun.star.comp.urlresolver.UrlResolver$_UrlResolver.resolve(UrlResolver.java:128)
at com.ibm.symphony.conversion.converter.sym.impl.SymFileConvert.getRemoteServiceManager(SymFileConvert.java:154)
at com.ibm.symphony.conversion.converter.sym.impl.SymFileConvert.openFile(SymFileConvert.java:218)
at com.ibm.symphony.conversion.converter.sym.impl.SymFileConvert.exportToODS(SymFileConvert.java:716)
at com.ibm.symphony.conversion.converter.sym.impl.SymFileConvert.convert(SymFileConvert.java:1066)
at com.ibm.symphony.conversion.converter.sym.impl.SymphonyConversionManager.doConvert(SymphonyConversionManager.java:201)
at com.ibm.symphony.conversion.converter.sym.impl.SymphonyConversionManager.doConvert(SymphonyConversionManager.java:210)

anon-881 · May 22, 2020, 4:44pm

Hi Elango,

I suggest running the following command to see if the soffice instances are running: ps -ef | grep soffice. If not, run 'crontab -l' and see if there are entries for killtime_out and sym_monitor. In my environment they look like this:

*/5 * * * * /opt/IBM/IBMConversion/symphony/sym_monitor/sym_monitor.sh /opt/IBM/IBMConversion/symphony/sym_monitor/instances.cfg 1000000000 /opt/IBM/IBMConversion/symphony/sym_monitor/monitor.log /opt/IBM/IBMConversion/symphony/sym_monitor/template.sh 2>/opt/IBM/IBMConversion/symphony/sym_monitor/error.log

*/5 * * * * /opt/IBM/IBMConversion/symphony/sym_monitor/kill_timeout.sh /opt/IBM/IBMConversion/data 1000 120 2>/opt/IBM/IBMConversion/symphony/sym_monitor/error2.log

The sanity checks that are documented here are also helpful: https://help.hcltechsw.com/docs/onprem_2.0/2.0_CR3_install_guide/guide/text/functional_verification_of_installation.html

Also, this article might be helpful: https://hclpnpsupport.hcltech.com/csm?sys_kb_id=e7477e371bd9fb4077761fc58d4bcb31&id=kb_article_view&sysparm_rank=4&sysparm_tsqueryId=c58492bf1b3010d0c48197d58d4bcb7e

Tony Dezanet

anon-825 · May 23, 2020, 11:43am

Hi Tony, Thank you so much for your response with the details and the relevant link.

Yes, the major issue with SELinux. I had to disable it and reboot the OS.

https://hclpnpsupport.hcltech.com/csm?sys_kb_id=e7477e371bd9fb4077761fc58d4bcb31&id=kb_article_view&sysparm_rank=4&sysparm_tsqueryId=c58492bf1b3010d0c48197d58d4bcb7e

After disabled, the SELinux issue was not resolved, so I checked the error in the file - /connectdata/IBM/IBMConversion/symphony/sym_monitor/error.log and no errors reported after installed below rpm packages in RHEL 7.8.

yum install -y libXext libSM libXrender *gnome* ( Following errors are not reported in the error file after installed in these packages )

/connectdata/IBM/IBMConversion/symphony/inst7/ibm_lotus_symphony2/program/soffice.bin: error while loading shared libraries: libSM.so.6: cannot open shared object file: No such file or directory

/connectdata/IBM/IBMConversion/symphony/inst0/ibm_lotus_symphony2/program/soffice.bin: error while loading shared libraries: libSM.so.6: cannot open shared object file: No such file or directory
/connectdata/IBM/IBMConversion/symphony/inst1/ibm_lotus_symphony2/program/soffice.bin: error while loading shared libraries: libSM.so.6: cannot open shared object file: No such file or directory

/connectdata/IBM/IBMConversion/symphony/inst4/ibm_lotus_symphony2/program/soffice.bin X11 error: Can't open display: :0
Set DISPLAY environment variable, use -display option
or check permissions of your X-Server
(See "man X" resp. "man xhost" for details)
/connectdata/IBM/IBMConversion/symphony/inst5/ibm_lotus_symphony2/program/soffice.bin X11 error: Can't open display: :0
Set DISPLAY environment variable, use -display option

soffice process output

[root@democonnect init.d]# ps -ef |grep soffice
root 9104 1 0 16:25 ? 00:00:00 /connectdata/IBM/IBMConversion/symphony/inst0/ibm_lotus_symphony2/program/soffice.bin -invisible -conversionmode -hidemenu -nofirststartwizard -accept=socket,host=0.0.0.0,port=8100;urp;StarOffice.ServiceManager
root 9109 1 0 16:25 ? 00:00:03 /connectdata/IBM/IBMConversion/symphony/inst1/ibm_lotus_symphony2/program/soffice.bin -invisible -conversionmode -hidemenu -nofirststartwizard -accept=socket,host=0.0.0.0,port=8101;urp;StarOffice.ServiceManager
root 9114 1 0 16:25 ? 00:00:01 /connectdata/IBM/IBMConversion/symphony/inst2/ibm_lotus_symphony2/program/soffice.bin -invisible -conversionmode -hidemenu -nofirststartwizard -accept=socket,host=0.0.0.0,port=8102;urp;StarOffice.ServiceManager
root 9119 1 0 16:25 ? 00:00:00 /connectdata/IBM/IBMConversion/symphony/inst3/ibm_lotus_symphony2/program/soffice.bin -invisible -conversionmode -hidemenu -nofirststartwizard -accept=socket,host=0.0.0.0,port=8103;urp;StarOffice.ServiceManager
root 9124 1 0 16:25 ? 00:00:00 /connectdata/IBM/IBMConversion/symphony/inst4/ibm_lotus_symphony2/program/soffice.bin -invisible -conversionmode -hidemenu -nofirststartwizard -accept=socket,host=0.0.0.0,port=8104;urp;StarOffice.ServiceManager
root 9129 1 0 16:25 ? 00:00:00 /connectdata/IBM/IBMConversion/symphony/inst5/ibm_lotus_symphony2/program/soffice.bin -invisible -conversionmode -hidemenu -nofirststartwizard -accept=socket,host=0.0.0.0,port=8105;urp;StarOffice.ServiceManager
root 9134 1 0 16:25 ? 00:00:00 /connectdata/IBM/IBMConversion/symphony/inst6/ibm_lotus_symphony2/program/soffice.bin -invisible -conversionmode -hidemenu -nofirststartwizard -accept=socket,host=0.0.0.0,port=8106;urp;StarOffice.ServiceManager
root 9139 1 0 16:25 ? 00:00:00 /connectdata/IBM/IBMConversion/symphony/inst7/ibm_lotus_symphony2/program/soffice.bin -invisible -conversionmode -hidemenu -nofirststartwizard -accept=socket,host=0.0.0.0,port=8107;urp;StarOffice.ServiceManager
root 11164 1926 0 17:07 pts/0 00:00:00 grep --color=auto soffice

crontab output

[root@democonnect init.d]# crontab -l
*/5 * * * * /connectdata/IBM/IBMConversion/symphony/sym_monitor/sym_monitor.sh /connectdata/IBM/IBMConversion/symphony/sym_monitor/instances.cfg 1000000000 /connectdata/IBM/IBMConversion/symphony/sym_monitor/monitor.log /connectdata/IBM/IBMConversion/symphony/sym_monitor/template.sh 2>/connectdata/IBM/IBMConversion/symphony/sym_monitor/error.log
*/5 * * * * /connectdata/IBM/IBMConversion/symphony/sym_monitor/kill_timeout.sh /connectdata/IBM/IBMConversion/data 1000 120 2>/connectdata/IBM/IBMConversion/symphony/sym_monitor/error2.log
[root@democonnect init.d]#

Now preview is appearing for all office files including .doc, .xls,.ppt,. docx,.xlsx, and .pptx.

Thanks.