cancel
Showing results for 
Search instead for 
Did you mean: 

Alfresco-5.0.d problems with SharePoint interface

fvincenti
Champ on-the-rise
Champ on-the-rise
Hi friends of the forum,
I have the following problem with SharePoint interface in Alfresco-5.0.d which I installed from:
alfresco-community-5.0.d-installer-linux-x64.bin
choosing easy installation.
When I try to open a document using function “Edit Online” (available in site only)  I get the following message:
"Could not start MS Office"
and nothing happens, both alfresco.log and catalina.out do not show any message.

I made a first check of the installation and all seemed to be OK, so I started to analyze the context to configure all the features offered.
The first aspect I wanted to start was the interface with SharePoint and I found the Vti module already installed:
this is the answer of mmt list:
"Module 'org.alfresco.module.vti' installed in 'tomcat/webapps/alfresco'
   -    Title:        Vti
   -    Version:      1.3
   -    Install Date: Mon Apr 13 14:26:25 CEST 2015
   -    Description:   Alfresco Vti Extension, provides Sharepoint protocol"
And this is what I found under amps:
"/usr/local/alfresco-5.0.d/amps/alfresco-spp.amp"

So I start to check if SharePoint works.
-   First, I try the following command:
"lsof –i TCP:7070"
which answers:
"java    16928 root  555u  IPv6 52348976      0t0  TCP *:arcp (LISTEN)"
-   Then I type in a firefox browser:
"http://IP_to_my_server:7070"
which asks for authentication and, then, shows the following message:
“This is the Alfresco SharePoint Module…….”
-   Moreover, for the documents inside a site, it is present the option “Edit Online”.
-   Windows registry are already configured for a previous release of Alfresco (4.0.d).

But I find the following abnormalities (?)
-   the file:
"alfresco-global.properties"
does not contain the following lines:
"vti.server.port=7070
vti.server.external.host=http://IP_to_my_server
vti.server.external.port=7070"
If I insert these lines and restart Alfresco, I get the following errors under catalina.out:
"2015-05-04 10:38:09,073  ERROR [web.context.ContextLoader] [localhost-startStop-1] Context initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'vtiUrlHelper' defined in class path resource [alfresco/module/org.alfresco.mo
dule.vti/context/vti-context.xml]: Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Unable to construct valid Sharepoint URL.
……………………………………………………………………………………………………………………………………..
Caused by: java.lang.IllegalArgumentException: Unable to construct valid Sharepoint URL.
……………………………………………………………………………………………………………………………………..
Caused by: java.net.URISyntaxException: Expected closing bracket for IPv6 address at index 13: http://[http://IP_to_my_server]:7070/alfresco
……………………………………………………………………………………………………………………………………………
SEVERE: Exception sending context initialized event to listener instance of class org.alfresco.web.app.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'vtiUrlHelper' defined in class path resource [alfresco/module/org.alfresco.module.vti/context/vti-context.xml]: Invocation of init method failed; nested exception is java.lang.IllegalArgumentException: Unable to construct valid Sharepoint URL".
-   The directory:
…./alfresco/WEB-INF/classes/alfresco/module/org.alfresco.module.vti/context/
does not exist.
-   I unzipped (using jar) alfresco-spp.amp but context is not present.

It seems that the directory "context" must be present.

I searched the alfresco forums but I do not find answers for my problem and I can not find the way to download a new "alfresco-community-spp-5.0.d.amp" to check if this new one has the context directory. I do not think that would be a good idea to install  an older version.
The server environment I am talking about is the following:
-   Operating System   Linux Centos 6.6
-   Data Base      PostgreSQL-9.3.6
-   Java         java version "1.8.0_31"
-   Tomcat      Apache Tomcat/7.0.59
-   Alfresco-5.0.d      using LibreOffice
The client is as follow:
-   Operating System   Windows 7
-   Browser      Firefox

Every help will be appreciated.
Thanks in advance
Frank
13 REPLIES 13

eswbitto
Confirmed Champ
Confirmed Champ
I think you should consider restarting your installation and doing the advanced and making sure the sharepoint module is installed.

From there if your using firefox as a browser to do the online editing make sure that the addon is working and installed.

Also make sure in the address bar of the browser to the very left click on the icon that looks like a lego block and make sure the plugin is allowed.

The other thing that you can do is open up word or excel and do a file….open….

