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

KB36188: "SQLEngine got an Exception from DFC: ????????????Can not find appropriate column reference" error occurs during attribute element browsing or running reports in MicroStrategy Developer 10.x


Stefan Zepeda

Salesforce Solutions Architect • Strategy


When browsing attribute elements or running certain reports in MicroStrategy Developer 10.x, the following error occurs: SQLEngine got an Exception from DFC: ??????????????????????Can not find appropriate column reference

SYMPTOM:
When browsing attribute elements or running certain reports in Strategy Developer 10.x, the following error occurs:

ka02R000000kbkbQAA_0EM440000002DlT.png

SQLEngine got an Exception from DFC: ??????????????????????Can not find appropriate column reference
CAUSE:
The exact cause of this issue is unknown at this point. In order to track down the cause of the inconsistency, customers encountering this issue should make note of Schema-related changes, Object Migrations, or error messages prior to experiencing the problem.  Change Journaling, if it has been enabled, can help in preserving this information.
WORKAROUND:
Run Strategy ScanMD (Schema Common Tests) which should be able to resolve the metadata inconsistency:
KB35809: Using ScanMD to fix known logical metadata inconsistencies in the Strategy Product Suite 9.4.x - 10.2 Hotfix1


Comment

0 comments

Details

Knowledge Article

Published:

June 9, 2017

Last Updated:

June 9, 2017