Topic: Recorder6 6.25.1 upgrading error
I tried to upgrade Recorder6 network from 6.24.0 to 6.25.1 and I got an error massage: “Error occurred running script 000000A0.sql. The error is described as: There is already an object named 'LC_ASSOCIATE_FILTER' in the database.” It seems that Recorder 6 has been upgraded but not the database as it does not show version 000000AG. I also tried to upgrade a Recorder6 standalone version and I got the same error.
I ran the script using SQL Server Management Studio and I got the following massage:
"Msg 2714, Level 16, State 3, Procedure LC_ASSOCIATE_FILTER, Line 5
There is already an object named 'LC_ASSOCIATE_FILTER' in the database.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_USABLE_TABLE'. Cannot insert duplicate key in object 'dbo.USABLE_TABLE'. The duplicate key value is (SRA0000400000006).
The statement has been terminated.
Msg 2627, Level 14, State 1, Line 1
Violation of PRIMARY KEY constraint 'PK_USABLE_FIELD'. Cannot insert duplicate key in object 'dbo.USABLE_FIELD'. The duplicate key value is (SRA0000400000006).
The statement has been terminated."
Any advice would be appreciated.