Skip to main content

psaCollate Incompatible with SST 7.4.5+

Jenny Drummey
  • Updated

This article applies to the Stewardship Tier 7.4.5 and later.

psaCollate is a Syniti professional services accelerator that improves the handling of case-sensitive data within Advanced Data Migration (ADM). In the 7.4.5 release of the Stewardship Tier, the functionality included with psaCollate was incorporated into the core product. Therefore, BEFORE upgrading to 7.4.5 or above, psaCollate must be uninstalled. 

To uninstall psaCollate: 

Deactivate psaCollate

  1. Navigate to psaCollate.
  2. Select Collate Activate in the Navigation pane.
  3. Click the Deactivate button shown in the screenshot below.
    NOTE: This will revert changes that were made to support case sensitivity.

    psaCollate.jpg

Remove psaCollate WebApp from Stewardship Tier Instance

  1. Execute the following SQL script (on the Stewardship Tier SQL Instance) to remove the psaCollate WebApp from the Stewardship Tier instance.
  USE [master]

  GO

  UPDATE CranSoft.dbo.WebApp SET HOMEPAGEID = NULL WHERE WebAppID = N'cdc6e442-2e10-4048-b971-cc58ea33119c'

  DELETE FROM CranSoft.dbo.Menu WHERE WebAppID = N'cdc6e442-2e10-4048-b971-cc58ea33119c'

  DELETE FROM CranSoft.dbo.Page WHERE WebAppID = N'cdc6e442-2e10-4048-b971-cc58ea33119c'

  DELETE FROM CranSoft.dbo.WebAppPluginAssembly WHERE WebAppID = N'cdc6e442-2e10-4048-b971-cc58ea33119c'

  DELETE FROM CranSoft.dbo.WebApp WHERE WebAppID = N'cdc6e442-2e10-4048-b971-cc58ea33119c'

  DELETE FROM [CranSoft].dbo.[DataSource] WHERE [DataSourceID] = N'90606010-454e-410c-9eb8-40f5f7363e2b'

  GO
  1. Execute the following SQL script (on the Stewardship Tier SQL Instance) to drop the psaCollate database:
DROP Database psaCollate

 

Related articles