1.34.5140

Release date | 2026-01-12

Always backup the Zervicepoint database before upgrading! If you experience an installation failure you must restore the database before continuing.

This is a superseded version of 5139 which is withdrawn from the site and is unavailable for download.

If you are upgrading from version 1.34.5090, 1.34.5091 you need to run this SQL query before upgrading

Upgrade From 1.34.5090, 1.34.5091

Please run the following sql against your ZervicePoint database before proceding with the upgrade if you are upgrading from version 1.34.5090 or 1.34.5091.

DECLARE @Version int = 5091;

IF (SELECT COUNT(*) FROM [AdminWeb].[SchemaVersion] WHERE Revision = 0) = 1
BEGIN
    UPDATE [AdminWeb].[SchemaVersion]
    SET
        Major       = 1,
        Minor       = 34,
        Revision    = @Version,
        Build       = 0,
        InstallDate = GETDATE()
    WHERE Revision = 0;
END

IF (SELECT COUNT(*) FROM [CatalogComponent].[SchemaVersion] WHERE Revision = 0) = 1
BEGIN
    UPDATE [CatalogComponent].[SchemaVersion]
    SET
        Major       = 1,
        Minor       = 34,
        Revision    = @Version,
        Build       = 0,
        InstallDate = GETDATE()
    WHERE Revision = 0;
END

IF (SELECT COUNT(*) FROM [ConfigurationSystem].[SchemaVersion] WHERE Revision = 0) = 1
BEGIN
    UPDATE [ConfigurationSystem].[SchemaVersion]
    SET
        Major       = 1,
        Minor       = 34,
        Revision    = @Version,
        Build       = 0,
        InstallDate = GETDATE()
    WHERE Revision = 0;
END

IF (SELECT COUNT(*) FROM [LocalizationComponent].[SchemaVersion] WHERE Revision = 0) = 1
BEGIN
    UPDATE [LocalizationComponent].[SchemaVersion]
    SET
        Major       = 1,
        Minor       = 34,
        Revision    = @Version,
        Build       = 0,
        InstallDate = GETDATE()
    WHERE Revision = 0;
END

IF (SELECT COUNT(*) FROM [MediaComponent].[SchemaVersion] WHERE Revision = 0) = 1
BEGIN
    UPDATE [MediaComponent].[SchemaVersion]
    SET
        Major       = 1,
        Minor       = 34,
        Revision    = @Version,
        Build       = 0,
        InstallDate = GETDATE()
    WHERE Revision = 0;
END

IF (SELECT COUNT(*) FROM [NotificationComponent].[SchemaVersion] WHERE Revision = 0) = 1
BEGIN
    UPDATE [NotificationComponent].[SchemaVersion]
    SET
        Major       = 1,
        Minor       = 34,
        Revision    = @Version,
        Build       = 0,
        InstallDate = GETDATE()
    WHERE Revision = 0;
END

IF (SELECT COUNT(*) FROM [OrderComponent].[SchemaVersion] WHERE Revision = 0) = 1
BEGIN
    UPDATE [OrderComponent].[SchemaVersion]
    SET
        Major       = 1,
        Minor       = 34,
        Revision    = @Version,
        Build       = 0,
        InstallDate = GETDATE()
    WHERE Revision = 0;
END

IF (SELECT COUNT(*) FROM [ProcessComponent].[SchemaVersion] WHERE Revision = 0) = 1
BEGIN
    UPDATE [ProcessComponent].[SchemaVersion]
    SET
        Major       = 1,
        Minor       = 34,
        Revision    = @Version,
        Build       = 0,
        InstallDate = GETDATE()
    WHERE Revision = 0;
END

IF (SELECT COUNT(*) FROM [ProcessSystem].[SchemaVersion] WHERE Revision = 0) = 1
BEGIN
    UPDATE [ProcessSystem].[SchemaVersion]
    SET
        Major       = 1,
        Minor       = 34,
        Revision    = @Version,
        Build       = 0,
        InstallDate = GETDATE()
    WHERE Revision = 0;
END

IF (SELECT COUNT(*) FROM [ReportingComponent].[SchemaVersion] WHERE Revision = 0) = 1
BEGIN
    UPDATE [ReportingComponent].[SchemaVersion]
    SET
        Major       = 1,
        Minor       = 34,
        Revision    = @Version,
        Build       = 0,
        InstallDate = GETDATE()
    WHERE Revision = 0;
END

IF (SELECT COUNT(*) FROM [SecuritySystem].[SchemaVersion] WHERE Revision = 0) = 1
BEGIN
    UPDATE [SecuritySystem].[SchemaVersion]
    SET
        Major       = 1,
        Minor       = 34,
        Revision    = @Version,
        Build       = 0,
        InstallDate = GETDATE()
    WHERE Revision = 0;
END

IF (SELECT COUNT(*) FROM [TaskComponent].[SchemaVersion] WHERE Revision = 0) = 1
BEGIN
    UPDATE [TaskComponent].[SchemaVersion]
    SET
        Major       = 1,
        Minor       = 34,
        Revision    = @Version,
        Build       = 0,
        InstallDate = GETDATE()
    WHERE Revision = 0;
END

IF (SELECT COUNT(*) FROM [UserWeb].[SchemaVersion] WHERE Revision = 0) = 1
BEGIN
    UPDATE [UserWeb].[SchemaVersion]
    SET
        Major       = 1,
        Minor       = 34,
        Revision    = @Version,
        Build       = 0,
        InstallDate = GETDATE()
    WHERE Revision = 0;
END

Solved issues

Cannot access a service using a shared process in draft mode

Fixed an issue that prevented you from accessing services using a shared process that is in draft mode.

Order events does not show up for services with access groups

Fixed an issue where order events in some cases did not show up correctly if the related service had access groups.