Bug with 2023.2.26 - Data Model Regen - Ice.ICEVer table incorrect entries

Hi

FYI in case anybody else runs into this one. I took a 2023.2 pilot environment to the latest update 2023.2.27 and it all seemed fine until I tried to a data model regeneration. It failed with this error:

Generator version: 4.2.400.0
Server version: 4.2.xxx.x
Error Generating the Data Models: The generator and server versions don’t match. Generator = 4.2.400; Server = 4.2.xxx.

I removed the database from Admin Console and tried to re-add it back in, then got another message:

System.FormatException: Input string was not in a correct format.

I checked the Ice.ICEVer table and found the following:

You’ll notice that where 4.2.400.26 should be instead just had 4.2.xxx.x and the same for 11.2.xxx.x. As it was just a pilot environment I fixed these 2 references up using sql and then was able to add the database back in and perform data model regen successfully. Case raised with support. I guess it will affect anybody applying .26 or .27 update, and potentially the next one if the script fix doesn’t make the cut for .28.

Not sure how this one got past QA testing - doing a data model regen is something that should get tested…!

3 Likes

Thanks for the heads up Mark!