DV Google Spreadsheet gives 401 error with OAuth2 Authentication Mode
Issue
- Trying to use personal client ID not the example in the documentation for OAuth2 on Google Spreadsheet and receive:
2016-06-03 23:49:53,685 WARN \[org.teiid.PROCESSOR\] (Worker0_QueryProcessorQueue14) TEIID30020 Processing exception for request f2oqJ/EUCuNq.6 'TEIID30504 Spreadsheet: TEIID60000 javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/google-DS'. Originally TeiidProcessingException 'Error when attempting OAuth2 process: 401: Unauthorized' OAuth2Authenticator.java:153.: org.teiid.core.TeiidProcessingException: TEIID30504 Spreadsheet: TEIID60000 javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/google-DS
Environment
- Red Hat JBoss Data Virtualization (DV) 6.2.5
- Google Spreadsheet Resource Adapter for DV
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.