All Import sets fail when run automatically; re-processing them manually works


Description

Symptoms

- Import sets get processed by the Transform Map scripts but noting is processed:
updated=0, inserted=0. skipped=0, ignored=0 
- When re-running manually ("Execute Now" button), this always works 

Cause

The staging tables are not given a "pending" state because the default value (pending) was somehow cleared from dictionary record. 

Resolution

1. For Dictionary Entries where table = sys_import_set_row and column = sys_import_state 
2. Modify the'Default value' field to pending