SQL evacuation failure with double entries in archive file

SQL evacuation failure with double entries in archive file

Summary

The SQL evacuation stops if in the archive file are two identical values. Identical means same NameID same Value same Timestamp same Status. These entries could happen if in the archive configuration the option 'save process image during start OR end' is activated.





Description

The SQL evacuation stops if in the archive file are two identical values. Identical means same NameID same Value same Timestamp same Status. These entries could happen if in the archive configuration the option 'save process image during start OR end' is activated.





Solution

If an integrity violation occours (Error 0x80040E2F) the record is skipped and not stored in SQL a second time and a log message is created.


Information

The fix is tested for SQL Server provider. If an ODBC provider is used you may end up with the same problem before the fix. The error message in that case would be: "Execute INSERT statement failed 1, hr=80004005"

To solve this error, change the provider to SQL Server provider.




Issue Number: 31820
Fixed on Date: 9.7.2014
Versions: 7.00 0 BUILD 20 | 7.20 0 BUILD 17768