topic Re: Failed to execute bulk insert statement. in Qlik Replicate

Failed to execute bulk insert statement.

AgusBudianto — Mon, 23 Dec 2024 04:12:03 GMT

We are having an issue where we are seeing the log notification showing Failed to execute bulk insert statement, and this is happening several times, we are using Log Stream Task for Source and Azure SQL Server for target.

Re: Failed to execute bulk insert statement.

john_wang — Mon, 23 Dec 2024 06:56:05 GMT

Hello @AgusBudianto ,

Welcome to Qlik Community forum and thanks for reaching out here!

The error message is in encrypted format we cannot read it. I'd like suggest you open a supported, set TARGET_APPLY to Verbose, recreate the issue then upload the Diagnostic Packages, and decrypt the task log file prior to upload it to support ticket as well,Our support team will be more than happy to assist you.

Hope this helps.

John.

Re: Failed to execute bulk insert statement.

AgusBudianto — Mon, 23 Dec 2024 07:24:00 GMT

seems like there is a time out on the target, I am using Log Stream Task as source and Azure SQL Server as target.

is this link the way to solve it? or do you have any other thoughts

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-Query-timeout-expired/ta-p/1779090

Re: Failed to execute bulk insert statement.

john_wang — Mon, 23 Dec 2024 07:39:59 GMT

Hello @AgusBudianto ,

Thanks for the detailed information - yes, please go ahead with the solutions, it's a good start. Feel free to let me know if it works for you.

Good luck,

John.