Web UI Stuck at "The WebUI is initializing"

[Ryan]

My WebUI is stuck at a state of “The WebUI is initializing” I found this mentioned on another recent post (here: BigFix WebUI stuck in initializing after January 2021 update) but the solution has not worked for me. I modified the file specified for V10 and restarted the WebUI but still stuck. HCL support has asked me to run the following command “delete * from webui.SCHEMA_VERSION” but I receive the error Msg: 102, Level 15, State 1, Server MyBigfixServer\BIGFIX, Line 1
Incorrect syntax near ’*’.
1>

I have tried running this command from a command line and from SQL management studio with SQLCMD Mode enabled. Could anyone point me towards the correct way to execute the command, or any other possible fixes for the stuck WebUI issue?

Here is my file “C:\Program Files (x86)\BigFix Enterprise\BES WebUI\WebUI\sites\WebUI Data Sync_12414_12_1611266610\datasync-app\app\dataSync\framework\10\computed_device_properties_mssql.sql” where I edited the comment section.

And here is the error I am receiving trying to run the command specified.

[cmcannady]

Given the current state, I’d either open a support case with our L2 team or I’d uninstall using BESRemover (version specific) and then reinstall via content.

[JasonWalker]

I agree, this kind of thing should only be run with Support on the line, and only after taking full backups of both the root server and the database.

That said, the sql statement DELETE * FROM WebUI.SCHEMA_VERSION doesn’t look right to me. The SQL’s DELETE statement doesn’t take a ‘*’ parameter.

A SQL delete is more like

DELETE FROM <table> WHERE <condition>

…and anyone who’s accidentally run a DELETE FROM and forgot to put the ‘WHERE’ on the end, can tell you it deletes every record in the table.