In the "Look In" part you can type your url. https://fqdn:7070/alfresco and it should access your alfresco server. That's if you have the SSL configured.

ESWBitto thank you very much for your answer.
I am sure firefox is correctly configured because it allows edit online with another alfresco-4.0.d installation, running in production environment.
BUT the URL "http://fqdn:7070/alfresco" gets the error "Connection refused" because firefox is searching on localhost instead of on the server.
I am going to search for this misconfiguration.
Thank you again.

fvincenti
Champ on-the-rise
Champ on-the-rise
Nothing to do.
I have reinstalled Alfresco-5.0.d using advanced way but when I try to edit ONLINE a file the error is always the same:
"Could not start MS Office"
without asking for authentication.
Here is my alfresco-global.properties file:

dir.root=/usr/local/alfresco-5.0.d/alf_data

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

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

### database connection properties ###
db.driver=org.postgresql.Driver
db.username=alfresco
db.password=XXXXXXXX
db.name=alfresco
db.url=jdbcSmiley Tongueostgresql://localhost:5432/${db.name}
# Note: your database must also be able to accept at least this many connections.  Please see your database documentation for instructions on how to configure this.
db.pool.max=275
db.pool.validate.query=SELECT 1

# The server mode. Set value here
# UNKNOWN | TEST | BACKUP | PRODUCTION
system.serverMode=UNKNOWN

### FTP Server Configuration ###
ftp.port=21

### RMI registry port for JMX ###
alfresco.rmi.services.port=50500

### External executable locations ###
ooo.exe=/usr/local/alfresco-5.0.d/libreoffice/program/soffice
ooo.enabled=true
ooo.port=8100
img.root=/usr/local/alfresco-5.0.d/common
img.dyn=${img.root}/lib
img.exe=${img.root}/bin/convert
swf.exe=/usr/local/alfresco-5.0.d/common/bin/pdf2swf
swf.languagedir=/usr/local/alfresco-5.0.d/common/japanese

jodconverter.enabled=false
jodconverter.officeHome=/usr/local/alfresco-5.0.d/libreoffice
jodconverter.portNumbers=8100

### Initial admin password ###
alfresco_user_store.adminpassword=51fb1ee7b830cf8e356ed4c554b66e4f

### E-mail site invitation setting ###
notification.email.siteinvite=false

### License location ###
dir.license.external=/usr/local/alfresco-5.0.d

### Solr indexing ###
index.subsystem.name=solr4
dir.keystore=${dir.root}/keystore
solr.port.ssl=8443

### BPM Engine ###
system.workflow.engine.jbpm.enabled=false

### Allow extended ResultSet processing
security.anyDenyDenies=false

### Inizio modifiche Major release 2.0  ###
content.transformer.PdfBox.TextToPdf.maxSourceSizeKBytes=10240
content.transformer.Pdf2swf.maxSourceSizeKBytes=8192
content.transformer.complex.Text.Pdf2swf.maxSourceSizeKBytes=8192
content.transformer.complex.OpenOffice.Pdf2swf.extensions.doc.swf.maxSourceSizeKBytes=5120
content.transformer.complex.OpenOffice.Pdf2swf.extensions.docx.swf.maxSourceSizeKBytes=5120

********************************************************************************************************************

Obviously, the directory:
…tomcat/webapps/alfresco/WEB-INF/classes/alfresco/module/org.alfresco.module.vti/context
is not present!

I have checked, in my opinion, everything was checkable without results.
Is there someone who faced the same issue?
Thank you.

eswbitto
Confirmed Champ
Confirmed Champ
I think your issue is that you are using a IP instead of a fully qualified domain name. Try using the fqdn with a ssl certificate and see if that is the issue.

fvincenti
Champ on-the-rise
Champ on-the-rise
First of all, Alfresco-5.0.d does NOT require the directory …alfresco/module/org.alfresco.module.vti/context, although the official documentation says otherwise.
Second point, I modified the alfresco-global.properties file inserting the following lines:

vti.server.port=7070
vti.alfresco.alfresoHostWithPort=http://127.0.0.1:8080
vti.share.shareHostWithPort=http://127.0.0.1:8080
vti.share.deployment.context=/share
vti.server.external.host=IP_TO_MY_SERVER   <—- WITHOUT http://!!
vti.server.external.port=7070
vti.alfresco.deployment.context=/alfresco
vti.server.external.contextPath=/alfresco

