mORMot Open Source

Our team uses Mormot in production now and it works well as the network is fast and reliable.

The problem is when developers work from home over a slower VPN connection.

So the setup is this:

Database and a WindowsService is located on the company network.
Developer runs a client.exe from home and uses a VPN connection to get access to service.

I didn't see how I could attach logfiles with VERBOSE mode here so I upload files on Google drive instead and post links.

Windows service
Client

In this case, the client first failed to connect with error "Invalid HTTP Upgrade Header" but later recover and do a normal connection.
This seems to be random. Sometimes success on the first try but sometimes I have to try several times until I got a connection.
My conclusion is that the slow speed of the network seems to trigger this problem.

Note that this is a multiuser environment so there could be other clients trying to connect to the service.
But to get a cleaner log-file for service I restarted it just for this case.

Please tell me if I can assist further to find the reason for this problem!

Regards
Roland Bengtsson

Well the header may describe our problem well.

Since a while, our team has used Synopse for networking. But some parts still use Indy.
The reason for the change was basically the support for WebSockets and nonblocking calls in Synopse.
Then that it has a reputation as fast doesn't hurt either.

Our client.exe and server.exe files use common units for connection to our own developed windows service.
This connection now uses Synopse for that. Some days everything works fine. But some days there are spontaneous disconnections that require manually restart of servers. This is of course serious!

Note that I have not worked with Synopse integration directly. It is Daniel Mauric that has vacation now.
The first question is what version of Synopse we use? I see in git that the latest commit in Synopse folder was 24 June 2019 with commit comment "Fix for thread names".

SynopseCommit.inc contains 1.18.5254. Is that the build-number?

The first change in SynCommons.pas is from

function IPToCardinal(const aIP: RawUTF8; out aValue: cardinal): boolean; overload;

to

function IPToCardinal(P: PUTF8Char; out aValue: cardinal): boolean; overload;

Maybe this is enough to identify our version?

Now the next question is how to fix this?
We have speculated that the reason can be a high load on the network.

This is a sample from logs when this happens at production. JCL is used as an exceptionhandler.

2019-08-16 11:15:13:612 (9584) Failed to send OSS message.: TInterfacedObjectFakeClient.FakeCall(IOSSService.SendOssNotification) failed: 'URI root/OSSService.SendOssNotification ["SYNC","E:GeoLocation:349879534\r\nM:GeoLocation.fLatitude,fLongitude,updated:349879534\r\n"] returned status 'Not Found' (404 - Network problem or request timeout)'
2019-08-16 11:15:13:752 (9584) [EXCEPTION] Raised EInterfaceFactoryException: TInterfacedObjectFakeClient.FakeCall(IOSSService.SendOssNotification) failed: 'URI root/OSSService.SendOssNotification ["SYNC","E:GeoLocation:349879534\r\nM:GeoLocation.fLatitude,fLongitude,updated:349879534\r\n"] returned status 'Not Found' (404 - Network problem or request timeout)'. At Location mORMot.RaiseError (mORMot.pas:54991)
Call Stack:
    [00] mORMot.RaiseError (mORMot.pas:54989)
    [01] mORMot.InternalProcess (mORMot.pas:55077)
    [02] System.@GetMem$qqri (System.pas:4614)
    [03] System.@NewAnsiString$qqrius (System.pas:24129)
    [04] System.@LStrAsg$qqrr27System.%AnsiStringT$us$i0$%x27System.%AnsiStringT$us$i0$% (System.pas:25278)
    [05] SynCommons.FormatUTF8$qqrx31System.%AnsiStringT$us$i65001$%px14System.TVarRecxir31System.%AnsiStringT$us$i65001$% (SynCommons.pas:24176)
    [06] FastMM4.FastReallocMem$qqrpvi
    [07] mORMot.TInterfacedObjectFake.FakeCall$qqrr21Mormot.TFakeCallStack (mORMot.pas:55165)
    [08] System.@UStrCat$qqrr20System.UnicodeStringx20System.UnicodeString (System.pas:29458)
    [09] System.@FreeMem$qqrpv (System.pas:4662)
    [10] System.@UStrClr$qqrpv (System.pas:24272)
    [11] BoldLoggableCriticalSection.TBoldLoggableCriticalSection.Release$qqrv
    [12] AttracsNetworkTransportSynopse.TOSSService.Execute$qqrv (AttracsNetworkTransportSynopse.pas:119)
    [13] System.Classes.Classes.ThreadProc$qqrxp22System.Classes.TThread (System.Classes.pas:14701)
    [14] System.ThreadWrapper$qqspv (System.pas:23825)

2019-08-16 11:15:13:971 (2876) Lost connection to OSS Server

Is there a more recent version of Synopse that can improve the situation?
We also discussed if we maybe could make a demo of the problem, but how do we simulate a high load on the network reproduce?

Of course, another possibility is wrong implementation of Synopse but Daniel doesn't believe that theory.
But I have noticed one thing.
At office when I connect to the database from my local machine this error never happens.
But when working from home when I use VPN it happens maybe 50 - 80 % of the time I try.
So obviously I now prefer to work at the office

So for us, this is top priority to solve!

Regards
Roland Bengtsson
Team Attracs Finland

I am using Fastreport to view reports and SynPDF to generate PDF-files. SynPDF version from 31 Jan 2017.
Problem is that a report with transparent image have inverted colors

See image
https://drive.google.com/file/d/0B4rghk … sp=sharing

So what is black should be white

If I turn off transparency it works fine

Regards
Roland Bengtsson

I found this https://synopse.info/forum/viewtopic.php?id=266

I have also a need to fill forms interactively. But this was 6 years ago.
Is the situation still the same that PDF engine have no support for this ?

Regards
Roland

How can I ensure a valid PDF/A file is generated ?

I tested my generated PDF in https://www.pdf-online.com/osa/validate.aspx with result

3-Heights™ PDF Validator
File	781305.pdf
Compliance	pdf1.3
Result	Document does not conform to PDF/A.
Details	
Validating file "781305.pdf" for conformance level pdf1.3
The object's identity 1 doesn't match with the object's reference identity 3.
The object's identity 1 doesn't match with the object's reference identity 2.
The object's identity 1 doesn't match with the object's reference identity 4.
The object's identity 1 doesn't match with the object's reference identity 5.
The object's identity 1 doesn't match with the object's reference identity 6.
The object's identity 1 doesn't match with the object's reference identity 7.
The object's identity 1 doesn't match with the object's reference identity 8.
The object's identity 1 doesn't match with the object's reference identity 9.
The object's identity 1 doesn't match with the object's reference identity 10.
The object's identity 1 doesn't match with the object's reference identity 11.
The object's identity 1 doesn't match with the object's reference identity 12.
The object's identity 1 doesn't match with the object's reference identity 13.
The object's identity 1 doesn't match with the object's reference identity 14.
The object's identity 1 doesn't match with the object's reference identity 5.
The object's identity 1 doesn't match with the object's reference identity 6.
The object's identity 1 doesn't match with the object's reference identity 7.
The object's identity 1 doesn't match with the object's reference identity 8.
The object's identity 1 doesn't match with the object's reference identity 9.
The object's identity 1 doesn't match with the object's reference identity 10.
The object's identity 1 doesn't match with the object's reference identity 11.
The object's identity 1 doesn't match with the object's reference identity 12.
The object's identity 1 doesn't match with the object's reference identity 13.
The object's identity 1 doesn't match with the object's reference identity 14.
The document does not conform to the requested standard.
The file format (header, trailer, objects, xref, streams) is corrupted.
Done.

Anyone thta can help ?