EducationSoftwareStrategy.com
StrategyCommunity

Knowledge Base

Product

Community

Knowledge Base

TopicsBrowse ArticlesDeveloper Zone

Product

Download SoftwareProduct DocumentationSecurity Hub

Education

Tutorial VideosSolution GalleryEducation courses

Community

GuidelinesGrandmastersEvents
x_social-icon_white.svglinkedin_social-icon_white.svg
Strategy logoCommunity

© Strategy Inc. All Rights Reserved.

LegalTerms of UsePrivacy Policy
  1. Home
  2. Topics

KB10660: "SQLEngine got an exception" error message appears when using the Oracle TIMESTAMP WITH LOCAL TIME ZONE data type with MicroStrategy Developer 10.x


Stefan Zepeda

Salesforce Solutions Architect • Strategy


The following error occurs when using MicroStrategy Developer: SQLEngine got an Exception from DFC: Engine Logic: The column %1's datatype %2 with precision %3 scale %4 is not supported.

SYMPTOM:
The following error occurs when using Strategy Developer:


SQLEngine got an Exception from DFC: Engine Logic: The column %1's datatype %2 with precision %3 scale %4 is not supported.


CAUSE:
This error occurs when using the Oracle WITH LOCAL TIME ZONE data type because it is not currently recognized by Strategy.
This data type is similar to the TIMESTAMP date format with the following exceptions:

  • Data are normalized to the database time zone when it is stored in the database.
  • When the data are retrieved, users see the data in the session time zone.

This is a known issue in Strategy Developer.
Strategy will continue to investigate and post updates as soon as they are available..
WORKAROUND:
To workaround this issue, use the TIMESTAMP or DATE data type instead of TIMESTAMP WITH LOCAL TIME ZONE


Comment

0 comments

Details

Knowledge Article

Published:

June 2, 2017

Last Updated:

June 2, 2017