[Connection problem / App freeze]

Yes. I undestand that I have to share information but before I do, I must cleanup my entries from log file. I have stress tested app and it shouldn't be the issue.

 

I managed to track down problem and it seems probable that it's my code which caused the freezing. It's very weird one though; whole application will freeze on line "DataSet.Next;".  To be more precise, application itself does not really freeze but database connection does. Code in question is not particularly complex and I couldn't figure out why this is happening although I managed to fix problem by using different technique to update database.

 

So, it seems the problem is solved. Thank to all of you for prompt responses.

 

--Mika

[Connection problem / App freeze]

Version is 0.99.96.1322

 

App log didn't have any entires at all at the time of problems. I can't share it because it contains lot of custom logged sensitive information.

[Connection problem / App freeze]

We have developed fairly large application using UniGUI and it has worked great for the most part. However, now we have a pretty big problem because our application froze and log entries don't tell us enough to resolve this issue.

 

We are running our application as a standalone executable.

 

Below is last lines of log. Problem started on line 11 and after that, all our users got disconnected and were unable to reconnect to application.

 

Any and all help would be greatly appreciated.

app.exe: 00001474: 15.29.38 [IP_HIDDEN_1]:FLastSequence set:338
app.exe: 00001474: 15.29.38 [IP_HIDDEN_1]:iSeq: Id: 339, Evt: move, [YgFHxzdG54FE331C0B]
app.exe: 00001474: 15.29.38 [IP_HIDDEN_1]:Processing: Id: 339, Evt: move
app.exe: 00001474: 15.29.38 [IP_HIDDEN_1]:Processed: Id: 339, Evt: move, [YgFHxzdG54FE331C0B]
app.exe: 00001474: 15.29.38 [IP_HIDDEN_1]:FLastSequence set:339
app.exe: 00000390: 15.29.38 [IP_HIDDEN_1]:iSeq: Id: 340, Evt: resize, [YgFHxzdG54FE331C0B]
app.exe: 00000390: 15.29.38 [IP_HIDDEN_1]:Processing: Id: 340, Evt: resize
app.exe: 00000390: 15.29.38 [IP_HIDDEN_1]:Processed: Id: 340, Evt: resize, [YgFHxzdG54FE331C0B]
app.exe: 00000390: 15.29.38 [IP_HIDDEN_1]:FLastSequence set:340
app.exe: 00001474: 15.29.38 [IP_HIDDEN_1]:iSeq: Id: 342, Evt: activate, [YgFHxzdG54FE331C0B]
app.exe: 00001474: 15.29.48 [IP_HIDDEN_1]:Sequence Error Timeout : TDiff:10015, Event: activate, Expected: 341, Received: 342, [YgFHxzdG54FE331C0B]
app.exe: 00001474: 15.29.48 [IP_HIDDEN_1]:Failed Sequence Reset to: 341
app.exe: 00001474: 15.29.48 [IP_HIDDEN_1]:Rejected Sequence : 342, Expected: 341, RecoverFailureTimeout: 90000, FTime: 0
app.exe: 00001474: 15.29.48 [IP_HIDDEN_1]:Processed: Id: 342, Evt: activate, [YgFHxzdG54FE331C0B]
app.exe: 00001318: 15.29.48 [IP_HIDDEN_2]:Processing: Id: -1, Evt: 
app.exe: 00001318: 15.29.48 [IP_HIDDEN_2]:Processed: Id: -1, Evt: , [npFRqhyt5EFE33249A]
app.exe: 00001474: 15.29.48 [IP_HIDDEN_1]:iSeq: Id: 342, Evt: activate, [YgFHxzdG54FE331C0B]
app.exe: 00001474: 15.29.48 [IP_HIDDEN_1]:Failed Sequence Recovery: SeqId: 342, Event: activate, Status: 401, StatusText: "Unauthorized", TimedOut: false, cQs: f:{}, s:{345,346}, a:{}, r:{}
app.exe: 00001474: 15.29.50 [IP_HIDDEN_1]:Failed Sequence Recovery : TDiff:2016, Event: activate, Expected: 341, Received: 342, [YgFHxzdG54FE331C0B]
app.exe: 00001474: 15.29.50 [IP_HIDDEN_1]:Rejected Sequence : 342, Expected: 341, RecoverFailureTimeout: 90000, FTime: 2141
app.exe: 00001474: 15.29.50 [IP_HIDDEN_1]:Processed: Id: 342, Evt: activate, [YgFHxzdG54FE331C0B]
app.exe: 00001744: 15.29.50 [IP_HIDDEN_1]:iSeq: Id: 341, Evt: deactivate, [YgFHxzdG54FE331C0B]
app.exe: 00001744: 15.29.50 [IP_HIDDEN_1]:Processing: Id: 341, Evt: deactivate
app.exe: 00001744: 15.29.50 [IP_HIDDEN_1]:Processed: Id: 341, Evt: deactivate, [YgFHxzdG54FE331C0B]
app.exe: 00001744: 15.29.50 [IP_HIDDEN_1]:FLastSequence set:341
app.exe: 00001474: 15.29.50 [IP_HIDDEN_1]:iSeq: Id: 342, Evt: activate, [YgFHxzdG54FE331C0B]
app.exe: 00001474: 15.29.50 [IP_HIDDEN_1]:Failed Sequence Recovery: SeqId: 342, Event: activate, Status: 401, StatusText: "Unauthorized", TimedOut: false, cQs: f:{}, s:{345,346}, a:{}, r:{}
app.exe: 00001474: 15.29.50 [IP_HIDDEN_1]:Processing: Id: 342, Evt: activate
app.exe: 00001474: 15.29.50 [IP_HIDDEN_1]:Processed: Id: 342, Evt: activate, [YgFHxzdG54FE331C0B]
app.exe: 00001474: 15.29.50 [IP_HIDDEN_1]:FLastSequence set:342
app.exe: 00001334: 15.29.50 [IP_HIDDEN_1]:iSeq: Id: 344, Evt: columnresize, [YgFHxzdG54FE331C0B]
app.exe: 00001334: 15.30.00 [IP_HIDDEN_1]:Sequence Error Timeout : TDiff:10016, Event: columnresize, Expected: 343, Received: 344, [YgFHxzdG54FE331C0B]
app.exe: 00001334: 15.30.00 [IP_HIDDEN_1]:Failed Sequence Reset to: 343
app.exe: 00001334: 15.30.00 [IP_HIDDEN_1]:Rejected Sequence : 344, Expected: 343, RecoverFailureTimeout: 90000, FTime: 0
app.exe: 00001334: 15.30.00 [IP_HIDDEN_1]:Processed: Id: 344, Evt: columnresize, [YgFHxzdG54FE331C0B]
app.exe: 00001334: 15.30.00 [IP_HIDDEN_1]:iSeq: Id: 344, Evt: columnresize, [YgFHxzdG54FE331C0B]
app.exe: 00001334: 15.30.00 [IP_HIDDEN_1]:Failed Sequence Recovery: SeqId: 344, Event: columnresize, Status: 401, StatusText: "Unauthorized", TimedOut: false, cQs: f:{}, s:{}, a:{}, r:{}
app.exe: 00001334: 15.30.02 [IP_HIDDEN_1]:Failed Sequence Recovery : TDiff:2016, Event: columnresize, Expected: 343, Received: 344, [YgFHxzdG54FE331C0B]
app.exe: 00001334: 15.30.02 [IP_HIDDEN_1]:Rejected Sequence : 344, Expected: 343, RecoverFailureTimeout: 90000, FTime: 2047
app.exe: 00001334: 15.30.02 [IP_HIDDEN_1]:Processed: Id: 344, Evt: columnresize, [YgFHxzdG54FE331C0B]
app.exe: 000017CC: 15.30.02 [IP_HIDDEN_3]:iSeq: Id: 2066, Evt: timer, [RpIzHBHBsnFE330F0A]
app.exe: 000017CC: 15.30.12 [IP_HIDDEN_3]:Sequence Error Timeout : TDiff:10016, Event: timer, Expected: 2064, Received: 2066, [RpIzHBHBsnFE330F0A]
app.exe: 000017CC: 15.30.12 [IP_HIDDEN_3]:Failed Sequence Reset to: 2064
app.exe: 000017CC: 15.30.12 [IP_HIDDEN_3]:Rejected Sequence : 2066, Expected: 2064, RecoverFailureTimeout: 90000, FTime: 0
app.exe: 000017CC: 15.30.12 [IP_HIDDEN_3]:Processed: Id: 2066, Evt: timer, [RpIzHBHBsnFE330F0A]
app.exe: 00001574: 15.30.12 [IP_HIDDEN_1]:iSeq: Id: 1248, Evt: update_idle_time, [6536otWzlqFE330899]
app.exe: 00001574: 15.30.12 [IP_HIDDEN_1]:Processing: Id: 1248, Evt: update_idle_time
app.exe: 00001574: 15.30.12 [IP_HIDDEN_1]:Processed: Id: 1248, Evt: update_idle_time, [6536otWzlqFE330899]
app.exe: 00001574: 15.30.12 [IP_HIDDEN_1]:FLastSequence set:1248
app.exe: 00001334: 15.30.12 [IP_HIDDEN_1]:iSeq: Id: 344, Evt: columnresize, [YgFHxzdG54FE331C0B]
app.exe: 00001334: 15.30.12 [IP_HIDDEN_1]:Failed Sequence Recovery: SeqId: 344, Event: columnresize, Status: 401, StatusText: "Unauthorized", TimedOut: false, cQs: f:{}, s:{}, a:{}, r:{}
app.exe: 00001334: 15.30.15 [IP_HIDDEN_1]:Failed Sequence Recovery : TDiff:2016, Event: columnresize, Expected: 343, Received: 344, [YgFHxzdG54FE331C0B]
app.exe: 00001334: 15.30.15 [IP_HIDDEN_1]:Rejected Sequence : 344, Expected: 343, RecoverFailureTimeout: 90000, FTime: 14156
app.exe: 00001334: 15.30.15 [IP_HIDDEN_1]:Processed: Id: 344, Evt: columnresize, [YgFHxzdG54FE331C0B]
app.exe: 00001744: 15.30.15 [IP_HIDDEN_1]:iSeq: Id: 345, Evt: tabchange, [YgFHxzdG54FE331C0B]
app.exe: 00001744: 15.30.25 [IP_HIDDEN_1]:Sequence Error Timeout : TDiff:10015, Event: tabchange, Expected: 343, Received: 345, [YgFHxzdG54FE331C0B]
app.exe: 00001744: 15.30.25 [IP_HIDDEN_1]:Rejected Sequence : 345, Expected: 343, RecoverFailureTimeout: 90000, FTime: 24187
app.exe: 00001744: 15.30.25 [IP_HIDDEN_1]:Processed: Id: 345, Evt: tabchange, [YgFHxzdG54FE331C0B]
app.exe: 00001744: 15.30.25 [IP_HIDDEN_1]:iSeq: Id: 345, Evt: tabchange, [YgFHxzdG54FE331C0B]
app.exe: 00001744: 15.30.25 [IP_HIDDEN_1]:Failed Sequence Recovery: SeqId: 345, Event: tabchange, Status: 401, StatusText: "Unauthorized", TimedOut: false, cQs: f:{}, s:{}, a:{347,348,349,350,351}, r:{}
app.exe: 00001744: 15.30.27 [IP_HIDDEN_1]:Failed Sequence Recovery : TDiff:2016, Event: tabchange, Expected: 343, Received: 345, [YgFHxzdG54FE331C0B]
app.exe: 00001744: 15.30.27 [IP_HIDDEN_1]:Rejected Sequence : 345, Expected: 343, RecoverFailureTimeout: 90000, FTime: 26234
app.exe: 00001744: 15.30.27 [IP_HIDDEN_1]:Processed: Id: 345, Evt: tabchange, [YgFHxzdG54FE331C0B]
app.exe: 0000165C: 15.30.27 [IP_HIDDEN_4]:iSeq: Id: 272, Evt: timer, [LvYRmoMHWFFE330F05]
app.exe: 0000165C: 15.30.37 [IP_HIDDEN_4]:Sequence Error Timeout : TDiff:10015, Event: timer, Expected: 269, Received: 272, [LvYRmoMHWFFE330F05]
app.exe: 0000165C: 15.30.37 [IP_HIDDEN_4]:Failed Sequence Reset to: 269
app.exe: 0000165C: 15.30.37 [IP_HIDDEN_4]:Rejected Sequence : 272, Expected: 269, RecoverFailureTimeout: 90000, FTime: 0
app.exe: 0000165C: 15.30.37 [IP_HIDDEN_4]:Processed: Id: 272, Evt: timer, [LvYRmoMHWFFE330F05]

