1

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.

2

Re: Recorder6 6.25.1 upgrading error

Attched is a revised version of script 000000A0 which is the one causing the problem. When you unzip the upgrade  files you should have a scripts folder. In this will be 000000A0.sql Replace this with attached file and run the upgrade again.

Post's attachments

000000A0.sql 95 b, 2 downloads since 2016-10-24 

You don't have the permssions to download the attachments of this post.
Mike Weideli

3

Re: Recorder6 6.25.1 upgrading error

Looks like everything is working fine now. Many Thanks!