Variables do not load correctly in the condition builder if a variable has invalid (missing) lookup table - Known Error

Variables do not load correctly in the condition builder if a variable has invalid (missing) lookup table Description Variables do not load correctly in the condition builder if a variable has invalid (missing) lookup table. Similar behavior is also seen when the variables have invalid/missing reference tables when the type of variable is Reference.

Steps to Reproduce

1. Create a new table like New Table Test [u_new_table_test]

2. Create a new choice type field on this table

3. Add some choice values

4. Create a new variable Type - Lookup Select box Lookup Table - New Table Test Lookup Field : Field created in step2

5. Save the variable and add to a catalog Item - Ex Apple Ipad 3

6. View the item and generate a sc_req_item record

7. Go to reports menu and create a new report

8. Select table sc_req_item

9. In the condition builder for filters apply/Select Variables->apple ipad 3

10. Ensure the variables load and show the new variable created too

11. Go to table u_new_table_test and delete the table

12. Repeat steps 7-8-9 for reports

As a result, no variables load and there is a NullPointerException in the logs.

Workaround This problem has been fixed. If you are able to upgrade, review the Fixed In section to determine the latest version with a permanent fix your instance can be upgraded to.

The issue was due to invalid table references. If the type of variable is Lookup Select box, the Lookup table is a mandatory field. If the type of variable is Reference, then Reference Table needs to be populated with a valid table name.

Correct the variables by providing a valid table or delete these invalid variables to load the condition builder successfully.