I restarted Alfresco and logs did not show errors, a really clean boot, and the "Edit On Line" functionality was perfectly working.

Last but not least: be careful about Firefox plugins because i noticed, culpably late, that if they work for a release, for a new one you have to enable them again.

Greetings
Frank

fvincenti
Champ on-the-rise
Champ on-the-rise
After the configuration I have done, the edit online function works, I am able to open and save MS Office document directly from Alfresco.
But there is still a problem with the MS Word (in this case) "Save AS" function: when I try to save a document with another name, another type (.docx instead of .doc) or in another place I get the following message (more or less, it is a free translation from italian):

"Modifies have been registered but it was impossible to upload them due to an error. It could be possible upload the file using the Web page of the server. Save Copy".

Clicking on the icon "Upload failed" appeared at the right bottom of the word page it opens an information MS Word page BUT, more important, it sends the following error in both alfresco.log and catalina.out:

2015-05-20 14:34:33,818 WARN  [org.alfresco.module.vti.web.actions.VtiSoapAction] [1919856525@qtp-598323383-7] Failure executing Vti request
org.alfresco.module.vti.web.ws.VtiSoapException: The system cannot find the file specified. (Exception from HRESULT: 0x80070002)
        at org.alfresco.module.vti.web.ws.GetVersionsEndpoint.executeVersionAction(GetVersionsEndpoint.java:57)
        at org.alfresco.module.vti.web.ws.AbstractVersionEndpoint.execute(AbstractVersionEndpoint.java:85)
        at org.alfresco.module.vti.web.actions.VtiSoapAction.execute(VtiSoapAction.java:84)
        at org.alfresco.module.vti.web.VtiRequestDispatcher.executeAction(VtiRequestDispatcher.java:257)
        at org.alfresco.module.vti.web.VtiRequestDispatcher.doActions(VtiRequestDispatcher.java:230)
        at org.alfresco.module.vti.web.VtiRequestDispatcher.service(VtiRequestDispatcher.java:148)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:511)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1221)
        at org.alfresco.module.vti.web.VtiFilter.doFilter(VtiFilter.java:192)
        at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1212)
        at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:399)
        at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:182)
        at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:766)
        at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:152)
        at org.mortbay.jetty.Server.handle(Server.java:326)
        at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:542)
        at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:945)
        at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:756)
        at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:218)
        at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:404)
        at org.mortbay.jetty.bio.SocketConnector$Connection.run(SocketConnector.java:228)
        at org.mortbay.thread.QueuedThreadPool$PoolThread.run(QueuedThreadPool.java:582)
Caused by: org.alfresco.service.cmr.model.FileNotFoundException: prova/documentLibrary/Prova-1/pippoxx.doc
        at org.alfresco.module.vti.handler.alfresco.AlfrescoVersionsServiceHandler.getVersions(AlfrescoVersionsServiceHandler.java:131)
        at org.alfresco.module.vti.web.ws.GetVersionsEndpoint.executeVersionAction(GetVersionsEndpoint.java:49)
        … 22 more

Because it did not find the NEW document I would want write, I tried "Save as" specifying the name of an already EXISTING document and in this case "Save as" worked perfectly.
This behaviour seems to be a bug rather than a configuration error.
Is there someone who already faced this kind of issue who can give me some explanations?

Thanks.
Frank

didiermpl
Champ in-the-making
Champ in-the-making
Hi Franck,

I working on a 5.0.c version, and I cannot get the "edit online" option. What do you mean about the plugins for Firefox? I will tris the 5.0.d version but not sure it will be the solution.

Didier

Hi Didier,
if you are using Mozilla Firefox browser you have to install the following plugin to make edit online working:
Microsoft Office 2010, the file name is NPSPWRAP.DLL, but is Firefox itself which shows you the full list of plugins (mozilla.com/plugincheck).
The first time you edit online a document, Firefox will ask you if you want enable, and how long, this plugin.
To check if you have this plugin installed type in Firefox, in the URL space, the following:
aboutSmiley Tonguelugins

Greetings
Frank

sobny
Champ in-the-making
Champ in-the-making
Hi Frank!

I have same problem with alfresco community 5.0.d. When using Sharepoint Protocol, all files are read-only.
The problem resolved by re-apply alfresco sharepoint 5.0.c AMP. It's working fine now Smiley Happy

Hope this help!
TuanNV
Getting started

Tags


Find what you came for

We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.