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
- Stop the SquaredUp DS application pool.
- Add the following lines to the
..\SquaredUp\User\Configuration\extensionpacks.json
file:{ "log-level": "debug", "trace-all-queries": true }
- Rename the current log to
.old
(see Where to find log files). - Start the SquaredUp DS application pool to reproduce the issue.
- 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 calledopslogixvmware
: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
- Stop the SquaredUp DS Application Pool.
- In the
..\SquaredUp\User\ReferencePackages
folder, remove the problematic package zip file.Name of the SquaredUp folder
The default name of the SquaredUp folder is
SquaredUp
for v6 and above.For v5 it is
SquaredUpv5
, and for v4SquaredUpv4
.Location of the SquaredUp folder
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 v4C:\inetpub\wwwroot\SquaredUpv4
. - Delete the
squaredup.index
file in..\SquaredUp\Transient\Cache\ExtensionPacks
- Start the SquaredUp DS Application Pool.
- Remember to change
"trace-all-queries": true
to"trace-all-queries": false
in theextensionpacks.json
file and recycle the SquaredUp DS application pool. - Check that you can now log in.