KB41042: “DFC: [DFCENGINE] Engine Logic: The column %1`s datatype %2 with precision %3 scale %4 is not supported.” error is received when running a report with a shortdate unknown datatype in MicroStrategy Desktop 9.2.x.

• Strategy

When running a report with an attribute that has a unknown shortdate datatype, the following error occurs: DFC: Engine Logic: The column %1`s datatype %2 with precision %3 scale %4 is not supported

SYMPTOM:

When running a report with an attribute that has a unknown shortdate datatype, the following error occurs:

DFC: Engine Logic: The column %1`s datatype %2 with precision %3 scale %4 is not supported

CAUSE:

The SQL Server driver does not support newly added or modified data types starting from 2008. Therefore, the output is being recognized as "unknown". However, the SQL Server Native Client driver supports all data types that are currently supported by Microsoft.

ACTION:

Install and use the SQL Server Native Client driver.

Comment

0 comments

Details

Knowledge Article

Published:

June 6, 2017

Last Updated:

June 6, 2017