OK, interesting.  It looks like every time you try and resize the UI, for some reason it is trying to insert a row into the DB and failing:

2020-11-19 11:12:05:606 - System.Data.SqlClient.SqlException: Cannot insert the value NULL into column 'USEUSERPASS', table 'IMan4.dbo.BASICAUTH'; column does not allow nulls. INSERT fails.
The statement has been terminated.
at Realisable.Utils.OM.CRUDDomainObject`1.Update()
at Realisable.IManWebUI.UserOptions.Save(String options)
at SyncInvokeSave(Object , Object[] , Object[] )
at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage4(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage3(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage2(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage1(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)

Few questions:

• Why is it trying to do a DB insert from simply re-sizing the UI, they aren't (or shouldn't be) related at all.
• What is column "USEUSERPASS" used for?  Why isn't IMan populating the value?
• Why wasn't this error shown to the user on the BASIC HTTP AUTHENTICATION page when they attempt to create the record.  Wouldn't it make sense to show the error then?
• Why wasn't this error written to Errors.txt when the actual attempt to add the BASIC HTTP AUTHENTICATION record happened?

Where is IMan even storing this data to keep attempting these DB inserts?  Is there a queue of queries to attempt everytime the UI is updated?

Randy,

A database upgrade step has failed.

1. What version of database did you upgrade from?

2. Does the WSLOOKUP table have the column CACHERESULT?

3. Is there a SCHEDOPTS table?

I don't remember which version we updated from, this was done months ago.  Most likely the previous version (Product Update 3).  I don't remember there being any issues with the install.

Yes, WSLOOKUP has the column CACHERESULT: bit

Yes, there is a SCHEDOPTS table.

Hello?  Any follow up?