Upgrade from 4.1 to 5

[phayman]

I've attempted to upgrade from our 4.1 server to 5.

 

Following the install, both version 4 and 5 services are listed in Windows Services.

 

I installed v5 client locally and changed the client configuration from port 8087 to port 8084 but when Plastic client starts, it complains with the following message

 

---------------------------

Error

---------------------------

There has been an unexpected error "Invalid column name 'iguidhigh'.

 

Invalid column name 'iguidlow'.". For more information check the server log. Plastic client can't continue and will be closed.

---------------------------

OK   

---------------------------

 

I ran up another 4.1 server with a local MS SQL Database, Populated it with a repository then upgraded it and it worked.

 

I'm thinking that the production server (which has a remote MS SQL Server database) failed to migrate the DB.

 

I've stopped the Plastic 5 service and started the Plastic 4 service, re-installed the v4 client locally and luckily it still works.

 

 

Has anyone else had migration / upgrade problems?

[calbzam]

Hi,

 

Could you tell me the Plastic versions (4.1 and 5.0) you installed and the backend you were using to reproduce the issue?  The migration should be automatic when installing Plastic 5 server.

 

Did you review if Plastic 5 client and server were properly configured? 

 

Regards,

Carlos

[phayman]

5  -   v5.0.43.495

4  -   v4.1.10.268

 

 

Database is SQL Server

[phayman]

Any luck reproducing?

[abhiravk]

Hi,

 

I am also facing a similar problem after upgradation to v5.

 

I had a working setup with v4.1 and MySql as database backend.

Installing v5 version didnot produce any error but for some reason it is not able to query the repositories. It doesn't list any of the old repositories.

 

This the log that I get whenever I restart the v5 server;

 

2013-11-14 16:00:05,845 (null) NT AUTHORITY\SYSTEM at (null) INFO  Channel - ThreadPool MaxThreads = 32
2013-11-14 16:00:05,845 (null) NT AUTHORITY\SYSTEM at (null) INFO  Channel - ThreadPool MinThreads = 8
2013-11-14 16:00:05,869 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TOTO-PC INFO  Operations - Check connection
2013-11-14 16:00:05,926  NT AUTHORITY\SYSTEM at  INFO  ChannelCall - recb:   552|rect:  0|sentb:   287|sendt:  0|prt:      62|th:    5|dest:   0|mt:      62|sert:   0|zip:   0|       127.0.0.1|CheckConnection
2013-11-14 16:00:05,929 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TOTO-PC INFO  Operations - Check connection
2013-11-14 16:00:05,929  NT AUTHORITY\SYSTEM at  INFO  ChannelCall - recb:   552|rect:  0|sentb:   287|sendt:  0|prt:       0|th:    5|dest:   0|mt:       0|sert:   0|zip:   0|       127.0.0.1|CheckConnection
2013-11-14 16:00:05,931 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TOTO-PC INFO  Operations - Get repository info op9500
2013-11-14 16:00:05,960 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TOTO-PC INFO  Security - AllAclReader reading all acls for repository 14. 0 ms
2013-11-14 16:00:05,963 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TOTO-PC ERROR CmCommand - Error ExecuteReader. SQL [sELECT fidacl, fidseid, igranted, idenied, ioverridegranted, ioverridedenied FROM aclentry]
2013-11-14 16:00:05,964 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TOTO-PC ERROR CmCommand - Exception: Unknown column 'ioverridegranted' in 'field list'    at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at Codice.CM.Data.CmCommand.ExecuteReader()
2013-11-14 16:00:05,964 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TOTO-PC ERROR DataConnection - Error in ExecuteReader. Query SELECT fidacl, fidseid, igranted, idenied, ioverridegranted, ioverridedenied FROM aclentry
Unknown column 'ioverridegranted' in 'field list'
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at Codice.CM.Data.CmCommand.ExecuteReader()
   at Codice.CM.Data.CmDataReader..ctor(CmConnection A_0, CmCommand A_1, DataConnection A_2)
   at Codice.CM.Data.DataConnection.ExecuteReader(CmConnection conn, CmCommand command)

2013-11-14 16:00:05,965 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TOTO-PC ERROR Operations - Plastic server version: 5.0.43.504

