Qlik Compose Failed to insert data to new column

[TranHuynh]

After I added a new column name sent_booking_datetime (Datetime) to Model, did the mapping, generate and run the DW, there's no data inserted to new column. Here's the error I found in log file: Failed at insertEtlRunInfo: null. Tried to run multiple times, result is still null. Even drop the column and recreate, same result.

Log file attached.

How can I fix this? Thanks.

[sureshkumar]

Hello @TranHuynh 

After adding the new column Did you run the Full Load job or CDC job?

What is the version of Qlik Compose?

Regards,

Suresh

[TranHuynh]

Hi @sureshkumar, DW runs CDC job, version 2022.5.0.1177.

[sureshkumar · Accepted solution]

Hello @TranHuynh 

When you run the CDC job for the newly added column, the Compose picks the current changes from the CT table, it will not pick the previous changes.

To pick the previous changes kindly run the Full Load Job.

Regards,

Suresh