Postgres Only - Include in the Data Warehouse flag stays checked even when error while including attribute.

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When you attempt to Include in the Data Warehouse for several attributes and one of those attributes getting an error it will keep Include in the Data Warehouse flag checked but those attribute are not making into DWH.

Steps to Reproduce: 
1. Create dynamic lookup with lookup id having a dot(.), for example "cop.portlet_prog". Note this can only be done via XOG as UI does not allow it.
2. Create attribute in the investment project pointing to the lookup created in step 1 above.
3. While under Investment object attributes tab attempt to select multiple attributes including the attribute created in the step above and click on INCLUDE IN DATA WAREHOUSE.
4. Even though you get Error 500 - Internal Server Error all the selected attribute will have a check mark for Data Warehouse.

Expected Results: It should not update the flag for Data Warehouse if encountered an error.

Actual Results: It is marking Data Warehouse flag

Environment

Clarity 16.x

Cause

DE195895

Resolution

Under review by Engineering.