[Precision Agriculture - Finished System]

That application looks good and very usable. Thumbs up.

[clone form]

xxf: TUniForm; should be xxf:Tffilter

[Can not download newest version from portal]

Same here. We haven't renewed our license yet as Farshad has said subscription will last until 1.0 version is released.

[Pivot]

Yep. PivotGrid would be very nice addition to UniGUI

[Bootstrap Theme]

It's not suppose to show up in object inspector. You just write theme name to object inspector in main module -> theme property.

[TUniDBComboBox with ITEMS+VALUES]

Seems to work great. Thank you gerardocrisci

[TUniDBComboBox with ITEMS+VALUES]

This feature is very much needed here too. It's frustrating to create memory table just to get lookup values for simplest things.

[ISAPI app]

Check path / filename you're using to export PDF file.

[ISAPI app]

It seems to me that bug is most likely in proc_1, proc_2 or both. How you have ensured that execution reacher to your evaluation? If evalution is actually processed, either proc_1 or proc_2 will be executed and bug must be in either of those procs. They either do nothing or they fail silently.

[scanner with unigui]

Using scanner through web??

 

If you mean some kind of LAN setup, you can probably use same components for scanning as you would use while developing standard VCL application.

[User activity / Idle time]

This seems quite easy to integrate to our software Thank you!

