SYMPTOM:
When executing a report in SQL view in Strategy Developer 9.4.x and 10.x, the error message as below is received:
Sample Code/Error
SQLEngine got an Exception from DFC: Engine Logic: Null table pointer passed to a leaf node in from tree.
CAUSE:
An attribute is a child to some of the other attributes in the report. However, the child attribute does not exist in the Metadata, which makes the Metadata in an inconsistent state.
ACTION:
Removing the attribute that no longer exists from the child relationship list of all the parent attributes in attribute editor fixes the issue. If the attribute is needed for the schema, re-create the children attribute from scratch.
