Back to forum list… Back to Issues and Problems...

Unknown server error when attempting to resize window (5 replies)

Randy
3 years ago
Randy 3 years ago

When I try to resize a DB writer I get a server error (?)

 

https://imgur.com/a/f4kwPtQ

https://www.realisable.co.uk/wp-content/uploads/2019/12/SQLServerDate.png
Randy
3 years ago
Randy 3 years ago

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?
Randy
3 years ago
Randy 3 years ago

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?

Support
3 years ago
Support 3 years ago

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?

Randy
3 years ago
Randy 3 years ago

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.

Randy
3 years ago
Randy 3 years ago

Hello?  Any follow up?

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close