INSERT BULK recompile

[SkippyTheMagnificent]

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?

[john_wang · Accepted solution]

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.

[lyka]

Hello,

Please try to disable BCP.

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

Save then Reload

Thanks

Lyka

[SkippyTheMagnificent]

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.