KB30059: “SQLEngine got an Exception from DFC: [DFCSCHEMA] Logic Exception: Attribute form's lookup table is empty.” error message appears when users execute a report in MicroStrategy Desktop 10.x.

Salesforce Solutions Architect • Strategy

This article describes error “SQLEngine got an Exception from DFC: [DFCSCHEMA] Logic Exception: Attribute form's lookup table is empty.” when users execute a report in MicroStrategy Desktop 10.x.

SYMPTOM:
When users execute a report in Strategy Desktop 10.x, the following error occurs:


SQLEngine got an Exception from DFC: Logic Exception: Attribute form's lookup table is empty.

CAUSE:
One possible cause of this error is that the Advanced Sorting list contains attributes or metrics that are available in the project, but no longer available in the Report's Design.

ACTION:
Please follow steps below to reset the Advanced Sorting:

Open the target report in design view.
Go to menu > Data > Advanced Sorting

Remove all the sorts (under both Rows and Columns tabs) and re-add them back again.
Note: Users may find few attributes or metrics are missing when trying to reconfigure the Advanced Sorting. Those missing attributes or metrics might no longer exist in the report design.
Save and close the report.

Comment

0 comments

Details

Knowledge Article

Published:

June 16, 2017

Last Updated:

June 16, 2017