[User activity / Idle time]

Is it possible to monitor user activity simple way? Ie. when was the last time user used keyboard or clicked something. Currently our software monitors only who are logged in but it doesn't tell us if user is actually doing anything or if user is only idling. Is there some common event(s) sent to server when user is active and if there is, what is the correct way to handle those event(s)?

 

I know I can code system that updates database every time user actually does something, but that is not really an option because it would be time consuming to cover whole software for user activity and there would be bound to be gaps.

 

This is not crucial to us, but it would certainly be helpful.

 

--Mika

[UniContainerPanel - reduce size of traffic]

I am wondering why do we require such component?

 

Thanks & Regards,

Bantu Kumar

Why not? Überlight container can be quite handy in situations erich.wanker described.

[Microsoft SQL Server For Linux]

This is very good news! When Idera releases Delphi with Linux support and Microsoft does the same with SQL Server, migration to Linux should be fairly easy task. Long live penguin! 

[UniSynEdit and custom highlighter]

Hi

 

We will try to find a solution..

 

Best regards.

Okay. Thank you.

[UniSynEdit and custom highlighter]

Okay. Let's try this another way. How can I utilize highlighters CodeMirror supports?

 

CodeMirror, used by uniGUI, supports many languages including Lua. However, currently uniGUI restricts usage of them to Pascal, CSS, HTML, Java, JavaScript, Perl, Ruby, PHP, SQL, VB, XML, TXT, Python and C#.

