Skip to main content
Click here if you are having trouble viewing this site
Older versions of Internet Explorer will not support certain site features. Chrome, Safari, Firefox, and Edge will provide the best experience.
Resources
Spok

Upgrading from Spok Mobile 3.5 to 4.6 - Device to Device Paging and Mobile Admin Page Setting Issues

  1. Last updated
  2. Save as PDF

Client was upgraded from 3.5 to 4.6 Spok Mobile version and started experiencing these issues:

  1. Admin portal was throwing error on clicking save button, as shown below
    Admin_Portal_Error.jpg
  2. Users were not able to send messages from device to device (it was asking for additional authentication to users)

After investigation, we came to know this is the data issue. While upgrading SME, data migration not happened properly because of some reason. So we added missing field ‘contact.service.api.url’ in Configuration_Info, using below query.

USE [AmcomAmcPremiseCore]
DECLARE @CONFIGURATION_ID_DEFAULT_DEVICE_CONFIG UNIQUEIDENTIFIER
IF NOT EXISTS (SELECT ID FROM [dbo].[CONFIGURATION] WHERE OBJECT_TYPE_ID = @OBJECT_TYPE_ID_DEVICE AND NAME = 'Default Device Config')
BEGIN
    SET @CONFIGURATION_ID_DEFAULT_DEVICE_CONFIG = NEWID()
END
ELSE
BEGIN
    SELECT @CONFIGURATION_ID_DEFAULT_DEVICE_CONFIG = ID FROM [dbo].[CONFIGURATION] WHERE OBJECT_TYPE_ID = @OBJECT_TYPE_ID_DEVICE AND NAME = 'Default Device Config'
END

IF NOT EXISTS (SELECT * FROM CONFIGURATION_INFO WHERE CONFIGURATION_ID = @CONFIGURATION_ID_DEFAULT_DEVICE_CONFIG AND NAME = N'contact.service.api.url')
BEGIN
    INSERT INTO CONFIGURATION_INFO (ID, CONFIGURATION_ID, NAME, VALUE, CREATED, UPDATED, SYSTEM_TYPE)
    VALUES (NEWID(), @CONFIGURATION_ID_DEFAULT_DEVICE_CONFIG, N'contact.service.api.url', '{Mobile.Scheme}://{Mobile.ServerName}/Amc/Contact/ContactAPI.svc', GETUTCDATE(), GETUTCDATE(), 'System.String')
END