Symptom:
When I attempt to run Check and Repair on my database from inside Act!, I receive the Error: “ActiveX control 8856F961-340a-11d0-a96b-00c04fd705a2 cannot be instantiated because the current thread is not a single threaded apartment”
Additionally, if I try to create a backup of my database, I receive the Error: "Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'... error 2601"
Product Details:
Product Family: Act!
Product: Act! Pro, Act! Premium
Version: v17
Cause:
This error is caused by a known issue that Microsoft published for Microsoft SQL Server that causes backup and checkpoint operations on Microsoft SQL Server databases to fail due to a duplicate database table row that gets inserted into the back end of the database. For more information, refer to the following knowledgebase article:
FIX: Backup operation fails in a SQL Server database after you enable change tracking
Solution:
When I attempt to run Check and Repair on my database from inside Act!, I receive the Error: “ActiveX control 8856F961-340a-11d0-a96b-00c04fd705a2 cannot be instantiated because the current thread is not a single threaded apartment”
Additionally, if I try to create a backup of my database, I receive the Error: "Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'... error 2601"
Product Details:
Product Family: Act!
Product: Act! Pro, Act! Premium
Version: v17
Cause:
This error is caused by a known issue that Microsoft published for Microsoft SQL Server that causes backup and checkpoint operations on Microsoft SQL Server databases to fail due to a duplicate database table row that gets inserted into the back end of the database. For more information, refer to the following knowledgebase article:
FIX: Backup operation fails in a SQL Server database after you enable change tracking
Solution:
- Follow the steps in the following article:
Error: "Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'... error 2601" when attempting to back up, copy, repair, create a remote, or synchronize an Act! database
Answer ID Error: "Cannot insert duplicate key row in object 'sys.syscommittab' with unique index 'si_xdes_id'... error 2601" when attempting to back up, copy, repair, create a remote, or synchronize an Act! database
- Attempt to run Check and Repair on your database again to test