Uploaded image for project: 'Confluence Cloud'
  1. Confluence Cloud
  2. CONFCLOUD-54504

New Google Sheets unable to be inserted into Confluence with Google Spreadsheets macro

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Medium
    • None

    Description

      Steps to reproduce

      1. Create a new spreadsheet in Google Sheets.
      2. Using a Cloud instance that's hooked into that same Google domain for user management, attempt to insert that new spreadsheet using the Google Spreadsheet macro.
      3. You get a system error in the Preview window, and this stack trace in the logs:
      2014-12-24 09:54:17,224 ERROR [TP-Processor45] [[Catalina].[localhost].[/wiki].[servlet-module-container-servlet]] log Servlet.service() for servlet servlet-module-container-servlet threw exception
      java.lang.RuntimeException: java.lang.IllegalArgumentException: Trying to set foreign cookie
            at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1137)
            at sun.net.www.protocol.http.HttpURLConnection.getHeaderField(HttpURLConnection.java:2346)
            at java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:388)
            at sun.net.www.protocol.https.HttpsURLConnectionImpl.getResponseCode(HttpsURLConnectionImpl.java:318)
            at com.google.gdata.client.http.HttpGDataRequest.checkResponse(HttpGDataRequest.java:549)
            at com.google.gdata.client.http.HttpGDataRequest.execute(HttpGDataRequest.java:530)
            at com.google.gdata.client.http.GoogleGDataRequest.execute(GoogleGDataRequest.java:535)
            at com.google.gdata.client.media.MediaService.getMediaResource(MediaService.java:234)
            at com.google.gdata.client.media.MediaService.getMedia(MediaService.java:286)
            at com.google.gdata.client.media.MediaService.getMedia(MediaService.java:302)
            at com.atlassian.agmp.gdata.impl.AuthenticatedMediaServiceImpl.exportFile(AuthenticatedMediaServiceImpl.java:55)
            at com.atlassian.agmp.gdata.impl.DocsServiceImpl.exportSpreadsheet(DocsServiceImpl.java:45)
            at com.atlassian.agmp.gdata.servlet.GSpreadsheetServlet.export(GSpreadsheetServlet.java:48)
            at com.atlassian.agmp.gdata.servlet.GSpreadsheetServlet.export(GSpreadsheetServlet.java:13)
            at com.atlassian.agmp.gdata.servlet.BaseGDataDocServlet.doGet(BaseGDataDocServlet.java:51)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
            at com.atlassian.plugin.servlet.DelegatingPluginServlet.service(DelegatingPluginServlet.java:42)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
            at com.atlassian.plugin.servlet.ServletModuleContainerServlet.service(ServletModuleContainerServlet.java:52)
            at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
            at com.atlassian.confluence.web.filter.DebugFilter.doFilter(DebugFilter.java:50)
            at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
            at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
            at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:70)
            at com.atlassian.labs.botkiller.BotKillerFilter.doFilter(BotKillerFilter.java:36)
            at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:78)
      [...]
      Caused by: java.lang.IllegalArgumentException: Trying to set foreign cookie
            at com.google.gdata.client.http.GoogleGDataRequest$GoogleCookie.<init>(GoogleGDataRequest.java:166)
            at com.google.gdata.client.http.GoogleGDataRequest$GoogleCookieHandler.put(GoogleGDataRequest.java:399)
            at sun.net.www.http.HttpClient.parseHTTPHeader(HttpClient.java:710)
            at sun.net.www.http.HttpClient.parseHTTP(HttpClient.java:632)
            at sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1195)
            at java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:379)
            ... 253 more
      

      Older documents actually work fine, but newly-created documents all fail. I haven't been able to determine the exact cut-off. This does not occur for Docs or Presentations, only Sheets.

      EDIT 21/04/2015 We rolled out new set of macros for google drive integration. More details onto:

      Unfortunately we weren't able to do automatic migration from old macros to new macros. This needs to be done manually.

      Attachments

        Issue Links

          Activity

            People

              psemeniuk Petro Semeniuk (Inactive)
              nmason Nick Mason
              Votes:
              33 Vote for this issue
              Watchers:
              37 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: