Qlik Compose Data Quality Cleansing Rule is not working as expected and task fails with SQL compilation error

[lilizou]

With a filter and a data quality cleansing rule defined on the same column, the data warehouse task fails with the following error:

[ERROR ] [] sqlstate '42000', errorcode '1003', message 'SQL compilation error:

syntax error line 404 at position 24 unexpected 'WHEN'.' java.sql.SQLException: sqlstate '42000', errorcode '1003', message 'SQL compilation error:

syntax error line 404 at position 24 unexpected 'WHEN'.'

Resolution

This issue was caused by defect RECOB-6917. 

Fix Version: 

• Qlik Compose 2023.11 SP10 and later releases

Contact Support to obtain the relevant fixes.

Cause

RECOB-6917

Environment

• Qlik Compose