Article - CS373502

Exception Occurs "update_mssql.ps1 is not Digitally Signed" for MSSQL and "update_postgresql.ps1 is not Digitally Signed" for PostgreSQL When Running Database Update Scripts from PowerShell for ThingWorx Upgrade

Modified: 30-Jul-2025   


Applies To

  • ThingWorx Platform 9.0 to 9.7

Description

  • Exception  occurs while running database update script in Windows PowerShell
update_mssql.ps1 is not digitally signed. You cannot run this script on the current system because running scripts is disabled on this system. For more information, see about_Execution_Policies at https:/go.microsoft.com/fwlink/?LinkID=135170
+ ./update_mssql.ps1 -h xxx -p xxxxx -d TW -u tw-xxx - ...
+ ~~~~~~~~~~~~~~~~~~
+ CategoryInfo : SecurityError: (:) [], PSSecurityException
+ FullyQualifiedErrorId : UnauthorizedAccess
  • Unable to execute dgitally unsigned script during ThingWorx upgrade on Windows server
  • When attempting a manual upgrade from ThingWorx using the upgrade_postgres script, an error is encountered:
D:\Software\MED-61111-CD-093_SP9_ThingWorx-Platform-Postgres-9-3-9\update\update_postgres.ps1 cannot be loaded. The file D:\Software\MED-61111-CD-093_SP9_Thingworx-Platform-Postgres-9-3-9\update\update_postgres.ps1 is not digitally signed. You cannot run this script on the current system. For more information about running scripts and setting execution policy, see about_Execution_Policies at https:/go.microsoft.com/fwlink/?LinkID=135170.
  • The issue persists even after changing the ExecutionPolicy to Bypass
This is a printer-friendly version of Article 373502 and may be out of date. For the latest version click CS373502