Compression And Optimize

Symptom :- The feed would fail with following error if the Optimize or compress flag is turned off.

Error:- Failed! Column 'dbo..ACCOUNT' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause. source:.Net SqlClient Data Provider

Cause: - The problem in Compression process was caused by following code where if the optimize flag is turned off it should not create “Sum” in the SQL.

cast(sum(signeddata) as [decimal](25, 10)) [signeddata]

Remedy.  This problem has been fixed. Apply the hot fix p_ETL_FILT_v1.4.sql to solve.