2013-11-14 16:00:05,965 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TOTO-PC ERROR Operations - OnError catching exception Unknown column 'ioverridegranted' in 'field list'

2013-11-14 16:00:05,971  NT AUTHORITY\SYSTEM at  ERROR Codice.CM.Server.ExceptionTracerSink - Dumping in-transit exception:There has been an unexpected error "Unknown column 'ioverridegranted' in 'field list'". For more information check the server log.

2013-11-14 16:00:05,971  NT AUTHORITY\SYSTEM at  INFO  ChannelCall - recb:   748|rect:  0|sentb:  1422|sendt:  0|prt:      31|th:    5|dest:   0|mt:      31|sert:   0|zip:   0|       127.0.0.1|GetRepositoryInfo
2013-11-14 16:00:38,809 (null) NT AUTHORITY\SYSTEM at (null) INFO  Channel - Tcp transport error. ReceiveMessageStatus Connection closed
2013-11-14 16:00:38,811 (null) NT AUTHORITY\SYSTEM at (null) INFO  Channel - conn        0 Tcp transport error. Connection closed
2013-11-14 16:01:15,837 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TOTO-PC INFO  Operations - Check connection
2013-11-14 16:01:15,837  NT AUTHORITY\SYSTEM at  INFO  ChannelCall - recb:   552|rect:  0|sentb:   287|sendt:  0|prt:       0|th:    5|dest:   0|mt:       0|sert:   0|zip:   0|       127.0.0.1|CheckConnection
2013-11-14 16:01:15,838 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TOTO-PC INFO  Operations - Check connection
2013-11-14 16:01:15,839  NT AUTHORITY\SYSTEM at  INFO  ChannelCall - recb:   552|rect:  0|sentb:   287|sendt:  0|prt:       0|th:    5|dest:   0|mt:       0|sert:   0|zip:   0|       127.0.0.1|CheckConnection
2013-11-14 16:01:15,840 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TOTO-PC INFO  Operations - Get repository info op9500
2013-11-14 16:01:15,841 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TOTO-PC INFO  Security - AllAclReader reading all acls for repository 14. 0 ms
2013-11-14 16:01:15,841 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TOTO-PC ERROR CmCommand - Error ExecuteReader. SQL [sELECT fidacl, fidseid, igranted, idenied, ioverridegranted, ioverridedenied FROM aclentry]
2013-11-14 16:01:15,841 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TOTO-PC ERROR CmCommand - Exception: Unknown column 'ioverridegranted' in 'field list'    at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at Codice.CM.Data.CmCommand.ExecuteReader()
2013-11-14 16:01:15,841 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TOTO-PC ERROR DataConnection - Error in ExecuteReader. Query SELECT fidacl, fidseid, igranted, idenied, ioverridegranted, ioverridedenied FROM aclentry
Unknown column 'ioverridegranted' in 'field list'
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader()
   at Codice.CM.Data.CmCommand.ExecuteReader()
   at Codice.CM.Data.CmDataReader..ctor(CmConnection A_0, CmCommand A_1, DataConnection A_2)
   at Codice.CM.Data.DataConnection.ExecuteReader(CmConnection conn, CmCommand command)

2013-11-14 16:01:15,841 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TOTO-PC ERROR Operations - Plastic server version: 5.0.43.504

2013-11-14 16:01:15,841 00000000-0000-0000-0000-000000000000 NT AUTHORITY\SYSTEM at TOTO-PC ERROR Operations - OnError catching exception Unknown column 'ioverridegranted' in 'field list'

2013-11-14 16:01:15,842  NT AUTHORITY\SYSTEM at  ERROR Codice.CM.Server.ExceptionTracerSink - Dumping in-transit exception:There has been an unexpected error "Unknown column 'ioverridegranted' in 'field list'". For more information check the server log.

