Return
-
Title
Getting error "System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'IX_TEMP_LocalDomain_Domain' in the database." -
Description
The Journal attributes in the Configuration Console show old dates for last JRDL retry and batch. No new messages can be found and the Dataloader log has "System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'IX_TEMP_LocalDomain_Domain' in the database." -
Resolution
Fix
1. Download the attached Stored Procedures scripts
2. Stop the Archive Manager Dataloader Service
3. Run both SQL scripts in the Archive Manager SQL Server, the order is not important
4. Start the Dataloader service and monitor the Dataloader log or the LastBatch for JRDL -
Attachments