Root deployment script fails for 2025.9

tvavrda · October 29, 2025, 4:09pm

There exist deployment scripts for Tracking User Actions and Data Exports.

These scripts fail on an application instance which does not share the same Language primary keys.

It fails in the following deployment script:

model-root/model/Root/DeploymentVersion/_origam_root/5.4.0.origam_commandText_84801f20-1134-4381-a2ad-751da9ae0916.txt

cccb2d1f8


      
          -- localization into cs-CZ
          INSERT INTO [OrigamEventType_l10n] ([Id], [refOrigamEventTypeId], [Name], [refLanguageId])
          VALUES
          ('2da15147-bd5f-4691-aec4-fa19829e6436', '3d91cd2c-1265-4022-8834-150de0237a3c', N'Přihlášení', '5477D278-BA2B-46EA-9BD3-509D4C699762'),
          ('da21f5b7-1978-4050-bc7e-73ce923de29a', 'b737ea8b-1cda-42d1-845a-c0c909386389', N'Odhlášení', '5477D278-BA2B-46EA-9BD3-509D4C699762'),
          ('74b04654-935b-4422-bb31-8eea37ee54d6', '4c14c1da-797b-4f0f-b6df-f787ca7e9647', N'Otevření obrazovky', '5477D278-BA2B-46EA-9BD3-509D4C699762'),
          ('4ac73bd3-3952-4729-bcb6-7e7972b5c204', '62f161e9-b817-4631-93e3-360551257dc2', N'Export do Excelu', '5477D278-BA2B-46EA-9BD3-509D4C699762');	
          
          -- localization into de-DE
          INSERT INTO [OrigamEventType_l10n] ([Id], [refOrigamEventTypeId], [Name], [refLanguageId])
          VALUES
          ('a13b496a-4ebc-437a-9afc-591d611efe79', '3d91cd2c-1265-4022-8834-150de0237a3c', N'Anmeldung', '8B92F824-289C-4F93-A245-ECB67B81DE1B'),
          ('c1c7305c-1202-4999-b08b-768cac2a30a1', 'b737ea8b-1cda-42d1-845a-c0c909386389', N'Abmeldung', '8B92F824-289C-4F93-A245-ECB67B81DE1B'),
          ('88fee706-bde6-4628-a88a-a9b05522acf0', '4c14c1da-797b-4f0f-b6df-f787ca7e9647', N'Bildschirmöffnung', '8B92F824-289C-4F93-A245-ECB67B81DE1B'),

The problem is that it references fixed lanuage Id but different instances might have their own primary keys. Therefore we normally make a dynamic select to the database based on IETF language code. It should also make sure that such a language even exists in that instance.

Like here:

github.com/origam/origam

model-root/model/Root/DeploymentVersion/_origam_root/5.3.origam_commandText_f92c7cc1-f0c9-41da-a148-3bd3f769b8ad.txt

cccb2d1f8


      
          			(select Id from language where TagIETF like '%de-CH%'))
          	INSERT INTO [dbo].[WorkQueueRetryType_l10n] ([refWorkQueueRetryTypeId],[Name],[RecordCreated],[Id],[refLanguageId])
          		VALUES ('57AD4C10-1F43-4CCF-A48A-132E7E418D53', 'Exponentielle Wiederholung', SYSDATETIME(), NEWID(), 
          			(select Id from language where TagIETF like '%de-CH%'))
          END
          
          IF EXISTS(select Id from language where TagIETF like '%cs-CZ%')
          BEGIN
          	INSERT INTO [dbo].[WorkQueueRetryType_l10n] ([refWorkQueueRetryTypeId],[Name],[RecordCreated],[Id],[refLanguageId])
          		VALUES ('69460BCF-81D4-4A97-94F7-5A391D16F771', 'Bez opakování', SYSDATETIME(), NEWID(), 
          			(select Id from language where TagIETF like '%cs-CZ%'))
          
          	INSERT INTO [dbo].[WorkQueueRetryType_l10n] ([refWorkQueueRetryTypeId],[Name],[RecordCreated],[Id],[refLanguageId])
          		VALUES ('8A5C793F-73B8-41EF-A459-618A8E6FE4FA', 'Lineární opakování', SYSDATETIME(), NEWID(), 
          			(select Id from language where TagIETF like '%cs-CZ%'))
          
          	INSERT INTO [dbo].[WorkQueueRetryType_l10n] ([refWorkQueueRetryTypeId],[Name],[RecordCreated],[Id],[refLanguageId])
          		VALUES ('57AD4C10-1F43-4CCF-A48A-132E7E418D53', 'Exponenciální opakování', SYSDATETIME(), NEWID(), 
          			(select Id from language where TagIETF like '%cs-CZ%'))
          END

The deployment scripts should be fixed so they do not depend on fixed primary keys.

zcapkova · October 30, 2025, 11:07am