topic Re: Alfresco community 201702 GA and Office 2013, MS Word starts but the document is not displayed. The same in Excel. in Alfresco Forum

Alfresco community 201702 GA and Office 2013, MS Word starts but the document is not displayed. The same in Excel.

ctorre — Mon, 13 Mar 2017 10:34:06 GMT

My OS is Windows 7 professional edition with MS Office 2013 and 201702 GA release of Alfresco Community Edition. When I try to edit a DOCX or XLSX from Alfresco Share, MS Word and Excel start but the documents are not displayed. I have the registry keys of basic authentication set to 2. In fact when

Re: Alfresco community 201702 GA and Office 2013, MS Word starts but the document is not displayed. The same in Excel.

mehe — Mon, 13 Mar 2017 17:58:05 GMT

could you describe your server environment? Are you using alfresco on your Windows Workstation (localhost)?

If yes, maybe you have to adjust the share.context variable in .../alfresco/tomcat/shared/classes/alfresco-global.properties.

Have you tried "edit in Microsoft office" or "edit offline"?

Are there any hints in your alfresco.log, share.log or catalina.out (.../alfresco/tomcat/logs)

regards...

Re: Alfresco community 201702 GA and Office 2013, MS Word starts but the document is not displayed. The same in Excel.

ctorre — Tue, 14 Mar 2017 09:09:06 GMT

Hi Martin,

this is my environment:

Windows 7 Professional Edition
Alfresco Community 201702 GA
MS Office 2013
I'm using Alfresco on my Windows Workstation (localhost)
Both the registry keys of basi authentication are set to 2
In the alfresco-global.properties I set:
- share.context=share
- share.host=localhost
- share.port=8080
- share.protocol=http
I use "Modify in Microsoft Office". When I click this action a pop-up appears asking "Open URL:Word Protocol?". I accept and MS Word starts but the document is not open. Attached you can find an extract of the localhost_access_log2017-03-14.txt file when I make the action "Modify in Microsoft Office".
No hint in the other log files.

Thanks.

Carlo

Re: Alfresco community 201702 GA and Office 2013, MS Word starts but the document is not displayed. The same in Excel.

mehe — Tue, 14 Mar 2017 09:58:35 GMT

Maybe two suggestions before I can look into this in more detail. Is your document located in the repository root? If true try to move it to a subfolder and open it from there.

change share.host to 127.0.0.1 and restart Alfresco to eliminate a possible problem with the localhost url.

Re: Alfresco community 201702 GA and Office 2013, MS Word starts but the document is not displayed. The same in Excel.

ctorre — Tue, 14 Mar 2017 10:21:21 GMT

My document is located into a subfolder.

I changed alfresco-global.properties as follow:

alfresco.context=alfresco
alfresco.host=127.0.0.1
alfresco.port=8080
alfresco.protocol=http

share.context=share
share.host=127.0.0.1
share.port=8080
share.protocol=http

The problem still exists.

Let me know.

Carlo

Re: Alfresco community 201702 GA and Office 2013, MS Word starts but the document is not displayed. The same in Excel.

mehe — Tue, 14 Mar 2017 11:19:04 GMT

The next thing would be to allow ms office to authenticate over non https connections - if don't have already done it. The default protocol for ms office connections is https.

you would have to edit your registry HKLM\system\currentcontrolset\services\webclient\parameters

create a new DWORD subkey BasicAuthLevel with a value of 2

But this is a security risk, only ok to use on your local workstation.

Re: Alfresco community 201702 GA and Office 2013, MS Word starts but the document is not displayed. The same in Excel.

ctorre — Tue, 14 Mar 2017 11:24:35 GMT

