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 of over 48,000 articles and solutions.
Close
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.