Bug 1095159
| Summary: | Unable to connect google spreadsheet | ||
|---|---|---|---|
| Product: | [JBoss] JBoss Data Virtualization 6 | Reporter: | Hisanobu Okuda <hokuda> |
| Component: | Teiid | Assignee: | jolee |
| Status: | CLOSED UPSTREAM | QA Contact: | |
| Severity: | unspecified | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 6.0.0 | CC: | asaji |
| Target Milestone: | --- | ||
| Target Release: | --- | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: |
Users cannot connect to the Google resource adapter in some cases. They will encounter an exception when they try to deploy a dynamic VDB.
|
Story Points: | --- |
| Clone Of: | Environment: | ||
| Last Closed: | 2025-02-10 03:35:48 UTC | Type: | Support Patch |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
Here's a reference to the google issue that's causing our issue: https://code.google.com/p/google-visualization-api-issues/issues/detail?id=1476 This is a third-party library issue and with no workaround provided. We need to get GSS to work with the engineers to see what can be done. Steven Hawkins <shawkins> updated the status of jira TEIID-2949 to Resolved Steven Hawkins <shawkins> updated the status of jira TEIID-2949 to Closed This product has been discontinued or is no longer tracked in Red Hat Bugzilla. |
Description of problem: Unable to connect google spreadsheet Version-Release number of selected component (if applicable): How reproducible: Steps to Reproduce: 1. configure resource adaptor for google in standalone.xml <resource-adapter id="google"> <module slot="main" id="org.jboss.teiid.resource-adapter.google"/> <transaction-support>NoTransaction</transaction-support> <connection-definitions> <connection-definition class-name="org.teiid.resource.adapter.google.SpreadsheetManagedConnectionFactory" jndi-name="java:/google" enabled="true" use-java-context="true" pool-name="google"> <config-property name="AuthMethod"> ClientLogin </config-property> <config-property name="SpreadsheetName"> testsheet </config-property> <config-property name="BatchSize"> 4096 </config-property> <config-property name="Username"> hokuda.test </config-property> <config-property name="Password"> passpassw </config-property> </connection-definition> </connection-definitions> </resource-adapter> 2. deploy dynamic vdb <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <vdb name="test" version="1"> <description>Dynamic Google Spreadsheet VDB</description> <model name="google"> <source name="google-spreadsheet" translator-name="google-spreadsheet" connection-jndi-name="java:/google"/> </model> </vdb> 3. you get an exception 16:59:34,429 WARN [org.teiid.RUNTIME] (teiid-async-threads - 1) TEIID50036 VDB test.1 model "google" metadata failed to load. Reas on:Error when getting batch 404:Not Found: org.teiid.resource.adapter.google.common.SpreadsheetOperationException: Error when getti ng batch 404:Not Found at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI$DataProtocolQueryStrategy.executeAndParse(GoogleDat aProtocolAPI.java:248) at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI$DataProtocolQueryStrategy.getResultsBatch(GoogleDat aProtocolAPI.java:163) at org.teiid.resource.adapter.google.dataprotocol.GoogleDataProtocolAPI.getMetadata(GoogleDataProtocolAPI.java:109) at org.teiid.resource.adapter.google.gdata.SpreadsheetMetadataExtractor.extractMetadata(SpreadsheetMetadataExtractor.java:7 4) at org.teiid.resource.adapter.google.SpreadsheetConnectionImpl.getSpreadsheetInfo(SpreadsheetConnectionImpl.java:147) at org.teiid.translator.google.SpreadsheetExecutionFactory.getMetadata(SpreadsheetExecutionFactory.java:71) at org.teiid.translator.google.SpreadsheetExecutionFactory.getMetadata(SpreadsheetExecutionFactory.java:45) at org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:61) [teiid-engine-8.4.1-red hat-7.jar:8.4.1-redhat-7] at org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55) [teiid-engine-8.4.1 -redhat-7.jar:8.4.1-redhat-7] at org.teiid.jboss.VDBService$6.run(VDBService.java:397) [teiid-jboss-integration-8.4.1-redhat-7.jar:8.4.1-redhat-7] at org.teiid.jboss.VDBService$7.run(VDBService.java:444) [teiid-jboss-integration-8.4.1-redhat-7.jar:8.4.1-redhat-7] at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33) at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:806) at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45) at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:826) at java.lang.Thread.run(Thread.java:744) [rt.jar:1.7.0_45] at org.jboss.threads.JBossThread.run(JBossThread.java:122) Actual results: Expected results: Additional info: