You are not logged in.
- Topics: Active | Unanswered
Pages: 1
#1 Re: mORMot 1 » Serialize several datasets » 2015-01-28 20:04:28
ab, and what about using FireDac.Reflection classes? of course those are new to XE6 but it is a beginning. The only thing DataSnap is supperior to mORMot is this.
#2 mORMot 1 » Serialize several datasets » 2015-01-27 17:25:05
- foncci
- Replies: 2
Hi, I need to serialize several datasets, for example Invoices, Details, Customers and Groups and expose them (maybe a DatasetToJSON function?), how can I join them in one JSON object? Any sample?
Of course, later I need to unserialize it (JSONToDataSet?) to 4 memory datasets. I'm using FirecDAC in memory DataSet but I'm open to other ideas.
Can I use mORMot on Android 4 as client to consume those datasets?
Regards,
Al
#3 mORMot 1 » function exposing a TFDJSONDataSets » 2014-10-22 03:11:44
- foncci
- Replies: 1
Hi All,
With the introduction of Data.FireDACJSONReflect I have seen some webminars using it with DataSnap. So far I have not used DataSnap for production(just played with it) but I have a many mORMot services working like a charm. As I'm not a big fan of ORMs I use mORMot for SOA, exposing my own serialized data as JSON and being able to use TFDJSONDataSets would be great for me.
Does anyone tried it? Any experience?
Ab, have you in plans to have a SOA framework independent of the ORM framework?
Regards,
Al
#4 Re: mORMot 1 » StackInfo and StackTrace for Exception » 2014-04-08 11:05:23
I know it but I would like to use it together with Delphi Exception. If you don't understand me I leave you some stackoverflow questions, maybe you'll better understand them. As I said before I know how to get it using SynCommons but it would be a good idea for marketing purposes to offer a simple way to get that for non mORMot users.
http://stackoverflow.com/questions/1589 … -exception
http://stackoverflow.com/questions/2587 … pplication
#5 mORMot 1 » StackInfo and StackTrace for Exception » 2014-03-31 12:35:03
- foncci
- Replies: 2
Last weekend I was having troubles with some exceptions, thanks to TSQLLog in mORMot to find them by accessing the stacktrace. But doing some research I found that Delphi Exception class doesn't provide it by itself so you have to get some extra utility like EurekaLog $$$ for example.
Delphi Helps says:
StackInfo provides the stack information when this exception is raised.
StackInfo provides the stack information when this exception is raised. The value of StackInfo is an untyped pointer, because there is no defined format for this information to be stored as. To access human-readable stack information, read the value of the StackTrace property.
StackTrace specifies the stack trace at the moment when the exception was raised.
Read the value of StackTrace on a caught exception to retrieve a formatted string that describes the stack trace at the moment when the exception was raised.
I think that TSQLLog should provide the procedure for StackInfo to get StackTrace, in TSQLLog it is already done so it is not a lot of work and the most important thing, I read several post in StackOverflow about people needing this feature and the choices are EurekaLog, JDBGVCL? and another 2 I don't recall now. Providing this feature will bring a lot of new users to know our mORMot even if that is the only reason. I think this is a marketing investment.
#6 Re: mORMot 1 » Memory Leak if exception is raised » 2014-03-31 12:21:35
Thanks, those are great news. I will try it tonight.
#7 Re: mORMot 1 » Memory Leak if exception is raised » 2014-03-31 02:26:18
I already debugged TWinHTTP.InternalRequest 2 days ago and it gets the ReceiveTimeOut I set, if it uses the value or not is another story. I assumed that it was OK but now I agree with you, We do have an issue with that method. I cannot go inside it because it is an external function but for sure it is not setting the timeout and it is a huge problem. Now, lets guess that we have an issue with TWinHTTP.InternalRequest(), I tried useHttpSocket with exactly the same results, then we have an issue with TWinINet.InternalRequest too. We have something else going wrong in here.
I changed HTTP_DEFAULT_RECEIVETIMEOUT = 240000; and now it works fine. So the issue is as you said before <"Setting the timeouts after the connection is open is perhaps not taken in account by the API.">
Maybe the best idea is to add a parameter to the constructor to control this and update the SAD with this behavior. It has cost me 4 days this week including the weekend and days last month when I was confused about the exception message. By the way, a more intuitive error message should be used. The idea is to save somebody's else time.
Will you be able to go deeper on it. I need to do more time consuming process in the server side and TimeOuts is a must for me. I have a solution now but something more elegant should be nice.
#8 Re: mORMot 1 » Memory Leak if exception is raised » 2014-03-30 13:33:52
BTW I just read your suggestion from StackOverflow, I do the same:
select * from ventas where status<>21 {Moved to main office} order by id rows 10
Of course this is created dynamically and next I read all dependent tables in the same way. The order is made by a json string like this:
{TABLE:"VENTAS", WHERE:"STATUS<>21"}
As I said before the 20s+ is due to the Status and Dates fields updates and some other calculation for reports.
This is a module supported by mORMot that is capable of integrate tables among different databases without needing of triggers and it is working 24/7.
Thanks again for mORMot and any news about the timeout will be appreciated.
#9 Re: mORMot 1 » Memory Leak if exception is raised » 2014-03-30 13:13:57
I know 20s is slow but I do some data processing inside it and connection latency is an issue too. The method process Invoices, Invoices Details, Payments, Customers and Products. I mean 20 000 invoices but when you sum all data it is more than 200 000 records. The time is pretty good and the indexes are well made. The result json is big, it is more than 5mb, now taking only 10 records is the way I found to make it work. But in any case why the client closes the connection? This is the real question here. If the timeout is set to 4 minutes and the processing time is only 20s why the connection is close? I think we have a bug in the KeepAlive or ReceiveTimeOut. If the connection last for more than a minute all my problems are solved.
About leaking memory I understand what you said, it takes time to release all those memory but there is always a new client connection so it will reserve more memory than it release and that why the service collapses.
I have always used useHTTPAPI, I try useHttpSocket just for testing to see if with it the connection is not closed but it is. I have been with this problem for a couple of weeks now so I'm trying every details to find the solution.
Service creation:
CompressShaAesSetKey(cMyShaKey);
aModel := TSQLModel.Create([], cServiceName);
aServer := TSQLRestServerFullMemory.Create(aModel, '', false, true);
aServer.ServiceRegister(TServiceIntegrador, [TypeInfo(IServiceIntegrador)], cServiceImplementation).AllowAll; // .AllowAllByName(['User']);
aHTTPServer := TSQLHttpServer.Create(aPort, [aServer],'+',useHttpApiRegisteringURI, 32, secSynShaAes);Client creation
CompressShaAesSetKey(cMyShaKey);
fModel := TSQLModel.Create([], cServiceName);
fClient := TSQLHttpClient.Create(aServer, aPort, fModel);
fClient.Compression := [hcSynLZ, hcDeflate, hcSynShaAes];
if not fClient.ServerTimeStampSynchronize
then raise ESynConnError.Create('Remote service not available on server');
if (not fClient.SetUser(aUser, aPass)) or
(not fClient.ServiceRegister([TypeInfo(IServiceIntegrador)], cServiceImplementation))
then raise Exception.Create('Remote service not available on server. 1');
if DebugHook<>0 then
begin // 100 min Solo por debugging process
fClient.WinAPI.ReceiveTimeout := 6000000;
end
else
begin
fClient.WinAPI.ReceiveTimeout := 120000; // 4 Min
fClient.KeepAliveMS := 120000;
end;
// TWinHttpAPI.Create tiene los TIMEOUTS
fService := fClient.Service<IServiceIntegrador>;Contract
IServiceIntegrador = interface(IInvokable)
['{DAC7E463-BBEC-4FC2-A7B2-B91E338D667C}']
Procedure UpdSQL(aTipo : integer; aComando, aData : RawJSON; out aError : RawJson);
Procedure UpdSQLFromSlave(aComando, aData : RawJSON);
Procedure Consulta(aComando : RawJSON; out aData : RawJSON; var aNav : RawJSON);
Procedure ExecAnySQLArr(aScript : RawJSON);
Procedure ExecAnySQL(jComando : RawJSON);
function Echo(const s : TConsultaNav) : TConsultaNav;
//function EchoWithException(s : RawJSON) : RawJSON;
end;You never told me why client connection is closed in that short time. Usually in less than 10 seconds the client closes the connection and that is the root of all my problems. By the way the message that is generated is quite confusing. It never say "connection closed" or something like that, it is always "...fake interface call:" without any status code like with the rest of exceptions.
If you are still online we can do a TeamViewer session and I can show you more details.
Thanks for your time. I appreciate it.
#10 Re: mORMot 1 » Memory Leak if exception is raised » 2014-03-30 11:03:19
After a deep debug I think I know what is happening:
I'm doing 5 select queries that returns a around 20 000 rows in a method of an Interface based service. The process takes almost 20 seconds to complete. The data returned is converted to json and returned in the Result variable of the method.
First I change the function to a procedure with a var param of RawJSON type to see if this solve the problem. Still the same exception.
Second, I reduced the amount of data returned to the half but I was still getting the exception.
Third doing a cycle I start requesting all the information in packages of 10 rows only, now IT WORKS. The method executes in less than half a second.
I have a timeout like this:
fClient.WinAPI.ReceiveTimeout := 120000; // 4 Min
fClient.KeepAliveMS := 120000;
so I have 4 minutes timeout and the whole process never took more than 20 seconds. Is Timeout working?
Conclusion:
The client is not honoring the TimeOut that is set in the connection or according to the exception log generated and posted before this there is a bug in the string handling routines when you send huge strings. So I'm asking now because I think I read that strings are "infinite" in size. Is there any size limit in RawJSON or RawUTF8 types?
Third and my most concerning question, I dig inside mORMot code and I found the method that deals with timeout in the server. In the debugger it works fine but I debug in my laptop locally and everything runs faster locally. Is there any chance that the Client closes the connection because the thread that is suppose to response to its keep alive packets is working doing some queries? If so, how can I do these queries without blocking the thread and why is that thread blocked because it should be a thread dedicated to run the method.
The memory leak is obvious now, the connection is closed by the client but the server is still processing those queries, the client tries again and again a new connection with more queries and in half an hour the service collapses.
Any help will be appreciated. I have expend days with this issue.
Regards,
Al
#11 Re: mORMot 1 » Memory Leak if exception is raised » 2014-03-30 06:49:24
This is the log I get for the client exception TThreadSendMessages.Execute Invalid fake IServiceIntegrador.Consulta interface call: :
and nothing more. Digging in mORMot code I see that it should return {Error:500 xxx} too but I just receive white spaces instead of the error code, so I think that is a bug too.
I have compiled it with XE2 and XE5 and we get the same exception. This time I have made the server sicPerThread.
By the way, this was made using useHttpSocket because I'm trying everyone option to see if the error goes away. The exception is similar if you are using useHTTPAPI.
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Server >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>.
D:\MAGNUS\TestIntegrador.exe 1.0.0.0 (2014-03-29 22:37:56)
Host=SER_FLP User=SOFTEL CPU=4*9-6-7685 OS=9.2=6.0.6002 Wow64=1 Freq=14318180
Environment variables=ALLUSERSPROFILE=C:\ProgramData APPDATA=C:\Users\SOFTEL\AppData\Roaming CLIENTNAME=SERVIDOR CommonProgramFiles=C:\Program Files (x86)\Common Files CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files CommonProgramW6432=C:\Program Files\Common Files COMPUTERNAME=SER_FLP ComSpec=C:\Windows\system32\cmd.exe DFSTRACINGON=FALSE FP_NO_HOST_CHECK=NO HOMEDRIVE=C: HOMEPATH=\Users\SOFTEL LOCALAPPDATA=C:\Users\SOFTEL\AppData\Local LOGONSERVER=\\SER_FLP NUMBER_OF_PROCESSORS=4 OS=Windows_NT Path=C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\Windows System Resource Manager\bin;;C:\Windows\idmu\common;C:\Program Files\Firebird\Firebird_2_5\bin PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC PROCESSOR_ARCHITECTURE=x86 PROCESSOR_ARCHITEW6432=AMD64 PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 30 Stepping 5, GenuineIntel PROCESSOR_LEVEL=6 PROCESSOR_REVISION=1e05 ProgramData=C:\ProgramData ProgramFiles=C:\Program Files (x86) ProgramFiles(x86)=C:\Program Files (x86) ProgramW6432=C:\Program Files PSModulePath=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\ PUBLIC=C:\Users\Public SESSIONNAME=RDP-Tcp#1 SystemDrive=C: SystemRoot=C:\Windows TEMP=C:\Users\SOFTEL\AppData\Local\Temp\3 TMP=C:\Users\SOFTEL\AppData\Local\Temp\3 TRACE_FORMAT_SEARCH_PATH=\\winseqfe\release\Windows6.0\lh_sp2rtm\6002.18005.090410-1830\amd64fre\symbols.pri\TraceFormat USERDOMAIN=SER_FLP USERNAME=SOFTEL USERPROFILE=C:\Users\SOFTEL windir=C:\Windows
TSQLLog 1.18 2014-03-30T02:04:33
20140330 02043343 EXC ECrtSocket ("SndLow -10054") at 003A98DF SynCrtSock.TCrtSocket.SndLow (2278) stack trace 003AAF78 SynCrtSock.THttpServerResp.Execute (3103) 000CB484 System.Classes.Classes.ThreadProc (14561) 0000A03E System.ThreadWrapper (23409)
20140330 02051847 EXC ECrtSocket ("SndLow -10054") at 003A98DF SynCrtSock.TCrtSocket.SndLow (2278) stack trace 003AAF78 SynCrtSock.THttpServerResp.Execute (3103) 000CB484 System.Classes.Classes.ThreadProc (14561) 0000A03E System.ThreadWrapper (23409)
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Client >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>.
20140330 02020809 EXC EOSError ("System Error. Code: 12002.\r\n") at 0002D31F System.SysUtils.SysUtils.RaiseLastOSError (24225) stack trace 0000A134 System.@NewAnsiString (23704) 0000AB60 System.@LStrCatN (26990) 003A2AEF mORMot.TServiceFactoryClient.InternalInvoke (35145) 00005A62 System.@GetMem (4321) 0000A134 System.@NewAnsiString (23704) 003A2978 mORMot.TServiceFactoryClient.Invoke (35115) 00398BBC mORMot.InternalProcess (32403)
20140330 02020809 EXC EInterfaceFactoryException ("Invalid fake IServiceIntegrador.Consulta interface call: : ") at 0039894A mORMot.RaiseError (32344) stack trace 000CB484 System.Classes.Classes.ThreadProc (14561) 0000A03E System.ThreadWrapper (23409) Just in case you need it, this is the same exception using useHTTPAPI
20140330 05101203 EXC EHttpApiServer ("HttpSendHttpResponse failed: Se ha intentado una operación en una conexión de red inexistente (1229)") at 003AD6B3 SynCrtSock.EHttpApiServer.RaiseOnError (4669) stack trace 000CB484 System.Classes.Classes.ThreadProc (14561) 0000A03E System.ThreadWrapper (23409)
20140330 05105508 EXC EHttpApiServer ("HttpSendHttpResponse failed: Se ha intentado una operación en una conexión de red inexistente (1229)") at 003AD6B3 SynCrtSock.EHttpApiServer.RaiseOnError (4669) stack trace 000CB484 System.Classes.Classes.ThreadProc (14561) 0000A03E System.ThreadWrapper (23409) #12 Re: mORMot 1 » If you set compiler setting Emit RunTime Information you get this erro » 2014-03-30 04:21:35
Here you have,
IServiceIntegrador = interface(IInvokable)
function Echo(const s : TConsultaNav) : TConsultaNav; <<<- This is a record
end;
I made an small app that is client and server at the same time to get this error log as simple as possible.
20140329 21181227 EXCOS EAccessViolation (C0000005) at 0031328E SynCommons.RecordClear (23260) stack trace 0033DFFC SynCrypto.TAES.EncryptInit (2109) 003B196C mORMotHttpServer.TSQLHttpServer.Request (570) 003A8B75 SynCrtSock.THttpServerGeneric.Request (1950) 003AA4F1 SynCrtSock.THttpServer.Process (2895) 003ABFAC SynCrtSock.THttpServerSocket.GetRequest (3396) 003AAE39 SynCrtSock.HandleRequestsProcess (3066) 003AAF78 SynCrtSock.THttpServerResp.Execute (3103) 000CB484 System.Classes.Classes.ThreadProc (14561) 0000A03E System.ThreadWrapper (23409)
20140329 21181228 ERROR TSQLHttpClientWinHTTP(016BBFA0) POST SERV_INTEGRADOR/ServiceIntegrador.Echo returned 500 Internal Server Error with message { "ErrorCode":500, "ErrorText":"Exception EAccessViolation: Access violation at address 0071428E in module 'TestIntegrador.exe'. Read of address 00000500" } stack trace API 0037CA7C mORMot.TSQLRestClientURI.URI (22896) 003A2AEF mORMot.TServiceFactoryClient.InternalInvoke (35145) 003A2978 mORMot.TServiceFactoryClient.Invoke (35115) 00398BBC mORMot.InternalProcess (32403) 00399476 mORMot.TInterfacedObjectFake.FakeCall (32522)
20140329 21181228 EXC EInterfaceFactoryException ("Invalid fake IServiceIntegrador.Echo interface call: : {\r\n\"ErrorCode\":500,\r\n\"ErrorText\":\"Exception EAccessViolation: Access violation at address 0071428E in module 'TestIntegrador.exe'. Read of address 00000500\"\r\n}") at 0039894A mORMot.RaiseError (32344) stack trace API 00330BF4 SynCommons.SynRtlUnwind (37232) 0000959C System.@HandleAnyException (18528) 0039894A mORMot.RaiseError (32344) 00398BCC mORMot.InternalProcess (32405) 00399476 mORMot.TInterfacedObjectFake.FakeCall (32522) #13 mORMot 1 » Memory Leak if exception is raised » 2014-03-30 02:59:17
- foncci
- Replies: 9
ab,
There is huge memory leak if an exception is raised inside an interface method service. This is simple, just add an exception at the end of a method service and call it 1000 times and you will see what happens in the task manager. To make it simpler, if there is an exception inside the method, the server never release the open connection and of course, in 2 hours the server runs out of memory. I have to remarks that this happens only with sicClientDriven, if you use sicPerThread it doesn't happend because it only creates one connection in the server.
I discover it because I'm getting the exception if the fake interface call and after 2 hours all services are using the whole memory. If you want I can send you a video with this.
I'm using mORMot to connect more than 10 branches and replicate data between them. It is a lot of data and it is replicated in real-time. All my method services are enclose in try-except so those exceptions are not mine. The is a bug deep inside mORMot. If you want I would like to do paid session with you to fix this. I'm in a lot of troubles because I replaced Rem Objects with mORMot and now we are collapsed.
function TServiceIntegrador.Consulta(aComando : RawJSON; var aNav : RawJSON) : RawJSON;
var NavRec : TConsultaNav;
begin
try
if TServerIntegrador.LogVerbose=1 then
TLogProc.WriteLogMemo(format('Consulta(In) = Comando=%s', [aComando]));
NavRec.FromJSON(aNav);
Connect;
Result := TdmDataHandle.ExportData(DB, StringToUTF8(aComando), NavRec);
aNav := NavRec.ToJSON;
if TServerIntegrador.LogVerbose=1 then
TLogProc.WriteLogMemo(format('Consulta(Out) = %s', [Result]));
except
on e:exception do TLogProc.WriteLogMemo('TServiceIntegrador.Consulta->'+e.Message);
end;
raise Exception.Create('Error raro desde el server'); <<<<<<<<<<<<<<<<<<<<<<<<<<< My exception
end;The real problem is the random iService.xxxx fake interface exception that is generated inside mORMot code and with this memory leaks is leaking all the memory.
#14 mORMot 1 » If you set compiler setting Emit RunTime Information you get this erro » 2014-03-28 21:32:52
- foncci
- Replies: 3
Hi ab,
[dcc32 Error] SynCrypto.pas(651): E2217 Published field 'OriginalLen' not a class or interface type
Last nightly build
XE5
{$A-} { packed memory structure }
/// internal header for storing our AES data with salt and CRC
TAESFullHeader = object
/// Len before compression (if any)
OriginalLen, <<<<<<<<<<<<<<<<<<<<<<<<< Error is here
/// Len before AES encoding
SourceLen,
/// Random Salt for better encryption
SomeSalt,
/// CRC from header
HeaderCheck: cardinal;
function Calc(const Key; KeySize: cardinal): cardinal;
end;
{$A+}And I get this exception with or without the Runtime information setting. All with the last nightly build.
I just updated to the last nightly build and now I get this exception in the client
20140328 13545509 ERROR TSQLHttpClientWinHTTP(0327C960) POST SERV_INTEGRADOR/ServiceIntegrador.Consulta returned 500 Internal Server Error with message { "ErrorCode":500, "ErrorText":"Exception EAccessViolation: Access violation at address 00713EF2 in module 'TestIntegrador.exe'. Read of address 00000500" } stack trace API 0037B334 mORMot.TSQLRestClientURI.URI (22896) 003A13A7 mORMot.TServiceFactoryClient.InternalInvoke (35145) 003A1230 mORMot.TServiceFactoryClient.Invoke (35115) 00397474 mORMot.InternalProcess (32403) 00397D2E mORMot.TInterfacedObjectFake.FakeCall (32522)After some tests I found that the exception is due to
TServiceIntegrador = class(TInterfacedObject, IServiceIntegrador)
public
function Consulta(aComando : string; var aNav : TConsultaNav) : string;
end
type
TConsultaNav = record
public
MaxRows, Row0, RowCount : int64;
IsSQLUpdateBack, EOF : boolean;
function Init(aMaxRows : int64) : TConsultaNav;
function InitNull : TConsultaNav;
Procedure Next;
function ToSQL : string;
function IsNotNull : boolean;
Procedure SetNull;
end;If I remove the record parameter the exception goes away, but it was working fine in the february version I was using. What have changed in mORMot?
#15 mORMot 1 » How to simulate a low speed network locally in my laptop » 2014-03-28 17:10:39
- foncci
- Replies: 3
I would like to simulate the delay of a wan network locally. This is my issue, I have several mORMot services in different branches talking to each others. I have some exceptions that I described in another post but when I do a simulation with the same data locally in my laptop, there are no such exceptions. It is impossible to install delphi and debug in those branches and my idea so far is that exceptions are due to the low speed of the internet connection. So any idea about that simulation?
#16 Re: mORMot 1 » Under some circumstances we get this exception » 2014-03-28 06:19:45
What I get in the server is
20140328 01335849 EXC EHttpApiServer ("HttpSendHttpResponse failed: Se ha intentado una operación en una conexión de red inexistente (1229)") at 003A43FA SynCrtSock.THttpApiServer.Execute (4393) stack trace 000CB374 System.Classes.Classes.ThreadProc 0000A03E System.ThreadWrapper
20140328 01344621 EXC EHttpApiServer ("HttpSendHttpResponse failed: Se ha intentado una operación en una conexión de red inexistente (1229)") at 003A43FA SynCrtSock.THttpApiServer.Execute (4393) stack trace 000CB374 System.Classes.Classes.ThreadProc 0000A03E System.ThreadWrapper
20140328 01353537 EXC EHttpApiServer ("HttpSendHttpResponse failed: Se ha intentado una operación en una conexión de red inexistente (1229)") at 003A43FA SynCrtSock.THttpApiServer.Execute (4393) stack trace 000CB374 System.Classes.Classes.ThreadProc 0000A03E System.ThreadWrapper
And in the client, the infamous exception:
20140328 01433852 EXC EOSError ("System Error. Code: 12002.\r\n") at 0002D317 System.SysUtils.SysUtils.RaiseLastOSError stack trace 0000A134 System.@NewAnsiString 0000AB60 System.@LStrCatN 00398E5B mORMot.TServiceFactoryClient.InternalInvoke (34459) 00005A62 System.@GetMem 0000A134 System.@NewAnsiString 00398CE4 mORMot.TServiceFactoryClient.Invoke (34429) 0038FC04 mORMot.InternalProcess (31827)
20140328 01433852 EXC EInterfaceFactoryException ("Invalid fake IServiceIntegrador.Consulta interface call: : ") at 0038F98E mORMot.RaiseError (31768) stack trace 000CB374 System.Classes.Classes.ThreadProc 0000A03E System.ThreadWrapper
20140328 01441319 EXC EOSError ("System Error. Code: 12002.\r\n") at 0002D317 System.SysUtils.SysUtils.RaiseLastOSError stack trace 0000A134 System.@NewAnsiString 0000AB60 System.@LStrCatN 00398E5B mORMot.TServiceFactoryClient.InternalInvoke (34459) 00005A62 System.@GetMem 0000A134 System.@NewAnsiString 00398CE4 mORMot.TServiceFactoryClient.Invoke (34429) 0038FC04 mORMot.InternalProcess (31827)
20140328 01441319 EXC EInterfaceFactoryException ("Invalid fake IServiceIntegrador.Consulta interface call: : ") at 0038F98E mORMot.RaiseError (31768) stack trace 000CB374 System.Classes.Classes.ThreadProc 0000A03E System.ThreadWrapper
Any help with this would be appreciated.
#17 Re: mORMot 1 » Under some circumstances we get this exception » 2014-03-22 06:19:59
High latency. We are in Venezuela and at some hours ADSL is terrible. Sometimes it just doesn't ping but it doesn't last long.
#18 Re: mORMot 1 » Under some circumstances we get this exception » 2014-03-20 23:28:15
The timeout is in 5 minutes. When I had it in 2 minutes these errors happens more often.
#19 Re: mORMot 1 » Under some circumstances we get this exception » 2014-03-20 20:42:00
Good news, SynCommons is OK and my JSON is OK too. I have logged my whole JSON to a file and it is perfect. What is happening is that when the connection fails in the middle of a method execution the server returns the "Invalid fake xxxx interface call:" and if the method is returning some JSON and it is incomplete, it adds "Invalid returned JSON content: expects {"result":...}" like in the example at the end. In future interactions the method executes OK and everything goes on.
This is my log,
I have a counter on how many times a method fails and here you have the results:
As you can see this exception is raised very often but it is not critical, on several interaction usually less than 5, the method is executed properly. The question is if the server is returning a proper error description.
DATE DATE PROCESS ERROR COUNT ERROR TEXT
02.02.2014 20:12 02.02.2014 20:15 3 Invalid fake IServiceIntegrador.UpdSQL interface call: :
02.02.2014 20:12 02.02.2014 20:29 3 Invalid fake IServiceIntegrador.UpdSQL interface call: :
03.02.2014 04:01 03.02.2014 05:32 22 Invalid fake IServiceIntegrador.UpdSQL interface call: :
03.02.2014 11:09 03.02.2014 15:01 25 Invalid fake IServiceIntegrador.ExecAnySQL interface call: :
03.02.2014 11:09 05.02.2014 00:22 37 Invalid fake IServiceIntegrador.ExecAnySQL interface call: :
03.02.2014 11:09 03.02.2014 11:45 1 Invalid fake IServiceIntegrador.ExecAnySQL interface call: :
03.02.2014 11:36 03.02.2014 12:12 1 Invalid fake IServiceIntegrador.ExecAnySQL interface call: :
03.02.2014 14:55 03.02.2014 15:01 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
03.02.2014 15:18 03.02.2014 15:52 5 Invalid fake IServiceIntegrador.UpdSQL interface call: :
03.02.2014 15:18 03.02.2014 15:37 3 Invalid fake IServiceIntegrador.UpdSQL interface call: :
03.02.2014 15:18 03.02.2014 15:37 3 Invalid fake IServiceIntegrador.UpdSQL interface call: :
12.02.2014 13:35 12.02.2014 13:38 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
12.02.2014 16:16 12.02.2014 16:18 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
13.02.2014 12:03 13.02.2014 12:08 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
14.02.2014 05:01 16.02.2014 04:36 1 Invalid fake IServiceIntegrador.Consulta interface call: :
14.02.2014 05:01 20.02.2014 18:26 5 Invalid fake IServiceIntegrador.Consulta interface call: :
14.02.2014 05:01 20.02.2014 18:26 5 Invalid fake IServiceIntegrador.Consulta interface call: Invalid returned JSON content: expects {"result":...}
14.02.2014 15:39 20.02.2014 18:26 5 Invalid fake IServiceIntegrador.Consulta interface call: :
14.02.2014 15:39 20.02.2014 18:26 5 Invalid fake IServiceIntegrador.Consulta interface call: Invalid returned JSON content: expects {"result":...}
15.02.2014 05:03 20.02.2014 18:26 5 Invalid fake IServiceIntegrador.Consulta interface call: :
15.02.2014 05:03 20.02.2014 18:26 5 Invalid fake IServiceIntegrador.Consulta interface call: Invalid returned JSON content: expects {"result":...}
15.02.2014 11:10 20.02.2014 18:26 5 Invalid fake IServiceIntegrador.Consulta interface call: Invalid returned JSON content: expects {"result":...}
16.02.2014 05:01 20.02.2014 18:26 5 Invalid fake IServiceIntegrador.Consulta interface call: :
16.02.2014 05:01 20.02.2014 18:26 5 Invalid fake IServiceIntegrador.Consulta interface call: Invalid returned JSON content: expects {"result":...}
16.02.2014 05:10 20.02.2014 18:26 5 Invalid fake IServiceIntegrador.Consulta interface call: :
17.02.2014 05:03 20.02.2014 18:26 5 Invalid fake IServiceIntegrador.Consulta interface call: :
17.02.2014 05:03 20.02.2014 18:26 5 Invalid fake IServiceIntegrador.Consulta interface call: Invalid returned JSON content: expects {"result":...}
18.02.2014 05:01 20.02.2014 18:26 5 Invalid fake IServiceIntegrador.Consulta interface call: :
18.02.2014 05:01 20.02.2014 18:26 5 Invalid fake IServiceIntegrador.Consulta interface call: Invalid returned JSON content: expects {"result":...}
19.02.2014 05:00 19.02.2014 05:11 20 Invalid fake IServiceIntegrador.Consulta interface call: Invalid returned JSON content: expects {"result":...}
20.02.2014 08:39 20.02.2014 08:48 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
24.02.2014 14:14 25.02.2014 13:24 1 Invalid fake IServiceIntegrador.Consulta interface call: :
24.02.2014 14:14 25.02.2014 13:24 1 Invalid fake IServiceIntegrador.Consulta interface call: :
24.02.2014 14:14 25.02.2014 13:24 1 Invalid fake IServiceIntegrador.Consulta interface call: :
24.02.2014 19:00 25.02.2014 13:24 1 Invalid fake IServiceIntegrador.ExecAnySQL interface call: :
25.02.2014 10:12 25.02.2014 13:24 1 Invalid fake IServiceIntegrador.Consulta interface call: :
25.02.2014 11:01 25.02.2014 13:24 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
25.02.2014 11:01 25.02.2014 13:24 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
25.02.2014 11:01 25.02.2014 13:24 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
25.02.2014 11:01 25.02.2014 13:24 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
25.02.2014 15:40 25.02.2014 15:45 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
26.02.2014 11:12 26.02.2014 11:16 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
27.02.2014 08:43 27.02.2014 08:46 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
28.02.2014 09:21 07.03.2014 14:23 1 Invalid fake IServiceIntegrador.ExecAnySQL interface call: :
28.02.2014 09:21 07.03.2014 14:23 1 Invalid fake IServiceIntegrador.Consulta interface call: :
28.02.2014 10:03 07.03.2014 14:23 1 Invalid fake IServiceIntegrador.Consulta interface call: :
28.02.2014 10:03 07.03.2014 14:23 1 Invalid fake IServiceIntegrador.Consulta interface call: :
28.02.2014 10:03 07.03.2014 14:23 1 Invalid fake IServiceIntegrador.Consulta interface call: :
28.02.2014 10:03 07.03.2014 14:23 1 Invalid fake IServiceIntegrador.Consulta interface call: :
28.02.2014 10:03 07.03.2014 14:23 1 Invalid fake IServiceIntegrador.Consulta interface call: :
28.02.2014 10:03 07.03.2014 14:23 1 Invalid fake IServiceIntegrador.Consulta interface call: :
28.02.2014 10:03 07.03.2014 14:24 1 Invalid fake IServiceIntegrador.Consulta interface call: :
28.02.2014 10:03 07.03.2014 14:25 1 Invalid fake IServiceIntegrador.Consulta interface call: :
28.02.2014 10:03 07.03.2014 14:25 1 Invalid fake IServiceIntegrador.Consulta interface call: :
28.02.2014 10:03 07.03.2014 14:25 1 Invalid fake IServiceIntegrador.Consulta interface call: :
28.02.2014 10:03 07.03.2014 14:25 1 Invalid fake IServiceIntegrador.Consulta interface call: :
28.02.2014 10:03 07.03.2014 14:25 1 Invalid fake IServiceIntegrador.Consulta interface call: :
28.02.2014 10:03 07.03.2014 14:25 1 Invalid fake IServiceIntegrador.Consulta interface call: :
01.03.2014 09:33 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.Consulta interface call: :
01.03.2014 09:33 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.Consulta interface call: :
01.03.2014 09:33 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.Consulta interface call: :
01.03.2014 09:33 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.Consulta interface call: :
01.03.2014 09:33 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.Consulta interface call: :
01.03.2014 09:33 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.Consulta interface call: :
05.03.2014 16:47 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:47 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:26 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:27 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:28 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:48 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:29 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:49 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:50 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:50 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:50 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:50 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:50 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:50 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:53 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:53 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:53 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:53 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:53 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:53 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:53 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:53 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:53 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:53 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:53 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:53 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:53 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:53 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:53 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:57 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:58 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.Consulta interface call: :
05.03.2014 16:58 07.03.2014 14:30 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 16:58 07.03.2014 14:40 1 Invalid fake IServiceIntegrador.Consulta interface call: :
05.03.2014 16:58 07.03.2014 14:40 1 Invalid fake IServiceIntegrador.Consulta interface call: :
05.03.2014 16:58 07.03.2014 14:40 1 Invalid fake IServiceIntegrador.Consulta interface call: :
05.03.2014 16:58 07.03.2014 14:40 1 Invalid fake IServiceIntegrador.Consulta interface call: :
05.03.2014 16:58 07.03.2014 14:40 1 Invalid fake IServiceIntegrador.Consulta interface call: :
05.03.2014 16:58 07.03.2014 14:40 1 Invalid fake IServiceIntegrador.Consulta interface call: :
05.03.2014 17:04 07.03.2014 14:40 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 17:10 07.03.2014 14:40 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 17:13 07.03.2014 14:40 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 17:28 07.03.2014 14:40 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 17:42 07.03.2014 14:41 1 Invalid fake IServiceIntegrador.ExecAnySQL interface call: :
05.03.2014 17:43 07.03.2014 14:40 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 18:08 07.03.2014 14:40 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 18:18 07.03.2014 14:41 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 18:25 07.03.2014 14:41 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 18:26 07.03.2014 14:42 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 18:29 07.03.2014 14:41 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 18:36 07.03.2014 14:41 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 18:37 07.03.2014 14:41 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
05.03.2014 19:34 07.03.2014 14:42 1 Invalid fake IServiceIntegrador.Consulta interface call: :
05.03.2014 19:36 07.03.2014 14:42 1 Invalid fake IServiceIntegrador.Consulta interface call: :
06.03.2014 05:02 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.Consulta interface call: :
06.03.2014 05:02 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.Consulta interface call: :
06.03.2014 05:02 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.Consulta interface call: :
06.03.2014 05:02 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.Consulta interface call: :
06.03.2014 05:02 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.Consulta interface call: :
06.03.2014 05:02 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.Consulta interface call: :
06.03.2014 08:37 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 09:02 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 09:06 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 09:13 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 09:15 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 09:42 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 09:47 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 09:51 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 09:54 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 10:01 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 10:12 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 10:12 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 10:12 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 10:12 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 10:12 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 10:12 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 10:12 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 10:12 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 10:22 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 10:30 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 10:32 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 10:32 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 10:35 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 11:07 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 11:09 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 11:18 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 11:21 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 11:23 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 11:26 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 11:32 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 11:37 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 11:39 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 11:43 07.03.2014 14:49 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 11:47 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 11:50 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 11:59 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 12:00 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 12:03 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 12:10 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 12:16 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 12:16 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 12:25 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 12:31 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 12:46 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 12:52 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 12:52 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 13:07 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 13:09 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 13:10 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 13:10 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 13:11 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 13:13 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 13:16 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 13:29 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 13:57 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 14:15 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 14:32 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 14:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 14:41 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 14:57 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 14:57 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:36 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:36 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:36 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:36 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:36 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:36 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:36 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:36 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:36 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:36 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:36 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:36 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:36 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:36 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:36 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:36 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:36 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:36 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:36 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:36 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:36 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:36 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:37 07.03.2014 14:50 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 15:45 07.03.2014 14:51 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 16:02 07.03.2014 14:51 1 Invalid fake IServiceIntegrador.ExecAnySQL interface call: :
06.03.2014 16:09 07.03.2014 14:51 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 16:10 07.03.2014 14:51 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 16:11 07.03.2014 14:51 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 16:14 07.03.2014 14:51 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 16:29 07.03.2014 14:51 1 Invalid fake IServiceIntegrador.ExecAnySQL interface call: :
06.03.2014 16:33 07.03.2014 14:51 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
06.03.2014 16:48 07.03.2014 14:51 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
10.03.2014 09:58 10.03.2014 10:42 1 Invalid fake IServiceIntegrador.ExecAnySQL interface call: :
10.03.2014 10:25 10.03.2014 19:46 569 Invalid fake IServiceIntegrador.Consulta interface call: Invalid returned JSON content: expects {"result":...}
11.03.2014 19:08 11.03.2014 20:06 1 Invalid fake IServiceIntegrador.Consulta interface call: :
13.03.2014 05:00 17.03.2014 15:55 1 Invalid fake IServiceIntegrador.Consulta interface call: Invalid returned JSON content: expects {"result":...}
14.03.2014 12:40 14.03.2014 16:58 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
17.03.2014 14:47 17.03.2014 15:40 1 Invalid fake IServiceIntegrador.Consulta interface call: :
17.03.2014 14:48 17.03.2014 16:00 4 Invalid fake IServiceIntegrador.Consulta interface call: :
17.03.2014 15:36 17.03.2014 16:23 1 Invalid fake IServiceIntegrador.Consulta interface call: :
17.03.2014 17:48 17.03.2014 18:40 5 Invalid fake IServiceIntegrador.Consulta interface call: Invalid returned JSON content: expects {"result":...}
17.03.2014 17:48 17.03.2014 18:41 5 Invalid fake IServiceIntegrador.Consulta interface call: Invalid returned JSON content: expects {"result":...}
17.03.2014 18:08 17.03.2014 19:01 1 Invalid fake IServiceIntegrador.ExecAnySQL interface call: :
17.03.2014 18:09 17.03.2014 19:15 1 Invalid fake IServiceIntegrador.Consulta interface call: :
17.03.2014 18:09 17.03.2014 19:15 1 Invalid fake IServiceIntegrador.Consulta interface call: :
17.03.2014 18:11 17.03.2014 19:15 1 Invalid fake IServiceIntegrador.ExecAnySQLArr interface call: :
17.03.2014 18:44 17.03.2014 19:15 2 Invalid fake IServiceIntegrador.UpdSQL interface call: :
18.03.2014 15:47 18.03.2014 18:52 85 Invalid fake IServiceIntegrador.Consulta interface call: Invalid returned JSON content: expects {"result":...}
18.03.2014 17:22 18.03.2014 18:52 18 Invalid fake IServiceIntegrador.Consulta interface call: Invalid returned JSON content: expects {"result":...}
18.03.2014 17:22 18.03.2014 22:33 1 Invalid fake IServiceIntegrador.Consulta interface call: Invalid returned JSON content: expects {"result":...}
19.03.2014 08:46 19.03.2014 08:53 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
19.03.2014 08:48 19.03.2014 08:56 2 Invalid fake IServiceIntegrador.UpdSQL interface call: :
19.03.2014 09:04 19.03.2014 09:06 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
19.03.2014 09:07 19.03.2014 09:11 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
19.03.2014 09:10 19.03.2014 09:13 1 Invalid fake IServiceIntegrador.UpdSQL interface call: :
19.03.2014 09:14 19.03.2014 09:21 2 Invalid fake IServiceIntegrador.UpdSQL interface call: : #20 Re: mORMot 1 » Under some circumstances we get this exception » 2014-03-18 22:54:00
I have validated all json from SO. I save it to a file and next validate it on the web and it is always valid. This is really weird because it happens ramdomly. Again, JSON data is ok and the exception said it is not. I think we have a bug in SynCommons.
<code>
20140318 15464851 + TSQLHttpServer(0316AE98).003A6202 mORMotHttpServer.TSQLHttpServer.Create (420)
20140318 15464852 trace TSQLRestServerFullMemory(030A6580).BeginCurrentThread(THttpApiServer(038B6480)) ThreadID=4240 ThreadCount=1
20140318 15464852 trace TSQLRestServerFullMemory(030A6580).BeginCurrentThread(THttpApiServer(038B6580)) ThreadID=8064 ThreadCount=2
20140318 15464853 trace TSQLRestServerFullMemory(030A6580).BeginCurrentThread(THttpApiServer(038B6600)) ThreadID=1480 ThreadCount=3
20140318 15464853 info TSQLHttpServer(0316AE98) THttpApiServer(038B6500) initialized at http://localhost/SERV_INTEGRADOR:8880
20140318 15464853 - 00.051.172
20140318 15464853 trace TSQLRestServerFullMemory(030A6580).BeginCurrentThread(THttpApiServer(038B6680)) ThreadID=6024 ThreadCount=4
20140318 15465123 + TSQLHttpClientWinHTTP(030B74B0).TimeStamp
20140318 15465123 + TSQLHttpClientWinHTTP(030B74B0).003D5031 mORMotHttpClient.TSQLHttpClientGeneric.InternalURI (303)
20140318 15465310 clnt TSQLHttpClientWinHTTP(030B74B0) GET SERV_INTEGRADOR/TimeStamp status=200 state=0
20140318 15465310 - 01.784.398
20140318 15465310 ret 135167945646
20140318 15465310 - 01.784.415
20140318 15465310 + TSQLHttpClientWinHTTP(030B74B0).auth
20140318 15465310 + TSQLHttpClientWinHTTP(030B74B0).003D5031 mORMotHttpClient.TSQLHttpClientGeneric.InternalURI (303)
20140318 15465321 clnt TSQLHttpClientWinHTTP(030B74B0) GET SERV_INTEGRADOR/auth?UserName=anonymous status=200 state=0
20140318 15465321 - 00.189.259
20140318 15465321 ret {"result":"daf942eb65abb86f6e94ef905c94faf2e46e7877d604f23f15beb07e6be2ea10"}
20140318 15465321 - 00.189.279
20140318 15465321 + TSQLHttpClientWinHTTP(030B74B0).auth
20140318 15465321 + TSQLHttpClientWinHTTP(030B74B0).003D5031 mORMotHttpClient.TSQLHttpClientGeneric.InternalURI (303)
20140318 15465333 clnt TSQLHttpClientWinHTTP(030B74B0) GET SERV_INTEGRADOR/auth?UserName=anonymous&Password=5124b1d7c4a2e6fa4b47353ee9d02e53e1995b5cf1c4d7b30ac2126d59b1cab4&ClientNonce=2ea111b9f81f7210fefea434e9a0ba054543754d83ce8368156138f22eb36134 status=200 state=0
20140318 15465333 - 00.188.931
20140318 15465333 ret {"result":"1556657296+8d677fca26c70ed8d2d642ad2af8f8181e41ebe006a8cb27f6799b4ec5175a50","logonname":"anonymous"}
20140318 15465333 - 00.188.963
20140318 15465333 + TServiceFactoryClient(052F69D0).ServiceIntegrador._contract_
20140318 15465333 + TSQLHttpClientWinHTTP(030B74B0).003D5031 mORMotHttpClient.TSQLHttpClientGeneric.InternalURI (303)
20140318 15465347 clnt TSQLHttpClientWinHTTP(030B74B0) POST SERV_INTEGRADOR/ServiceIntegrador._contract_?session_signature=5CC8B4900001A3D6F6583443 status=200 state=0
20140318 15465347 - 00.221.181
20140318 15465347 ret {"result":{"contract":"CBB48168DB791632"}}
20140318 15465347 - 00.221.203
20140318 15465347 + TServiceFactoryClient(052F69D0).ServiceIntegrador.ExecAnySQL
20140318 15465347 + TSQLHttpClientWinHTTP(030B74B0).003D5031 mORMotHttpClient.TSQLHttpClientGeneric.InternalURI (303)
20140318 15465425 clnt TSQLHttpClientWinHTTP(030B74B0) POST SERV_INTEGRADOR/ServiceIntegrador.ExecAnySQL?session_signature=5CC8B4900001A3D797EC4BCE status=200 state=0
20140318 15465425 - 00.634.218
20140318 15465425 ret {"result":{},"id":1528}
20140318 15465425 - 00.634.242
20140318 15465425 + TSQLHttpClientWinHTTP(030B74B0).auth
20140318 15465425 + TSQLHttpClientWinHTTP(030B74B0).003D5031 mORMotHttpClient.TSQLHttpClientGeneric.InternalURI (303)
20140318 15465437 clnt TSQLHttpClientWinHTTP(030B74B0) GET SERV_INTEGRADOR/auth?UserName=anonymous&Session=1556657296&session_signature=5CC8B4900001A3DAEF46D888 status=200 state=0
20140318 15465437 - 00.182.908
20140318 15465437 - 00.182.933
20140318 15475040 + TSQLHttpClientWinHTTP(030B74B0).TimeStamp
20140318 15475040 + TSQLHttpClientWinHTTP(030B74B0).003D5031 mORMotHttpClient.TSQLHttpClientGeneric.InternalURI (303)
20140318 15475052 clnt TSQLHttpClientWinHTTP(030B74B0) GET SERV_INTEGRADOR/TimeStamp status=200 state=0
20140318 15475052 - 00.201.473
20140318 15475052 ret 135167945708
20140318 15475052 - 00.201.491
20140318 15475052 + TSQLHttpClientWinHTTP(030B74B0).auth
20140318 15475052 + TSQLHttpClientWinHTTP(030B74B0).003D5031 mORMotHttpClient.TSQLHttpClientGeneric.InternalURI (303)
20140318 15475102 clnt TSQLHttpClientWinHTTP(030B74B0) GET SERV_INTEGRADOR/auth?UserName=anonymous status=200 state=0
20140318 15475102 - 00.184.860
20140318 15475102 ret {"result":"daf942eb65abb86f6e94ef905c94faf2e46e7877d604f23f15beb07e6be2ea10"}
20140318 15475102 - 00.184.921
20140318 15475102 + TSQLHttpClientWinHTTP(030B74B0).auth
20140318 15475102 + TSQLHttpClientWinHTTP(030B74B0).003D5031 mORMotHttpClient.TSQLHttpClientGeneric.InternalURI (303)
20140318 15475114 clnt TSQLHttpClientWinHTTP(030B74B0) GET SERV_INTEGRADOR/auth?UserName=anonymous&Password=5124b1d7c4a2e6fa4b47353ee9d02e53e1995b5cf1c4d7b30ac2126d59b1cab4&ClientNonce=2ea111b9f81f7210fefea434e9a0ba054543754d83ce8368156138f22eb36134 status=200 state=0
20140318 15475114 - 00.200.167
20140318 15475114 ret {"result":"1556657298+bf47fb44805da166b61899d5ec469b9a264aa6f171c7c52d5e0686d87053766a","logonname":"anonymous"}
20140318 15475114 - 00.200.198
20140318 15475114 + TServiceFactoryClient(052F5F50).ServiceIntegrador._contract_
20140318 15475114 + TSQLHttpClientWinHTTP(030B74B0).003D5031 mORMotHttpClient.TSQLHttpClientGeneric.InternalURI (303)
20140318 15475129 clnt TSQLHttpClientWinHTTP(030B74B0) POST SERV_INTEGRADOR/ServiceIntegrador._contract_?session_signature=5CC8B4920001A4B8FE5A255C status=200 state=0
20140318 15475129 - 00.233.309
20140318 15475129 ret {"result":{"contract":"CBB48168DB791632"}}
20140318 15475129 - 00.233.330
20140318 15475354 + TServiceFactoryClient(052F5F50).ServiceIntegrador.Consulta
20140318 15475354 + TSQLHttpClientWinHTTP(030B74B0).003D5031 mORMotHttpClient.TSQLHttpClientGeneric.InternalURI (303)
20140318 15502640 clnt TSQLHttpClientWinHTTP(030B74B0) POST SERV_INTEGRADOR/ServiceIntegrador.Consulta?session_signature=5CC8B4920001A4C2DC0294A8 status=200 state=0
20140318 15502640 - 99.775.275
20140318 15502640 ret {"result":{"aNav":"AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA=","Result":{"VENTAS":{"JSON_RECORD_COUNT":670,"JSON_DATA":[[1000532622,30,"NULL",318264,"NULL","NULL","NULL","NULL","NULL",20,41715.3576613079,41715.3576613079,"NULL",41715.3577278588,"NULL","NULL",0,4.96,4.96,0,4.43,0.53,0,0,1.14,0,0,0,0,1,1,1,"NULL",161671,"NULL","NULL","NULL","NULL","NULL",104,342,"NULL",1,1000017379,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532623,30,"NULL",318267,"NULL","NULL","NULL","NULL","NULL",20,41715.3630222685,41715.3630222685,"NULL",41715.3633866782,"NULL","NULL",0,140.26,140.26,140.26,0,0,0,0,31.23,0,0,0,0,1,1,1,"NULL",161671,"NULL","NULL","NULL","NULL","NULL",104,342,"NULL",1,1000017379,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532624,30,"NULL",318265,"NULL","NULL","NULL","NULL","NULL",20,41715.3584696875,41715.3584696875,"NULL",41715.3586279282,"NULL","NULL",0,145.51,145.51,145.51,0,0,0,0,31.29,0,0,0,0,1,1,1,"NULL",159303,"NULL","NULL","NULL","NULL","NULL",102,342,"NULL",1,1000017379,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532626,30,"NULL",318266,"NULL","NULL","NULL","NULL","NULL",20,41715.3628381713,41715.3628381713,"NULL",41715.3628801273,"NULL","NULL",0,96.98,96.98,96.98,0,0,0,0,24.09,0,0,0,0,1,1,1,"NULL",115274,"NULL","NULL","NULL","NULL","NULL",102,305,"NULL",1,1000017380,"NULL","NULL",0,"NULL","NULL",2,"NULL"],[1000532627,30,"NULL",318268,"NULL","NULL","NULL","NULL","NULL",20,41715.3635962731,41715.3635962731,"NULL",41715.3636622801,"NULL","NULL",0,135.05,135.05,135.05,0,0,0,0,19.64,0,0,0,0,1,1,1,"NULL",163714,"NULL","NULL","NULL","NULL","NULL",102,305,"NULL",1,1000017380,"NULL","NULL",0,"NULL","NULL",2,"NULL"],[1000532628,30,"NULL",318269,"NULL","NULL","NULL","NULL","NULL",20,41715.3643270718,41715.3643270718,"NULL",41715.3644478704,"NULL","NULL",0,394.19,394.19,394.19,0,0,0,0,84.48,0,0,0,0,1,1,1,"NULL",164700,"NULL","NULL","NULL","NULL","NULL",104,342,"NULL",1,1000017379,"NULL","NULL",0,"NULL","NULL",4,"NULL"],[1000532629,30,"NULL",318270,"NULL","NULL","NULL","NULL","NULL",20,41715.3648536921,41715.3648536921,"NULL",41715.3649489931,"NULL","NULL",0,327.17,327.17,327.17,0,0,0,0,35.99,0,0,0,0,1,1,1,"NULL",115274,"NULL","NULL","NULL","NULL","NULL",102,305,"NULL",1,1000017380,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532631,30,"NULL",318271,"NULL","NULL","NULL","NULL","NULL",20,41715.3655524769,41715.3655524769,"NULL",41715.3655915394,"NULL","NULL",0,71.71,71.71,71.71,0,0,0,0,12.2,0,0,0,0,1,1,1,"NULL",159303,"NULL","NULL","NULL","NULL","NULL",104,342,"NULL",1,1000017379,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532632,30,"NULL",318273,"NULL","NULL","NULL","NULL","NULL",20,41715.3679971412,41715.3679971412,"NULL",41715.3685261111,"NULL","NULL",0,266.29,266.29,266.29,0,0,0,0,46.79,0,0,0,0,1,1,1,"NULL",115274,"NULL","NULL","NULL","NULL","NULL",102,305,"NULL",1,1000017380,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532633,30,"NULL",318272,"NULL","NULL","NULL","NULL","NULL",20,41715.3675949421,41715.3675949421,"NULL",41715.3676399653,"NULL","NULL",0,42.13,42.13,42.13,0,0,0,0,22.13,0,0,0,0,1,1,1,"NULL",159303,"NULL","NULL","NULL","NULL","NULL",104,342,"NULL",1,1000017379,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532634,30,"NULL",318274,"NULL","NULL","NULL","NULL","NULL",20,41715.3696108102,41715.3696108102,"NULL",41715.3699752199,"NULL","NULL",0,358.39,358.39,358.39,0,0,0,0,67.61,0,0,0,0,1,1,1,"NULL",159303,"NULL","NULL","NULL","NULL","NULL",104,342,"NULL",1,1000017379,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532635,30,"NULL",318325,"NULL","NULL","NULL","NULL","NULL",20,41715.4236673495,41715.4236673495,"NULL",41715.4237123727,"NULL","NULL",0,111.52,111.52,111.52,0,0,0,0,22.15,0,0,0,0,1,1,1,"NULL",115274,"NULL","NULL","NULL","NULL","NULL",102,305,"NULL",1,1000017380,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532636,30,"NULL",318275,"NULL","NULL","NULL","NULL","NULL",20,41715.3711838079,41715.3711838079,"NULL",41715.3712272106,"NULL","NULL",0,69,69,69,0,0,0,0,12.04,0,0,0,0,1,1,1,"NULL",115274,"NULL","NULL","NULL","NULL","NULL",102,305,"NULL",1,1000017380,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532637,30,"NULL",318276,"NULL","NULL","NULL","NULL","NULL",20,41715.3713315509,41715.3713315509,"NULL",41715.3713697107,"NULL","NULL",0,72.75,72.75,72.75,0,0,0,0,13.03,0,0,0,0,1,1,1,"NULL",159303,"NULL","NULL","NULL","NULL","NULL",104,342,"NULL",1,1000017379,"NULL","NULL",0,"NULL","NULL",2,"NULL"],[1000532638,30,"NULL",318279,"NULL","NULL","NULL","NULL","NULL",20,41715.3730139583,41715.3730139583,"NULL",41715.3730542824,"NULL","NULL",0,84.67,84.67,84.67,0,0,0,0,11.5,0,0,0,0,1,1,1,"NULL",115274,"NULL","NULL","NULL","NULL","NULL",102,305,"NULL",1,1000017380,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532639,20,117117,"NULL","NULL","NULL","NULL","Z1A8127214",1408,20,41715.3652546296,"NULL","NULL",41715.3723866088,"NULL","NULL",0,345.86,345.86,345.86,0,0,0,0,123.48,0,0,0,0,1,1,1,"NULL",23019,"NULL","NULL","NULL","NULL","NULL",102,305,"NULL",1,1000017380,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532640,30,"NULL",318277,"NULL","NULL","NULL","NULL","NULL",20,41715.372103044,41715.372103044,"NULL",41715.3721692245,"NULL","NULL",0,10.29,10.29,5.33,4.43,0.53,0,0,2.49,0,0,0,0,1,1,1,"NULL",15867,"NULL","NULL","NULL","NULL","NULL",104,342,"NULL",1,1000017379,"NULL","NULL",0,"NULL","NULL",2,"NULL"],[1000532641,30,"NULL",318278,"NULL","NULL","NULL","NULL","NULL",20,41715.3727048958,41715.3727048958,"NULL",41715.3727548032,"NULL","NULL",0,30.14,30.14,30.14,0,0,0,0,16.88,0,0,0,0,1,1,1,"NULL",128691,"NULL","NULL","NULL","NULL","NULL",104,342,"NULL",1,1000017379,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532642,20,117121,"NULL","NULL","NULL","NULL","Z1A8127214",1408,20,41715.4147569444,"NULL","NULL",41715.421860706,"NULL","NULL",0,468.2,468.2,468.2,0,0,0,0,76.52,0,0,0,0,1,1,1,"NULL",31730,"NULL","NULL","NULL","NULL","NULL",102,305,"NULL",1,1000017380,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532643,30,"NULL",318280,"NULL","NULL","NULL","NULL","NULL",20,41715.3747936458,41715.3747936458,"NULL",41715.3748408449,"NULL","NULL",0,512.7,512.7,512.7,0,0,0,0,86.68,0,0,0,0,1,1,1,"NULL",161671,"NULL","NULL","NULL","NULL","NULL",104,342,"NULL",1,1000017379,"NULL","NULL",0,"NULL","NULL",2,"NULL"],[1000532644,30,"NULL",318286,"NULL","NULL","NULL","NULL","NULL",20,41715.3789680903,41715.3789680903,"NULL",41715.3790404282,"NULL","NULL",0,416.44,416.44,416.44,0,0,0,0,109.65,0,0,0,0,1,1,1,"NULL",115274,"NULL","NULL","NULL","NULL","NULL",102,305,"NULL",1,1000017380,"NULL","NULL",0,"NULL","NULL",3,"NULL"],[1000532645,30,"NULL",318282,"NULL","NULL","NULL","NULL","NULL",20,41715.3760599306,41715.3760599306,"NULL",41715.3761584838,"NULL","NULL",0,25.28,25.28,25.28,0,0,0,0,10.13,0,0,0,0,1,1,1,"NULL",3861,"NULL","NULL","NULL","NULL","NULL",101,265,"NULL",1,1000017443,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532646,30,"NULL",318281,"NULL","NULL","NULL","NULL","NULL",20,41715.3758553935,41715.3758553935,"NULL",41715.3758942708,"NULL","NULL",0,4.96,4.96,0,4.43,0.53,0,0,1.14,0,0,0,0,1,1,1,"NULL",104980,"NULL","NULL","NULL","NULL","NULL",104,342,"NULL",1,1000017379,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532647,30,"NULL",318283,"NULL","NULL","NULL","NULL","NULL",20,41715.3767059028,41715.3767059028,"NULL",41715.3767507523,"NULL","NULL",0,227.78,227.78,227.78,0,0,0,0,56.19,0,0,0,0,1,1,1,"NULL",159303,"NULL","NULL","NULL","NULL","NULL",104,342,"NULL",1,1000017379,"NULL","NULL",0,"NULL","NULL",3,"NULL"],[1000532648,30,"NULL",318287,"NULL","NULL","NULL","NULL","NULL",20,41715.3792225463,41715.3792225463,"NULL",41715.379284213,"NULL","NULL",0,40.14,40.14,40.14,0,0,0,0,4.57,0,0,0,0,1,1,1,"NULL",3861,"NULL","NULL","NULL","NULL","NULL",101,265,"NULL",1,1000017443,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532649,30,"NULL",318284,"NULL","NULL","NULL","NULL","NULL",20,41715.3785610069,41715.3785610069,"NULL",41715.3786078472,"NULL","NULL",0,250.84,250.84,250.84,0,0,0,0,109.81,0,0,0,0,1,1,1,"NULL",159303,"NULL","NULL","NULL","NULL","NULL",104,342,"NULL",1,1000017379,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532650,30,"NULL",318285,"NULL","NULL","NULL","NULL","NULL",20,41715.3788912384,41715.3788912384,"NULL",41715.3789373495,"NULL","NULL",0,53.52,53.52,53.52,0,0,0,0,7.92,0,0,0,0,1,1,1,"NULL",159303,"NULL","NULL","NULL","NULL","NULL",104,342,"NULL",1,1000017379,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532651,30,"NULL",318288,"NULL","NULL","NULL","NULL","NULL",20,41715.3813221528,41715.3813221528,"NULL",41715.3813581366,"NULL","NULL",0,34.23,34.23,34.23,0,0,0,0,16.14,0,0,0,0,1,1,1,"NULL",163714,"NULL","NULL","NULL","NULL","NULL",102,305,"NULL",1,1000017380,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532652,30,"NULL",318292,"NULL","NULL","NULL","NULL","NULL",20,41715.3864581481,41715.3864581481,"NULL",41715.386514213,"NULL","NULL",0,162.12,162.12,162.12,0,0,0,0,33.04,0,0,0,0,1,1,1,"NULL",4012,"NULL","NULL","NULL","NULL","NULL",104,342,"NULL",1,1000017379,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532653,30,"NULL",318294,"NULL","NULL","NULL","NULL","NULL",20,41715.3885687847,41715.3885687847,"NULL",41715.3886187037,"NULL","NULL",0,70.49,70.49,70.49,0,0,0,0,19.61,0,0,0,0,1,1,1,"NULL",3861,"NULL","NULL","NULL","NULL","NULL",101,265,"NULL",1,1000017443,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532654,30,"NULL",318289,"NULL","NULL","NULL","NULL","NULL",20,41715.3820777199,41715.3820777199,"NULL",41715.3821126273,"NULL","NULL",0,97.48,97.48,97.48,0,0,0,0,16.94,0,0,0,0,1,1,1,"NULL",40268,"NULL","NULL","NULL","NULL","NULL",102,305,"NULL",1,1000017380,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532655,30,"NULL",318290,"NULL","NULL","NULL","NULL","NULL",20,41715.3830063542,41715.3830063542,"NULL",41715.3830437963,"NULL","NULL",0,41.24,41.24,41.24,0,0,0,0,6.33,0,0,0,0,1,1,1,"NULL",115274,"NULL","NULL","NULL","NULL","NULL",102,305,"NULL",1,1000017380,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532656,20,117118,"NULL","NULL","NULL","NULL","Z1A8127214",1408,20,41715.3775462963,"NULL","NULL",41715.3846652546,"NULL","NULL",0,264.32,264.32,264.32,0,0,0,0,87.41,0,0,0,0,1,1,1,"NULL",74754,"NULL","NULL","NULL","NULL","NULL",101,265,"NULL",1,1000017443,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532657,30,"NULL",318291,"NULL","NULL","NULL","NULL","NULL",20,41715.3849376042,41715.3849376042,"NULL",41715.384979375,"NULL","NULL",0,62.01,62.01,62.01,0,0,0,0,13.21,0,0,0,0,1,1,1,"NULL",115274,"NULL","NULL","NULL","NULL","NULL",102,305,"NULL",1,1000017380,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532659,20,117119,"NULL","NULL","NULL","NULL","Z1A8127214",1408,20,41715.3784722222,"NULL","NULL",41715.3855776157,"NULL","NULL",0,9.33,9.33,9.33,0,0,0,0,2.77,0,0,0,0,1,1,1,"NULL",3861,"NULL","NULL","NULL","NULL","NULL",101,265,"NULL",1,1000017443,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532660,30,"NULL",318293,"NULL","NULL","NULL","NULL","NULL",20,41715.3869417245,41715.3869417245,"NULL",41715.3869994097,"NULL","NULL",0,229.51,229.51,229.51,0,0,0,0,67.14,0,0,0,0,1,1,1,"NULL",115274,"NULL","NULL","NULL","NULL","NULL",102,305,"NULL",1,1000017380,"NULL","NULL",0,"NULL","NULL",3,"NULL"],[1000532661,20,117120,"NULL","NULL","NULL","NULL","Z1A8127214",1408,20,41715.406724537,"NULL","NULL",41715.4138433102,"NULL","NULL",0,269.28,269.28,269.28,0,0,0,0,75.26,0,0,0,0,1,1,1,"NULL",2187,"NULL","NULL","NULL","NULL","NULL",101,265,"NULL",1,1000017443,"NULL","NULL",0,"NULL","NULL",2,"NULL"],[1000532662,30,"NULL",318296,"NULL","NULL","NULL","NULL","NULL",20,41715.3902370833,41715.3902370833,"NULL",41715.3902678241,"NULL","NULL",0,261.26,261.26,261.26,0,0,0,0,64.55,0,0,0,0,1,1,1,"NULL",115274,"NULL","NULL","NULL","NULL","NULL",102,305,"NULL",1,1000017380,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532663,30,"NULL",318299,"NULL","NULL","NULL","NULL","NULL",20,41715.3947484375,41715.3947484375,"NULL",41715.3947941898,"NULL","NULL",0,638.01,638.01,638.01,0,0,0,0,113.73,0,0,0,0,1,1,1,"NULL",164704,"NULL","NULL","NULL","NULL","NULL",104,342,"NULL",1,1000017379,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532664,30,"NULL",318295,"NULL","NULL","NULL","NULL","NULL",20,41715.389113125,41715.389113125,"NULL",41715.3891599653,"NULL","NULL",0,135.81,135.81,135.81,0,0,0,0,26.56,0,0,0,0,1,1,1,"NULL",3861,"NULL","NULL","NULL","NULL","NULL",101,265,"NULL",1,1000017443,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532665,30,"NULL",318297,"NULL","NULL","NULL","NULL","NULL",20,41715.3932221065,41715.3932221065,"NULL",41715.3932559259,"NULL","NULL",0,109.79,109.79,109.79,0,0,0,0,27.79,0,0,0,0,1,1,1,"NULL",163714,"NULL","NULL","NULL","NULL","NULL",102,305,"NULL",1,1000017380,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532666,30,"NULL",318298,"NULL","NULL","NULL","NULL","NULL",20,41715.3944442593,41715.3944442593,"NULL",41715.3945261806,"NULL","NULL",0,167.17,167.17,167.17,0,0,0,0,36.62,0,0,0,0,1,1,1,"NULL",3861,"NULL","NULL","NULL","NULL","NULL",101,265,"NULL",1,1000017443,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532667,30,"NULL",318300,"NULL","NULL","NULL","NULL","NULL",20,41715.3948269213,41715.3948269213,"NULL",41715.3948670718,"NULL","NULL",0,617.41,617.41,617.41,0,0,0,0,132.44,0,0,0,0,1,1,1,"NULL",40268,"NULL","NULL","NULL","NULL","NULL",102,305,"NULL",1,1000017380,"NULL","NULL",0,"NULL","NULL",2,"NULL"],[1000532668,30,"NULL",318305,"NULL","NULL","NULL","NULL","NULL",20,41715.4024028819,41715.4024028819,"NULL",41715.4024621991,"NULL","NULL",0,70.39,70.39,70.39,0,0,0,0,11.51,0,0,0,0,1,1,1,"NULL",3861,"NULL","NULL","NULL","NULL","NULL",101,265,"NULL",1,1000017443,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532669,30,"NULL",318301,"NULL","NULL","NULL","NULL","NULL",20,41715.3952933218,41715.3952933218,"NULL",41715.3953351042,"NULL","NULL",0,9.29,9.29,9.29,0,0,0,0,0.92,0,0,0,0,1,1,1,"NULL",115274,"NULL","NULL","NULL","NULL","NULL",102,305,"NULL",1,1000017380,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532670,30,"NULL",318302,"NULL","NULL","NULL","NULL","NULL",20,41715.3962348032,41715.3962348032,"NULL",41715.3963310069,"NULL","NULL",0,62.01,62.01,62.01,0,0,0,0,13.21,0,0,0,0,1,1,1,"NULL",161671,"NULL","NULL","NULL","NULL","NULL",104,342,"NULL",1,1000017379,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532671,30,"NULL",318303,"NULL","NULL","NULL","NULL","NULL",20,41715.3964686343,41715.3964686343,"NULL",41715.3965001042,"NULL","NULL",0,28.85,28.85,0,25.76,3.09,0,0,8.8,0,0,0,0,1,1,1,"NULL",115274,"NULL","NULL","NULL","NULL","NULL",102,305,"NULL",1,1000017380,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532672,30,"NULL",318304,"NULL","NULL","NULL","NULL","NULL",20,41715.4014923264,41715.4014923264,"NULL",41715.4015417014,"NULL","NULL",0,159.18,159.18,136.29,20.44,2.45,0,0,28.8,0,0,0,0,1,1,1,"NULL",161671,"NULL","NULL","NULL","NULL","NULL",104,342,"NULL",1,1000017379,"NULL","NULL",0,"NULL","NULL",4,"NULL"],[1000532673,30,"NULL",318306,"NULL","NULL","NULL","NULL","NULL",20,41715.40279875,41715.40279875,"NULL",41715.4028441435,"NULL","NULL",0,116.43,116.43,116.43,0,0,0,0,20.06,0,0,0,0,1,1,1,"NULL",115274,"NULL","NULL","NULL","NULL","NULL",102,305,"NULL",1,1000017380,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532674,30,"NULL",318308,"NULL","NULL","NULL","NULL","NULL",20,41715.4037771181,41715.4037771181,"NULL",41715.4038346296,"NULL","NULL",0,60.75,60.75,60.75,0,0,0,0,9.92,0,0,0,0,1,1,1,"NULL",107119,"NULL","NULL","NULL","NULL","NULL",104,342,"NULL",1,1000017379,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532675,30,"NULL",318307,"NULL","NULL","NULL","NULL","NULL",20,41715.4031512153,41715.4031512153,"NULL",41715.4031944329,"NULL","NULL",0,137.98,137.98,137.98,0,0,0,0,22.55,0,0,0,0,1,1,1,"NULL",3861,"NULL","NULL","NULL","NULL","NULL",101,265,"NULL",1,1000017443,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532676,30,"NULL",318309,"NULL","NULL","NULL","NULL","NULL",20,41715.4039165509,41715.4039165509,"NULL",41715.4039567014,"NULL","NULL",0,81.81,81.81,81.81,0,0,0,0,16.54,0,0,0,0,1,1,1,"NULL",115274,"NULL","NULL","NULL","NULL","NULL",102,305,"NULL",1,1000017380,"NULL","NULL",0,"NULL","NULL",2,"NULL"],[1000532677,30,"NULL",318310,"NULL","NULL","NULL","NULL","NULL",20,41715.4042965046,41715.4042965046,"NULL",41715.4043748148,"NULL","NULL",0,59.28,59.28,59.28,0,0,0,0,25.91,0,0,0,0,1,1,1,"NULL",3861,"NULL","NULL","NULL","NULL","NULL",101,265,"NULL",1,1000017443,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532678,30,"NULL",318317,"NULL","NULL","NULL","NULL","NULL",20,41715.4145247338,41715.4145247338,"NULL",41715.4145598148,"NULL","NULL",0,467.94,467.94,467.94,0,0,0,0,69.23,0,0,0,0,1,1,1,"NULL",159303,"NULL","NULL","NULL","NULL","NULL",104,342,"NULL",1,1000017379,"NULL","NULL",0,"NULL","NULL",2,"NULL"],[1000532679,30,"NULL",318312,"NULL","NULL","NULL","NULL","NULL",20,41715.4051316435,41715.4051316435,"NULL",41715.4052063426,"NULL","NULL",0,126.13,126.13,126.13,0,0,0,0,32.25,0,0,0,0,1,1,1,"NULL",115274,"NULL","NULL","NULL","NULL","NULL",102,305,"NULL",1,1000017380,"NULL","NULL",0,"NULL","NULL",2,"NULL"],[1000532680,30,"NULL",318311,"NULL","NULL","NULL","NULL","NULL",20,41715.405093125,41715.405093125,"NULL",41715.4051455787,"NULL","NULL",0,10.12,10.12,10.12,0,0,0,0,4.11,0,0,0,0,1,1,1,"NULL",3861,"NULL","NULL","NULL","NULL","NULL",101,265,"NULL",1,1000017443,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532681,30,"NULL",318313,"NULL","NULL","NULL","NULL","NULL",20,41715.4076754167,41715.4076754167,"NULL",41715.407779213,"NULL","NULL",0,141.4,141.4,141.4,0,0,0,0,40.7,0,0,0,0,1,1,1,"NULL",3861,"NULL","NULL","NULL","NULL","NULL",101,265,"NULL",1,1000017443,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532682,30,"NULL",318314,"NULL","NULL","NULL","NULL","NULL",20,41715.4081262616,41715.4081262616,"NULL",41715.4081750926,"NULL","NULL",0,102.49,102.49,102.49,0,0,0,0,17.55,0,0,0,0,1,1,1,"NULL",115274,"NULL","NULL","NULL","NULL","NULL",102,305,"NULL",1,1000017380,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532683,30,"NULL",318315,"NULL","NULL","NULL","NULL","NULL",20,41715.4089577894,41715.4089577894,"NULL",41715.4090080556,"NULL","NULL",0,20.49,20.49,20.49,0,0,0,0,5.35,0,0,0,0,1,1,1,"NULL",3861,"NULL","NULL","NULL","NULL","NULL",101,265,"NULL",1,1000017443,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532684,30,"NULL",318318,"NULL","NULL","NULL","NULL","NULL",20,41715.4148108333,41715.4148108333,"NULL",41715.4148535069,"NULL","NULL",0,29.77,29.77,0,26.58,3.19,0,0,6.83,0,0,0,0,1,1,1,"NULL",3861,"NULL","NULL","NULL","NULL","NULL",101,265,"NULL",1,1000017443,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532685,20,4721,"NULL","NULL","NULL","NULL","Z1B8031571",183,20,41715.4184027778,"NULL","NULL","NULL","NULL","NULL",60,863.63,863.63,863.63,0,0,0,0,439.69,0,0,3243716.13,0,1,1,0,"NULL",68555,"NULL","NULL",162872,162872,"63368280",106,110,"NULL",1,1000017391,"NULL","NULL",0,"NULL","NULL",2,"NULL"],[1000532686,30,"NULL",318316,"NULL","NULL","NULL","NULL","NULL",20,41715.413629375,41715.413629375,"NULL",41715.4137031597,"NULL","NULL",0,175.66,175.66,175.66,0,0,0,0,27.72,0,0,0,0,1,1,1,"NULL",163714,"NULL","NULL","NULL","NULL","NULL",102,305,"NULL",1,1000017380,"NULL","NULL",0,"NULL","NULL",2,"NULL"],[1000532687,20,117122,"NULL","NULL","NULL","NULL","Z1A8127214",1408,20,41715.4169791667,"NULL","NULL",41715.4240812963,"NULL","NULL",0,122.79,122.79,122.79,0,0,0,0,27.04,0,0,0,0,1,1,1,"NULL",62439,"NULL","NULL","NULL","NULL","NULL",101,265,"NULL",1,1000017443,"NULL","NULL",0,"NULL","NULL",3,"NULL"],[1000532688,30,"NULL",318321,"NULL","NULL","NULL","NULL","NULL",20,41715.4175663657,41715.4175663657,"NULL",41715.4178676505,"NULL","NULL",0,23.6,23.6,23.6,0,0,0,0,4.47,0,0,0,0,1,1,1,"NULL",115274,"NULL","NULL","NULL","NULL","NULL",102,305,"NULL",1,1000017380,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532689,30,"NULL",318319,"NULL","NULL","NULL","NULL","NULL",20,41715.4166089699,41715.4166089699,"NULL",41715.4166491204,"NULL","NULL",0,46.85,46.85,46.85,0,0,0,0,7.65,0,0,0,0,1,1,1,"NULL",139654,"NULL","NULL","NULL","NULL","NULL",101,265,"NULL",1,1000017443,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532690,30,"NULL",318320,"NULL","NULL","NULL","NULL","NULL",20,41715.4170209375,41715.4170209375,"NULL",41715.4170822454,"NULL","NULL",0,25.28,25.28,25.28,0,0,0,0,10.13,0,0,0,0,1,1,1,"NULL",3861,"NULL","NULL","NULL","NULL","NULL",101,265,"NULL",1,1000017443,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532691,30,"NULL",318322,"NULL","NULL","NULL","NULL","NULL",20,41715.4188272106,41715.4188272106,"NULL",41715.4190335532,"NULL","NULL",0,82.35,82.35,82.35,0,0,0,0,15.6,0,0,0,0,1,1,1,"NULL",159303,"NULL","NULL","NULL","NULL","NULL",104,342,"NULL",1,1000017379,"NULL","NULL",0,"NULL","NULL",1,"NULL"],[1000532
20140318 15502640 - 99.779.492
20140318 15504048 EXC EInterfaceFactoryException ("Invalid fake IServiceIntegrador.Consulta interface call: Invalid returned JSON content: expects {\"result\":...}") at 0038F986 mORMot.RaiseError (31767) stack trace 000CB374 System.Classes.Classes.ThreadProc 0000A03E System.ThreadWrapper
</code>
#21 Re: mORMot 1 » Under some circumstances we get this exception » 2014-02-28 15:00:15
Again it works for me.
I would like to submit an image of it but I don't know how.
#22 Re: mORMot 1 » Under some circumstances we get this exception » 2014-02-28 13:11:34
I just added "{}" to your json and {"format": "12\", EP, Ltd"} is perfectly validated in http://json.parser.online.fr
#23 Re: mORMot 1 » Under some circumstances we get this exception » 2014-02-27 08:55:26
JSon is created using SuperObjects, I made a method to serialize a TDataSet descendant and that's the output. Returned JSon have been validated with this page http://json.parser.online.fr/.
I think I found the issue,
First I had
Result := StringToUTF8(ResJson.AsJSon); AsJson is a function that returns an string
I changed it to
TmpStr := ResJson.AsJSon;
Result := StringToUTF8(TmpStr);
using TmpStr as a temporal string variable the problem is gone. Maybe StringToUTF8 has some minor bug when a function is passed as a parameter.
This is the definition of my function:
function Consulta(aComando : RawJSON; var aNav : int64) : RawJSON;
Enabling Logging causes a lot of access violations in this code:
while (PtrUInt(stack)<max_stack) do begin
st := stack^;
if ((st>max_stack) or (st<min_stack)) and
not IsBadReadPtr(pointer(st-8),12) and
((pByte(st-5)^=$E8) or check2(st)) then begin
TSynMapFile.Log(fWriter,st); // will ignore any TSynLog.* methods
dec(depth);
if depth=0 then break;
end;#24 Re: mORMot 1 » Under some circumstances we get this exception » 2014-02-26 05:24:17
Here you have,
+ TSQLHttpServer(02F9A998).002E61DE mORMotHttpServer.TSQLHttpServer.Create (420)
20140226 00273545 trace TSQLRestServerFullMemory(02ECF080).BeginCurrentThread(THttpApiServer(036132C0)) ThreadID=7028 ThreadCount=1
20140226 00273545 trace TSQLRestServerFullMemory(02ECF080).BeginCurrentThread(THttpApiServer(03613340)) ThreadID=6332 ThreadCount=2
20140226 00273545 info TSQLHttpServer(02F9A998) THttpApiServer(03613240) initialized at http://localhost/SERV_INTEGRADOR:8880
20140226 00273545 - 00.047.945
20140226 00273547 trace TSQLRestServerFullMemory(02ECF080).BeginCurrentThread(THttpApiServer(036133C0)) ThreadID=4240 ThreadCount=3
20140226 00273547 trace TSQLRestServerFullMemory(02ECF080).BeginCurrentThread(THttpApiServer(03613440)) ThreadID=1732 ThreadCount=4
20140226 00273932 + TSQLHttpClientWinHTTP(02EEFBE0).TimeStamp
20140226 00273932 + TSQLHttpClientWinHTTP(02EEFBE0).0034F39D mORMotHttpClient.TSQLHttpClientGeneric.InternalURI (303)
20140226 00273960 clnt TSQLHttpClientWinHTTP(02EEFBE0) GET SERV_INTEGRADOR/TimeStamp status=200 state=0
20140226 00273960 - 00.455.349
20140226 00273960 ret 135164724903
20140226 00273960 - 00.455.365
20140226 00273960 + TSQLHttpClientWinHTTP(02EEFBE0).auth
20140226 00273960 + TSQLHttpClientWinHTTP(02EEFBE0).0034F39D mORMotHttpClient.TSQLHttpClientGeneric.InternalURI (303)
20140226 00274008 clnt TSQLHttpClientWinHTTP(02EEFBE0) GET SERV_INTEGRADOR/auth?UserName=anonymous status=200 state=0
20140226 00274008 - 00.162.598
20140226 00274008 ret {"result":"d40bb43b67f3c44b271128addc04f5ee0987755cf956cfd045779cf7b02eb17f"}
20140226 00274008 - 00.162.619
20140226 00274008 + TSQLHttpClientWinHTTP(02EEFBE0).auth
20140226 00274008 + TSQLHttpClientWinHTTP(02EEFBE0).0034F39D mORMotHttpClient.TSQLHttpClientGeneric.InternalURI (303)
20140226 00274018 clnt TSQLHttpClientWinHTTP(02EEFBE0) GET SERV_INTEGRADOR/auth?UserName=anonymous&Password=cbca160ed444f4eab43cdf1168c10749b9d92676d5bf4b361f0b0bc204972b7b&ClientNonce=1fc3bd4778fdfdaea679fe9d9da2bf8a30ce49e7a9e477c602c0ae68da9f57b6 status=200 state=0
20140226 00274018 - 00.155.689
20140226 00274018 ret {"result":"106498865+11a1cf92c44aac97111ee95b7a859409c37cf3fa71ae403f3662e9228d23c600","logonname":"anonymous"}
20140226 00274018 - 00.155.719
20140226 00274018 + TServiceFactoryClient(036ABFC8).ServiceIntegrador._contract_
20140226 00274018 + TSQLHttpClientWinHTTP(02EEFBE0).0034F39D mORMotHttpClient.TSQLHttpClientGeneric.InternalURI (303)
20140226 00274028 clnt TSQLHttpClientWinHTTP(02EEFBE0) POST SERV_INTEGRADOR/ServiceIntegrador._contract_?session_signature=06590B310002518618BCC67A status=200 state=0
20140226 00274028 - 00.161.467
20140226 00274028 ret {"result":{"contract":"FCAE8344209F2589"}}
20140226 00274028 - 00.161.489
20140226 00274239 + TServiceFactoryClient(036ABFC8).ServiceIntegrador.Consulta
20140226 00274239 + TSQLHttpClientWinHTTP(02EEFBE0).0034F39D mORMotHttpClient.TSQLHttpClientGeneric.InternalURI (303)
20140226 00274528 clnt TSQLHttpClientWinHTTP(02EEFBE0) POST SERV_INTEGRADOR/ServiceIntegrador.Consulta?session_signature=06590B310002518F17BA0175 status=200 state=0
20140226 00274528 - 02.832.242
20140226 00274528 ret {"result":{"Result":{"ESTADISTICAS_PROD_PERIODO":{"JSON_RECORD_COUNT":10635,"JSON_DATA":[[5000000001,2753,0,0,0,0,0,0,0,0,0,0,0,1,17.848,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000002,16274,0,0,0,0,0,0,0,0,0,0,0,1,17.82,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000003,924,0,0,0,0,0,0,0,0,0,0,0,1,7.7268,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000004,21163,0,0,0,0,0,0,0,0,0,0,0,1,67.97,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000005,20954,0,0,0,0,0,0,0,0,0,0,0,1,21.09,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000006,20953,0,0,0,0,0,0,0,0,0,0,0,1,28.3734,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000007,20955,0,0,0,0,0,0,0,0,0,0,0,1,34.9767,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000008,2003,0,0,0,0,0,0,0,0,0,0,0,1,98.6624,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000009,6246,0,0,0,0,0,0,0,0,0,0,0,1,120.9879,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000010,6021,0,0,0,0,0,0,0,0,0,0,0,1,146.813,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000011,17815,0,0,0,0,0,0,0,0,0,0,0,1,119.43,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000012,18532,0,0,0,0,0,0,0,0,0,0,0,1,1,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000013,18531,0,0,0,0,0,0,0,0,0,0,0,1,1.5,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000014,17638,0,0,0,0,0,0,0,0,0,0,0,1,1.29,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000015,18600,0,0,0,0,0,0,0,0,0,0,0,1,1.29,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000016,18529,0,0,0,0,0,0,0,0,0,0,0,1,2.29,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000017,21341,0,0,0,0,0,0,0,0,0,0,0,1,20.2554,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000018,21462,0,0,0,0,0,0,0,0,0,0,0,1,20.2554,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000019,21333,0,0,0,0,0,0,0,0,0,0,0,1,20.2554,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000020,3486,0,0,0,0,0,0,0,0,0,0,0,1,25.6312,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000021,2148,0,0,0,0,0,0,0,0,0,0,0,1,84.1582,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000022,6220,0,0,0,0,0,0,0,0,0,0,0,1,107.489,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000023,2152,0,0,0,0,0,0,0,0,0,0,0,1,131.0577,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000024,2764,0,0,0,0,0,0,0,0,0,0,0,1,21.3624,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000025,635,0,0,0,0,0,0,0,0,0,0,0,1,214.9592,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000026,636,0,0,0,0,0,0,0,0,0,0,0,1,272.8256,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000027,13658,0,0,0,0,0,0,0,0,0,0,0,1,196.79,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000028,5932,0,0,0,0,0,0,0,0,0,0,0,1,122.9802,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000029,27732,0,0,0,0,0,0,0,0,0,0,0,1,150.6605,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000030,20092,0,0,0,0,0,0,0,0,0,0,0,1,212.1486,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000031,6022,0,0,0,0,0,0,0,0,0,0,0,1,226.493,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000032,27734,0,0,0,0,0,0,0,0,0,0,0,1,194.721,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000033,21511,0,0,0,0,0,0,0,0,0,0,0,1,10.7456,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000034,15855,0,0,0,0,0,0,0,0,0,0,0,1,13.46,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000035,3884,0,0,0,0,0,0,0,0,0,0,0,1,0.83,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000036,21450,0,0,0,0,0,0,0,0,0,0,0,1,10.3776,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000037,2734,0,0,0,0,0,0,0,0,0,0,0,1,16.9952,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000038,18107,0,0,0,0,0,0,0,0,0,0,0,1,1.43,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000039,14354,0,0,0,0,0,0,0,0,0,0,0,1,12.784,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000040,19342,0,0,0,0,0,0,0,0,0,0,0,1,7.53,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000041,1226,0,0,0,0,0,0,0,0,0,0,0,1,1.34,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000042,1224,0,0,0,0,0,0,0,0,0,0,0,1,17.3994,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000043,18024,0,0,0,0,0,0,0,0,0,0,0,1,13.376,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000044,4145,0,0,0,0,0,0,0,0,0,0,0,1,26.273,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000045,18003,0,0,0,0,0,0,0,0,0,0,0,1,2.6038,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000046,5050,0,0,0,0,0,0,0,0,0,0,0,1,5.53,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000047,448,0,0,0,0,0,0,0,0,0,0,0,1,1.42,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000048,6023,0,0,0,0,0,0,0,0,0,0,0,1,12.7098,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000049,5868,0,0,0,0,0,0,0,0,0,0,0,1,1.5697,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000050,1585,0,0,0,0,0,0,0,0,0,0,0,1,11.6884,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000051,4762,0,0,0,0,0,0,0,0,0,0,0,1,4.0595,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000052,5642,0,0,0,0,0,0,0,0,0,0,0,1,55.1592,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000053,5153,0,0,0,0,0,0,0,0,0,0,0,1,2.7,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000054,2080,0,0,0,0,0,0,0,0,0,0,0,1,10,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000055,2083,0,0,0,0,0,0,0,0,0,0,0,1,15,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000056,2085,0,0,0,0,0,0,0,0,0,0,0,1,1.5698,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000057,1461,0,0,0,0,0,0,0,0,0,0,0,1,24.5058,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000058,1435,0,0,0,0,0,0,0,0,0,0,0,1,17.672,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000059,5525,0,0,0,0,0,0,0,0,0,0,0,1,22.0242,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000060,1436,0,0,0,0,0,0,0,0,0,0,0,1,1.4475,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000061,4887,0,0,0,0,0,0,0,0,0,0,0,1,10.968,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000062,4321,0,0,0,0,0,0,0,0,0,0,0,1,25.41,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000063,1355,0,0,0,0,0,0,0,0,0,0,0,1,40.19,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000064,435,0,0,0,0,0,0,0,0,0,0,0,1,68.29,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000065,4010,0,0,0,0,0,0,0,0,0,0,0,1,64.14,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000066,334,0,0,0,0,0,0,0,0,0,0,0,1,110.07,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000067,5395,0,0,0,0,0,0,0,0,0,0,0,1,150.9255,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000068,27330,0,0,0,0,0,0,0,0,0,0,0,1,104.5,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000069,5284,0,0,0,0,0,0,0,0,0,0,0,1,69.78,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000070,5300,0,0,0,0,0,0,0,0,0,0,0,1,22.93,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000071,1088,0,0,0,0,0,0,0,0,0,0,0,1,166.0416,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000072,1090,0,0,0,0,0,0,0,0,0,0,0,1,222.5074,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000073,6024,0,0,0,0,0,0,0,0,0,0,0,1,219.5165,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000074,5239,0,0,0,0,0,0,0,0,0,0,0,1,199.092,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000075,20809,0,0,0,0,0,0,0,0,0,0,0,1,17.4141,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000076,18960,0,0,0,0,0,0,0,0,0,0,0,1,29.26,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000077,18958,0,0,0,0,0,0,0,0,0,0,0,1,17.4141,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000078,27458,0,0,0,0,0,0,0,0,0,0,0,1,22.91,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000079,18961,0,0,0,0,0,0,0,0,0,0,0,1,29.26,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000080,14321,0,0,0,0,0,0,0,0,0,0,0,12,17.32,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000081,816,0,0,0,0,0,0,0,0,0,0,0,12,153.22,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000082,33207,0,0,0,0,0,0,0,0,0,0,0,12,97.9198,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000083,6025,0,0,0,0,0,0,0,0,0,0,0,6,52.123,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000084,26006,0,0,0,0,0,0,0,0,0,0,0,1,4.2,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000085,34348,0,0,0,0,0,0,0,0,0,0,0,12,128.97,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000086,4894,0,0,0,0,0,0,0,0,0,0,0,12,78.4242,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000087,14319,0,0,0,0,0,0,0,0,0,0,0,12,79.4112,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000088,18230,0,0,0,0,0,0,0,0,0,0,0,1,32.33,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000089,32436,0,0,0,0,0,0,0,0,0,0,0,6,30.74,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000090,817,0,0,0,0,0,0,0,0,0,0,0,12,206.9128,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000091,33996,0,0,0,0,0,0,0,0,0,0,0,12,247.114,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000092,22847,0,0,0,0,0,0,0,0,0,0,0,1,4.2,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000093,18547,0,0,0,0,0,0,0,0,0,0,0,1,0.88,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000094,24596,0,0,0,0,0,0,0,0,0,0,0,1,4.2,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000095,13894,0,0,0,0,0,0,0,0,0,0,0,12,109.181,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000096,18797,0,0,0,0,0,0,0,0,0,0,0,6,51.5986,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000097,4870,0,0,0,0,0,0,0,0,0,0,0,12,87.12,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000098,1912,0,0,0,0,0,0,0,0,0,0,0,1,18.9525,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000099,15094,0,0,0,0,0,0,0,0,0,0,0,1,4.2,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000100,33923,0,0,0,0,0,0,0,0,0,0,0,1,213.83,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000101,3828,0,0,0,0,0,0,0,0,0,0,0,1,68.6388,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000102,4669,0,0,0,0,0,0,0,0,0,0,0,1,66.6366,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000103,2466,0,0,0,0,0,0,0,0,0,0,0,1,28.3128,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000104,16209,0,0,0,0,0,0,0,0,0,0,0,1,0.76,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000105,16211,0,0,0,0,0,0,0,0,0,0,0,1,1.34,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000106,16248,0,0,0,0,0,0,0,0,0,0,0,1,5.9005,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000107,34270,0,0,0,0,0,0,0,0,0,0,0,1,17.4,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000108,20062,0,0,0,0,0,0,0,0,0,0,0,1,13.51,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000109,13815,0,0,0,0,0,0,0,0,0,0,0,1,1.55,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000110,13841,0,0,0,0,0,0,0,0,0,0,0,1,0.76,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000111,20694,0,0,0,0,0,0,0,0,0,0,0,1,11.7208,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000112,1671,0,0,0,0,0,0,0,0,0,0,0,1,1.67,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000113,1667,0,0,0,0,0,0,0,0,0,0,0,25,5.15,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000114,1809,0,0,0,0,0,0,0,0,0,0,0,1,1.5426,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000115,14998,0,0,0,0,0,0,0,0,0,0,0,1,2.55,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000116,5000,0,0,0,0,0,0,0,0,0,0,0,1,6.0325,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000117,6404,0,0,0,0,0,0,0,0,0,0,0,1,11.0351,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000118,123,0,0,0,0,0,0,0,0,0,0,0,1,5.7716,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000119,4878,0,0,0,0,0,0,0,0,0,0,0,1,3.9159,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000120,1565,0,0,0,0,0,0,0,0,0,0,0,1,1.4302,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000121,35069,0,0,0,0,0,0,0,0,0,0,0,1,1.6245,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000122,3087,0,0,0,0,0,0,0,0,0,0,0,1,1.5496,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000123,16692,0,0,0,0,0,0,0,0,0,0,0,1,20.57,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000124,3092,0,0,0,0,0,0,0,0,0,0,0,1,14.52,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000125,24928,0,0,0,0,0,0,0,0,0,0,0,1,6.2792,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000126,19975,0,0,0,0,0,0,0,0,0,0,0,1,0.66,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000127,20319,0,0,0,0,0,0,0,0,0,0,0,1,1.41,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000128,34030,0,0,0,0,0,0,0,0,0,0,0,1,33.22,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000129,31788,0,0,0,0,0,0,0,0,0,0,0,1,6.1006,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000130,20112,0,0,0,0,0,0,0,0,0,0,0,1,5.22,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000131,3883,0,0,0,0,0,0,0,0,0,0,0,1,12.8122,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000132,34646,0,0,0,0,0,0,0,0,0,0,0,1,16.321,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000133,25133,0,0,0,0,0,0,0,0,0,0,0,1,4.59,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000134,4155,0,0,0,0,0,0,0,0,0,0,0,1,16.3936,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000135,2642,0,0,0,0,0,0,0,0,0,0,0,1,114.6424,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000136,2670,0,0,0,0,0,0,0,0,0,0,0,1,219.5021,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000137,2662,0,0,0,0,0,0,0,0,0,0,0,1,14.4242,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000138,2684,0,0,0,0,0,0,0,0,0,0,0,1,73.179,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000139,2641,0,0,0,0,0,0,0,0,0,0,0,1,3.3652,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000140,2640,0,0,0,0,0,0,0,0,0,0,0,1,2,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000141,2660,0,0,0,0,0,0,0,0,0,0,0,1,3.29,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000142,2643,0,0,0,0,0,0,0,0,0,0,0,1,74.865,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000143,13844,0,0,0,0,0,0,0,0,0,0,0,1,15.4677,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000144,1707,0,0,0,0,0,0,0,0,0,0,0,1,2.15,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000145,1714,0,0,0,0,0,0,0,0,0,0,0,1,12.972,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000146,139,0,0,0,0,0,0,0,0,0,0,0,1,53.0212,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000147,5645,0,0,0,0,0,0,0,0,0,0,0,1,15.4724,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000148,230,0,0,0,0,0,0,0,0,0,0,0,1,18.5617,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000149,1507,0,0,0,0,0,0,0,0,0,0,0,1,15.4724,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000150,1545,0,0,0,0,0,0,0,0,0,0,0,1,6.31,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000151,1580,0,0,0,0,0,0,0,0,0,0,0,1,1.482,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000152,1611,0,0,0,0,0,0,0,0,0,0,0,1,0.83,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000153,2350,0,0,0,0,0,0,0,0,0,0,0,1,2.47,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000154,2349,0,0,0,0,0,0,0,0,0,0,0,1,15.4724,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000155,28111,0,0,0,0,0,0,0,0,0,0,0,1,2.3777,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000156,668,0,0,0,0,0,0,0,0,0,0,0,1,29.0415,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000157,666,0,0,0,0,0,0,0,0,0,0,0,1,37.4532,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000158,649,0,0,0,0,0,0,0,0,0,0,0,1,71.478,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000159,667,0,0,0,0,0,0,0,0,0,0,0,1,26.4005,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000160,5646,0,0,0,0,0,0,0,0,0,0,0,1,17.86,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000161,5082,0,0,0,0,0,0,0,0,0,0,0,1,4,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000162,5083,0,0,0,0,0,0,0,0,0,0,0,1,8.6177,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000163,35542,0,0,0,0,0,0,0,0,0,0,0,12,69.1,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000164,1201,0,0,0,0,0,0,0,0,0,0,0,25,137.9638,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000165,29182,0,0,0,0,0,0,0,0,0,0,0,25,55.8642,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000166,822,0,0,0,0,0,0,0,0,0,0,0,24,150.4282,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000167,5616,0,0,0,0,0,0,0,0,0,0,0,1,9.4335,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000168,5617,0,0,0,0,0,0,0,0,0,0,0,1,12.863,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000169,4775,0,0,0,0,0,0,0,0,0,0,0,1,12.39,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000170,35389,0,0,0,0,0,0,0,0,0,0,0,1,91.8324,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000171,6027,0,0,0,0,0,0,0,0,0,0,0,1,39.2638,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000172,6028,0,0,0,0,0,0,0,0,0,0,0,1,4411.1098,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000173,15637,0,0,0,0,0,0,0,0,0,0,0,1,5.624,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000174,1990,0,0,0,0,0,0,0,0,0,0,0,1,5.624,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000175,2768,0,0,0,0,0,0,0,0,0,0,0,1,37.5342,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000176,2769,0,0,0,0,0,0,0,0,0,0,0,1,16.3936,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000177,2783,0,0,0,0,0,0,0,0,0,0,0,1,24.5613,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000178,2782,0,0,0,0,0,0,0,0,0,0,0,1,35.7012,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000179,2131,0,0,0,0,0,0,0,0,0,0,0,1,125.0294,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000180,4867,0,0,0,0,0,0,0,0,0,0,0,1,73.91,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000181,4735,0,0,0,0,0,0,0,0,0,0,0,1,180.7902,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000182,3943,0,0,0,0,0,0,0,0,0,0,0,1,13.3254,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000183,17673,0,0,0,0,0,0,0,0,0,0,0,1,5.86,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000184,3942,0,0,0,0,0,0,0,0,0,0,0,1,12.5433,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000185,1724,0,0,0,0,0,0,0,0,0,0,0,1,85.2931,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000186,164,0,0,0,0,0,0,0,0,0,0,0,1,139.62,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000187,150,0,0,0,0,0,0,0,0,0,0,0,1,174.0083,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000188,151,0,0,0,0,0,0,0,0,0,0,0,1,320.5264,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000189,4724,0,0,0,0,0,0,0,0,0,0,0,1,199.842,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000190,4725,0,0,0,0,0,0,0,0,0,0,0,1,205.9446,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000191,107,0,0,0,0,0,0,0,0,0,0,0,1,155.7905,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000192,108,0,0,0,0,0,0,0,0,0,0,0,1,116.55,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000193,192,0,0,0,0,0,0,0,0,0,0,0,1,53.8338,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000194,962,0,0,0,0,0,0,0,0,0,0,0,1,59.267,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000195,6029,0,0,0,0,0,0,0,0,0,0,0,1,27.8073,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000196,5831,0,0,0,0,0,0,0,0,0,0,0,1,27.5215,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000197,5508,0,0,0,0,0,0,0,0,0,0,0,1,64.108,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000198,1102,0,0,0,0,0,0,0,0,0,0,0,1,6.2416,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000199,18533,0,0,0,0,0,0,0,0,0,0,0,1,4.29,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000200,2863,0,0,0,0,0,0,0,0,0,0,0,1,67.8413,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000201,3587,0,0,0,0,0,0,0,0,0,0,0,1,110.68,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000202,3589,0,0,0,0,0,0,0,0,0,0,0,1,171.1176,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000203,3591,0,0,0,0,0,0,0,0,0,0,0,1,149.42,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000204,363,0,0,0,0,0,0,0,0,0,0,0,1,12.1695,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000205,22118,0,0,0,0,0,0,0,0,0,0,0,1,58.49,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000206,22105,0,0,0,0,0,0,0,0,0,0,0,1,13.98,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000207,13367,0,0,0,0,0,0,0,0,0,0,0,1,31.31,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000208,13355,0,0,0,0,0,0,0,0,0,0,0,1,13.34,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000209,19598,0,0,0,0,0,0,0,0,0,0,0,1,13.37,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000210,5001,0,0,0,0,0,0,0,0,0,0,0,1,69.4848,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000211,6030,0,0,0,0,0,0,0,0,0,0,0,1,8.2626,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000212,14957,0,0,0,0,0,0,0,0,0,0,0,1,116.49,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000213,4911,0,0,0,0,0,0,0,0,0,0,0,1,13.4232,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000214,378,0,0,0,0,0,0,0,0,0,0,0,1,16.7475,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000215,4910,0,0,0,0,0,0,0,0,24,0,0,1,182.36,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000216,373,0,0,0,0,0,0,0,0,0,0,0,1,66.42,0,"NULL","NULL",0,0,41640,41694.6666666667,5],[5000000217,4914,0,0,0,0,0,0,0,0,24
20140226 00274529 - 02.841.037
20140226 00274529 EXC EInterfaceFactoryException ("Invalid fake IServiceIntegrador.Consulta interface call: Invalid returned JSON content: expects {\"result\":...}") at 002CFA0E mORMot.RaiseError (31760) stack trace 0005B1F5 System.Classes.Classes.ThreadProc 00007C0A System.ThreadWrapper
#25 mORMot 1 » Under some circumstances we get this exception » 2014-02-26 01:04:34
- foncci
- Replies: 17
Invalid fake IServiceIntegrador.Consulta interface call: Invalid returned JSON content: expects {"result":...}
Can you give me a tip on this? I get this exception randomly.
#26 Re: mORMot 1 » Invalid fake IIxxxx.Method Interface call » 2014-02-06 23:45:29
What I sent you was an example. Of course I don't have 1 second timeout in the client. In the real life I had 1 minute in the client and the process took around 2 minutes when I got the error the first time. If you have any doubt just use 10 second timeout and put a delay of 20 seconds. You should double check, it is not working as expected.
#27 Re: mORMot 1 » Invalid fake IIxxxx.Method Interface call » 2014-02-06 04:02:15
Client:
fModel := TSQLModel.Create([], cServiceName);
fClient := TSQLHttpClient.Create(aServer, aPort, fModel);
fClient.Compression := [hcSynLZ, hcDeflate, hcSynShaAes];
if not fClient.ServerTimeStampSynchronize then raise ESynConnError.Create('Servidor no disponible');
// Si requiere Autenticación hay que autenticar antes de REGISTRAR el Servicio
if not fClient.SetUser(aUser, aPass) then raise ESynConnError.Create('Error de autenticación');
if not fClient.ServiceRegister([TypeInfo(IMyPrueba)], sicPerThread)
then raise ESynConnError.Create('Servicio no disponible en el servidor');
fClient.WinAPI.ReceiveTimeout := 1000Server:
function TServicePrueba.Echo(s: RawUTF8): RawUTF8;
begin
sleep(5000);
Result := s;
end;If I remove the sleep(5000) everything works fine.
By the way, how can I log to a TMemo instead of a file?
If you need it, I can send you all the source code.
Log File:
windir=C:\Windows __COMPAT_LAYER=RunAsAdmin
TSQLLog 1.18 2014-02-05T23:57:49
20140205 23574955 + TSQLHttpServer(024BA1A0).006BD7A6
20140205 23574957 trace TSQLRestServerFullMemory(02404410).BeginCurrentThread(THttpApiServer(02432180)) ThreadID=1616 ThreadCount=1
20140205 23574957 trace TSQLRestServerFullMemory(02404410).BeginCurrentThread(THttpApiServer(02432200)) ThreadID=5380 ThreadCount=2
20140205 23574958 trace TSQLRestServerFullMemory(02404410).BeginCurrentThread(THttpApiServer(02432280)) ThreadID=7116 ThreadCount=3
20140205 23574958 info TSQLHttpServer(024BA1A0) THttpApiServer(02432100) initialized at http://localhost/SERVICIO_PRUEBA:8888
20140205 23574959 - 00.071.735
20140205 23574959 trace TSQLRestServerFullMemory(02404410).BeginCurrentThread(THttpApiServer(02432300)) ThreadID=2836 ThreadCount=4
20140205 23580424 + TSQLHttpClientWinHTTP(023D69F0).TimeStamp
20140205 23580424 + TSQLHttpClientWinHTTP(023D69F0).006C3E38
20140205 23580428 trace TSQLRestServerFullMemory(02404410).BeginCurrentThread(THttpApiServer(02432100)) ThreadID=6708 ThreadCount=5
20140205 23580428 + TSQLRestServerFullMemory(02404410).SERVICIO_PRUEBA/TimeStamp
20140205 23580428 call TSQLRestServerFullMemory(02404410) TimeStamp
20140205 23580428 srvr TSQLRestServerFullMemory(02404410) GET TimeStamp -> 200
20140205 23580428 - 00.000.015
20140205 23580428 clnt TSQLHttpClientWinHTTP(023D69F0) GET SERVICIO_PRUEBA/TimeStamp status=200 state=0
20140205 23580428 - 00.064.119
20140205 23580428 ret 135162068612
20140205 23580428 - 00.064.131
20140205 23580428 + TSQLHttpClientWinHTTP(023D69F0).auth
20140205 23580428 + TSQLHttpClientWinHTTP(023D69F0).006C3E38
20140205 23580428 + TSQLRestServerFullMemory(02404410).SERVICIO_PRUEBA/auth?UserName=alfonso
20140205 23580428 call TSQLRestServerFullMemory(02404410) Auth
20140205 23580428 srvr TSQLRestServerFullMemory(02404410) GET auth -> 200
20140205 23580428 - 00.000.031
20140205 23580428 clnt TSQLHttpClientWinHTTP(023D69F0) GET SERVICIO_PRUEBA/auth?UserName=alfonso status=200 state=0
20140205 23580428 - 00.007.065
20140205 23580428 ret {"result":"cb30e91817239109ffd0a5870046e128f04619da80c7624d921162fdfe514f76"}
20140205 23580428 - 00.007.078
20140205 23580428 + TSQLHttpClientWinHTTP(023D69F0).auth
20140205 23580428 + TSQLHttpClientWinHTTP(023D69F0).006C3E38
20140205 23580430 + TSQLRestServerFullMemory(02404410).SERVICIO_PRUEBA/auth?UserName=alfonso&Password=225c12031c4c3726d7ef93b717733d7ce08a3b001369318a9179a57cef043496&ClientNonce=cb30e91817239109ffd0a5870046e128f04619da80c7624d921162fdfe514f76
20140205 23580430 call TSQLRestServerFullMemory(02404410) Auth
20140205 23580430 auth TAuthSession(02494080) New "Admin" session alfonso/3387704 created at 127.0.0.1/FF00000660000004 running Mozilla/4.0 (compatible; MSIE 5.5; Windows; Synopse mORMot 1.18 TWinHTTP)
20140205 23580430 srvr TSQLRestServerFullMemory(02404410) GET auth -> 200
20140205 23580430 - 00.000.070
20140205 23580430 clnt TSQLHttpClientWinHTTP(023D69F0) GET SERVICIO_PRUEBA/auth?UserName=alfonso&Password=225c12031c4c3726d7ef93b717733d7ce08a3b001369318a9179a57cef043496&ClientNonce=cb30e91817239109ffd0a5870046e128f04619da80c7624d921162fdfe514f76 status=200 state=0
20140205 23580430 - 00.016.359
20140205 23580430 ret {"result":"3387704+048cf404d7913f4e4f2651c75d5b4134cf49990c0622d3f02d4234374915265c","logonname":"alfonso"}
20140205 23580430 - 00.016.371
20140205 23580430 + TServiceFactoryClient(024DCB48).MyPrueba._contract_
20140205 23580430 + TSQLHttpClientWinHTTP(023D69F0).006C3E38
20140205 23580430 + TSQLRestServerFullMemory(02404410).SERVICIO_PRUEBA/MyPrueba._contract_
20140205 23580430 auth TSQLRestRoutingREST(02432480) alfonso/TAuthSession(02494080)
20140205 23580430 call TSQLRestServerFullMemory(02404410) MyPrueba._contract_
20140205 23580430 srvr TSQLRestServerFullMemory(02404410) POST MyPrueba._contract_ -> 200
20140205 23580430 - 00.000.037
20140205 23580430 clnt TSQLHttpClientWinHTTP(023D69F0) POST SERVICIO_PRUEBA/MyPrueba._contract_?session_signature=0033B138000033EA22664429 status=200 state=0
20140205 23580430 - 00.004.870
20140205 23580430 ret {"result":{"contract":"5A3970602848AC42"}}
20140205 23580430 - 00.004.880
20140205 23580654 + TServiceFactoryClient(024DCB48).MyPrueba.Echo
20140205 23580654 + TSQLHttpClientWinHTTP(023D69F0).006C3E38
20140205 23580654 + TSQLRestServerFullMemory(02404410).SERVICIO_PRUEBA/MyPrueba.Echo
20140205 23580654 auth TSQLRestRoutingREST(02432380) alfonso/TAuthSession(02494080)
20140205 23580654 call TSQLRestServerFullMemory(02404410) MyPrueba.Echo
20140205 23580654 call TServiceFactoryServer(023E4F00) Adding MyPrueba instance (id=2836)
20140205 23580725 EXC EOSError ("System Error. Code: 12002.\r\n") at 0042AEC9 stack trace 00654542 00404B03 00404AC6 006B1A3B 76BF6CE9 75455AF9 006B18F7 006A9DF4 75452B8C 75456AAD 75447446 75454228 75456958 75448C0B 75447A53 772F5465 772F5172 75456A50 75447AEF 772F51B2
20140205 23581632 srvr TSQLRestServerFullMemory(02404410) POST MyPrueba.Echo -> 200
20140205 23581632 - 09.644.156
20140205 23581632 - 09.653.788
20140205 23581632 - 09.657.918
20140205 23581632 EXC EInterfaceFactoryException ("Invalid fake IMyPrueba.Echo interface call: : ") at 006A9BC3 stack trace API 00651D88 00407F7C 777EB46B 777A0133 006A9BC3 006A9E04 006AA63E
20140205 23583133 + TSQLHttpClientWinHTTP(023D69F0).auth
20140205 23583133 + TSQLHttpClientWinHTTP(023D69F0).006C3E38
20140205 23583133 + TSQLRestServerFullMemory(02404410).SERVICIO_PRUEBA/auth?UserName=alfonso&Session=3387704
20140205 23583133 auth TSQLRestRoutingREST(02432380) alfonso/TAuthSession(02494080)
20140205 23583133 call TSQLRestServerFullMemory(02404410) Auth
20140205 23583133 auth TSQLRestServerFullMemory(02404410) Deleted session alfonso/3387704 from 127.0.0.1/FF00000660000004
20140205 23583133 srvr TSQLRestServerFullMemory(02404410) GET auth -> 200
20140205 23583133 - 00.000.030
20140205 23583133 clnt TSQLHttpClientWinHTTP(023D69F0) GET SERVICIO_PRUEBA/auth?UserName=alfonso&Session=3387704&session_signature=0033B13800003454F6D00CF6 status=200 state=0
20140205 23583133 - 00.008.197
20140205 23583133 - 00.008.217
20140205 23583133 trace TSQLRestServerFullMemory(02404410).EndCurrentThread(THttpApiServer(02432180)) ThreadID=1616 ThreadCount=4
20140205 23583133 trace TSQLRestServerFullMemory(02404410).EndCurrentThread(THttpApiServer(02432300)) ThreadID=2836 ThreadCount=3
20140205 23583135 trace TSQLRestServerFullMemory(02404410).EndCurrentThread(THttpApiServer(02432200)) ThreadID=5380 ThreadCount=2
20140205 23583135 trace TSQLRestServerFullMemory(02404410).EndCurrentThread(THttpApiServer(02432280)) ThreadID=7116 ThreadCount=1
20140205 23583135 trace TSQLRestServerFullMemory(02404410).EndCurrentThread(THttpApiServer(02432100)) ThreadID=6708 ThreadCount=0
20140205 23583136 info TSQLRestServerFullMemory(02404410) { "ClientsCurrent": 0, "ClientsMax": 1, "Invalid": 0, "Responses": 6, "Modified": 0, "IncomingBytes": 2639, "OutcomingBytes": 599, "OutcomingFiles": 0, "ServiceCalls": 6, "CurrentThreadCount": 0, "ProcessTime": "9.64s" }#28 Re: mORMot 1 » Invalid fake IIxxxx.Method Interface call » 2014-02-05 05:23:53
This exception is raise on TIMEOUT. ab, can you give some name to it?
Regards,
#29 Re: mORMot 1 » Invalid fake IIxxxx.Method Interface call » 2014-02-04 15:07:32
Yes, I'm using the latest source code. This is extremely weird. No antivirus, no firewall. I'm going to reinstall the server and see what happens.
#30 mORMot 1 » Invalid fake IIxxxx.Method Interface call » 2014-02-04 05:33:57
- foncci
- Replies: 7
Hi,
A simple service in my PC works OK(Win 7) but when I move it to a Windows 2003 server I get this exception Invalid fake IIxxxx.Method Interface call.
Is there any incompatibilities with Windows 2003 server?
It is the same executable so it must be something in the Server.
I'm running the program with Administrator Privileges.
Regards.,
Al
#31 Re: mORMot 1 » User authentication proposal » 2014-02-02 04:00:32
Perfect, Result.GroupRights := TSQLAuthGroup(1); works. Thanks.
#32 Re: mORMot 1 » User authentication proposal » 2014-02-01 16:36:34
ok, I'll try it now but It should be a good idea to make a "TSQLRecord-Independent" class just for Authentication. In the close future I think it will be an strong requirement. That's why I encourage you to use Interfaces because any class implementing that interface will be able to Authenticate and it won't break the actual code logic.
About the authentication registering order, it should be good to handle it like an stack, Last In-First try. If I register a new authentication class it is because I want to use it first and if I have an authentication-chain and the first doesn't work, it will try the second and so on.
#33 Re: mORMot 1 » User authentication proposal » 2014-01-31 22:18:28
Doing something like this is not working. The problem raises in TAuthSession.Create(aCtxt: TSQLRestServerURIContext; aUser: TSQLAuthUser); because it is expecting a group in if User.GroupRights.fID<>0 then begin ... and I don't know a "good" way to create a group on the fly. It should be nice to have a new constructor in TSQLAuthUser to do that and create a group with privileges that I can store in my own users table.
type
TIntegradorAuthenticationDefault = class(TSQLRestServerAuthenticationDefault)
protected
function GetUser(Ctxt: TSQLRestServerURIContext; const aUserName: RawUTF8): TSQLAuthUser; override;
end;
function TIntegradorAuthenticationDefault.GetUser(Ctxt: TSQLRestServerURIContext; const aUserName: RawUTF8): TSQLAuthUser;
begin
Result := TSQLAuthUser.Create;
Result.ID := 100; // Tiene q tener un valor para que pase x una condición en TAuthSession.Create
Result.LogonName := 'alfonso';
Result.PasswordPlain := 'probando';
end;Also I have a question, Do I must unregister "standards" authentications before using mine? If not, TSQLRestServerAuthenticationDefault will handle the authentication instead mine (TIntegradorAuthenticationDefault)
aServer.AuthenticationUnregister([TSQLRestServerAuthenticationDefault, TSQLRestServerAuthenticationSSPI]);
aServer.AuthenticationRegister([TIntegradorAuthenticationDefault]);#34 Re: mORMot 1 » User authentication proposal » 2014-01-31 18:03:55
ab, these are great!!! news. I understand you love ORM and you create mORMot thinking of ORM but today mORMot IS BETTER THAN REMONJECTS SDK and I was a Rem Object SDK User so I have compared both frameworks before deciding for mORMot. I suggest that you think a way to decouple as much as possible the ORM from the Rest FrameWork as RemObject did with SDK and DataAbstract(it is not exactly and ORM but it tries to behave like one). mORMot is faster easier and more understandable than RemObject, so it is time to have a Rest-ORM-Independent FrameWork. With this you will get hundreds of users from RemObject, RealThinClient and other frameworks.
IMHO
Thanks, Al
#35 Re: mORMot 1 » User authentication proposal » 2014-01-31 00:19:34
TSQLAuthUser inherits from TSQLRecord so it is not just a container and the idea behind it is to support authentication against the ORM. Today Mormot is much more than an ORM.
I understand you point but sub-classing TSQLRestServerAuthentication class is a lot of meaningless work. My point is that I want to use TSQLRestServerAuthenticationDefault exactly as it is implemented except for the way it "compares the username and password against the database". That's why I'm thinking on an Interface that implements a method for get username, password and privilege from another source. It will decouple the authentication process from the ORM or at least make things easier for non ORM users like me. With it I can still using TSQLRestServerAuthenticationDefault without any changes. Authentication method will be independent of the way we get the credentials.
Something like this would be good:
IAuthUser = interface
function GetUser(aUser : RawUTF8) : IAuthUser; // If the user doesn't exist raise except
function GetUser(aUser : RawUTF8) : boolean; // If you don't want an exception
function LogonName : RawUTF8;
function PasswordHashHexa: RawUTF8;
function Privileges;
end;
function TSQLRestServerAuthenticationDefault.Auth(Ctxt: TSQLRestServerURIContext): boolean;
var aUserName, aPassWord, aClientNonce, aSalt: RawUTF8;
User: IAuthUser;
Session: TAuthSession;
begin
result := true;
if AuthSessionRelease(Ctxt) then
exit else
if UrlDecodeNeedParameters(Ctxt.Parameters,'PassWord,ClientNonce') then begin
// GET ModelRoot/auth?UserName=...&PassWord=...&ClientNonce=... -> handshaking
while Ctxt.Parameters<>nil do begin
UrlDecodeValue(Ctxt.Parameters,'USERNAME=',aUserName);
UrlDecodeValue(Ctxt.Parameters,'PASSWORD=',aPassWord);
UrlDecodeValue(Ctxt.Parameters,'CLIENTNONCE=',aClientNonce,@Ctxt.Parameters);
end;
User := AuthClassX(aUserName);
try
if User.fID=0 then
exit; // unknown user name
// check if match TSQLRestClientURI.SetUser() algorithm
aSalt := aClientNonce+User.LogonName+User.PasswordHashHexa;
if (aPassWord<>SHA256(fServer.Model.Root+Nonce(false)+aSalt)) and
// if didn't try with current nonce, try with previous 5 minutes nonce
(aPassWord<>SHA256(fServer.Model.Root+Nonce(true)+aSalt)) then
exit;
// now client is authenticated -> create a session
fServer.SessionCreate(User,Ctxt,Session);
if Session<>nil then
Ctxt.Returns(['result',Session.fPrivateSalt,'logonname',Session.User.LogonName]);
finally
end;
end else
if PosChar(Ctxt.Parameters,'&')=nil then
// only UserName=... -> return hexadecimal nonce content valid for 5 minutes
Ctxt.Results([Nonce(false)]) else
// parameters does not match any expected layout
result := false;
end;#36 mORMot 1 » User authentication proposal » 2014-01-30 19:30:54
- foncci
- Replies: 12
Hi,
What about if authentication is accomplished using an INTERFACE instead of a class (TSQLAuthUser). It means that any class which implements that interface could be used by TSQLRestServer.Auth to authenticate User and Password. The advantages are pretty obvious, we could authenticate against a text file, ldap server a "non supported" database server or whatever we want.
Regards,
Al
#37 mORMot 1 » Extending the client timeout » 2014-01-10 10:57:21
- foncci
- Replies: 1
ab,
Only when debugging and expend some time I receive the exception timeout. When can I change that value? I tried with fClient.WinAPI.ConnectTimeout := 5000 but the same, in less than 1 minutes I receive the timeout. What Am I missing? I have the last build.
Regards,
Al
#38 Re: mORMot 1 » CurrentServiceContext returns RunningThread as NIL randomly » 2014-01-09 21:11:13
Yes, I'm using the last nightly version. Could you reproduce it ?
#39 mORMot 1 » CurrentServiceContext returns RunningThread as NIL randomly » 2014-01-09 03:53:24
- foncci
- Replies: 3
Hi,
CurrentServiceContext returns RunningThread as NIL randomly. sicPerThread service called from multiple threads from one client IP or localhost. It is very simple to reproduce:
Server:
aModel := TSQLModel.Create([], cServiceName);
aServer := TSQLRestServerFullMemory.Create(aModel, 'users.json', false, false);
aServer.ServiceRegister(TServiceIntegrador, [TypeInfo(IServiceIntegrador)], sicPerThread). AllowAll; // .AllowAllByName(['User']);
aHTTPServer := TSQLHttpServer.Create('8888', [aServer],'+',useHttpApiRegisteringURI, 5, secSynShaAes); // Is it due to 5 threads? I tried with 10 getting the same NIL result.
function TServiceIntegrador.UpdSQL(aComando, aData: RawJSON): RawJSON;
var
Ctxt : TServiceRunningContext;
begin
Ctxt := CurrentServiceContext;
if Ctxt.RunningThread=nil then TLogMemo.WriteLog('ThreadID=NIL')
else TLogMemo.WriteLog('ThreadID='+IntToStr(Ctxt.RunningThread.ThreadID));
Result := '[]';
end;
Client:
fModel := TSQLModel.Create([], cServiceName);
fClient := TSQLHttpClient.Create(aServer, aPort, fModel);
fClient.Compression := [hcSynLZ, hcDeflate, hcSynShaAes];
if not fClient.ServerTimeStampSynchronize then raise Exception.Create('Remote service not available on server');
if // (not fClient.SetUser(aUser, aPass)) or
(not fClient.ServiceRegister([TypeInfo(IServiceIntegrador)], sicPerThread))
then raise Exception.Create('Remote service not available on server. 1');
fService := fClient.Service<IServiceIntegrador>;
jRes := MyCli.fService.UpdSQL(jComando, jData); is called from multiple threads in the same machine. This is not a real life project, it is a test I'm doing while I'm learning the framework.
Result with 5 threads pool:
ThreadID=9528
ThreadID=NIL
ThreadID=11524
ThreadID=9684
ThreadID=2156
ThreadID=9528
ThreadID=NIL
ThreadID=11524
ThreadID=9684
ThreadID=2156
ThreadID=9528
ThreadID=NIL
Result with 32 threads pool:
ThreadID=5144
ThreadID=11828
ThreadID=2616
ThreadID=8304
ThreadID=9136
ThreadID=8516
ThreadID=11884
ThreadID=6512
ThreadID=7032
ThreadID=6336
ThreadID=NIL ------------------- NIL
ThreadID=5604
ThreadID=7336
ThreadID=12008
ThreadID=11328
ThreadID=8024
ThreadID=12064
ThreadID=10696
ThreadID=10996
ThreadID=10632
ThreadID=10072
ThreadID=10820
ThreadID=9976
ThreadID=8112
ThreadID=4968
ThreadID=11900
ThreadID=2616
ThreadID=8304
ThreadID=9136
ThreadID=8516
ThreadID=11884
ThreadID=6512
ThreadID=7032
ThreadID=6336
ThreadID=NIL -------------------------- NIL
ThreadID=5604
ThreadID=7336
ThreadID=12008
ThreadID=11328
ThreadID=8024
ThreadID=12064
ThreadID=10696
ThreadID=10996
ThreadID=10632
ThreadID=10072
ThreadID=10820
ThreadID=9976
ThreadID=8112
ThreadID=4968
ThreadID=11900
ThreadID=9140
ThreadID=10912
ThreadID=11624
ThreadID=11852
ThreadID=12272
ThreadID=8784
ThreadID=5144
ThreadID=6512
ThreadID=7032
ThreadID=6336
ThreadID=NIL --------------------------------- NIL
ThreadID=5604
ThreadID=8024
ThreadID=12064
ThreadID=10696
ThreadID=10996
ThreadID=10632
ThreadID=10072
ThreadID=10820Thanks in advance,
Al
#40 Re: mORMot 1 » Interface Based Services - Called From Javascript (AJAX) » 2014-01-08 23:31:56
Hi ab,
Now I'm concerned about the best way to interact with an external database. So far I'm doing this way:
TServiceIntegrador = class(TInterfacedObject, IServiceIntegrador)
public
DB : TFIBDataBase;
Trans : TFIBTransaction;
Query : TFIBDataSet;
Procedure Connect;
function UpdSQL(aComando, aData : RawJSON) : RawJSON;
function echo(s : RawJSON) : RawJSON;
destructor Destroy; override;
end;
function TServiceIntegrador.UpdSQL(aComando, aData: RawJSON): RawJSON;
begin
Connect; // Check if there is a connection, if not do it.
....
end;
begin
CompressShaAesSetKey('TesingCipher');
aModel := TSQLModel.Create([], cServiceName);
aServer := TSQLRestServerFullMemory.Create(aModel, '', false, false);
aServer.ServiceRegister(TServiceIntegrador, [TypeInfo(IServiceIntegrador)], sicPerThread). AllowAll; // .AllowAllByName(['User']);
aHTTPServer := TSQLHttpServer.Create('8888', [aServer],'+',useHttpApiRegisteringURI, cCantThreads, secSynShaAes);
.....
end.
It is working pretty good but now I'm wondering if BeginCurrentThread/EndCurrentThread is a better way. I was looking in the samples but couldn't find anything. Can you provide us with a very simple sample that covers this topic?
By the way, I'm testing the encryption using wireshark/RowCap and nothing. This line fClient.Compression := [hcSynLZ, hcDeflate, hcSynShaAes]; is on the client.
I'm using today build. Am I missing something?
Thanks in advance,
Al
#41 Re: mORMot 1 » Change Password » 2013-12-31 07:19:52
Hi, logging is enabled and verbose and .map file or {$D+} is active but no stack is returned in the log because the Access Violation is raised inside procedure AddStackManual(Stack: PPtrUInt); ( Of course if you disable logging no Access Violation is raised )
in line
while (PtrUInt(stack)<max_stack) do begin
st := stack^;
if ((st>max_stack) or (st<min_stack)) and <------ Exception is here
not IsBadReadPtr(pointer(st-8),12) and
((pByte(st-5)^=$E8) or check2(st)) then begin
TSynMapFile.Log(fWriter,st); // will ignore any TSynLog.* methods
dec(depth);
if depth=0 then break;
end;
inc(stack);
end;
except
// just ignore any access violation here
end;
The console LOG is:
20131231 03130315 srvr TSQLRestServerFullMemory(0575B170) POST MySQLExe
c.ChangePassword -> 200
20131231 03130315 - TSQLRestServerFullMemory(0575B170). 77.034.233
20131231 03141752 EXC EHttpApiServer ("HttpSendHttpResponse failed: An operati
on was attempted on a nonexistent network connection (1229)") at 007DE63E stack
trace 00475925 00408E72 00639D4C 00528E99 7564336A 774A9F72 774A9F45
#42 Re: mORMot 1 » Change Password » 2013-12-29 05:41:08
Hi ab, a regular access violation, I can send you a print screen if you want but it is a "pretty regular" access violation. By the way, what is the best place to catch EHttpApiServer exception? It is raised after the method is completed.
Regards,
AL
#43 Re: mORMot 1 » Change Password » 2013-12-27 06:56:55
Hi ab, first of all Marry Christmas, second, it works perfect, thank you and third, when debugging the server I got this exception in case of time-out or if the client close the connection:
20131227 02492900 EXC EHttpApiServer ("HttpSendHttpResponse failed: An operati
on was attempted on a nonexistent network connection (1229)") at 006C97D2 stack
trace 0045B1BD 00408B26 762A336A 77379F72 77379F45
I got 2 others access violations, it is very simple to reproduce, just start debugging and have a coffee or smoke a cigarette.
Thanks in advance and merry Christmas again.
Al
#44 mORMot 1 » Change Password » 2013-12-22 08:04:14
- foncci
- Replies: 9
Hi, I'm trying to change a password of the current user using a Interface based service.
function TServiceSQLExec.ChangePassword(aPass : RawUTF8) : RawJSON;
var
Ctxt : TServiceRunningContext;
AuthUser : TSQLAuthUser;
Rest : TSQLRestServerFullMemory;
begin
Ctxt := CurrentServiceContext;
Rest := Ctxt.Request.Server as TSQLRestServerFullMemory;
AuthUser := Rest.SessionGetUser(Ctxt.Request.Session);
AuthUser.PasswordPlain := aPass;
Rest.Update(AuthUser);
Rest.UpdateToFile;
end;It saves the password OK but it saves the GroupRights field equal to 0 instead of 3. I'm using TSQLRestServerFullMemory and a JSON file for user registration like sample 16.
What am I doing wrong?
Thanks in advance,
Al
#45 mORMot 1 » Some issues » 2013-12-16 07:12:00
- foncci
- Replies: 1
Hi,
I have to say that after some help from a friend I'm taking off with mORMot and results are quite impressive but I still need some help with some issues.
I'm using the last Nightly Build.
- Returning a manually serialized JSON
function TServiceSQLExec.echonoparams: RawJSON;
begin
Result := '{"PRUEBA NO PARAMS":100}';
end;what I actually get is:
{
"result":{
"Result":{"PRUEBA NO PARAMS":100}
},
"id":2092
}Why the framework adds two "Results" and "id":2092 and what does it means? How can I get only my original JSON {"PRUEBA NO PARAMS":100}?
- In case a function is defined parameterless, service return error "Parameters required", a workaround is to use "?[]"
http://localhost:888/rest/MySQLExec.echonoparams?[]
but it doesn't look any good in an URL. I'm consuming the services from a browser.
- Is it there any way to serialize a TDataSet descendent or import/export it directly to/from a TSQLTableJSON?
- For debugging purposes it should be nice to have named threads. I propose to use the classname + consecutive.
- I would like to "zip" and encrypt the JSONs, I know from Delphi-Client it is possible, how can I do that from Browser-Client using Content-Type: gzip?
Regards,
Al
#46 Re: mORMot 1 » Interface example for transmitting complex JSON Object » 2013-12-06 21:49:56
Hi, ab
I was checking out the source but I couldn't find where you define that you handle the POST method not where to read the body. Can you tell me where you you read it?
Regards,
Al
#47 Re: mORMot 1 » Newbie to mORMot needs helps. » 2013-11-16 00:09:39
Hi All,
tanghz, I have read your conversation with AB and I cannot be more agree with you. I think it is too hard to make a short development and the learning curve is huge. Of course I understand AB point too but I think AB is talking about madium to large developments and not an small webservice exporting 3 functions like the one I'm trying to do. It would be great to have some "WebBroker/DataSnap" like examples of mORMot conected to a TDataSet descendant in case we want to do some CRUD operations on a DataBase. tanghz, if you finally did that I would appreciate some help. Anyway I'm digging into 1.18 SAD but I have to say it is more like a book about good practices than a tutorial to understand a framework. For me, I feel a lack of examples.
Thanks you all
#48 mORMot 1 » Rest server sample » 2013-11-15 08:13:42
- foncci
- Replies: 1
Hi,
I have been reading the Synopse SAD 1.18.PDF but I found it too dense for my knowledge. Maybe I'm not following good practices or maybe this is not what I really need or I couldn't understand the samples so I'm going to explain what I need with an example:
- I need to create a web service wich will be accessed by Delphi and JavaScript clients.
- I'm not prepare to use the ORM so I preffer to continue using a TDataset descendant, in my case FIBPlus.
- I would like to get some data and use the mORMot inmemory dataset to show it on a DBGrid. Something like
localhost/rest/getcustomers
HEADERS
POSITIONINI = XXX
CANT = 20
and get the JSON of the customers table from position XXX and 20 rows.
Read that JSON into the memory table and show it on a DBGRID. Of course this would be on the client side.
I have been playing with websnap following the examples of Delphi 2010 Handbook so that is my background on webservices using Delphi.
Can you refer me to an example close to what I need?
Thanks in advance,
Fon
Pages: 1