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:
# set the path to the Strategy Google BigQuery Driver ini file
StrategyBIGQUERYINI="${MSTR_HOME_PATH:?}"/Strategy.bigqueryodbc.ini
export StrategyBIGQUERYINI
# set the path to the Strategy Google BigQuery Driver ini file
StrategyGOOGLEBIGQUERYODBCINI="${MSTR_HOME_PATH:?}"/Strategy.bigqueryodbc.ini
export StrategyGOOGLEBIGQUERYODBCINI
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.