Already done (as written in the previous messages "Both the registry keys of basic authentication are set to 2).

Re: Alfresco community 201702 GA and Office 2013, MS Word starts but the document is not displayed. The same in Excel.

mehe — Tue, 14 Mar 2017 11:33:13 GMT

Sorry I haven't seen this - it seems to be more a windows than Alfresco problem. Have you set up Alfresco sso (ntlm ?) or is web-virus-Defence in the way....

Re: Alfresco community 201702 GA and Office 2013, MS Word starts but the document is not displayed. The same in Excel.

ctorre — Tue, 14 Mar 2017 11:44:26 GMT

Alfresco SSO is configured.

I also tried with antivirus and firewall disabled but the problem still exists.

Re: Alfresco community 201702 GA and Office 2013, MS Word starts but the document is not displayed. The same in Excel.

mehe — Tue, 14 Mar 2017 11:47:11 GMT

Webbrowser is?

Re: Alfresco community 201702 GA and Office 2013, MS Word starts but the document is not displayed. The same in Excel.

ctorre — Tue, 14 Mar 2017 11:51:12 GMT

I'm trying with Chrome version 56.0.2924.87 and Internet Explorer 11.

Re: Alfresco community 201702 GA and Office 2013, MS Word starts but the document is not displayed. The same in Excel.

mehe — Tue, 14 Mar 2017 15:32:19 GMT

Ok, I have to look into this on our test VM - maybe it's a general problem... takes some time

...looks like I can try Alfresco 5.2 AOS on windows 7 with office 2010 this Friday.

Re: Alfresco community 201702 GA and Office 2013, MS Word starts but the document is not displayed. The same in Excel.

minzawoo8080 — Wed, 15 Mar 2017 03:46:25 GMT

That would be appreciated. My installation on fresh server 2012R2 faced the same problem. Blank page and nothing show up.

Re: Alfresco community 201702 GA and Office 2013, MS Word starts but the document is not displayed. The same in Excel.

ctorre — Wed, 15 Mar 2017 16:16:29 GMT

I tried Alfresco Enterprise Edition (trial) with MS Office 2013 and this configuration faced the same problem. By using webdav everything works fine (both Community and Enterprise). I suppose this is a problem with Share that doesn't set up UNC path correctly. Is something like "file not found". Tomorrow I'll try with MS 2016 version.

Re: Alfresco community 201702 GA and Office 2013, MS Word starts but the document is not displayed. The same in Excel.

mehe — Wed, 15 Mar 2017 16:27:36 GMT

You can see the created Url when activating "Developer Tools" in Chrome or Firefox and watch for your document in the Network-Tab.

The provided Url should be something like "ms-wordfe%7Cu%7Chttp://yourIpAddressOrServerName:8080/alfresco/aos/pathtoyourDocx"

when you work without SSL and on the standard port.

Re: Alfresco community 201702 GA and Office 2013, MS Word starts but the document is not displayed. The same in Excel.

ctorre — Thu, 16 Mar 2017 10:09:34 GMT

SOLVED!

I had mistakenly defined the registry Key

“HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Common\Internet\BasicAuthLevel”

as QWORD (64-bit) and not DWORD (32-bit).

This is a good reference:

Setting up Alfresco Office Services using a non-SSL connection | Alfresco Documentation

Re: Alfresco community 201702 GA and Office 2013, MS Word starts but the document is not displayed. The same in Excel.

mehe — Thu, 16 Mar 2017 12:48:18 GMT

That's easy to get the reg-keys wrong. Very good that you found it. maybe min zaw oo has the same issue...

Re: Alfresco community 201702 GA and Office 2013, MS Word starts but the document is not displayed. The same in Excel.

minzawoo8080 — Sat, 18 Mar 2017 05:31:57 GMT

Thanks you Martin! there are two steps inside registery, one to modify and other one to create.

It would be very please if you can send me the guideline to enable SSL, easy way!. Official documentation is quite complicated. Anyway Thanks.

Re: Alfresco community 201702 GA and Office 2013, MS Word starts but the document is not displayed. The same in Excel.

mehe — Sat, 18 Mar 2017 10:14:47 GMT

I prefer to set-up a http server (apache or nginx) as reverse proxy in front of alfresco. This also has the benefit to be able to show up a friendly maintenance page when alfresco is down - and you can easily deploy Angular(js) single-page apps for Alfresco directly on the http server or call your also proxied nodeJs app from the same site-name, preventing you from cross-origin problems.

The http Server is then handling the SSL work and your alfresco tomcat won't have to encrypt and decrypt the traffic.

But if you want tomcat to do the "heavy lifting" Apache Tomcat 7 (7.0.76) - SSL/TLS Configuration HOW-TO on the Apache site shows how to SSL your container - should be ok for alfresco, im not sure about the tomcat version (maybe 7.0.59 when using the installer, but SSL config should be the same).

If you want to use the http-reverse proxy approach, look for a setup on GitHub.com - I think there is an nginx example provided by loftux.

Further questions? Then please describe your setup - mainly server os (I'm using Linux and macOs server side), deploying alfresco on premise or in www and if you already have a ssl certificate or need to know how to create or obtain one...

Maybe we/someone/I should create a community.alfresco.com blog article on "how to SSL enable Alfresco" or there is already one...