Qlik Replicate: Issue when adding multiple tables to the Logstream task using SQL server as a source.

[SwathiPulagam]

When attempting to add multiple tables to the Logstream Task using the SQL server as the source, the task fails with an error message. However, if adding tables one at a time, the task runs without any issues. The error message received is as follows:

00009352: 2023-02-03T16:27:32 [SOURCE_CAPTURE ]E: Failure in executing add article through batch [1022505] (sqlserver_log_utils.c:2260)

00009352: 2023-02-03T16:28:32 [SOURCE_CAPTURE ]E: Failed (retcode -1) to execute statement: 'select OBJECTPROPERTY(id,'TableHasPrimaryKey') from sysobjects where id = ?' [1022502] (ar_odbc_stmt.c:2799)

00009352: 2023-02-03T16:28:32 [SOURCE_CAPTURE ]E: RetCode: SQL_ERROR SqlState: HYT00 NativeError: 0 Message: [Microsoft][ODBC Driver 17 for SQL Server]Query timeout expired [1022502] (ar_odbc_stmt.c:2805)

Resolution:

The issue is caused by the SQL server LDF file growth, which becomes too large and causes the task to get stuck. Shrinking the LDF file will resolve the issue and allow for the addition of multiple tables to the Logstream Task.

Environment

Qlik Replicate 
SQL Sever Source