topic Re: Qlik Compose DW DB Transaction Log in Qlik Compose

Qlik Compose DW DB Transaction Log

Al_gar — Fri, 14 Mar 2025 20:49:07 GMT

Our DW target db (MS SQL Server) transaction log is getting full pretty quickly causing some tasks to fails. Recovery mode is set to Simple and transaction log is currently at 25 GB. Is there any option in Qlik Compose to for the transactions to have batches with commits? Trying not to keep increasing the transaction log file size.

Re: Qlik Compose DW DB Transaction Log

Nanda_Ravindra — Thu, 19 Jan 2023 21:46:56 GMT

@Al_gar We don't have an option in Compose for the transactions to have batches with commits. We have a few best practices to control the transaction logs.

1. Make sure you have a good policy of either cleaning up the logs

2. In compose, under 'Data Warehouse' settings you can reduce the 'Maximum number of database connections. Not sure if this value was increased in the past to get the task to run fast. Our default value is 10

3. You can split your tasks into smaller groups of tables and run them separately in workflow and make sure all tables load

Hope this helps!

Thanks,

Nanda

Re: Qlik Compose DW DB Transaction Log

Nanda_Ravindra — Tue, 28 Mar 2023 15:26:57 GMT

Suggested the follwoing:

1. Make sure you have a good policy of either cleaning up the logs

3. You can split your tasks into smaller groups of tables and run them separately in workflow and make sure all tables load