We are On Prem and currently running 2024.1.8. I have spun up a new Application Server to test 2024.1.20 but only have a single DB server.
In order to test an upgrade to this version I have to update the common database but before I do that I am wondering if anyone here has a similar scenario, multiple versions, mostly for testing purposes within the same major release but with a single DB server and is there any issue with updating the common db to .20 while still running .8 in production?
I have two versions on 2024.1 on a machine .18 and .6 Both seem to be running and both using the common db. here is an example of the [ICECommon_4_3_100].[Ice].[ICECommonVer]
SystemCode SystemVersion DBSchemaVersion SystemDate DBSchemaDate SysRevID SysRowID
ERP 11.3.100.0 11.3.100.0 51:02.6 51:02.6 0x00000000000007D1 F4E5C625-500F-4F4D-AB11-B0DD01579BF5
ERP 11.3.100.1 11.3.100.1 42:57.0 42:57.0 0x00000000000036B3 D2C1FAFB-E0AF-46EA-811F-B18F003D3C47
ERP 11.3.100.10 11.3.100.10 19:25.0 19:25.0 0x00000000000065A5 A8560557-805C-474D-B006-B2600036C5AB
ERP 11.3.100.11 11.3.100.11 19:25.0 19:25.0 0x00000000000065A7 44676094-C8D3-4F73-8549-B2600036C5AF
ERP 11.3.100.12 11.3.100.12 19:25.0 19:25.0 0x00000000000065A9 2F5B10BB-C740-4DC4-B7B2-B2600036C5B3
ERP 11.3.100.13 11.3.100.13 19:25.0 19:25.0 0x00000000000065AB F6B990D1-D992-4273-98B9-B2600036C5B7
ERP 11.3.100.14 11.3.100.14 19:25.0 19:25.0 0x00000000000065AD EE3F473C-546A-48AC-8F35-B2600036C5BC
ERP 11.3.100.15 11.3.100.15 19:25.0 19:25.0 0x00000000000065AF 9787F894-1590-47ED-A077-B2600036C5C0
ERP 11.3.100.16 11.3.100.16 19:27.0 19:27.0 0x0000000000006785 B6DAB074-A408-46B7-B39B-B2600036C813
ERP 11.3.100.17 11.3.100.17 19:27.0 19:27.0 0x0000000000006787 AFBF3745-9EC1-45CA-92BF-B2600036C816
ERP 11.3.100.18 11.3.100.18 19:27.0 19:27.0 0x0000000000006789 D2AD5B5A-1BBA-441A-B23D-B2600036C81B
ERP 11.3.100.2 11.3.100.2 42:57.0 42:57.0 0x00000000000036B6 FFBA324F-F91F-411D-95BD-B18F003D3C51
ERP 11.3.100.3 11.3.100.3 42:57.0 42:57.0 0x00000000000036C7 36BE3007-0F68-4159-8B83-B18F003D3C67
ERP 11.3.100.4 11.3.100.4 42:57.0 42:57.0 0x00000000000036C9 8CD73B6B-8B60-4508-B39C-B18F003D3C6C
ERP 11.3.100.5 11.3.100.5 42:57.0 42:57.0 0x00000000000036CB DDDF7541-E65B-4BEE-9494-B18F003D3C71
ERP 11.3.100.6 11.3.100.6 42:57.0 42:57.0 0x00000000000036CD E81C3290-F3FF-438C-8E46-B18F003D3C75
ERP 11.3.100.7 11.3.100.7 19:27.0 19:27.0 0x000000000000678B 3291A542-FAA4-44F0-A384-B2600036C81F
ERP 11.3.100.8 11.3.100.8 19:27.0 19:27.0 0x000000000000678D DC9DE7A7-D52C-4AEE-81A3-B2600036C822
ERP 11.3.100.9 11.3.100.9 19:27.0 19:27.0 0x00000000000067AA 14C4450F-8F86-48CD-9FD2-B2600036C84C
ICE 4.3.100.0 4.3.100.0 51:02.6 51:02.6 0x00000000000007D2 A5F80570-223F-43F2-A416-B0DD01579BF5
ICE 4.3.100.1 4.3.100.1 42:57.0 42:57.0 0x00000000000036B2 1B268B76-502D-4DD8-BE32-B18F003D3C46
ICE 4.3.100.10 4.3.100.10 19:25.0 19:25.0 0x00000000000065A4 66B97A2F-717D-4292-A87F-B2600036C5A9
ICE 4.3.100.11 4.3.100.11 19:25.0 19:25.0 0x00000000000065A6 FDE34B0C-E82B-46CC-B5B0-B2600036C5AD
ICE 4.3.100.12 4.3.100.12 19:25.0 19:25.0 0x00000000000065A8 32023CE0-AECA-416B-B06E-B2600036C5B1
ICE 4.3.100.13 4.3.100.13 19:25.0 19:25.0 0x00000000000065AA 83B2F605-00F1-4A29-999D-B2600036C5B5
ICE 4.3.100.14 4.3.100.14 19:25.0 19:25.0 0x00000000000065AC 6EBADC69-9430-4354-ACD6-B2600036C5B9
ICE 4.3.100.15 4.3.100.15 19:25.0 19:25.0 0x00000000000065AE 71CE22CB-5FB6-4C3B-A3A7-B2600036C5BE
ICE 4.3.100.16 4.3.100.16 19:27.0 19:27.0 0x0000000000006784 22C802E5-4F68-4E92-AD8C-B2600036C810
ICE 4.3.100.17 4.3.100.17 19:27.0 19:27.0 0x0000000000006786 868077E4-29F1-44A3-BC7D-B2600036C815
ICE 4.3.100.18 4.3.100.18 19:27.0 19:27.0 0x0000000000006788 98463565-6C6D-4955-825C-B2600036C819
ICE 4.3.100.2 4.3.100.2 42:57.0 42:57.0 0x00000000000036B5 AB683A74-BEA7-4341-9551-B18F003D3C4F
ICE 4.3.100.3 4.3.100.3 42:57.0 42:57.0 0x00000000000036C6 4997B5B7-EA8A-4528-9DB0-B18F003D3C64
ICE 4.3.100.4 4.3.100.4 42:57.0 42:57.0 0x00000000000036C8 8487731D-C656-46D2-BAC8-B18F003D3C6A
ICE 4.3.100.5 4.3.100.5 42:57.0 42:57.0 0x00000000000036CA F4F0C221-5B04-43D4-8C7A-B18F003D3C6F
ICE 4.3.100.6 4.3.100.6 42:57.0 42:57.0 0x00000000000036CC 144A9436-85E3-452B-860E-B18F003D3C73
ICE 4.3.100.7 4.3.100.7 19:27.0 19:27.0 0x000000000000678A CD1404E9-17A5-41FD-A3C9-B2600036C81C
ICE 4.3.100.8 4.3.100.8 19:27.0 19:27.0 0x000000000000678C 0EF41582-297E-454E-A184-B2600036C821
ICE 4.3.100.9 4.3.100.9 19:27.0 19:27.0 0x00000000000067A9 11FF1DA4-C893-4C5D-AEB6-B2600036C84A
EDIT
Yikes! wait out on that. The app servers might be running but I just got an error when trying to login.
EDIT Again:
I just checked the configuration of both the app servers, appears they are pointing to the same kinetic DB that was upgrade to .18. I’ll generate another demo db for .6 and let you know how it goes. I suspect it will work.
Edit Again ++:
After installing a new demo db and running it against the .6 version app server of 2024.1.6 when I logged for the first time it asked to upgrade the database from .0 to .6 and then went into running Conversion Workbench. It appears the ice.common db was not effected, and I can run both instances side by side on the same machine and it works. So to answer your question YES you can run two different minor releases of the applicaiton on the same machine and database server instance.
Thank you for testing with this.
Support confirmed that doing this should not have any impact so I will be testing it here this weekend so I can roll back if everything breaks.
I was an interesting exercise.