The repository X wasn't upgraded correctly, it can't be used until the problem is solved.

[zz74b]

Hi

 

Just upgraded from 4.1.10.440 to 5.0.44.519. Upgrade went fine, and also as part of the upgrade moved from the Firebird DB Back end to SQL Server.

 

Now, when I try to commit anything to existing repositories (new ones work fine), I get an error on the client "The repository X wasn't upgraded correctly, it can't be used until the problem is solved." where X is the repository number. There are quite a few repositories where this has happened.

 

The Plastic SCM client shows the files I would expect as being part of the repositories, and also the repositories are listed correctly...

 

In the server logs I get:

 

2014-01-15 00:18:35,316 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at MachineName INFO  Operations - Get info for branch 3 at repository ID 34

2014-01-15 00:18:35,318 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at MachineName ERROR Operations - Plastic server version: 5.0.44.519

 

2014-01-15 00:18:35,321 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at MachineName ERROR Operations - OnError catching exception The repository 34 wasn't upgraded correctly, it can't be used until the problem is solved.

 

2014-01-15 00:18:35,324  NT AUTHORITY\SYSTEM at  ERROR Codice.CM.Server.ExceptionTracerSink - Dumping in-transit exception:The repository 34 wasn't upgraded correctly, it can't be used until the problem is solved.

 

2014-01-15 00:18:35,327  NT AUTHORITY\SYSTEM at  INFO  ChannelCall - recb:   749|rect:  0|sentb:  1668|sendt:  0|prt:      15|th:   15|dest:   0|mt:      15|sert:   0|zip:   0|    <MachineIP>|GetBranchInfo

2014-01-15 00:19:06,909 (null) NT AUTHORITY\SYSTEM at (null) INFO  Channel - Tcp transport error. ReceiveMessageStatus Connection closed

2014-01-15 00:19:06,912 (null) NT AUTHORITY\SYSTEM at (null) INFO  Channel - conn        9 Tcp transport error. Connection closed

 

In the Upgrade Log I get:

 

014-01-15 00:07:24,959 3720 EVERY_USER_OR_GROUP c33cb2e1-6893-4e58-865b-85b5102dba3c Server:SERVER INFO  DatabaseUpgrade - Upgrading Repository 34 from version 53 to version 54. Adding ioverridegranted and ioverridedenied fields in aclentry table.

2014-01-15 00:07:24,968 3720 EVERY_USER_OR_GROUP c33cb2e1-6893-4e58-865b-85b5102dba3c Server:SERVER ERROR DatabaseUpgrade - Error upgrading repository 34 from version 53 to version 54.

2014-01-15 00:07:24,975 3720    ERROR DatabaseUpgrade - There was a problem trying to upgrade repository 34. Column names in each table must be unique. Column name 'ioverridegranted' in table 'aclentry' is specified more than once.    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

   at Codice.CM.Data.CmCommand.DoExecuteNonQuery()

   at Codice.CM.Data.CmCommand.ExecuteNonQuery()

   at Codice.CM.Data.DataConnection.a(CmConnection A_0, CmCommand A_1)

   at Codice.CM.Data.DataConnection.ExecuteNonQuery(CmConnection cmconn, String commandText)

   at oh.a(Int64 A_0, String A_1, a A_2)

   at nt.a(Int64 A_0)

   at mz.f.a()

   at Codice.CM.Server.TransactionManager.ExecuteServerTransactedCall(DoServerTransactedCallDelegate call)

   at mz.c(Int64 A_0)

   at mz.b()

 

Any Ideas?

 

Kind regards

 

zz74b

 

[manu]

Hi, sorry for the delay.

 

can you please post us the sql "define" operation for the "aclentry" table?

And:

 

"select * from databaseinfo"

 

​Make sure you are using the repository with the ID #34