Edit online not working

[criskolkman]

Hello,

I don't know why but my previous post just got deleted...

I installed a fresh CentOS 7 server with Alfresco Community using this guide:

How to Install Alfresco Community Edition on RHEL/CentOS 7/6 and Debian 8 

Everything seems to be working fine except the "Edit in Microsoft Office".

When I click that link, it opens Excel but the sheet is not being opened, just a blank page while Excel is still responsive.

Using Office 2013, tested on different PC's but all same results.

I did notice that http://mydomain.com:7070 is not reachable while I added the port forward in the router and also opened the port on the server firewall.

During the installation it did not ask for the Sharepoint port like the above instruction suggest:

Alfresco SharePoint Port Please choose a port number for the SharePoint protocol. Port: [7070]:

Any help would be appreciated.

Thanks!

[kgastaldo]

Hey Chris - Your other post wasn't deleted - just caught in the moderation queue. I've approved it and it's published over in ECM. I'll delete this one, as it is a duplicate now. Sorry about the delay!

[criskolkman]

Thanks for your answer.

Don't delete this one please because when I browse to the other one I get:

An unexpected error has occurred

[kgastaldo]

We're having issues with moderation. I'll just move this post over to ECM and delete the one that seems to be stuck!

[afaust]

When installing Alfresco did you use the 5.0.d version as indicated in the linked guide or did you use the newer 5.1.x or 2016xx GA releases? In that case the SharePoint support no longer has a separate port and thus the question for the port will not come up. SharePoint support now runs on the same ports as the web UI (default installer sets up ports 8080 and 8443).

It would be great if you could provide log output regarding your issue. Typically alfresco.log is relevant for SharePoint support. Additionally I always find that the access log can also be helpful in this case since that helps determine at what point an issue in the communication between browser / office app and Alfresco occurred.

[criskolkman]

Thanks for your answer!

No I used that guide but I indeed installed the newest version, so that would be the answer for not getting that Sharepoint port question

See the attachment for the complete alfresco.log

[afaust]

The log does not show anything related to Edit Online. Can you provide the access log as well?

[criskolkman]

Hello,

The access file is really big, maybe search words I can use to narrow it down a bit?

What I have to say is that I followed that guide but I didn't install the nginx server, only did the part of installing Alfresco.

Don't know if that's a problem?

[criskolkman]

Think the only things worth mentioning in the tomcat access logs are:

