topic Re: Cannot Edit with MS office (2016 in Alfresco Archive

Cannot Edit with MS office (2016

momac — Wed, 19 Oct 2016 10:09:21 GMT

Hi Everyone,Im new at alfresco and Linux, i freshly installed version 5.1 for Linux (ECM Edition). I managed to open alfresco via SSL and the GUI is also working stable. I realised some of the features does not work out of the box.-Tags are not working-Document Browser Preview ist not working-Editin

Re: Cannot Edit with MS office (2016

momac — Wed, 19 Oct 2016 13:01:50 GMT

Environment:

- Windows 7 and 10

- Alfresco community 5.1

- Microsoft Office 2016

Re: Cannot Edit with MS office (2016

afaust — Wed, 19 Oct 2016 14:24:44 GMT

Ja servus - leider sind hier nur wenige deutschsprachige regelmäßig unterwegs (mit mir sind es soweit bekannt nur zwei Fragenbeantworter). Daher ist eine Frage/Antwort in Englisch immer erfolgsversprechender.

Hello - unfortunately there are very few German-speaking members on this platform on a regular basis (only two responders including myself, as far as I know). For that reason questions / answers will most likely have more impact when written in English.

Can you provide the Alfresco log file (alfresco.log) after you have tried to use either of the functionalities you mentioned as "not working"? This log file might provide sufficient information to potentially deal with at least one of the issues without us having to resort to wild guesses. I personally never use the Alfresco-provided installers so am not familiar with any current or potential issues that might relate to the setup procedure and restrict these core functionalities.

You are quite right to assume that the installer should provide all the components necessary for using tags, document preview (of common file types) and edit online (using Alfresco Office Services). From feedback on the #alfresco IRC channel (on Freenode) I know that the online edit feature may have some issues with certain client / use constellations.

Re: Cannot Edit with MS office (2016

momac — Wed, 19 Oct 2016 15:29:29 GMT

Here is the alfresco.log

2016-10-19 00:00:00,436 INFO [org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer] [DefaultScheduler_Worker-9] Synchronizing users and groups with user registry 'ldap-ad1'

2016-10-19 00:00:00,436 WARN [org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer] [DefaultScheduler_Worker-9] Full synchronization with user registry 'ldap-ad1'

2016-10-19 00:00:00,436 WARN [org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer] [DefaultScheduler_Worker-9] Some users and groups previously created by synchronization with this user registry may be removed.

2016-10-19 00:00:00,472 INFO [org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer] [DefaultScheduler_Worker-9] Retrieving all groups from user registry 'ldap-ad1'

2016-10-19 00:00:00,663 INFO [org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer] [DefaultScheduler_Worker-9] Synchronization,Category=directory,id1=ldap-ad1,id2=1 Group Analysis: Commencing batch of 27 entries

2016-10-19 00:00:00,774 INFO [org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer] [DefaultScheduler_Worker-9] Synchronization,Category=directory,id1=ldap-ad1,id2=1 Group Analysis: Processed 27 entries out of 27. 100% complete. Rate: 243 per second. 0 failures detected.

2016-10-19 00:00:00,852 INFO [org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer] [DefaultScheduler_Worker-9] Retrieving all users from user registry 'ldap-ad1'

2016-10-19 00:00:00,854 INFO [org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer] [DefaultScheduler_Worker-9] Synchronization,Category=directory,id1=ldap-ad1,id2=6 User Creation and Association: Commencing batch of 5 entries

2016-10-19 00:00:00,878 INFO [org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer] [DefaultScheduler_Worker-9] Synchronization,Category=directory,id1=ldap-ad1,id2=6 User Creation and Association: Processed 5 entries out of 5. 100% complete. Rate: 208 per second. 0 failures detected.

2016-10-19 00:00:00,880 INFO [org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer] [DefaultScheduler_Worker-9] Synchronization,Category=directory,id1=ldap-ad1,id2=5 User Association: Commencing batch of 71 entries

2016-10-19 00:00:00,895 INFO [org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer] [DefaultScheduler_Worker-9] Synchronization,Category=directory,id1=ldap-ad1,id2=5 User Association: Processed 71 entries out of 71. 100% complete. Rate: 4733 per second. 0 failures detected.

2016-10-19 00:00:00,896 INFO [org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer] [DefaultScheduler_Worker-9] Synchronization,Category=directory,id1=ldap-ad1,id2=5 User Association: Completed batch of 71 entries

2016-10-19 00:00:00,975 INFO [org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer] [DefaultScheduler_Worker-9] Finished synchronizing users and groups with user registry 'ldap-ad1'

2016-10-19 00:00:00,975 INFO [org.alfresco.repo.security.sync.ChainingUserRegistrySynchronizer] [DefaultScheduler_Worker-9] 5 user(s) and 27 group(s) processed

2016-10-19 00:00:01,099 ERROR [freemarker.runtime] [FeedNotifier1] Error executing FreeMarker template

FreeMarker template error:

The following has evaluated to null or missing:

==> {activity.activitySummary.pag [in template "workspace://SpacesStore/6e935594-97ca-4489-bf3c-e5ff32d7a145" at line 53, column 130]

Re: Cannot Edit with MS office (2016

afaust — Wed, 19 Oct 2016 15:46:20 GMT

Can you attach (not copy&paste) the entire alfresco.log file (and similarly named files from previous days)? The output you pasted currently doesn't show anything except the automatic user synchronization that runs at midnight.

Re: Cannot Edit with MS office (2016

momac — Thu, 20 Oct 2016 11:00:19 GMT

added

Re: Cannot Edit with MS office (2016

afaust — Thu, 20 Oct 2016 11:53:05 GMT

Judging from the logs you have an issue with search / SOLR in general. The backup job is also failing, but this could be related to the general issue. I have also found errors that directly link SOLR and tagging, specifically during the attempt to set / create tags on a document.

It looks like SOLR did not start up correctly at some point, causing 404 errors during search requests. After a restart it appeared to be running but an invalid SSL configuration caused the SSL handshake to fail.

For some reason your user / group synchronization runs quite frequently which should not be the case in a normal system (default run only once every night).

Regarding preview issues I can only find issues with MS Office files where the content transformer cannot extract a thumbnail from the file itself (MS Office might embed thumbnails). LibreOffice could not be started due to an invalid (or no?) path configuration in alfresco-global.properties. As a result it cannot act as a fallback when the thumbnail extraction fails.

I haven't found an indication what might be the problem regarding edit online.

To me it looks like something went wrong during installation and configuration. The incorrect path for LibreOffice should have been replaced with the real path during installation, and if you installed from the installer you should have a working SSL setup. It might be worth redoing the install and looking for any errors along the way.

Re: Cannot Edit with MS office (2016

momac — Fri, 21 Oct 2016 07:45:58 GMT

Thx for a precise Reply.

Do you have any suggestion how i should install the alfresco in order to be able to work with ssl and Microsoft Online Editing. Maybe a short guide would help

Im kinda struggling with the alfresco right now. Maybe its better to install it manualy.

Re: Cannot Edit with MS office (2016

afaust — Fri, 21 Oct 2016 08:32:19 GMT

I always install it (semi) manually to better adapt Alfresco to specific policies / structures used by a customers IT department. Quite a few people are using the Loftux installer script.

Re: Cannot Edit with MS office (2016

binduwavell — Sat, 22 Oct 2016 17:43:43 GMT

Last time I checked Office 2016 was not supported. I know it's being worked on, so it's possible there is initial support in recent community releases.