SquaredUp cannot start due to an error

SquaredUp cannot start due to an error.

Startup failed for 'Extension packs'.

In the log:

[FTL] Error during startup sequence
System.InvalidOperationException: Exception during startup sequence ---> System.InvalidOperationException: Startup failed for 'Extension packs' ---> System.Data.SQLiteException
FOREIGN KEY constraint failed

Cause

There is a problem with one of the package zip files in the ..\SquaredUp\User\ReferencePackages folder.

Solution

1. Stop the SquaredUp DS application pool.
   
2. Add the following lines to the ..\SquaredUp\User\Configuration\extensionpacks.json file:
   Copy

   {
   "log-level": "debug",
   "trace-all-queries": true
   }

3. Rename the current log to .old (see Where to find log files).
   
4. Start the SquaredUp DS application pool to reproduce the issue.
   
5. Review the log for the line Startup failed for 'Extension Packs' and check the lines above that error for the last pack that is referenced. This will be the package file that is causing the startup failure.
   In the following example it was a pack called opslogixvmware:
   Copy

   2020-12-23 11:53:20.140 >> 011 >> [DBG] DELETE FROM Pack WHERE (ID = '52bc9c4d-1910-460b-86c5-7531a2dff2eb' OR InternalName = 'opslogixvmware');
   2020-12-23 11:53:20.140 >> 011 >> [DBG] DELETE FROM Pack WHERE (ID = '52bc9c4d-1910-460b-86c5-7531a2dff2eb' OR InternalName = 'opslogixvmware');
   2020-12-23 11:53:20.140 >> 011 >> [DBG] ROLLBACK TO sqlite_dotnet_savepoint_1;
   2020-12-23 11:53:20.140 >> 011 >> [DBG] ROLLBACK;
   2020-12-23 11:53:20.142 >> 011 >> [FTL] Error during startup sequence
   System.InvalidOperationException: Exception during startup sequence ---> System.InvalidOperationException: Startup failed for 'Extension packs' ---> System.Data.SQLite.SQLiteException: constraint failed
   FOREIGN KEY constraint failed

6. Stop the SquaredUp DS Application Pool.
7. In the ..\SquaredUp\User\ReferencePackages folder, remove the problematic package zip file.
   Where to find the SquaredUp folder

   Name of the SquaredUp folder

   Location of the SquaredUp folder

   If you deployed SquaredUp DS via the Azure Marketplace:

   The default location for the SquaredUp folder is F:\SquaredUpv[Version Number].
   For v5 it is F:\SquaredUpv5 and for v4 F:\SquaredUpv4.

   If you installed SquaredUp DS using the installer:

   A custom location may have been chosen during the installation.

   The default location for the SquaredUp folder is C:\inetpub\wwwroot\SquaredUp

   For v5 it is C:\inetpub\wwwroot\SquaredUpv5 and for v4 C:\inetpub\wwwroot\SquaredUpv4.

8. Delete the squaredup.index file in ..\SquaredUp\Transient\Cache\ExtensionPacks
   
9. Start the SquaredUp DS Application Pool.
   
10. Remember to change "trace-all-queries": true to "trace-all-queries": false in the extensionpacks.json file and recycle the SquaredUp DS application pool.
11. Check that you can now log in.