2013-11-14 16:01:15,842  NT AUTHORITY\SYSTEM at  INFO  ChannelCall - recb:   748|rect:  0|sentb:  1422|sendt:  0|prt:       0|th:    5|dest:   0|mt:       0|sert:   0|zip:   0|       127.0.0.1|GetRepositoryInfo
2013-11-14 16:01:40,376 (null) NT AUTHORITY\SYSTEM at (null) INFO  Channel - 'BufferPoolMax' is set to '10'. It sets the maximum number of available buffers for object data transfers
2013-11-14 16:01:40,399 (null) NT AUTHORITY\SYSTEM at (null) INFO  Channel - 'SerializationObjectsAtSink' is set to 'True'. True means SerializationBase descendants are  directly written into the response buffer
2013-11-14 16:01:40,400 (null) NT AUTHORITY\SYSTEM at (null) INFO  Channel - 'sinklevel' compression mode set. all metadata will be serialized
2013-11-14 16:01:40,413 (null) NT AUTHORITY\SYSTEM at (null) INFO  Channel - Start listening
2013-11-14 16:01:40,414 (null) NT AUTHORITY\SYSTEM at (null) INFO  Channel - 'BufferPoolMax' is set to '10'. It sets the maximum number of available buffers for object data transfers
2013-11-14 16:01:40,414 (null) NT AUTHORITY\SYSTEM at (null) INFO  Channel - 'SerializationObjectsAtSink' is set to 'True'. True means SerializationBase descendants are  directly written into the response buffer
2013-11-14 16:01:40,414 (null) NT AUTHORITY\SYSTEM at (null) INFO  Channel - 'sinklevel' compression mode set. all metadata will be serialized
2013-11-14 16:01:40,418 (null) NT AUTHORITY\SYSTEM at (null) INFO  Channel - Using certificate file ssl-certificate.pfx
2013-11-14 16:01:40,441 (null) NT AUTHORITY\SYSTEM at (null) INFO  Channel - Start listening
2013-11-14 16:01:40,596 74a185e9-ebb7-4fe8-b4e1-01ee02d646dd NT AUTHORITY\SYSTEM at Server:TOTO-PC INFO  Transaction - Transaction timeout -> 120000ms
 

[manu]

Sorry, no luck reproducing the issue.

 

We are open to schedule an online meeting for both of you to review if there's something wrong.

[phayman]

Yes please, I'd really like to upgrade my server.

[manu]

Got the email. We'll be in touch soon.

[calbzam]

Hi,

 

​Could you check if you have configured prefix/suffix on your db.conf file (server folder)??

 

We had a similar issue before: http://www.plasticscm.net/index.php?/topic/1827-upgrading-blew-away-my-repository-list/?hl=database#entry10075 

 

Thank you!

 

Regards,

Carlos

[phayman]

ok .. I got round this problem.

 

The situation

• My Plastic upgrade from 4 to 5 failed, it left two copies of PlasticSCM on the Plastic server, v4 and v5.
• Both services were listed in Windows Service and the database was still version 4.
• Starting the client threw this error : "Invalid column name 'iguidhigh'.

Background

• My Plastic server is on a separate server to MS SQL Server.
• My Plastic server had previously been a Plastic 3 server.
• Program Files\PlasticSCM and Program Files\PlasticSCM4 both existed.

The solution

• I installed Plastic SCM 4 on the SQL Server
• I upgraded to Plastic SCM 5 on the SQL Server
• I uninstalled Plastic SCM 4 from the Plastic Server, backed up the config files and cleaned up the folders.
• I removed any PlasticSCM and Codice entries from the registry on the Plastic Server.
• I installed Plastic 5 on the Plastic Server.
• My team then installed Plastic 5 and it worked.

Summary

I believe the problem was either to do with permissions (separate server for SQL) .. or the installer had problems due to Plastic 3 being on the server at some point. I noticed that Plastic now uses Program Files/PlasticSCM rather than Program Files/PlasticSCM5.. perhaps some of the remaining files from Plastic SCM 3 caused problems.

[manu]

Hello Paul,

 

thanks for returning with the solution!

 

I might be an installer issue due to the Plastic 3 installation as you said. Anyway, happy to hear you are not in Plastic 5

[pseabury]

Which versions of 4.1 are upgradable to which versions of 5.0?

 

For instance, is 4.1.10.493 directly upgradeable to 5.0.44.509?  On both the client and the server side?

 

Thanks,

 

Paul

[manu]

Hi Paul,

 

all the 4 releases can directly upgrade to 5, and you need to upgrade both clients and server.

[pseabury]

Many thanks - we will give it a try.

[manu]

If you have any question ask back.