Getting error "System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'IX_TEMP_LocalDomain_Domain' in the database." (4376175)
Getting error "System.Data.SqlClient.SqlException (0x80131904): There is already an object named 'IX_TEMP_LocalDomain_Domain' in the database."
説明
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."
対策
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