SYMPTOM:
When trying to connect to Google BigQuery with service authentication, the following error appears in Strategy 2021 Update 9 and 10.
(Database error <5>: Connect failed. Error type: Odbc error. Odbc operation
attempted: SQLDriverConnect. [HY000:-1: on SQLHANDLE] [Strategy][DSI]
An error occurred while attempting to retrieve the error message for key
'DSDecryptError' with message parameters ['The parameter is incorrect.']
and component ID 100: Message not found in file "C:\Program Files
(x86)\Common
Files\MicroStrategy\ODBC\BigQuery\en-US\SimbaBigQueryODBCMessages.xml")
STEPS TO REPRODUCE:
CAUSE:
This is a known issue that occurs with the ODBC driver shipped with Strategy Updates 9 and 10. It does not happen when using the JDBC driver for Google BigQuery.
ACTION:
This issue has been fixed with the ODBC driver shipped with Strategy Update 11. Upgrade to this version in order to take advantage of the fix.