KB47336: "The lookup table `table name´ was not found either within the expression`s related tables or within the EXPSOURCETABLES explicitly defined" error appears when creating an attribute in MicroStrategy Command Manager

SYMPTOM:
 
"The lookup table 'table name' was not found either within the expression's related tables or within the EXPSOURCETABLES explicitly defined" error appears when running script to create an attribute in Strategy Command Manager 9.x as shown below:
 

CREATE ATTRIBUTE "AtributeCol5" IN FOLDER "\SCHEMA Objects\ATTRIBUTES" ATTRIBUTEFORM "ID" FORMCATEGORY "ID" FORMTYPE TEXT EXPRESSION "ColA" LOOKUPTABLE "TestTable3" FOR PROJECT "Strategy Tutorial";

Syntax is correct.
The lookup table 'TestTable3' was not found either within the expression's related tables or within the EXPSOURCETABLES explicitly defined.
Task(s) execution completed with errors.
Execution Time: 00:00:02

 
CAUSE:
 
One possible cause for this issue is that ColA is not mapping to TestTable3 due to duplicate column issue as described in KB35168. Multiple columns with extra suffix are seen in System Objects\Columns folder after enabling Desktop to show it by following KB19828 as shown below:
 

 
The dependent search of ColA (2) indicates that TestTable3 actually includes column ColA (2) instead of ColA as shown below:
 

 
 
ACTION:
 
Please contact Strategy Technical Support to merge duplicate column objects.