EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

Updating Google BigQuery driver in MicroStrategy Secure Enterprise 10.4 Hotfix 5


Norman Matos

Associate Scrum Master • Strategy


In Strategy Secure Enterprise version 10.4 Hotfix 5, the Google Big Query driver is updated from version 1.01.04.1006  to newer version 2.00.08.1015. When Intelligence Server is installed in Linux OS the following environment variable needs to be updated manually to complete the Google Big Query driver upgrade: 
 

  1. Assume Strategy home folder is $MSTR_HOME.
  2. Edit the file $MSTR_HOME/env/ODBC.sh
  3. Find the following lines:

# set the path to the Strategy Google BigQuery Driver ini file
StrategyBIGQUERYINI="${MSTR_HOME_PATH:?}"/Strategy.bigqueryodbc.ini
export StrategyBIGQUERYINI
 

  1. Change them to: 

# set the path to the Strategy Google BigQuery Driver ini file
StrategyGOOGLEBIGQUERYODBCINI="${MSTR_HOME_PATH:?}"/Strategy.bigqueryodbc.ini
export StrategyGOOGLEBIGQUERYODBCINI   
 

  1. Save the file $MSTR_HOME/env/ODBC.sh
  2. Restart Intelligence Server.


 
If the steps above are not followed, the following error message may appear when executing reports:
 
[Strategy][DSI] An error occurred while attempting to retrieve the error message for key ‘GQueryExecFail’ and component ID 100: Could not open error message files – Check that ‘/opt/mstr/MicroStrategy/install/lib/en-US/SimbaBigQueryODBCMessages.xml’ or ‘/opt/mstr/MicroStrategy/install/lib/SimbaBigQueryODBCMessages_en-US.xml’ exists and are accessible.
 
Notice that if Intelligence Server is installed in Windows, the Google Big Query driver is updated automatically with the Hotfix 5 installation.   
 


Comment

0 comments

Details

Knowledge Article

Published:

October 2, 2017

Last Updated:

October 2, 2017