Qlik Community

Qlik Replicate

Discussion board for collaboration on Qlik Replicate.

Announcements
Qlik Insider: SaaS capabilities for Data Integration and Analytics, May 25th! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
SkippyTheMagnificent
Contributor II
Contributor II

INSERT BULK recompile

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?

Labels (2)
1 Solution

Accepted Solutions
john_wang
Support
Support

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.

 

View solution in original post

3 Replies
john_wang
Support
Support

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
Support
Support

Hello,

Please try to disable BCP.

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

Save then Reload

Thanks

Lyka

SkippyTheMagnificent
Contributor II
Contributor II
Author

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.