KB47674: "Error: Data type conversion failed: from DSS type to native type" error message appears when executing reports in MicroStrategy Analytics Enterprise 9.x or 10.x against Arcadia Platform 1.1

SYMPTOM:
 
When executing reports which contain varchar fields against Arcadia Platform 1.1 in Strategy Analytics Enterprise 9.x or 10.x the following error may occur:
 

Error: Data type conversion failed: from DSS type to native type. Database type: SQL Engine encountered an exception for query wizard report Engine Logic: The column XXX’s datatype XX with precision 2147483647 scale – 2147483648 is not supported.]

 
CAUSE:
 
The error is caused by the default value for 'Max Varchar Size' set on the Strategy ODBC Driver for Impala Wire Protocol. The value by default is set at 2147483647 which will cause errors running reports against Arcadia Platform 1.1
 
ACTION:
 
In order to resolve the issue, modify the DSN and under the "Advanced" section set 'Max Varchar Size" to 334 as shown below: