KB46955: "[MySQL][ODBC 5.2(w) DRIVER][mysqld-5.5.21]Variable 'sql_mode' can't be set to the value of 'N'" error message appears when performing a data import from a MySQL Community 5.5 database in MicroStrategy Web 9.4.1

• Strategy

When performing a data import from database in MicroStrategy Web 9.4.1 against a MySQL Community 5.5 database, the following error message is observed when selecting the connection: Database error <5>: Execute Query failed. %0d%0aError type: Odbc error. Odbc operation attempted: SQLExecDirect. Variable 'sql_mode' can't be set to the value of 'N'

SYMPTOM:
When performing a data import from database in Strategy Web 9.4.1 against a MySQL Community 5.5 database, the following error message is observed when selecting the connection:


Database error <5>: Execute Query failed. %0d%0aError type: Odbc error. Odbc operation attempted: SQLExecDirect. 
Variable 'sql_mode' can't be set to the value of 'N'

CAUSE:
This is a known issue in Strategy Web 9.4.1.
ACTION:
Contact Strategy Technical Support for an update on this issue.

Comment

0 comments

Details

Knowledge Article

Published:

May 15, 2017

Last Updated:

May 15, 2017