topic Re: INSERT BULK recompile in Qlik Replicate

INSERT BULK recompile

SkippyTheMagnificent — Wed, 20 Oct 2021 01:55:49 GMT

Got the following error tonight:

Failed to commit 10000 rows to target 'schema.table'
RetCode: SQL_SUCCESS SqlState: 42000 NativeError: 13800 Message: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]INSERT BULK statement does not support recompile.

This is from an Oracle 19c system to a SQL Server 2019 system using qlik replicate build 2021.5.0.863.

Thoughts anyone?

Re: INSERT BULK recompile

john_wang — Sun, 24 Oct 2021 12:12:49 GMT

Hello @SkippyTheMagnificent ,

This is a very rare error. We even cannot find helpful information from Microsoft Docs.

The only instance in our record is that, while Replicate performing the Full Load from Source DB to SQL Server target DB, the SQL Server daily task of rebuilding the indexes started too and it causing the error. Please check if it meet your scenario.

Hope this helps.

Regards,

John.

Re: INSERT BULK recompile

lyka — Tue, 26 Oct 2021 18:31:21 GMT

Hello,

Please try to disable BCP.

On your target endpoint, disable Use BCP for loading tables.

Save then Reload

Thanks

Lyka

Re: INSERT BULK recompile

SkippyTheMagnificent — Fri, 29 Oct 2021 19:23:01 GMT

In reviewing the logs, they error did present during nightly index rebuilds. After disabling indexes during FULL Load we no longer received the error and have successfully loaded the data.

Appreciate the assistance.