KB40845: "Error type:... [Microsoft][SQL Server Native Client 10.0]String data, right truncation" error occurs when running a report for a metric with VARCHAR (MAX) datatype in MicroStrategy 9.4.x-10.x.

Salesforce Solutions Architect • Strategy

This knowledge base article explains why "Error type:... [Microsoft][SQL Server Native Client 10.0]String data, right truncation" error occurs when running a report for a metric with VARCHAR (MAX) datatype in MicroStrategy 9.4.x-10.x.

SYMPTOM:
When using a VarChar(MAX) datatype, represented as VarChar(-1) in Strategy, the following error occurs:


Error type: Odbc success with info. Odbc operation attempted: SQLFetchScroll. String data, right truncation

CAUSE:
SQL Server Native Client ODBC drivers do not support VarChar (Max) datatypes.

ACTION:
CAST the field to a specific amount (i.e. VarChar(500))

Comment

0 comments

Details

Knowledge Article

Published:

June 6, 2017

Last Updated:

June 6, 2017