Hi Karim,
[CA Clarity][SQLServer JDBC Driver][SQLServer]Invalid column name 'LODH_ALL_COMMENTS'.
Please try unchecking the following attribute from Data Warehouse: LODH_ALL_COMMENTS. To do this, please do the following:
1. Go to PPM UI - Administration - Objects - Idea
2. In Attributes, find LODH_ALL_COMMENTS, open it
3. Uncheck the "Include in Data Warehouse" flag.
4. Run the Load Data Warehouse - Full Load
Once it completes we can try adding the attribute back. Looks like it didn't add properly.
Please let me know how it goes. -Nika