[UniSynEdit and custom highlighter]

Is it possible to extend uniSynEdit to handle extra language(s)? I need uniSynEdit to highlight Lua code.

[How do you create Reports? FastReport or jQuery plugins?]

Mika! Do you use Fast Report VCL? 

Yes I do.

[How do you create Reports? FastReport or jQuery plugins?]

I use only FastReport as our appliation requires most of our reports to have very specific look to a millimeter. I personally think that creating PDF file on server side is also simple and efficient way to create reports from uniGUI.

[Embarcadero Aquired by IDERA]

I'm agree with Farshad, as far as I know Delphi is the competition of Visual Studio.

I'd like that Google or other big company  Buy Delphi and convert to Open Source

Delphi to open source? Neat idea but it's not going to happen; ever. Also, I did not mean that delphi should be abandoned. However, it would be beneficial not to be entirely dependant on Delphi.

[Embarcadero Aquired by IDERA]

In what regards?

There is probablity that development of RAD Studio will be ceased in not too distant future. Idera is specialiced in database solutions and it wouldn't surprise me at all if they decide to discontinue developing RAD Studio.

[DBLookupComboBox without lookup dataset]

+1. This would be very useful. Until now, I've been using memory table and dblookupcombobox to achieve this. Using just combobox with key/value pairs would be lot easier and also code would be more clean because in that case, there would be no need to initialize lookup memory table and other things.