Google Docs cannot save to alfresco

[bopolissimus]

Hi All,

<ul>
  <li>Linux (Ubuntu Precise, Ubuntu Quantal, Linux Mint Nadia)</li>
  <li>alfresco-community-4.2.b linux installer</li>
  <li>Tested with browser hitting port 8080 and with apache reverse proxy sitting in front of alfresco.</li>
  <li>All alfrescos are not directly accessible from the internet, only from the LAN.</li>
</ul>

I have an alfresco 4.2.b instance which previously worked perfectly with Google Docs.  Recently I tested google docs again and, while the document will open in Google Docs, when I click on "Save to Alfresco", the save fails with "Failed to save Google Doc to Alfresco."

I thought it might be a problem with just that instance (installed WAR files into distribution tomcat), so I installed 4.2.b from scratch into separate virtual machines using the bundled installer.  Even with this fresh install however, saving in Google Docs fails the same way.

I've since tried on other alfresco installations (4.2.b, 4.2.c) and I get the same error in all of them. 

My client machines are Linux (tested with chrome and firefox).  In case it was a problem with my client, I tested on various other linux clients (some pristine virtual machines) and on a Windows 7 machine too.  Same error.

In case it was possibly due to the google account I was using, I switched to another free account.  That failed similarly.

Has anyone else seen this? How would I debug this?  I have
tomcat/shared/classes/alfresco/extension/custom-log4j.properties

and have uncommented:

log4j.logger.org.alfresco.repo.googledocs=debug

but I still see nothing in the debug logs.

Thanks in advance for any pointers.

Gerald

[dlaiz]

Hi Jared,

I have applied the amps upgrade but still can't save or modify any type of google document.

Thanks in advance.

Here my output:

15:23:42,727 ERROR [org.springframework.extensions.webscripts.AbstractRuntime] Exception from executeScript - redirecting to status template error: 08190001 Wrapped Exception (with status template): null
org.springframework.extensions.webscripts.WebScriptException: 08190001 Wrapped Exception (with status template): null
   at org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:1067)
   at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:171)
   at org.alfresco.repo.web.scripts.RepositoryContainer$3.execute(RepositoryContainer.java:433)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:433)
   at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:495)
   at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:533)
   at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:349)
   at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:377)
   at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)
   at org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:118)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
   at org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:61)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
   at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
   at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
   at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
   at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1813)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
   at java.lang.Thread.run(Thread.java:722)
Caused by: java.lang.NullPointerException
   at org.alfresco.integrations.google.docs.webscripts.SaveContent.executeImpl(SaveContent.java:122)
   at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:64)
   … 28 more
15:24:48,268 ERROR [org.springframework.extensions.webscripts.AbstractRuntime] Exception from executeScript - redirecting to status template error: 08190002 Wrapped Exception (with status template): null
org.springframework.extensions.webscripts.WebScriptException: 08190002 Wrapped Exception (with status template): null
   at org.springframework.extensions.webscripts.AbstractWebScript.createStatusException(AbstractWebScript.java:1067)
   at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:171)
   at org.alfresco.repo.web.scripts.RepositoryContainer$3.execute(RepositoryContainer.java:433)
   at org.alfresco.repo.transaction.RetryingTransactionHelper.doInTransaction(RetryingTransactionHelper.java:433)
   at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecute(RepositoryContainer.java:495)
   at org.alfresco.repo.web.scripts.RepositoryContainer.transactionedExecuteAs(RepositoryContainer.java:533)
   at org.alfresco.repo.web.scripts.RepositoryContainer.executeScript(RepositoryContainer.java:349)
   at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:377)
   at org.springframework.extensions.webscripts.AbstractRuntime.executeScript(AbstractRuntime.java:209)
   at org.springframework.extensions.webscripts.servlet.WebScriptServlet.service(WebScriptServlet.java:118)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
   at org.alfresco.web.app.servlet.GlobalLocalizationFilter.doFilter(GlobalLocalizationFilter.java:61)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
   at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:222)
   at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
   at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
   at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:99)
   at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:929)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
   at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1002)
   at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
   at org.apache.tomcat.util.net.AprEndpoint$SocketProcessor.run(AprEndpoint.java:1813)
   at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
   at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
   at java.lang.Thread.run(Thread.java:722)
Caused by: java.lang.NullPointerException
   at org.alfresco.integrations.google.docs.webscripts.SaveContent.executeImpl(SaveContent.java:122)
   at org.springframework.extensions.webscripts.DeclarativeWebScript.execute(DeclarativeWebScript.java:64)
   … 28 more

[jottley]

@dlaiz:  Let's verify somethings:  Which version of Alfresco are you using?  Which version of the GoogleDocs integration are you using (please include the -buildnumber).  Where are you attempting to edit content in Alfresco Share?  Within a site? Or within the repository view?

[dlaiz]

Hi Jared,

Thanks for your reply.

I am currently using Alfresco community 4.2.0 and alfresco-googledocs-repo-2.0.3-23
We only use Alfresco share frontend to edit documentation -> http://server-name/share/page/repository

Regards,
David

[jottley]

@dlaiz, Unless you are using Community 4.2d with Google Docs 2.0.4-31c, the repository view in share will not work with the Alfresco provided amps.  You will need to use the amps provided at https://github.com/Pluies/Alfresco-Google-docs-plugin for the repository view to work.

[dlaiz]

Thanks Jared,

Where should I copy those folders? In my last update I used the amp file (alfresco-googledocs-share-2.0.3-23.amp) restarting tomcat.

Regards,
David

[jottley]

@dlaiz

You'll need to navigate into each of the top level directories and then into their respective target directories. Inside the target directories are the amps you'll need.

[dlaiz]

Hi Jared,

I have tried applying both 2.0.2 and 2.0.3 published amp snapshots and still have the same issue. I am able enter my google credentials and create the document, but the error comes when clicking on save document to alfresco. Should I upgrade to a new alfresco version? I suppose this won't be a straight forward procedure…

Thanks again!

David

[jottley]

Hi David,


The issue that you are seeing sounds like an issue that is fixed in the google docs release that is part of 4.2.d.  (4.2.d is required for the 2.0.4 version of the integration.)  Upgrading sounds like your best bet.  Upgrading shouldn't be that hard.  At the base level it is just switching our the war files.  But you should do the normal steps of backing the db and the contentstore.  Don't let the documentation frighten you! http://docs.alfresco.com/4.2/topic/com.alfresco.enterprise.doc/concepts/ch-upgrade.html

[jmatsushita]

This problem exists now (reappeared?) with Google Spreadsheets, see attached screenshot.

I have tested with a Google Doc and it works fine.

[slanglois]

Hello

Yes, the Google API changed again… We have released version 2.0.7 of GoogleDocs to fix this problem, internally referenced as <a href="https://issues.alfresco.com/jira/browse/MNT-11432">MNT-11432</a>.

You can download it from our Maven repository:
https://artifacts.alfresco.com/nexus/index.html#nexus-search;gav~org.alfresco.integrations~~2.0.7~~

I will deploy it shortly to the Community download page.

Hope this helps!