127.0.0.1 - - [17/Nov/2016:10:45:00 +0100] "GET /alfresco/service/api/solr/transactions?fromCommitTime=1479364732535&toCommitTime=1479368332535&maxResults=2000&baseUrl=%2Fsolr4%2Falfresco%2F&hostName=MY.DOMAIN.COM&template=&instance=0&numberOfShards=1&port=8081&stores=workspace%3A%2F%2FSpacesStore&isMaster=true&hasContent=true&shardMethod=MOD_ACL_ID&lastUpdated=1479375900351&lastIndexedChangeSetCommitTime=1479288280889&lastIndexedChangeSetId=15&lastIndexedTxCommitTime=1479332332535&lastIndexedTxId=56 HTTP/1.1" 200 115
127.0.0.1 - - [17/Nov/2016:10:45:00 +0100] "GET /alfresco/service/api/solr/transactions?fromCommitTime=1479368332535&toCommitTime=1479371932535&maxResults=2000&baseUrl=%2Fsolr4%2Farchive%2F&hostName=MY.DOMAIN.COM&template=&instance=0&numberOfShards=1&port=8081&stores=archive%3A%2F%2FSpacesStore&isMaster=true&hasContent=true&shardMethod=MOD_ACL_ID&lastUpdated=1479375900351&lastIndexedChangeSetCommitTime=1479288280889&lastIndexedChangeSetId=15&lastIndexedTxCommitTime=1479332332535&lastIndexedTxId=56 HTTP/1.1" 200 115
127.0.0.1 - - [17/Nov/2016:10:45:00 +0100] "GET /alfresco/service/api/solr/transactions?fromCommitTime=1479368332535&toCommitTime=1479371932535&maxResults=2000&baseUrl=%2Fsolr4%2Falfresco%2F&hostName=MY.DOMAIN.COM&template=&instance=0&numberOfShards=1&port=8081&stores=workspace%3A%2F%2FSpacesStore&isMaster=true&hasContent=true&shardMethod=MOD_ACL_ID&lastUpdated=1479375900351&lastIndexedChangeSetCommitTime=1479288280889&lastIndexedChangeSetId=15&lastIndexedTxCommitTime=1479332332535&lastIndexedTxId=56 HTTP/1.1" 200 115
127.0.0.1 - - [17/Nov/2016:10:45:00 +0100] "GET /alfresco/service/api/solr/transactions?fromCommitTime=1479371932535&toCommitTime=1479375532535&maxResults=2000&baseUrl=%2Fsolr4%2Falfresco%2F&hostName=MY.DOMAIN.COM&template=&instance=0&numberOfShards=1&port=8081&stores=workspace%3A%2F%2FSpacesStore&isMaster=true&hasContent=true&shardMethod=MOD_ACL_ID&lastUpdated=1479375900351&lastIndexedChangeSetCommitTime=1479288280889&lastIndexedChangeSetId=15&lastIndexedTxCommitTime=1479332332535&lastIndexedTxId=56 HTTP/1.1" 200 115
127.0.0.1 - - [17/Nov/2016:10:45:00 +0100] "GET /alfresco/service/api/solr/transactions?fromCommitTime=1479375532535&toCommitTime=1479379132535&maxResults=2000&baseUrl=%2Fsolr4%2Falfresco%2F&hostName=MY.DOMAIN.COM&template=&instance=0&numberOfShards=1&port=8081&stores=workspace%3A%2F%2FSpacesStore&isMaster=true&hasContent=true&shardMethod=MOD_ACL_ID&lastUpdated=1479375900351&lastIndexedChangeSetCommitTime=1479288280889&lastIndexedChangeSetId=15&lastIndexedTxCommitTime=1479332332535&lastIndexedTxId=56 HTTP/1.1" 200 115
127.0.0.1 - - [17/Nov/2016:10:45:00 +0100] "GET /alfresco/service/api/solr/transactions?fromCommitTime=1479371932535&toCommitTime=1479375532535&maxResults=2000&baseUrl=%2Fsolr4%2Farchive%2F&hostName=MY.DOMAIN.COM&template=&instance=0&numberOfShards=1&port=8081&stores=archive%3A%2F%2FSpacesStore&isMaster=true&hasContent=true&shardMethod=MOD_ACL_ID&lastUpdated=1479375900351&lastIndexedChangeSetCommitTime=1479288280889&lastIndexedChangeSetId=15&lastIndexedTxCommitTime=1479332332535&lastIndexedTxId=56 HTTP/1.1" 200 115
127.0.0.1 - - [17/Nov/2016:10:45:00 +0100] "GET /alfresco/service/api/solr/transactions?fromCommitTime=1479375532535&toCommitTime=1479379132535&maxResults=2000&baseUrl=%2Fsolr4%2Farchive%2F&hostName=MY.DOMAIN.COM&template=&instance=0&numberOfShards=1&port=8081&stores=archive%3A%2F%2FSpacesStore&isMaster=true&hasContent=true&shardMethod=MOD_ACL_ID&lastUpdated=1479375900351&lastIndexedChangeSetCommitTime=1479288280889&lastIndexedChangeSetId=15&lastIndexedTxCommitTime=1479332332535&lastIndexedTxId=56 HTTP/1.1" 200 115
127.0.0.1 - - [17/Nov/2016:10:45:00 +0100] "POST /alfresco/service/api/solr/modelsdiff HTTP/1.1" 200 37

And maybe:

[root@shared logs]# cat localhost_access_log2016-11-17.txt | grep office
**.***.***.*** - - [17/Nov/2016:10:41:03 +0100] "GET /share/res/js/officelauncher_c5dab768d0335483c03558e7df0e3dbd.js HTTP/1.1" 200 7208
[root@shared logs]#

[afaust]

The SOLR related accesses are just the "background noise". You may search for lines that refer to _vti or /aos but by only providing a grep-ed excerpt you may miss some important information. The best option would be to strip all lines that contain /service/api/solr calls.