U:\SAS.Planet.Nightly.151105.9209\SASPlanet.exe 1.0.0.0 (2015-11-09 10:31:39) Host=CZC4282VYY User=sheavy CPU=4*0-6-15363 OS=12.1=6.1.7601 Wow64=0 Freq=3118007 Environment variables=ALLUSERSPROFILE=C:\ProgramData APPDATA=C:\Users\sheavy\AppData\Roaming CommonProgramFiles=C:\Program Files\Common Files COMPUTERNAME=CZC4282VYY ComSpec=C:\Windows\system32\cmd.exe FP_NO_HOST_CHECK=NO HOMEDRIVE=C: HOMEPATH=\Users\sheavy HOMESHARE=C:\Users\sheavy LOCALAPPDATA=C:\Users\sheavy\AppData\Local LOGONSERVER=\\RUDC001 NUMBER_OF_PROCESSORS=4 OS=Windows_NT Path=C:\ProgramData\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\WinMerge;C:\Program Files\IT Tools\Tools PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC PROCESSOR_ARCHITECTURE=x86 PROCESSOR_IDENTIFIER=x86 Family 6 Model 60 Stepping 3, GenuineIntel PROCESSOR_LEVEL=6 PROCESSOR_REVISION=3c03 ProgramData=C:\ProgramData ProgramFiles=C:\Program Files PSModulePath=C:\Windows\system32\WindowsPowerShell\v1.0\Modules\;C:\Program Files\Microsoft Security Client\MpProvider\ PUBLIC=C:\Users\Public SESSIONNAME=Console SystemDrive=C: SystemRoot=C:\Windows TEMP=C:\Users\sheavy\AppData\Local\Temp TMP=C:\Users\sheavy\AppData\Local\Temp UATDATA=C:\Windows\CCM\UATData\D9F8C395-CAB8-491d-B8AC-189A2FE1BE78 USERDNSDOMAIN=my.domain USERDOMAIN=domain USERDOMAIN_ROAMINGPROFILE=domain USERNAME=user USERPROFILE=C:\Users\sheavy windir=C:\Windows _NT_SYMBOL_PATH=srv*c:\symbols*http://msdl.microsoft.com/download/symbols TSQLLog 1.18.2030 FTS3 2015-11-09T07:32:24 0000000000000008 ! EXC EAbort ("Operation aborted") at 006406C9 u_Bitmap32To8ConverterByLibImageQuant.RaiseLastOSError (232) stack trace API 006406C9 u_Bitmap32To8ConverterByLibImageQuant.RaiseLastOSError (232) 006406C9 u_Bitmap32To8ConverterByLibImageQuant.RaiseLastOSError (232) 00640909 u_Bitmap32To8ConverterByLibImageQuant.TBitmap32To8ConverterByLibImageQuant.Create (293) 00649F30 u_BitmapTileSaveLoadFactory.TBitmapTileSaveLoadFactory.Create (115) 00C2F34D u_GlobalState.TGlobalState.Create (517) 00000000000000A6 ! EXC EAbort ("Operation aborted") at 006406C9 u_Bitmap32To8ConverterByLibImageQuant.RaiseLastOSError (232) stack trace API 006406C9 u_Bitmap32To8ConverterByLibImageQuant.RaiseLastOSError (232) 006406C9 u_Bitmap32To8ConverterByLibImageQuant.RaiseLastOSError (232) 00640909 u_Bitmap32To8ConverterByLibImageQuant.TBitmap32To8ConverterByLibImageQuant.Create (293) 00649F30 u_BitmapTileSaveLoadFactory.TBitmapTileSaveLoadFactory.Create (115) 00C2F34D u_GlobalState.TGlobalState.Create (517) 00000000000292BD ! EXC EAbort ("Operation aborted") at 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) stack trace API 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B6314 u_DistanceCalculatorByGeodesicLib.TDistanceCalculatorByGeodesicLib.Create (139) 007B7FE9 u_Datum.TDatum.Create (125) 007B88A3 u_DatumFactory.TDatumFactory.Create (71) 00C2F5F1 u_GlobalState.TGlobalState.Create (553) 00000000000293E3 ! EXC EAbort ("Operation aborted") at 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) stack trace API 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B6314 u_DistanceCalculatorByGeodesicLib.TDistanceCalculatorByGeodesicLib.Create (139) 007B7FE9 u_Datum.TDatum.Create (125) 007B88A3 u_DatumFactory.TDatumFactory.Create (71) 00C2F5F1 u_GlobalState.TGlobalState.Create (553) 0000000000029CD3 ! EXC EAbort ("Operation aborted") at 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) stack trace API 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B6314 u_DistanceCalculatorByGeodesicLib.TDistanceCalculatorByGeodesicLib.Create (139) 007B7FE9 u_Datum.TDatum.Create (125) 007B891F u_DatumFactory.TDatumFactory.Create (77) 00C2F5F1 u_GlobalState.TGlobalState.Create (553) 000000000002A44C ! EXC EAbort ("Operation aborted") at 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) stack trace API 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B6314 u_DistanceCalculatorByGeodesicLib.TDistanceCalculatorByGeodesicLib.Create (139) 007B7FE9 u_Datum.TDatum.Create (125) 007B891F u_DatumFactory.TDatumFactory.Create (77) 00C2F5F1 u_GlobalState.TGlobalState.Create (553) 000000000002AF1A ! EXC EAbort ("Operation aborted") at 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) stack trace API 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B6314 u_DistanceCalculatorByGeodesicLib.TDistanceCalculatorByGeodesicLib.Create (139) 007B7FE9 u_Datum.TDatum.Create (125) 007B8999 u_DatumFactory.TDatumFactory.Create (83) 00C2F5F1 u_GlobalState.TGlobalState.Create (553) 000000000002AFD7 ! EXC EAbort ("Operation aborted") at 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) stack trace API 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B6314 u_DistanceCalculatorByGeodesicLib.TDistanceCalculatorByGeodesicLib.Create (139) 007B7FE9 u_Datum.TDatum.Create (125) 007B8999 u_DatumFactory.TDatumFactory.Create (83) 00C2F5F1 u_GlobalState.TGlobalState.Create (553) 00000000000E6860 ! EXC EDirNotExist ("not found U:\\SAS.Planet.Nightly.151105.9209\\UserData\\gpx\\! skip GeoCoderByGpx") at 0082737C u_GeoCoderByGpx.TGeoCoderByGpx.Create (90) stack trace API 0082737C u_GeoCoderByGpx.TGeoCoderByGpx.Create (90) 0084078E u_GeoCoderListSimple.TGeoCoderListSimple.Create (160) 00C3021F u_GlobalState.TGlobalState.Create (737) 00000000000E6A56 ! EXC EDirNotExist ("not found U:\\SAS.Planet.Nightly.151105.9209\\UserData\\gpx\\! skip GeoCoderByGpx") at 0082737C u_GeoCoderByGpx.TGeoCoderByGpx.Create (90) stack trace API 0082737C u_GeoCoderByGpx.TGeoCoderByGpx.Create (90) 0084078E u_GeoCoderListSimple.TGeoCoderListSimple.Create (160) 00C3021F u_GlobalState.TGlobalState.Create (737) 000000000010F712 ! EXC EDirNotExist ("not found U:\\SAS.Planet.Nightly.151105.9209\\UserData\\mp\\! skip GeoCoderByPolishMap") at 0083801C u_GeoCoderByPolishMap.TGeoCoderByPolishMap.Create (692) stack trace API 0083801C u_GeoCoderByPolishMap.TGeoCoderByPolishMap.Create (692) 00840820 u_GeoCoderListSimple.TGeoCoderListSimple.Create (171) 00C3021F u_GlobalState.TGlobalState.Create (737) 000000000010F851 ! EXC EDirNotExist ("not found U:\\SAS.Planet.Nightly.151105.9209\\UserData\\mp\\! skip GeoCoderByPolishMap") at 0083801C u_GeoCoderByPolishMap.TGeoCoderByPolishMap.Create (692) stack trace API 0083801C u_GeoCoderByPolishMap.TGeoCoderByPolishMap.Create (692) 00840820 u_GeoCoderListSimple.TGeoCoderListSimple.Create (171) 00C3021F u_GlobalState.TGlobalState.Create (737) 00000000001377D2 ! EXC EDirNotExist ("not found U:\\SAS.Planet.Nightly.151105.9209\\UserData\\txt\\! skip GeoCoderByTXT") at 00839E34 u_GeoCoderByTXT.TGeoCoderByTXT.Create (91) stack trace API 00839E34 u_GeoCoderByTXT.TGeoCoderByTXT.Create (91) 008408B2 u_GeoCoderListSimple.TGeoCoderListSimple.Create (182) 00C3021F u_GlobalState.TGlobalState.Create (737) 0000000000137940 ! EXC EDirNotExist ("not found U:\\SAS.Planet.Nightly.151105.9209\\UserData\\txt\\! skip GeoCoderByTXT") at 00839E34 u_GeoCoderByTXT.TGeoCoderByTXT.Create (91) stack trace API 00839E34 u_GeoCoderByTXT.TGeoCoderByTXT.Create (91) 008408B2 u_GeoCoderListSimple.TGeoCoderListSimple.Create (182) 00C3021F u_GlobalState.TGlobalState.Create (737) 000000000D343E8B ! EXC EAbort ("Operation aborted") at 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) stack trace API 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B6314 u_DistanceCalculatorByGeodesicLib.TDistanceCalculatorByGeodesicLib.Create (139) 007B7FE9 u_Datum.TDatum.Create (125) 007B8B0C u_DatumFactory.TDatumFactory.GetByRadius (121) 007D1A70 u_ProjectionTypeFactorySimple.TProjectionTypeFactorySimple.GetByConfig (190) 007D24CC u_ProjectionSetFactorySimple.TProjectionSetFactorySimple.GetProjectionSetByConfig (156) 00B9ED6C u_ZmpInfo.TZmpInfo.LoadProjectionInfo (791) 00B9E953 u_ZmpInfo.TZmpInfo.LoadConfig (740) 00B9E24F u_ZmpInfo.TZmpInfo.Create (582) 00B9FBD8 u_ZmpInfoSet.TZmpInfoSet.Create (106) 00C302F6 u_GlobalState.TGlobalState.Create (751) 000000000D344237 ! EXC EAbort ("Operation aborted") at 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) stack trace API 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B6314 u_DistanceCalculatorByGeodesicLib.TDistanceCalculatorByGeodesicLib.Create (139) 007B7FE9 u_Datum.TDatum.Create (125) 007B8B0C u_DatumFactory.TDatumFactory.GetByRadius (121) 007D1A70 u_ProjectionTypeFactorySimple.TProjectionTypeFactorySimple.GetByConfig (190) 007D24CC u_ProjectionSetFactorySimple.TProjectionSetFactorySimple.GetProjectionSetByConfig (156) 00B9ED6C u_ZmpInfo.TZmpInfo.LoadProjectionInfo (791) 00B9E953 u_ZmpInfo.TZmpInfo.LoadConfig (740) 00B9E24F u_ZmpInfo.TZmpInfo.Create (582) 00B9FBD8 u_ZmpInfoSet.TZmpInfoSet.Create (106) 00C302F6 u_GlobalState.TGlobalState.Create (751) 000000000D7293DF ! EXC EAbort ("Operation aborted") at 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) stack trace API 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B6314 u_DistanceCalculatorByGeodesicLib.TDistanceCalculatorByGeodesicLib.Create (139) 007B7FE9 u_Datum.TDatum.Create (125) 007B8B0C u_DatumFactory.TDatumFactory.GetByRadius (121) 007D1A70 u_ProjectionTypeFactorySimple.TProjectionTypeFactorySimple.GetByConfig (190) 007D24CC u_ProjectionSetFactorySimple.TProjectionSetFactorySimple.GetProjectionSetByConfig (156) 00B9ED6C u_ZmpInfo.TZmpInfo.LoadProjectionInfo (791) 00B9E953 u_ZmpInfo.TZmpInfo.LoadConfig (740) 00B9E24F u_ZmpInfo.TZmpInfo.Create (582) 00B9FBD8 u_ZmpInfoSet.TZmpInfoSet.Create (106) 00C302F6 u_GlobalState.TGlobalState.Create (751) 000000000D72944E ! EXC EAbort ("Operation aborted") at 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) stack trace API 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B6314 u_DistanceCalculatorByGeodesicLib.TDistanceCalculatorByGeodesicLib.Create (139) 007B7FE9 u_Datum.TDatum.Create (125) 007B8B0C u_DatumFactory.TDatumFactory.GetByRadius (121) 007D1A70 u_ProjectionTypeFactorySimple.TProjectionTypeFactorySimple.GetByConfig (190) 007D24CC u_ProjectionSetFactorySimple.TProjectionSetFactorySimple.GetProjectionSetByConfig (156) 00B9ED6C u_ZmpInfo.TZmpInfo.LoadProjectionInfo (791) 00B9E953 u_ZmpInfo.TZmpInfo.LoadConfig (740) 00B9E24F u_ZmpInfo.TZmpInfo.Create (582) 00B9FBD8 u_ZmpInfoSet.TZmpInfoSet.Create (106) 00C302F6 u_GlobalState.TGlobalState.Create (751) 000000000DAE5D4F ! EXC EAbort ("Operation aborted") at 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) stack trace API 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B6314 u_DistanceCalculatorByGeodesicLib.TDistanceCalculatorByGeodesicLib.Create (139) 007B7FE9 u_Datum.TDatum.Create (125) 007B8B0C u_DatumFactory.TDatumFactory.GetByRadius (121) 007D1A70 u_ProjectionTypeFactorySimple.TProjectionTypeFactorySimple.GetByConfig (190) 007D24CC u_ProjectionSetFactorySimple.TProjectionSetFactorySimple.GetProjectionSetByConfig (156) 00B9ED6C u_ZmpInfo.TZmpInfo.LoadProjectionInfo (791) 00B9E953 u_ZmpInfo.TZmpInfo.LoadConfig (740) 00B9E24F u_ZmpInfo.TZmpInfo.Create (582) 00B9FBD8 u_ZmpInfoSet.TZmpInfoSet.Create (106) 00C302F6 u_GlobalState.TGlobalState.Create (751) 000000000DAE6596 ! EXC EAbort ("Operation aborted") at 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) stack trace API 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B6314 u_DistanceCalculatorByGeodesicLib.TDistanceCalculatorByGeodesicLib.Create (139) 007B7FE9 u_Datum.TDatum.Create (125) 007B8B0C u_DatumFactory.TDatumFactory.GetByRadius (121) 007D1A70 u_ProjectionTypeFactorySimple.TProjectionTypeFactorySimple.GetByConfig (190) 007D24CC u_ProjectionSetFactorySimple.TProjectionSetFactorySimple.GetProjectionSetByConfig (156) 00B9ED6C u_ZmpInfo.TZmpInfo.LoadProjectionInfo (791) 00B9E953 u_ZmpInfo.TZmpInfo.LoadConfig (740) 00B9E24F u_ZmpInfo.TZmpInfo.Create (582) 00B9FBD8 u_ZmpInfoSet.TZmpInfoSet.Create (106) 00C302F6 u_GlobalState.TGlobalState.Create (751) 000000000DE8E8F1 ! EXC EAbort ("Operation aborted") at 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) stack trace API 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B6314 u_DistanceCalculatorByGeodesicLib.TDistanceCalculatorByGeodesicLib.Create (139) 007B7FE9 u_Datum.TDatum.Create (125) 007B8B0C u_DatumFactory.TDatumFactory.GetByRadius (121) 007D1A70 u_ProjectionTypeFactorySimple.TProjectionTypeFactorySimple.GetByConfig (190) 007D24CC u_ProjectionSetFactorySimple.TProjectionSetFactorySimple.GetProjectionSetByConfig (156) 00B9ED6C u_ZmpInfo.TZmpInfo.LoadProjectionInfo (791) 00B9E953 u_ZmpInfo.TZmpInfo.LoadConfig (740) 00B9E24F u_ZmpInfo.TZmpInfo.Create (582) 00B9FBD8 u_ZmpInfoSet.TZmpInfoSet.Create (106) 00C302F6 u_GlobalState.TGlobalState.Create (751) 000000000DE8E9F3 ! EXC EAbort ("Operation aborted") at 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) stack trace API 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B6314 u_DistanceCalculatorByGeodesicLib.TDistanceCalculatorByGeodesicLib.Create (139) 007B7FE9 u_Datum.TDatum.Create (125) 007B8B0C u_DatumFactory.TDatumFactory.GetByRadius (121) 007D1A70 u_ProjectionTypeFactorySimple.TProjectionTypeFactorySimple.GetByConfig (190) 007D24CC u_ProjectionSetFactorySimple.TProjectionSetFactorySimple.GetProjectionSetByConfig (156) 00B9ED6C u_ZmpInfo.TZmpInfo.LoadProjectionInfo (791) 00B9E953 u_ZmpInfo.TZmpInfo.LoadConfig (740) 00B9E24F u_ZmpInfo.TZmpInfo.Create (582) 00B9FBD8 u_ZmpInfoSet.TZmpInfoSet.Create (106) 00C302F6 u_GlobalState.TGlobalState.Create (751) 000000000E222178 ! EXC EAbort ("Operation aborted") at 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) stack trace API 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B6314 u_DistanceCalculatorByGeodesicLib.TDistanceCalculatorByGeodesicLib.Create (139) 007B7FE9 u_Datum.TDatum.Create (125) 007B8B0C u_DatumFactory.TDatumFactory.GetByRadius (121) 007D1BE3 u_ProjectionTypeFactorySimple.TProjectionTypeFactorySimple.GetByConfig (214) 007D24CC u_ProjectionSetFactorySimple.TProjectionSetFactorySimple.GetProjectionSetByConfig (156) 00B9ED6C u_ZmpInfo.TZmpInfo.LoadProjectionInfo (791) 00B9E953 u_ZmpInfo.TZmpInfo.LoadConfig (740) 00B9E24F u_ZmpInfo.TZmpInfo.Create (582) 00B9FBD8 u_ZmpInfoSet.TZmpInfoSet.Create (106) 00C302F6 u_GlobalState.TGlobalState.Create (751) 000000000E2221DF ! EXC EAbort ("Operation aborted") at 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) stack trace API 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B61D1 u_DistanceCalculatorByGeodesicLib.RaiseLastOSError (108) 007B6314 u_DistanceCalculatorByGeodesicLib.TDistanceCalculatorByGeodesicLib.Create (139) 007B7FE9 u_Datum.TDatum.Create (125) 007B8B0C u_DatumFactory.TDatumFactory.GetByRadius (121) 007D1BE3 u_ProjectionTypeFactorySimple.TProjectionTypeFactorySimple.GetByConfig (214) 007D24CC u_ProjectionSetFactorySimple.TProjectionSetFactorySimple.GetProjectionSetByConfig (156) 00B9ED6C u_ZmpInfo.TZmpInfo.LoadProjectionInfo (791) 00B9E953 u_ZmpInfo.TZmpInfo.LoadConfig (740) 00B9E24F u_ZmpInfo.TZmpInfo.Create (582) 00B9FBD8 u_ZmpInfoSet.TZmpInfoSet.Create (106) 00C302F6 u_GlobalState.TGlobalState.Create (751) 000000001A325AD7 " + TODBCConnection(04EF1700).00AED8D1 SynDBODBC.TODBCConnection.Create (1071) 000000001A325AF3 " - 00.000.008 000000001A325AFA " + 00AED307 SynDBODBC.TODBCConnection.Connect (1015) 000000001A8FC537 " info [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'SASPlanet'. (5701) [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english. (5703) [01S00] [Microsoft][ODBC SQL Server Driver]Недопустимый атрибут строки соединения (0) 000000001A8FCD0F " debug Connected to Microsoft SQL Server using SQLSRV32.DLL 10.50.2500 recognized as MSSQL 000000001A8FCD30 " - 01.964.102 000000001A917350 " + TSQLDatabase(053F23F8).00976547 SynSQLite3.TSQLDatabase.DBOpen (4312) 000000001A95441B " DB TSQLDatabase(053F23F8) ":memory:" database file opened with PageSize=1024 and CacheSize=2000 000000001A954432 " - 00.080.205 000000001A967348 " SQL TSQLDatabase(053F23F8) 97us returned 0 rows SELECT name FROM sqlite_master WHERE type='table' AND name NOT LIKE 'sqlite_%'; 000000001A967364 " DB TSQLRestServerDB(03258C40) CreateMissingTables on {"TSQLDatabase(053F23F8)":{"FileName":":memory:","IsMemory":true,"UseCache":true,"TransactionActive":false,"BusyTimeout":0,"CacheSize":2000,"PageSize":1024,"PageCount":0,"FileSize":0,"WALMode":false,"Synchronous":"Full","LockingMode":"Normal","MemoryMappedMB":0,"user_version":0,"OpenV2Flags":6,"BackupBackgroundInProcess":false,"BackupBackgroundLastTime":"","BackupBackgroundLastFileName":"","SQLite3Library":{"TSQLite3LibraryStatic(02CEC940)":{"Version":"3.9.1 with internal MM"}}}} 000000001A969B11 " DB TSQLRestServerDB(03258C40) "GetTables":[] 000000001A96A9D4 " SQL TSQLDatabase(053F23F8) 16us BEGIN TRANSACTION; 000000001A96AD79 " + TSQLRestStorageExternal(02CE0E70).00AE4B6E mORMotDB.TSQLRestStorageExternal.Create (771) 000000001A96C3B9 " info TSQLRestStorageExternal(02CE0E70) TSQLUser {"TODBCConnectionProperties(02CE2900)":{"Engine":"ODBC","ServerName":"","DatabaseNameSafe":"Driver=SQL Server;Server=nlsql012; Database=SASPlanet;Integrated Security=SSPI","UserID":"","DBMS":"MSSQL","DBMSEngineName":"MSSQL","BatchSendingAbilities":["Create"],"BatchMaxSentAtOnce":4096,"LoggedSQLMaxSize":0,"LogSQLStatementOnException":false,"ForcedSchemaName":"dbo","UseCache":false,"RollbackOnDisconnect":true,"StoreVoidStringAsNull":true}} Server={"TSQLRestServerDB(03258C40)":{"DB":{"TSQLDatabase(053F23F8)":{"FileName":":memory:","IsMemory":true,"UseCache":true,"TransactionActive":true,"BusyTimeout":0,"CacheSize":2000,"PageSize":1024,"PageCount":1,"FileSize":1024,"WALMode":false,"Synchronous":"Full","LockingMode":"Normal","MemoryMappedMB":0,"user_version":0,"OpenV2Flags":6,"BackupBackgroundInProcess":false,"BackupBackgroundLastTime":"","BackupBackgroundLastFileName":"","SQLite3Library":{"TSQLite3LibraryStatic(02CEC940)":{"Version":"3.9.1 with internal MM"}}}},"StatementLastException":"","NoAJAXJSON":true,"HandleAuthentication":false,"BypassORMAuthentication":[],"Stats":{"Success":0,"ServiceMethod":0,"ServiceInterface":0,"OutcomingFiles":0,"CurrentThreadCount":0,"Created":0,"Read":0,"Updated":0,"Deleted":0,"ClientsCurrent":0,"ClientsMax":0,"CurrentRequestCount":0,"Input":{"Bytes":0,"Text":"0 B"},"Output":{"Bytes":0,"Text":"0 B"},"InputThroughput":{"BytesPerSec":0,"Text":"0 B/s"},"OutputThroughput":{"BytesPerSec":0,"Text":"0 B/s"},"Processing":false,"TaskCount":0,"TotalTime":{"MicroSec":0,"Text":"0us"},"LastTime":{"MicroSec":0,"Text":"0us"},"MinimalTime":{"MicroSec":0,"Text":"0us"},"AverageTime":{"MicroSec":0,"Text":"0us"},"MaximalTime":{"MicroSec":0,"Text":"0us"},"PerSec":0,"Errors":0,"LastError":null},"StatLevels":["Tables","Methods","Interfaces","SQLite3"],"StaticVirtualTableDirect":true,"Model":{"TSQLModel(0500B0F0)":{"Root":"root","TableProps":[{"TSQLModelRecordProperties(03FEDDA0)":{"Props":{"TSQLRecordProperties(02146550)":{"SQLTableName":"User","SQLTableRetrieveAllFields":"ID,uName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDE38)":{"Props":{"TSQLRecordProperties(02146390)":{"SQLTableName":"Category","SQLTableRetrieveAllFields":"ID,cName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDED0)":{"Props":{"TSQLRecordProperties(02146010)":{"SQLTableName":"CategoryView","SQLTableRetrieveAllFields":"ID,cvUser,cvCategory,cvVisible,cvMinZoom,cvMaxZoom"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDF68)":{"Props":{"TSQLRecordProperties(021461D0)":{"SQLTableName":"MarkImage","SQLTableRetrieveAllFields":"ID,miName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE000)":{"Props":{"TSQLRecordProperties(03FF4880)":{"SQLTableName":"MarkDBMS","SQLTableRetrieveAllFields":"ID,mCategory,mImage,mAppearance,mName,mDesc,mGeoType,mGeoCount,mGeoLonSize,mGeoLatSize,mGeoWKB,mLeft,mRight,mBottom,mTop"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE098)":{"Props":{"TSQLRecordProperties(03FF4A40)":{"SQLTableName":"MarkView","SQLTableRetrieveAllFields":"ID,mvUser,mvMark,mvCategory,mvVisible"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE130)":{"Props":{"TSQLRecordProperties(03FF4C00)":{"SQLTableName":"MarkAppearance","SQLTableRetrieveAllFields":"ID,maColor1,maColor2,maScale1,maScale2"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE1C8)":{"Props":{"TSQLRecordProperties(03FF4DC0)":{"SQLTableName":"MarkFTS","SQLTableRetrieveAllFields":"ID,mName,mDesc"}},"Kind":"CustomAutoID"}}]}}}} 000000001A97016D " + TODBCStatement(0500B1A0).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001A97029C " - 00.000.097 000000001A9702A7 " + TODBCStatement(0500B1A0).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001A9702C2 " SQL TODBCStatement(0500B1A0) select COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE, 0 INDEX_COUNT from INFORMATION_SCHEMA.COLUMNS where UPPER(TABLE_SCHEMA) = 'DBO' and UPPER(TABLE_NAME) = 'USERINFO' 000000001AA15125 " - 00.216.630 000000001AA66A23 " debug TSQLRestStorageExternal(02CE0E70) "GetFields":[{"ColumnName":"ID","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"uName","ColumnTypeNative":"nvarchar","ColumnLength":-1,"ColumnPrecision":0,"ColumnScale":0,"ColumnType":6,"ColumnIndexed":false}] 000000001AA66B45 " - 00.330.861 000000001AA66D38 " SQL TSQLDatabase(053F23F8) 331.29ms CREATE VIRTUAL TABLE User USING External(uName TEXT COLLATE SYSTEMNOCASE); 000000001AA67057 " + TSQLRestStorageExternal(02CE2080).00AE4B6E mORMotDB.TSQLRestStorageExternal.Create (771) 000000001AA670A4 " info TSQLRestStorageExternal(02CE2080) TSQLCategory {"TODBCConnectionProperties(02CE2900)":{"Engine":"ODBC","ServerName":"","DatabaseNameSafe":"Driver=SQL Server;Server=nlsql012; Database=SASPlanet;Integrated Security=SSPI","UserID":"","DBMS":"MSSQL","DBMSEngineName":"MSSQL","BatchSendingAbilities":["Create"],"BatchMaxSentAtOnce":4096,"LoggedSQLMaxSize":0,"LogSQLStatementOnException":false,"ForcedSchemaName":"dbo","UseCache":false,"RollbackOnDisconnect":true,"StoreVoidStringAsNull":true}} Server={"TSQLRestServerDB(03258C40)":{"DB":{"TSQLDatabase(053F23F8)":{"FileName":":memory:","IsMemory":true,"UseCache":true,"TransactionActive":true,"BusyTimeout":0,"CacheSize":2000,"PageSize":1024,"PageCount":1,"FileSize":1024,"WALMode":false,"Synchronous":"Full","LockingMode":"Normal","MemoryMappedMB":0,"user_version":0,"OpenV2Flags":6,"BackupBackgroundInProcess":false,"BackupBackgroundLastTime":"","BackupBackgroundLastFileName":"","SQLite3Library":{"TSQLite3LibraryStatic(02CEC940)":{"Version":"3.9.1 with internal MM"}}}},"StatementLastException":"","NoAJAXJSON":true,"HandleAuthentication":false,"BypassORMAuthentication":[],"Stats":{"Success":0,"ServiceMethod":0,"ServiceInterface":0,"OutcomingFiles":0,"CurrentThreadCount":0,"Created":0,"Read":0,"Updated":0,"Deleted":0,"ClientsCurrent":0,"ClientsMax":0,"CurrentRequestCount":0,"Input":{"Bytes":0,"Text":"0 B"},"Output":{"Bytes":0,"Text":"0 B"},"InputThroughput":{"BytesPerSec":0,"Text":"0 B/s"},"OutputThroughput":{"BytesPerSec":0,"Text":"0 B/s"},"Processing":false,"TaskCount":0,"TotalTime":{"MicroSec":0,"Text":"0us"},"LastTime":{"MicroSec":0,"Text":"0us"},"MinimalTime":{"MicroSec":0,"Text":"0us"},"AverageTime":{"MicroSec":0,"Text":"0us"},"MaximalTime":{"MicroSec":0,"Text":"0us"},"PerSec":0,"Errors":0,"LastError":null},"StatLevels":["Tables","Methods","Interfaces","SQLite3"],"StaticVirtualTableDirect":true,"Model":{"TSQLModel(0500B0F0)":{"Root":"root","TableProps":[{"TSQLModelRecordProperties(03FEDDA0)":{"Props":{"TSQLRecordProperties(02146550)":{"SQLTableName":"User","SQLTableRetrieveAllFields":"ID,uName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDE38)":{"Props":{"TSQLRecordProperties(02146390)":{"SQLTableName":"Category","SQLTableRetrieveAllFields":"ID,cName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDED0)":{"Props":{"TSQLRecordProperties(02146010)":{"SQLTableName":"CategoryView","SQLTableRetrieveAllFields":"ID,cvUser,cvCategory,cvVisible,cvMinZoom,cvMaxZoom"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDF68)":{"Props":{"TSQLRecordProperties(021461D0)":{"SQLTableName":"MarkImage","SQLTableRetrieveAllFields":"ID,miName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE000)":{"Props":{"TSQLRecordProperties(03FF4880)":{"SQLTableName":"MarkDBMS","SQLTableRetrieveAllFields":"ID,mCategory,mImage,mAppearance,mName,mDesc,mGeoType,mGeoCount,mGeoLonSize,mGeoLatSize,mGeoWKB,mLeft,mRight,mBottom,mTop"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE098)":{"Props":{"TSQLRecordProperties(03FF4A40)":{"SQLTableName":"MarkView","SQLTableRetrieveAllFields":"ID,mvUser,mvMark,mvCategory,mvVisible"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE130)":{"Props":{"TSQLRecordProperties(03FF4C00)":{"SQLTableName":"MarkAppearance","SQLTableRetrieveAllFields":"ID,maColor1,maColor2,maScale1,maScale2"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE1C8)":{"Props":{"TSQLRecordProperties(03FF4DC0)":{"SQLTableName":"MarkFTS","SQLTableRetrieveAllFields":"ID,mName,mDesc"}},"Kind":"CustomAutoID"}}]}}}} 000000001AA674B5 " + TODBCStatement(0500B1A0).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001AA67580 " - 00.000.065 000000001AA6758D " + TODBCStatement(0500B1A0).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001AA675A3 " SQL TODBCStatement(0500B1A0) select COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE, 0 INDEX_COUNT from INFORMATION_SCHEMA.COLUMNS where UPPER(TABLE_SCHEMA) = 'DBO' and UPPER(TABLE_NAME) = 'CATEGORY' 000000001AAB7CBD " - 00.105.682 000000001AB07B3E " debug TSQLRestStorageExternal(02CE2080) "GetFields":[{"ColumnName":"ID","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"cName","ColumnTypeNative":"nvarchar","ColumnLength":-1,"ColumnPrecision":0,"ColumnScale":0,"ColumnType":6,"ColumnIndexed":false}] 000000001AB07BED " - 00.211.136 000000001AB07DE3 " SQL TSQLDatabase(053F23F8) 211.52ms CREATE VIRTUAL TABLE Category USING External(cName TEXT COLLATE SYSTEMNOCASE); 000000001AB0818F " + TSQLRestStorageExternal(02CE22A0).00AE4B6E mORMotDB.TSQLRestStorageExternal.Create (771) 000000001AB081E7 " info TSQLRestStorageExternal(02CE22A0) TSQLCategoryView {"TODBCConnectionProperties(02CE2900)":{"Engine":"ODBC","ServerName":"","DatabaseNameSafe":"Driver=SQL Server;Server=nlsql012; Database=SASPlanet;Integrated Security=SSPI","UserID":"","DBMS":"MSSQL","DBMSEngineName":"MSSQL","BatchSendingAbilities":["Create"],"BatchMaxSentAtOnce":4096,"LoggedSQLMaxSize":0,"LogSQLStatementOnException":false,"ForcedSchemaName":"dbo","UseCache":false,"RollbackOnDisconnect":true,"StoreVoidStringAsNull":true}} Server={"TSQLRestServerDB(03258C40)":{"DB":{"TSQLDatabase(053F23F8)":{"FileName":":memory:","IsMemory":true,"UseCache":true,"TransactionActive":true,"BusyTimeout":0,"CacheSize":2000,"PageSize":1024,"PageCount":1,"FileSize":1024,"WALMode":false,"Synchronous":"Full","LockingMode":"Normal","MemoryMappedMB":0,"user_version":0,"OpenV2Flags":6,"BackupBackgroundInProcess":false,"BackupBackgroundLastTime":"","BackupBackgroundLastFileName":"","SQLite3Library":{"TSQLite3LibraryStatic(02CEC940)":{"Version":"3.9.1 with internal MM"}}}},"StatementLastException":"","NoAJAXJSON":true,"HandleAuthentication":false,"BypassORMAuthentication":[],"Stats":{"Success":0,"ServiceMethod":0,"ServiceInterface":0,"OutcomingFiles":0,"CurrentThreadCount":0,"Created":0,"Read":0,"Updated":0,"Deleted":0,"ClientsCurrent":0,"ClientsMax":0,"CurrentRequestCount":0,"Input":{"Bytes":0,"Text":"0 B"},"Output":{"Bytes":0,"Text":"0 B"},"InputThroughput":{"BytesPerSec":0,"Text":"0 B/s"},"OutputThroughput":{"BytesPerSec":0,"Text":"0 B/s"},"Processing":false,"TaskCount":0,"TotalTime":{"MicroSec":0,"Text":"0us"},"LastTime":{"MicroSec":0,"Text":"0us"},"MinimalTime":{"MicroSec":0,"Text":"0us"},"AverageTime":{"MicroSec":0,"Text":"0us"},"MaximalTime":{"MicroSec":0,"Text":"0us"},"PerSec":0,"Errors":0,"LastError":null},"StatLevels":["Tables","Methods","Interfaces","SQLite3"],"StaticVirtualTableDirect":true,"Model":{"TSQLModel(0500B0F0)":{"Root":"root","TableProps":[{"TSQLModelRecordProperties(03FEDDA0)":{"Props":{"TSQLRecordProperties(02146550)":{"SQLTableName":"User","SQLTableRetrieveAllFields":"ID,uName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDE38)":{"Props":{"TSQLRecordProperties(02146390)":{"SQLTableName":"Category","SQLTableRetrieveAllFields":"ID,cName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDED0)":{"Props":{"TSQLRecordProperties(02146010)":{"SQLTableName":"CategoryView","SQLTableRetrieveAllFields":"ID,cvUser,cvCategory,cvVisible,cvMinZoom,cvMaxZoom"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDF68)":{"Props":{"TSQLRecordProperties(021461D0)":{"SQLTableName":"MarkImage","SQLTableRetrieveAllFields":"ID,miName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE000)":{"Props":{"TSQLRecordProperties(03FF4880)":{"SQLTableName":"MarkDBMS","SQLTableRetrieveAllFields":"ID,mCategory,mImage,mAppearance,mName,mDesc,mGeoType,mGeoCount,mGeoLonSize,mGeoLatSize,mGeoWKB,mLeft,mRight,mBottom,mTop"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE098)":{"Props":{"TSQLRecordProperties(03FF4A40)":{"SQLTableName":"MarkView","SQLTableRetrieveAllFields":"ID,mvUser,mvMark,mvCategory,mvVisible"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE130)":{"Props":{"TSQLRecordProperties(03FF4C00)":{"SQLTableName":"MarkAppearance","SQLTableRetrieveAllFields":"ID,maColor1,maColor2,maScale1,maScale2"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE1C8)":{"Props":{"TSQLRecordProperties(03FF4DC0)":{"SQLTableName":"MarkFTS","SQLTableRetrieveAllFields":"ID,mName,mDesc"}},"Kind":"CustomAutoID"}}]}}}} 000000001AB08E24 " + TODBCStatement(0500B250).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001AB08EEA " - 00.000.063 000000001AB08EF7 " + TODBCStatement(0500B250).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001AB08F10 " SQL TODBCStatement(0500B250) select COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE, 0 INDEX_COUNT from INFORMATION_SCHEMA.COLUMNS where UPPER(TABLE_SCHEMA) = 'DBO' and UPPER(TABLE_NAME) = 'CATEGORYVIEW' 000000001AB83E6A " - 00.161.534 000000001ABD749C " debug TSQLRestStorageExternal(02CE22A0) "GetFields":[{"ColumnName":"ID","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"cvUser","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"cvCategory","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"cvVisible","ColumnTypeNative":"int","ColumnLength":0,"ColumnPrecision":10,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"cvMinZoom","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"cvMaxZoom","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false}] 000000001ABD76A6 " - 00.272.345 000000001ABD78BD " SQL TSQLDatabase(053F23F8) 272.78ms CREATE VIRTUAL TABLE CategoryView USING External(cvUser INTEGER, cvCategory INTEGER, cvVisible INTEGER, cvMinZoom INTEGER, cvMaxZoom INTEGER); 000000001ABD7BCC " + TSQLRestStorageExternal(02CE24C0).00AE4B6E mORMotDB.TSQLRestStorageExternal.Create (771) 000000001ABD7C18 " info TSQLRestStorageExternal(02CE24C0) TSQLMarkImage {"TODBCConnectionProperties(02CE2900)":{"Engine":"ODBC","ServerName":"","DatabaseNameSafe":"Driver=SQL Server;Server=nlsql012; Database=SASPlanet;Integrated Security=SSPI","UserID":"","DBMS":"MSSQL","DBMSEngineName":"MSSQL","BatchSendingAbilities":["Create"],"BatchMaxSentAtOnce":4096,"LoggedSQLMaxSize":0,"LogSQLStatementOnException":false,"ForcedSchemaName":"dbo","UseCache":false,"RollbackOnDisconnect":true,"StoreVoidStringAsNull":true}} Server={"TSQLRestServerDB(03258C40)":{"DB":{"TSQLDatabase(053F23F8)":{"FileName":":memory:","IsMemory":true,"UseCache":true,"TransactionActive":true,"BusyTimeout":0,"CacheSize":2000,"PageSize":1024,"PageCount":1,"FileSize":1024,"WALMode":false,"Synchronous":"Full","LockingMode":"Normal","MemoryMappedMB":0,"user_version":0,"OpenV2Flags":6,"BackupBackgroundInProcess":false,"BackupBackgroundLastTime":"","BackupBackgroundLastFileName":"","SQLite3Library":{"TSQLite3LibraryStatic(02CEC940)":{"Version":"3.9.1 with internal MM"}}}},"StatementLastException":"","NoAJAXJSON":true,"HandleAuthentication":false,"BypassORMAuthentication":[],"Stats":{"Success":0,"ServiceMethod":0,"ServiceInterface":0,"OutcomingFiles":0,"CurrentThreadCount":0,"Created":0,"Read":0,"Updated":0,"Deleted":0,"ClientsCurrent":0,"ClientsMax":0,"CurrentRequestCount":0,"Input":{"Bytes":0,"Text":"0 B"},"Output":{"Bytes":0,"Text":"0 B"},"InputThroughput":{"BytesPerSec":0,"Text":"0 B/s"},"OutputThroughput":{"BytesPerSec":0,"Text":"0 B/s"},"Processing":false,"TaskCount":0,"TotalTime":{"MicroSec":0,"Text":"0us"},"LastTime":{"MicroSec":0,"Text":"0us"},"MinimalTime":{"MicroSec":0,"Text":"0us"},"AverageTime":{"MicroSec":0,"Text":"0us"},"MaximalTime":{"MicroSec":0,"Text":"0us"},"PerSec":0,"Errors":0,"LastError":null},"StatLevels":["Tables","Methods","Interfaces","SQLite3"],"StaticVirtualTableDirect":true,"Model":{"TSQLModel(0500B0F0)":{"Root":"root","TableProps":[{"TSQLModelRecordProperties(03FEDDA0)":{"Props":{"TSQLRecordProperties(02146550)":{"SQLTableName":"User","SQLTableRetrieveAllFields":"ID,uName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDE38)":{"Props":{"TSQLRecordProperties(02146390)":{"SQLTableName":"Category","SQLTableRetrieveAllFields":"ID,cName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDED0)":{"Props":{"TSQLRecordProperties(02146010)":{"SQLTableName":"CategoryView","SQLTableRetrieveAllFields":"ID,cvUser,cvCategory,cvVisible,cvMinZoom,cvMaxZoom"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDF68)":{"Props":{"TSQLRecordProperties(021461D0)":{"SQLTableName":"MarkImage","SQLTableRetrieveAllFields":"ID,miName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE000)":{"Props":{"TSQLRecordProperties(03FF4880)":{"SQLTableName":"MarkDBMS","SQLTableRetrieveAllFields":"ID,mCategory,mImage,mAppearance,mName,mDesc,mGeoType,mGeoCount,mGeoLonSize,mGeoLatSize,mGeoWKB,mLeft,mRight,mBottom,mTop"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE098)":{"Props":{"TSQLRecordProperties(03FF4A40)":{"SQLTableName":"MarkView","SQLTableRetrieveAllFields":"ID,mvUser,mvMark,mvCategory,mvVisible"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE130)":{"Props":{"TSQLRecordProperties(03FF4C00)":{"SQLTableName":"MarkAppearance","SQLTableRetrieveAllFields":"ID,maColor1,maColor2,maScale1,maScale2"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE1C8)":{"Props":{"TSQLRecordProperties(03FF4DC0)":{"SQLTableName":"MarkFTS","SQLTableRetrieveAllFields":"ID,mName,mDesc"}},"Kind":"CustomAutoID"}}]}}}} 000000001ABD7FB3 " + TODBCStatement(0500B250).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001ABD806F " - 00.000.060 000000001ABD807B " + TODBCStatement(0500B250).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001ABD8091 " SQL TODBCStatement(0500B250) select COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE, 0 INDEX_COUNT from INFORMATION_SCHEMA.COLUMNS where UPPER(TABLE_SCHEMA) = 'DBO' and UPPER(TABLE_NAME) = 'MARKIMAGE' 000000001AC27BC9 " - 00.104.707 000000001AC779EB " debug TSQLRestStorageExternal(02CE24C0) "GetFields":[{"ColumnName":"ID","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"miName","ColumnTypeNative":"nvarchar","ColumnLength":-1,"ColumnPrecision":0,"ColumnScale":0,"ColumnType":6,"ColumnIndexed":false}] 000000001AC77A95 " - 00.210.085 000000001AC77C81 " SQL TSQLDatabase(053F23F8) 210.46ms CREATE VIRTUAL TABLE MarkImage USING External(miName TEXT COLLATE SYSTEMNOCASE); 000000001AC78040 " + TSQLRestStorageExternal(02CE25D0).00AE4B6E mORMotDB.TSQLRestStorageExternal.Create (771) 000000001AC7808B " info TSQLRestStorageExternal(02CE25D0) TSQLMarkDBMS {"TODBCConnectionProperties(02CE2900)":{"Engine":"ODBC","ServerName":"","DatabaseNameSafe":"Driver=SQL Server;Server=nlsql012; Database=SASPlanet;Integrated Security=SSPI","UserID":"","DBMS":"MSSQL","DBMSEngineName":"MSSQL","BatchSendingAbilities":["Create"],"BatchMaxSentAtOnce":4096,"LoggedSQLMaxSize":0,"LogSQLStatementOnException":false,"ForcedSchemaName":"dbo","UseCache":false,"RollbackOnDisconnect":true,"StoreVoidStringAsNull":true}} Server={"TSQLRestServerDB(03258C40)":{"DB":{"TSQLDatabase(053F23F8)":{"FileName":":memory:","IsMemory":true,"UseCache":true,"TransactionActive":true,"BusyTimeout":0,"CacheSize":2000,"PageSize":1024,"PageCount":1,"FileSize":1024,"WALMode":false,"Synchronous":"Full","LockingMode":"Normal","MemoryMappedMB":0,"user_version":0,"OpenV2Flags":6,"BackupBackgroundInProcess":false,"BackupBackgroundLastTime":"","BackupBackgroundLastFileName":"","SQLite3Library":{"TSQLite3LibraryStatic(02CEC940)":{"Version":"3.9.1 with internal MM"}}}},"StatementLastException":"","NoAJAXJSON":true,"HandleAuthentication":false,"BypassORMAuthentication":[],"Stats":{"Success":0,"ServiceMethod":0,"ServiceInterface":0,"OutcomingFiles":0,"CurrentThreadCount":0,"Created":0,"Read":0,"Updated":0,"Deleted":0,"ClientsCurrent":0,"ClientsMax":0,"CurrentRequestCount":0,"Input":{"Bytes":0,"Text":"0 B"},"Output":{"Bytes":0,"Text":"0 B"},"InputThroughput":{"BytesPerSec":0,"Text":"0 B/s"},"OutputThroughput":{"BytesPerSec":0,"Text":"0 B/s"},"Processing":false,"TaskCount":0,"TotalTime":{"MicroSec":0,"Text":"0us"},"LastTime":{"MicroSec":0,"Text":"0us"},"MinimalTime":{"MicroSec":0,"Text":"0us"},"AverageTime":{"MicroSec":0,"Text":"0us"},"MaximalTime":{"MicroSec":0,"Text":"0us"},"PerSec":0,"Errors":0,"LastError":null},"StatLevels":["Tables","Methods","Interfaces","SQLite3"],"StaticVirtualTableDirect":true,"Model":{"TSQLModel(0500B0F0)":{"Root":"root","TableProps":[{"TSQLModelRecordProperties(03FEDDA0)":{"Props":{"TSQLRecordProperties(02146550)":{"SQLTableName":"User","SQLTableRetrieveAllFields":"ID,uName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDE38)":{"Props":{"TSQLRecordProperties(02146390)":{"SQLTableName":"Category","SQLTableRetrieveAllFields":"ID,cName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDED0)":{"Props":{"TSQLRecordProperties(02146010)":{"SQLTableName":"CategoryView","SQLTableRetrieveAllFields":"ID,cvUser,cvCategory,cvVisible,cvMinZoom,cvMaxZoom"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDF68)":{"Props":{"TSQLRecordProperties(021461D0)":{"SQLTableName":"MarkImage","SQLTableRetrieveAllFields":"ID,miName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE000)":{"Props":{"TSQLRecordProperties(03FF4880)":{"SQLTableName":"MarkDBMS","SQLTableRetrieveAllFields":"ID,mCategory,mImage,mAppearance,mName,mDesc,mGeoType,mGeoCount,mGeoLonSize,mGeoLatSize,mGeoWKB,mLeft,mRight,mBottom,mTop"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE098)":{"Props":{"TSQLRecordProperties(03FF4A40)":{"SQLTableName":"MarkView","SQLTableRetrieveAllFields":"ID,mvUser,mvMark,mvCategory,mvVisible"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE130)":{"Props":{"TSQLRecordProperties(03FF4C00)":{"SQLTableName":"MarkAppearance","SQLTableRetrieveAllFields":"ID,maColor1,maColor2,maScale1,maScale2"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE1C8)":{"Props":{"TSQLRecordProperties(03FF4DC0)":{"SQLTableName":"MarkFTS","SQLTableRetrieveAllFields":"ID,mName,mDesc"}},"Kind":"CustomAutoID"}}]}}}} 000000001AC784B1 " + TODBCStatement(0500B250).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001AC78573 " - 00.000.062 000000001AC7857F " + TODBCStatement(0500B250).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001AC78595 " SQL TODBCStatement(0500B250) select COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE, 0 INDEX_COUNT from INFORMATION_SCHEMA.COLUMNS where UPPER(TABLE_SCHEMA) = 'DBO' and UPPER(TABLE_NAME) = 'MARK' 000000001ACCA51B " - 00.107.688 000000001AD19E9D " debug TSQLRestStorageExternal(02CE25D0) "GetFields":[{"ColumnName":"ID","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"mCategory","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"mImage","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"mAppearance","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"mName","ColumnTypeNative":"nvarchar","ColumnLength":-1,"ColumnPrecision":0,"ColumnScale":0,"ColumnType":6,"ColumnIndexed":false},{"ColumnName":"mDesc","ColumnTypeNative":"nvarchar","ColumnLength":-1,"ColumnPrecision":0,"ColumnScale":0,"ColumnType":6,"ColumnIndexed":false},{"ColumnName":"mGeoType","ColumnTypeNative":"int","ColumnLength":0,"ColumnPrecision":10,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"mGeoCount","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"mGeoLonSize","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"mGeoLatSize","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"mGeoWKB","ColumnTypeNative":"varbinary","ColumnLength":-1,"ColumnPrecision":0,"ColumnScale":0,"ColumnType":7,"ColumnIndexed":false},{"ColumnName":"mLeft","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"mRight","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"mBottom","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"mTop","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false}] 000000001AD1A010 " - 00.212.797 000000001AD1A2AE " SQL TSQLDatabase(053F23F8) 213.27ms CREATE VIRTUAL TABLE MarkDBMS USING External(mCategory INTEGER, mImage INTEGER, mAppearance INTEGER, mName TEXT COLLATE SYSTEMNOCASE, mDesc TEXT COLLATE SYSTEMNOCASE, mGeoType INTEGER, mGeoCount INTEGER, mGeoLonSize INTEGER, mGeoLatSize INTEGER, mGeoWKB BLOB, mLeft INTEGER, mRight INTEGER, mBottom INTEGER, mTop INTEGER); 000000001AD1A680 " + TSQLRestStorageExternal(02CE26E0).00AE4B6E mORMotDB.TSQLRestStorageExternal.Create (771) 000000001AD1A6D1 " info TSQLRestStorageExternal(02CE26E0) TSQLMarkView {"TODBCConnectionProperties(02CE2900)":{"Engine":"ODBC","ServerName":"","DatabaseNameSafe":"Driver=SQL Server;Server=nlsql012; Database=SASPlanet;Integrated Security=SSPI","UserID":"","DBMS":"MSSQL","DBMSEngineName":"MSSQL","BatchSendingAbilities":["Create"],"BatchMaxSentAtOnce":4096,"LoggedSQLMaxSize":0,"LogSQLStatementOnException":false,"ForcedSchemaName":"dbo","UseCache":false,"RollbackOnDisconnect":true,"StoreVoidStringAsNull":true}} Server={"TSQLRestServerDB(03258C40)":{"DB":{"TSQLDatabase(053F23F8)":{"FileName":":memory:","IsMemory":true,"UseCache":true,"TransactionActive":true,"BusyTimeout":0,"CacheSize":2000,"PageSize":1024,"PageCount":2,"FileSize":2048,"WALMode":false,"Synchronous":"Full","LockingMode":"Normal","MemoryMappedMB":0,"user_version":0,"OpenV2Flags":6,"BackupBackgroundInProcess":false,"BackupBackgroundLastTime":"","BackupBackgroundLastFileName":"","SQLite3Library":{"TSQLite3LibraryStatic(02CEC940)":{"Version":"3.9.1 with internal MM"}}}},"StatementLastException":"","NoAJAXJSON":true,"HandleAuthentication":false,"BypassORMAuthentication":[],"Stats":{"Success":0,"ServiceMethod":0,"ServiceInterface":0,"OutcomingFiles":0,"CurrentThreadCount":0,"Created":0,"Read":0,"Updated":0,"Deleted":0,"ClientsCurrent":0,"ClientsMax":0,"CurrentRequestCount":0,"Input":{"Bytes":0,"Text":"0 B"},"Output":{"Bytes":0,"Text":"0 B"},"InputThroughput":{"BytesPerSec":0,"Text":"0 B/s"},"OutputThroughput":{"BytesPerSec":0,"Text":"0 B/s"},"Processing":false,"TaskCount":0,"TotalTime":{"MicroSec":0,"Text":"0us"},"LastTime":{"MicroSec":0,"Text":"0us"},"MinimalTime":{"MicroSec":0,"Text":"0us"},"AverageTime":{"MicroSec":0,"Text":"0us"},"MaximalTime":{"MicroSec":0,"Text":"0us"},"PerSec":0,"Errors":0,"LastError":null},"StatLevels":["Tables","Methods","Interfaces","SQLite3"],"StaticVirtualTableDirect":true,"Model":{"TSQLModel(0500B0F0)":{"Root":"root","TableProps":[{"TSQLModelRecordProperties(03FEDDA0)":{"Props":{"TSQLRecordProperties(02146550)":{"SQLTableName":"User","SQLTableRetrieveAllFields":"ID,uName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDE38)":{"Props":{"TSQLRecordProperties(02146390)":{"SQLTableName":"Category","SQLTableRetrieveAllFields":"ID,cName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDED0)":{"Props":{"TSQLRecordProperties(02146010)":{"SQLTableName":"CategoryView","SQLTableRetrieveAllFields":"ID,cvUser,cvCategory,cvVisible,cvMinZoom,cvMaxZoom"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDF68)":{"Props":{"TSQLRecordProperties(021461D0)":{"SQLTableName":"MarkImage","SQLTableRetrieveAllFields":"ID,miName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE000)":{"Props":{"TSQLRecordProperties(03FF4880)":{"SQLTableName":"MarkDBMS","SQLTableRetrieveAllFields":"ID,mCategory,mImage,mAppearance,mName,mDesc,mGeoType,mGeoCount,mGeoLonSize,mGeoLatSize,mGeoWKB,mLeft,mRight,mBottom,mTop"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE098)":{"Props":{"TSQLRecordProperties(03FF4A40)":{"SQLTableName":"MarkView","SQLTableRetrieveAllFields":"ID,mvUser,mvMark,mvCategory,mvVisible"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE130)":{"Props":{"TSQLRecordProperties(03FF4C00)":{"SQLTableName":"MarkAppearance","SQLTableRetrieveAllFields":"ID,maColor1,maColor2,maScale1,maScale2"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE1C8)":{"Props":{"TSQLRecordProperties(03FF4DC0)":{"SQLTableName":"MarkFTS","SQLTableRetrieveAllFields":"ID,mName,mDesc"}},"Kind":"CustomAutoID"}}]}}}} 000000001AD1AB0F " + TODBCStatement(02162940).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001AD1ABD8 " - 00.000.064 000000001AD1ABE3 " + TODBCStatement(02162940).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001AD1ABF9 " SQL TODBCStatement(02162940) select COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE, 0 INDEX_COUNT from INFORMATION_SCHEMA.COLUMNS where UPPER(TABLE_SCHEMA) = 'DBO' and UPPER(TABLE_NAME) = 'MARKVIEW' 000000001AD6BFCF " - 00.106.728 000000001ADBAD0D " debug TSQLRestStorageExternal(02CE26E0) "GetFields":[{"ColumnName":"ID","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"mvUser","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"mvMark","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"mvCategory","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"mvVisible","ColumnTypeNative":"int","ColumnLength":0,"ColumnPrecision":10,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false}] 000000001ADBAEFA " - 00.210.881 000000001ADBB103 " SQL TSQLDatabase(053F23F8) 211.32ms CREATE VIRTUAL TABLE MarkView USING External(mvUser INTEGER, mvMark INTEGER, mvCategory INTEGER, mvVisible INTEGER); 000000001ADBB503 " + TSQLRestStorageExternal(02CE2A10).00AE4B6E mORMotDB.TSQLRestStorageExternal.Create (771) 000000001ADBB551 " info TSQLRestStorageExternal(02CE2A10) TSQLMarkAppearance {"TODBCConnectionProperties(02CE2900)":{"Engine":"ODBC","ServerName":"","DatabaseNameSafe":"Driver=SQL Server;Server=nlsql012; Database=SASPlanet;Integrated Security=SSPI","UserID":"","DBMS":"MSSQL","DBMSEngineName":"MSSQL","BatchSendingAbilities":["Create"],"BatchMaxSentAtOnce":4096,"LoggedSQLMaxSize":0,"LogSQLStatementOnException":false,"ForcedSchemaName":"dbo","UseCache":false,"RollbackOnDisconnect":true,"StoreVoidStringAsNull":true}} Server={"TSQLRestServerDB(03258C40)":{"DB":{"TSQLDatabase(053F23F8)":{"FileName":":memory:","IsMemory":true,"UseCache":true,"TransactionActive":true,"BusyTimeout":0,"CacheSize":2000,"PageSize":1024,"PageCount":3,"FileSize":3072,"WALMode":false,"Synchronous":"Full","LockingMode":"Normal","MemoryMappedMB":0,"user_version":0,"OpenV2Flags":6,"BackupBackgroundInProcess":false,"BackupBackgroundLastTime":"","BackupBackgroundLastFileName":"","SQLite3Library":{"TSQLite3LibraryStatic(02CEC940)":{"Version":"3.9.1 with internal MM"}}}},"StatementLastException":"","NoAJAXJSON":true,"HandleAuthentication":false,"BypassORMAuthentication":[],"Stats":{"Success":0,"ServiceMethod":0,"ServiceInterface":0,"OutcomingFiles":0,"CurrentThreadCount":0,"Created":0,"Read":0,"Updated":0,"Deleted":0,"ClientsCurrent":0,"ClientsMax":0,"CurrentRequestCount":0,"Input":{"Bytes":0,"Text":"0 B"},"Output":{"Bytes":0,"Text":"0 B"},"InputThroughput":{"BytesPerSec":0,"Text":"0 B/s"},"OutputThroughput":{"BytesPerSec":0,"Text":"0 B/s"},"Processing":false,"TaskCount":0,"TotalTime":{"MicroSec":0,"Text":"0us"},"LastTime":{"MicroSec":0,"Text":"0us"},"MinimalTime":{"MicroSec":0,"Text":"0us"},"AverageTime":{"MicroSec":0,"Text":"0us"},"MaximalTime":{"MicroSec":0,"Text":"0us"},"PerSec":0,"Errors":0,"LastError":null},"StatLevels":["Tables","Methods","Interfaces","SQLite3"],"StaticVirtualTableDirect":true,"Model":{"TSQLModel(0500B0F0)":{"Root":"root","TableProps":[{"TSQLModelRecordProperties(03FEDDA0)":{"Props":{"TSQLRecordProperties(02146550)":{"SQLTableName":"User","SQLTableRetrieveAllFields":"ID,uName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDE38)":{"Props":{"TSQLRecordProperties(02146390)":{"SQLTableName":"Category","SQLTableRetrieveAllFields":"ID,cName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDED0)":{"Props":{"TSQLRecordProperties(02146010)":{"SQLTableName":"CategoryView","SQLTableRetrieveAllFields":"ID,cvUser,cvCategory,cvVisible,cvMinZoom,cvMaxZoom"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDF68)":{"Props":{"TSQLRecordProperties(021461D0)":{"SQLTableName":"MarkImage","SQLTableRetrieveAllFields":"ID,miName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE000)":{"Props":{"TSQLRecordProperties(03FF4880)":{"SQLTableName":"MarkDBMS","SQLTableRetrieveAllFields":"ID,mCategory,mImage,mAppearance,mName,mDesc,mGeoType,mGeoCount,mGeoLonSize,mGeoLatSize,mGeoWKB,mLeft,mRight,mBottom,mTop"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE098)":{"Props":{"TSQLRecordProperties(03FF4A40)":{"SQLTableName":"MarkView","SQLTableRetrieveAllFields":"ID,mvUser,mvMark,mvCategory,mvVisible"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE130)":{"Props":{"TSQLRecordProperties(03FF4C00)":{"SQLTableName":"MarkAppearance","SQLTableRetrieveAllFields":"ID,maColor1,maColor2,maScale1,maScale2"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE1C8)":{"Props":{"TSQLRecordProperties(03FF4DC0)":{"SQLTableName":"MarkFTS","SQLTableRetrieveAllFields":"ID,mName,mDesc"}},"Kind":"CustomAutoID"}}]}}}} 000000001ADBB89F " + TODBCStatement(02162940).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001ADBB95C " - 00.000.060 000000001ADBB968 " + TODBCStatement(02162940).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001ADBB97F " SQL TODBCStatement(02162940) select COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE, 0 INDEX_COUNT from INFORMATION_SCHEMA.COLUMNS where UPPER(TABLE_SCHEMA) = 'DBO' and UPPER(TABLE_NAME) = 'MARKAPPEARANCE' 000000001AE3316B " - 00.156.983 000000001AE8334E " debug TSQLRestStorageExternal(02CE2A10) "GetFields":[{"ColumnName":"ID","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"maColor1","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"maColor2","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"maScale1","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"maScale2","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false}] 000000001AE8340E " - 00.262.653 000000001AE83614 " SQL TSQLDatabase(053F23F8) 263.11ms CREATE VIRTUAL TABLE MarkAppearance USING External(maColor1 INTEGER, maColor2 INTEGER, maScale1 INTEGER, maScale2 INTEGER); 000000001AE8394E " + TSQLRestStorageExternal(02CE2B20).00AE4B6E mORMotDB.TSQLRestStorageExternal.Create (771) 000000001AE83999 " info TSQLRestStorageExternal(02CE2B20) TSQLMarkFTS {"TODBCConnectionProperties(02CE2900)":{"Engine":"ODBC","ServerName":"","DatabaseNameSafe":"Driver=SQL Server;Server=nlsql012; Database=SASPlanet;Integrated Security=SSPI","UserID":"","DBMS":"MSSQL","DBMSEngineName":"MSSQL","BatchSendingAbilities":["Create"],"BatchMaxSentAtOnce":4096,"LoggedSQLMaxSize":0,"LogSQLStatementOnException":false,"ForcedSchemaName":"dbo","UseCache":false,"RollbackOnDisconnect":true,"StoreVoidStringAsNull":true}} Server={"TSQLRestServerDB(03258C40)":{"DB":{"TSQLDatabase(053F23F8)":{"FileName":":memory:","IsMemory":true,"UseCache":true,"TransactionActive":true,"BusyTimeout":0,"CacheSize":2000,"PageSize":1024,"PageCount":3,"FileSize":3072,"WALMode":false,"Synchronous":"Full","LockingMode":"Normal","MemoryMappedMB":0,"user_version":0,"OpenV2Flags":6,"BackupBackgroundInProcess":false,"BackupBackgroundLastTime":"","BackupBackgroundLastFileName":"","SQLite3Library":{"TSQLite3LibraryStatic(02CEC940)":{"Version":"3.9.1 with internal MM"}}}},"StatementLastException":"","NoAJAXJSON":true,"HandleAuthentication":false,"BypassORMAuthentication":[],"Stats":{"Success":0,"ServiceMethod":0,"ServiceInterface":0,"OutcomingFiles":0,"CurrentThreadCount":0,"Created":0,"Read":0,"Updated":0,"Deleted":0,"ClientsCurrent":0,"ClientsMax":0,"CurrentRequestCount":0,"Input":{"Bytes":0,"Text":"0 B"},"Output":{"Bytes":0,"Text":"0 B"},"InputThroughput":{"BytesPerSec":0,"Text":"0 B/s"},"OutputThroughput":{"BytesPerSec":0,"Text":"0 B/s"},"Processing":false,"TaskCount":0,"TotalTime":{"MicroSec":0,"Text":"0us"},"LastTime":{"MicroSec":0,"Text":"0us"},"MinimalTime":{"MicroSec":0,"Text":"0us"},"AverageTime":{"MicroSec":0,"Text":"0us"},"MaximalTime":{"MicroSec":0,"Text":"0us"},"PerSec":0,"Errors":0,"LastError":null},"StatLevels":["Tables","Methods","Interfaces","SQLite3"],"StaticVirtualTableDirect":true,"Model":{"TSQLModel(0500B0F0)":{"Root":"root","TableProps":[{"TSQLModelRecordProperties(03FEDDA0)":{"Props":{"TSQLRecordProperties(02146550)":{"SQLTableName":"User","SQLTableRetrieveAllFields":"ID,uName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDE38)":{"Props":{"TSQLRecordProperties(02146390)":{"SQLTableName":"Category","SQLTableRetrieveAllFields":"ID,cName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDED0)":{"Props":{"TSQLRecordProperties(02146010)":{"SQLTableName":"CategoryView","SQLTableRetrieveAllFields":"ID,cvUser,cvCategory,cvVisible,cvMinZoom,cvMaxZoom"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDF68)":{"Props":{"TSQLRecordProperties(021461D0)":{"SQLTableName":"MarkImage","SQLTableRetrieveAllFields":"ID,miName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE000)":{"Props":{"TSQLRecordProperties(03FF4880)":{"SQLTableName":"MarkDBMS","SQLTableRetrieveAllFields":"ID,mCategory,mImage,mAppearance,mName,mDesc,mGeoType,mGeoCount,mGeoLonSize,mGeoLatSize,mGeoWKB,mLeft,mRight,mBottom,mTop"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE098)":{"Props":{"TSQLRecordProperties(03FF4A40)":{"SQLTableName":"MarkView","SQLTableRetrieveAllFields":"ID,mvUser,mvMark,mvCategory,mvVisible"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE130)":{"Props":{"TSQLRecordProperties(03FF4C00)":{"SQLTableName":"MarkAppearance","SQLTableRetrieveAllFields":"ID,maColor1,maColor2,maScale1,maScale2"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE1C8)":{"Props":{"TSQLRecordProperties(03FF4DC0)":{"SQLTableName":"MarkFTS","SQLTableRetrieveAllFields":"ID,mName,mDesc"}},"Kind":"CustomAutoID"}}]}}}} 000000001AE83D5C " + TODBCStatement(02162940).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001AE83E1D " - 00.000.061 000000001AE83E2B " + TODBCStatement(02162940).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001AE83E41 " SQL TODBCStatement(02162940) select COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, NUMERIC_PRECISION, NUMERIC_SCALE, 0 INDEX_COUNT from INFORMATION_SCHEMA.COLUMNS where UPPER(TABLE_SCHEMA) = 'DBO' and UPPER(TABLE_NAME) = 'MARKFTS' 000000001AED3170 " - 00.104.047 000000001AF237F2 " debug TSQLRestStorageExternal(02CE2B20) "GetFields":[{"ColumnName":"ID","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":2,"ColumnIndexed":false},{"ColumnName":"mName","ColumnTypeNative":"nvarchar","ColumnLength":-1,"ColumnPrecision":0,"ColumnScale":0,"ColumnType":6,"ColumnIndexed":false},{"ColumnName":"mDesc","ColumnTypeNative":"nvarchar","ColumnLength":-1,"ColumnPrecision":0,"ColumnScale":0,"ColumnType":6,"ColumnIndexed":false}] 000000001AF23852 " - 00.210.104 000000001AF23926 " SQL TSQLDatabase(053F23F8) 210.41ms CREATE VIRTUAL TABLE MarkFTS USING External(mName TEXT COLLATE SYSTEMNOCASE, mDesc TEXT COLLATE SYSTEMNOCASE); 000000001AF23955 " + TODBCStatement(02162940).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001AF2398F " - 00.000.018 000000001AF23993 " + TODBCStatement(02162940).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001AF2399A " SQL TODBCStatement(02162940) select top(1) ID from dbo.UserInfo 000000001AF7282E " - 00.103.664 000000001AFC4DC1 " + TODBCStatement(02162940).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001AFC4DF3 " - 00.000.016 000000001AFC4DF9 " + TODBCStatement(02162940).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001AFC4DFE " SQL TODBCStatement(02162940) select top(1) ID from dbo.Category 000000001B015237 " - 00.105.441 000000001B064840 " + TODBCStatement(02162940).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001B064878 " - 00.000.017 000000001B06487D " + TODBCStatement(02162940).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001B064882 " SQL TODBCStatement(02162940) select top(1) ID from dbo.CategoryView 000000001B0B534D " - 00.105.980 000000001B104534 " + TODBCStatement(02162940).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001B10457C " - 00.000.023 000000001B104583 " + TODBCStatement(02162940).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001B10458C " SQL TODBCStatement(02162940) CREATE INDEX NDXCategoryViewcvUser ON dbo.CategoryView(cvUser) 000000001B170522 " EXC EODBCException {"Statement":{"SQL":"CREATE INDEX NDXCategoryViewcvUser ON dbo.CategoryView(cvUser)","SQLWithInlinedParams":"CREATE INDEX NDXCategoryViewcvUser ON dbo.CategoryView(cvUser)","CurrentRow":0,"TotalRowsRetrieved":0,"Connection":{"DBMSName":"Microsoft SQL Server","DBMSVersion":"10.50.2500","DriverName":"SQLSRV32.DLL","Connected":true,"ServerTimeStampAtConnection":"2015-11-09T07:34:48","TotalConnectionCount":1,"TransactionCount":0,"InTransaction":false,"RollbackOnDisconnect":true,"LastErrorMessage":"","LastErrorWasAboutConnection":false,"Properties":{"Engine":"ODBC","ServerName":"","DatabaseNameSafe":"Driver=SQL Server;Server=nlsql012; Database=SASPlanet;Integrated Security=SSPI","UserID":"","DBMS":3,"DBMSEngineName":"MSSQL","BatchSendingAbilities":1,"BatchMaxSentAtOnce":4096,"LoggedSQLMaxSize":0,"LogSQLStatementOnException":false,"ForcedSchemaName":"dbo","UseCache":false,"RollbackOnDisconnect":true,"StoreVoidStringAsNull":true}}},"Message":"TODBCStatement - TODBCLib error: [42S11] [Microsoft][ODBC SQL Server Driver][SQL Server]The operation failed because an index or statistics with name 'NDXCategoryViewcvUser' already exists on table 'dbo.CategoryView'. (1913)\r\n"} at 00AF01D9 SynDBODBC.TODBCLib.HandleError (1755) stack trace API 000000001B1705CC " - 00.141.898 000000001B170617 " + TODBCStatement(02162940).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001B170638 " - 00.000.010 000000001B17063B " + TODBCStatement(02162940).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001B170640 " SQL TODBCStatement(02162940) CREATE INDEX NDXCategoryViewcvCategory ON dbo.CategoryView(cvCategory) 000000001B1BFB55 " EXC EODBCException {"Statement":{"SQL":"CREATE INDEX NDXCategoryViewcvCategory ON dbo.CategoryView(cvCategory)","SQLWithInlinedParams":"CREATE INDEX NDXCategoryViewcvCategory ON dbo.CategoryView(cvCategory)","CurrentRow":0,"TotalRowsRetrieved":0,"Connection":{"DBMSName":"Microsoft SQL Server","DBMSVersion":"10.50.2500","DriverName":"SQLSRV32.DLL","Connected":true,"ServerTimeStampAtConnection":"2015-11-09T07:34:48","TotalConnectionCount":1,"TransactionCount":0,"InTransaction":false,"RollbackOnDisconnect":true,"LastErrorMessage":"","LastErrorWasAboutConnection":false,"Properties":{"Engine":"ODBC","ServerName":"","DatabaseNameSafe":"Driver=SQL Server;Server=nlsql012; Database=SASPlanet;Integrated Security=SSPI","UserID":"","DBMS":3,"DBMSEngineName":"MSSQL","BatchSendingAbilities":1,"BatchMaxSentAtOnce":4096,"LoggedSQLMaxSize":0,"LogSQLStatementOnException":false,"ForcedSchemaName":"dbo","UseCache":false,"RollbackOnDisconnect":true,"StoreVoidStringAsNull":true}}},"Message":"TODBCStatement - TODBCLib error: [42S11] [Microsoft][ODBC SQL Server Driver][SQL Server]The operation failed because an index or statistics with name 'NDXCategoryViewcvCategory' already exists on table 'dbo.CategoryView'. (1913)\r\n"} at 00AF01D9 SynDBODBC.TODBCLib.HandleError (1755) stack trace API 000000001B1BFC20 " - 00.104.263 000000001B1BFC80 " + TODBCStatement(02162940).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001B1BFCAF " - 00.000.015 000000001B1BFCBE " + TODBCStatement(02162940).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001B1BFCC4 " SQL TODBCStatement(02162940) select top(1) ID from dbo.MarkImage 000000001B20F4F2 " - 00.104.452 000000001B25DDAC " + TODBCStatement(02162940).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001B25DDE0 " - 00.000.016 000000001B25DDE4 " + TODBCStatement(02162940).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001B25DDEA " SQL TODBCStatement(02162940) select top(1) ID from dbo.Mark 000000001B2B6443 " - 00.116.125 000000001B3064A9 " + TODBCStatement(02162940).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001B3064E2 " - 00.000.018 000000001B3064E9 " + TODBCStatement(02162940).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001B3064EF " SQL TODBCStatement(02162940) CREATE INDEX NDXMarkmCategory ON dbo.Mark(mCategory) 000000001B3593EE " EXC EODBCException {"Statement":{"SQL":"CREATE INDEX NDXMarkmCategory ON dbo.Mark(mCategory)","SQLWithInlinedParams":"CREATE INDEX NDXMarkmCategory ON dbo.Mark(mCategory)","CurrentRow":0,"TotalRowsRetrieved":0,"Connection":{"DBMSName":"Microsoft SQL Server","DBMSVersion":"10.50.2500","DriverName":"SQLSRV32.DLL","Connected":true,"ServerTimeStampAtConnection":"2015-11-09T07:34:48","TotalConnectionCount":1,"TransactionCount":0,"InTransaction":false,"RollbackOnDisconnect":true,"LastErrorMessage":"","LastErrorWasAboutConnection":false,"Properties":{"Engine":"ODBC","ServerName":"","DatabaseNameSafe":"Driver=SQL Server;Server=nlsql012; Database=SASPlanet;Integrated Security=SSPI","UserID":"","DBMS":3,"DBMSEngineName":"MSSQL","BatchSendingAbilities":1,"BatchMaxSentAtOnce":4096,"LoggedSQLMaxSize":0,"LogSQLStatementOnException":false,"ForcedSchemaName":"dbo","UseCache":false,"RollbackOnDisconnect":true,"StoreVoidStringAsNull":true}}},"Message":"TODBCStatement - TODBCLib error: [42S11] [Microsoft][ODBC SQL Server Driver][SQL Server]The operation failed because an index or statistics with name 'NDXMarkmCategory' already exists on table 'dbo.Mark'. (1913)\r\n"} at 00AF01D9 SynDBODBC.TODBCLib.HandleError (1755) stack trace API 000000001B3594CE " - 00.109.025 000000001B35953C " + TODBCStatement(02162940).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001B359578 " - 00.000.019 000000001B35957E " + TODBCStatement(02162940).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001B359586 " SQL TODBCStatement(02162940) CREATE INDEX NDXMarkmImage ON dbo.Mark(mImage) 000000001B3ABD9D " EXC EODBCException {"Statement":{"SQL":"CREATE INDEX NDXMarkmImage ON dbo.Mark(mImage)","SQLWithInlinedParams":"CREATE INDEX NDXMarkmImage ON dbo.Mark(mImage)","CurrentRow":0,"TotalRowsRetrieved":0,"Connection":{"DBMSName":"Microsoft SQL Server","DBMSVersion":"10.50.2500","DriverName":"SQLSRV32.DLL","Connected":true,"ServerTimeStampAtConnection":"2015-11-09T07:34:48","TotalConnectionCount":1,"TransactionCount":0,"InTransaction":false,"RollbackOnDisconnect":true,"LastErrorMessage":"","LastErrorWasAboutConnection":false,"Properties":{"Engine":"ODBC","ServerName":"","DatabaseNameSafe":"Driver=SQL Server;Server=nlsql012; Database=SASPlanet;Integrated Security=SSPI","UserID":"","DBMS":3,"DBMSEngineName":"MSSQL","BatchSendingAbilities":1,"BatchMaxSentAtOnce":4096,"LoggedSQLMaxSize":0,"LogSQLStatementOnException":false,"ForcedSchemaName":"dbo","UseCache":false,"RollbackOnDisconnect":true,"StoreVoidStringAsNull":true}}},"Message":"TODBCStatement - TODBCLib error: [42S11] [Microsoft][ODBC SQL Server Driver][SQL Server]The operation failed because an index or statistics with name 'NDXMarkmImage' already exists on table 'dbo.Mark'. (1913)\r\n"} at 00AF01D9 SynDBODBC.TODBCLib.HandleError (1755) stack trace API 000000001B3ABE46 " - 00.108.441 000000001B3ABE9D " + TODBCStatement(02162940).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001B3ABEC8 " - 00.000.013 000000001B3ABECC " + TODBCStatement(02162940).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001B3ABED4 " SQL TODBCStatement(02162940) CREATE INDEX NDXMarkmAppearance ON dbo.Mark(mAppearance) 000000001B3FD67F " EXC EODBCException {"Statement":{"SQL":"CREATE INDEX NDXMarkmAppearance ON dbo.Mark(mAppearance)","SQLWithInlinedParams":"CREATE INDEX NDXMarkmAppearance ON dbo.Mark(mAppearance)","CurrentRow":0,"TotalRowsRetrieved":0,"Connection":{"DBMSName":"Microsoft SQL Server","DBMSVersion":"10.50.2500","DriverName":"SQLSRV32.DLL","Connected":true,"ServerTimeStampAtConnection":"2015-11-09T07:34:48","TotalConnectionCount":1,"TransactionCount":0,"InTransaction":false,"RollbackOnDisconnect":true,"LastErrorMessage":"","LastErrorWasAboutConnection":false,"Properties":{"Engine":"ODBC","ServerName":"","DatabaseNameSafe":"Driver=SQL Server;Server=nlsql012; Database=SASPlanet;Integrated Security=SSPI","UserID":"","DBMS":3,"DBMSEngineName":"MSSQL","BatchSendingAbilities":1,"BatchMaxSentAtOnce":4096,"LoggedSQLMaxSize":0,"LogSQLStatementOnException":false,"ForcedSchemaName":"dbo","UseCache":false,"RollbackOnDisconnect":true,"StoreVoidStringAsNull":true}}},"Message":"TODBCStatement - TODBCLib error: [42S11] [Microsoft][ODBC SQL Server Driver][SQL Server]The operation failed because an index or statistics with name 'NDXMarkmAppearance' already exists on table 'dbo.Mark'. (1913)\r\n"} at 00AF01D9 SynDBODBC.TODBCLib.HandleError (1755) stack trace API 000000001B3FD72C " - 00.107.094 000000001B3FD773 " + TODBCStatement(02162940).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001B3FD79E " - 00.000.013 000000001B3FD7A1 " + TODBCStatement(02162940).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001B3FD7A7 " SQL TODBCStatement(02162940) select top(1) ID from dbo.MarkView 000000001B44E0F5 " - 00.105.858 000000001B49ECE4 " + TODBCStatement(02162940).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001B49ED19 " - 00.000.016 000000001B49ED20 " + TODBCStatement(02162940).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001B49ED26 " SQL TODBCStatement(02162940) CREATE INDEX NDXMarkViewmvUser ON dbo.MarkView(mvUser) 000000001B51616D " EXC EODBCException {"Statement":{"SQL":"CREATE INDEX NDXMarkViewmvUser ON dbo.MarkView(mvUser)","SQLWithInlinedParams":"CREATE INDEX NDXMarkViewmvUser ON dbo.MarkView(mvUser)","CurrentRow":0,"TotalRowsRetrieved":0,"Connection":{"DBMSName":"Microsoft SQL Server","DBMSVersion":"10.50.2500","DriverName":"SQLSRV32.DLL","Connected":true,"ServerTimeStampAtConnection":"2015-11-09T07:34:48","TotalConnectionCount":1,"TransactionCount":0,"InTransaction":false,"RollbackOnDisconnect":true,"LastErrorMessage":"","LastErrorWasAboutConnection":false,"Properties":{"Engine":"ODBC","ServerName":"","DatabaseNameSafe":"Driver=SQL Server;Server=nlsql012; Database=SASPlanet;Integrated Security=SSPI","UserID":"","DBMS":3,"DBMSEngineName":"MSSQL","BatchSendingAbilities":1,"BatchMaxSentAtOnce":4096,"LoggedSQLMaxSize":0,"LogSQLStatementOnException":false,"ForcedSchemaName":"dbo","UseCache":false,"RollbackOnDisconnect":true,"StoreVoidStringAsNull":true}}},"Message":"TODBCStatement - TODBCLib error: [42S11] [Microsoft][ODBC SQL Server Driver][SQL Server]The operation failed because an index or statistics with name 'NDXMarkViewmvUser' already exists on table 'dbo.MarkView'. (1913)\r\n"} at 00AF01D9 SynDBODBC.TODBCLib.HandleError (1755) stack trace API 000000001B5162A7 " - 00.156.779 000000001B516334 " + TODBCStatement(02162940).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001B51636E " - 00.000.018 000000001B516373 " + TODBCStatement(02162940).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001B51637A " SQL TODBCStatement(02162940) CREATE INDEX NDXMarkViewmvMark ON dbo.MarkView(mvMark) 000000001B58B341 " EXC EODBCException {"Statement":{"SQL":"CREATE INDEX NDXMarkViewmvMark ON dbo.MarkView(mvMark)","SQLWithInlinedParams":"CREATE INDEX NDXMarkViewmvMark ON dbo.MarkView(mvMark)","CurrentRow":0,"TotalRowsRetrieved":0,"Connection":{"DBMSName":"Microsoft SQL Server","DBMSVersion":"10.50.2500","DriverName":"SQLSRV32.DLL","Connected":true,"ServerTimeStampAtConnection":"2015-11-09T07:34:48","TotalConnectionCount":1,"TransactionCount":0,"InTransaction":false,"RollbackOnDisconnect":true,"LastErrorMessage":"","LastErrorWasAboutConnection":false,"Properties":{"Engine":"ODBC","ServerName":"","DatabaseNameSafe":"Driver=SQL Server;Server=nlsql012; Database=SASPlanet;Integrated Security=SSPI","UserID":"","DBMS":3,"DBMSEngineName":"MSSQL","BatchSendingAbilities":1,"BatchMaxSentAtOnce":4096,"LoggedSQLMaxSize":0,"LogSQLStatementOnException":false,"ForcedSchemaName":"dbo","UseCache":false,"RollbackOnDisconnect":true,"StoreVoidStringAsNull":true}}},"Message":"TODBCStatement - TODBCLib error: [42S11] [Microsoft][ODBC SQL Server Driver][SQL Server]The operation failed because an index or statistics with name 'NDXMarkViewmvMark' already exists on table 'dbo.MarkView'. (1913)\r\n"} at 00AF01D9 SynDBODBC.TODBCLib.HandleError (1755) stack trace API 000000001B58B43E " - 00.153.763 000000001B58B49D " + TODBCStatement(02162940).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001B58B4D1 " - 00.000.016 000000001B58B4D5 " + TODBCStatement(02162940).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001B58B4DC " SQL TODBCStatement(02162940) CREATE INDEX NDXMarkViewmvCategory ON dbo.MarkView(mvCategory) 000000001B5DC782 " EXC EODBCException {"Statement":{"SQL":"CREATE INDEX NDXMarkViewmvCategory ON dbo.MarkView(mvCategory)","SQLWithInlinedParams":"CREATE INDEX NDXMarkViewmvCategory ON dbo.MarkView(mvCategory)","CurrentRow":0,"TotalRowsRetrieved":0,"Connection":{"DBMSName":"Microsoft SQL Server","DBMSVersion":"10.50.2500","DriverName":"SQLSRV32.DLL","Connected":true,"ServerTimeStampAtConnection":"2015-11-09T07:34:48","TotalConnectionCount":1,"TransactionCount":0,"InTransaction":false,"RollbackOnDisconnect":true,"LastErrorMessage":"","LastErrorWasAboutConnection":false,"Properties":{"Engine":"ODBC","ServerName":"","DatabaseNameSafe":"Driver=SQL Server;Server=nlsql012; Database=SASPlanet;Integrated Security=SSPI","UserID":"","DBMS":3,"DBMSEngineName":"MSSQL","BatchSendingAbilities":1,"BatchMaxSentAtOnce":4096,"LoggedSQLMaxSize":0,"LogSQLStatementOnException":false,"ForcedSchemaName":"dbo","UseCache":false,"RollbackOnDisconnect":true,"StoreVoidStringAsNull":true}}},"Message":"TODBCStatement - TODBCLib error: [42S11] [Microsoft][ODBC SQL Server Driver][SQL Server]The operation failed because an index or statistics with name 'NDXMarkViewmvCategory' already exists on table 'dbo.MarkView'. (1913)\r\n"} at 00AF01D9 SynDBODBC.TODBCLib.HandleError (1755) stack trace API 000000001B5DC8B1 " - 00.106.723 000000001B5DC92E " + TODBCStatement(02162940).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001B5DC97C " - 00.000.025 000000001B5DC983 " + TODBCStatement(02162940).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001B5DC98F " SQL TODBCStatement(02162940) select top(1) ID from dbo.MarkAppearance 000000001B62B119 " - 00.103.088 000000001B67A9CA " + TODBCStatement(02162940).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001B67A9FE " - 00.000.016 000000001B67AA03 " + TODBCStatement(02162940).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001B67AA09 " SQL TODBCStatement(02162940) select top(1) ID from dbo.MarkFTS 000000001B6CAB54 " - 00.105.200 000000001B71BA22 " SQL TSQLDatabase(053F23F8) 21us COMMIT TRANSACTION; 000000001B71BA50 " + TSQLRestClientDB(02D0FD00).TimeStamp 000000001B71F814 " + TSQLRestServerDB(03258C40).URI(GET root/TimeStamp inlen=0) 000000001B7222C5 " call TSQLRestServerDB(03258C40) TimeStamp 000000001B7222E8 " srvr TSQLRestServerDB(03258C40) GET root/TimeStamp SOA-Method -> 200 with outlen=12 in 3514 us 000000001B7222F6 " - 00.003.520 000000001B7222FC " ret 135267383476 000000001B7222FD " - 00.008.594 000000001B722308 " + TSQLRestServerDB(03258C40).URI(GET root inlen=53) 000000001B7224D2 # trace TSQLRestServerDB(03258C40) BeginCurrentThread(TSynBackgroundThreadMethod) ThreadID=00001A80 ThreadCount=1 000000001B722518 # + TODBCConnection(04EF1B00).00AED8D1 SynDBODBC.TODBCConnection.Create (1071) 000000001B722524 # - 00.000.003 000000001B722530 # + TODBCStatement(0500B300).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001B722536 # + 00AED307 SynDBODBC.TODBCConnection.Connect (1015) 000000001B975C89 # info [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'SASPlanet'. (5701) [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english. (5703) [01S00] [Microsoft][ODBC SQL Server Driver]Недопустимый атрибут строки соединения (0) 000000001B975CE0 # debug Connected to Microsoft SQL Server using SQLSRV32.DLL 10.50.2500 recognized as MSSQL 000000001B975D0F # + TODBCStatement(0500B3B0).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001B975D7B # - 00.000.034 000000001B975D86 # + TODBCStatement(0500B3B0).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001B975D93 # SQL TODBCStatement(0500B3B0) select GETDATE() 000000001B9C580D # - 00.104.643 000000001BA142F5 # - 00.990.314 000000001BA1437A # - 00.990.358 000000001BA1439B # + TODBCStatement(0500B300).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001BA143E0 # SQL TODBCStatement(0500B300) select ID,uName from dbo.UserInfo where uName='sasgis' 000000001BA14568 # EXC EODBCException {"Statement":{"SQL":"select ID,uName from dbo.UserInfo where uName=?","SQLWithInlinedParams":"select ID,uName from dbo.UserInfo where uName='sasgis'","CurrentRow":0,"TotalRowsRetrieved":0,"Connection":{"DBMSName":"Microsoft SQL Server","DBMSVersion":"10.50.2500","DriverName":"SQLSRV32.DLL","Connected":true,"ServerTimeStampAtConnection":"2015-11-09T10:34:52","TotalConnectionCount":1,"TransactionCount":0,"InTransaction":false,"RollbackOnDisconnect":true,"LastErrorMessage":"","LastErrorWasAboutConnection":false,"Properties":{"Engine":"ODBC","ServerName":"","DatabaseNameSafe":"Driver=SQL Server;Server=nlsql012; Database=SASPlanet;Integrated Security=SSPI","UserID":"","DBMS":3,"DBMSEngineName":"MSSQL","BatchSendingAbilities":1,"BatchMaxSentAtOnce":4096,"LoggedSQLMaxSize":0,"LogSQLStatementOnException":false,"ForcedSchemaName":"dbo","UseCache":false,"RollbackOnDisconnect":true,"StoreVoidStringAsNull":true}}},"Message":"TODBCStatement - TODBCLib error: [HY104] [Microsoft][ODBC SQL Server Driver]Недопустимое значение точности (0)\r\n"} at 00AF01D9 SynDBODBC.TODBCLib.HandleError (1755) stack trace API 00AF01D9 SynDBODBC.TODBCLib.HandleError (1755) 00AEFC62 SynDBODBC.TODBCLib.Check (1674) 00AEF58D SynDBODBC.TODBCStatement.ExecutePrepared (1566) 00AC46B6 SynDB.TSQLDBStatement.ExecutePreparedAndFetchAllAsJSON (6819) 00AE850C mORMotDB.TSQLRestStorageExternal.EngineList (1348) 009E6D5D mORMot.TSQLRestServerURIContext.ExecuteORMGet (35530) 00A15F38 mORMot.BackgroundExecuteProc (50160) 00964F6E SynCommons.TSynBackgroundThreadMethod.Process (50848) 009649C3 SynCommons.TSynBackgroundThreadAbstract.Execute (50717) 00460E19 System.Classes.ThreadProc 004098FE System.ThreadWrapper 000000001BA147FC # - 00.000.359 000000001BA14922 " EXC EODBCException {"Statement":{"SQL":"","SQLWithInlinedParams":"","CurrentRow":0,"TotalRowsRetrieved":0,"Connection":{"DBMSName":"Microsoft SQL Server","DBMSVersion":"10.50.2500","DriverName":"SQLSRV32.DLL","Connected":true,"ServerTimeStampAtConnection":"2015-11-09T10:34:52","TotalConnectionCount":1,"TransactionCount":0,"InTransaction":false,"RollbackOnDisconnect":true,"LastErrorMessage":"","LastErrorWasAboutConnection":false,"Properties":{"Engine":"ODBC","ServerName":"","DatabaseNameSafe":"Driver=SQL Server;Server=nlsql012; Database=SASPlanet;Integrated Security=SSPI","UserID":"","DBMS":3,"DBMSEngineName":"MSSQL","BatchSendingAbilities":1,"BatchMaxSentAtOnce":4096,"LoggedSQLMaxSize":0,"LogSQLStatementOnException":false,"ForcedSchemaName":"dbo","UseCache":false,"RollbackOnDisconnect":true,"StoreVoidStringAsNull":true}}},"Message":"TODBCStatement - TODBCLib error: [HY104] [Microsoft][ODBC SQL Server Driver]Недопустимое значение точности (0)\r\n"} at 00964CB3 SynCommons.TSynBackgroundThreadAbstract.RunAndWait (50805) stack trace API 000000001BA14B3E " debug TSQLRestServerDB(03258C40) TSQLRestRoutingREST.Error: { "errorCode":500, "error": {"EODBCException":{ "ClassName":"EODBCException", "Address":"03FEA410", "Statement": { "ClassName":"TODBCStatement", "Address":"0500B300", "SQL": "", "SQLWithInlinedParams": "", "CurrentRow": 0, "TotalRowsRetrieved": 0, "Connection": { "ClassName":"TODBCConnection", "Address":"04EF1B00", "DBMSName": "Microsoft SQL Server", "DBMSVersion": "10.50.2500", "DriverName": "SQLSRV32.DLL", "Connected": true, "ServerTimeStampAtConnection": "2015-11-09T10:34:52", "TotalConnectionCount": 1, "TransactionCount": 0, "InTransaction": false, "RollbackOnDisconnect": true, "LastErrorMessage": "", "LastErrorWasAboutConnection": false, "Properties": { "ClassName":"TODBCConnectionProperties", "Address":"02CE2900", "Engine": "ODBC", "ServerName": "", "DatabaseNameSafe": "Driver=SQL Server;Server=nlsql012; Database=SASPlanet;Integrated Security=SSPI", "UserID": "", "DBMS": "MSSQL", "DBMSEngineName": "MSSQL", "BatchSendingAbilities": ["Create"], "BatchMaxSentAtOnce": 4096, "LoggedSQLMaxSize": 0, "LogSQLStatementOnException": false, "ForcedSchemaName": "dbo", "UseCache": false, "RollbackOnDisconnect": true, "StoreVoidStringAsNull": true } } }, "Message": "TODBCStatement - TODBCLib error: [HY104] [Microsoft][ODBC SQL Server Driver]Недопустимое значение точности (0)\r\n" }} } 000000001BA14BAD " srvr TSQLRestServerDB(03258C40) GET root/ ORM-Get -> 500 with outlen=1503 in 991204 us 000000001BA14C48 " - 00.991.258 000000001BA14C53 " ERROR TSQLRestClientDB(02D0FD00) GET root returned 500 Internal Server Error with message { "errorCode":500, "error": {"EODBCException":{ "ClassName":"EODBCException", "Address":"03FEA410", "Statement": { "ClassName":"TODBCStatement", "Address":"0500B300", "SQL": "", "SQLWithInlinedParams": "", "CurrentRow": 0, "TotalRowsRetrieved": 0, "Connection": { "ClassName":"TODBCConnection", "Address":"04EF1B00", "DBMSName": "Microsoft SQL Server", "DBMSVersion": "10.50.2500", "DriverName": "SQLSRV32.DLL", "Connected": true, "ServerTimeStampAtConnection": "2015-11-09T10:34:52", "TotalConnectionCount": 1, "TransactionCount": 0, "InTransaction": false, "RollbackOnDisconnect": true, "LastErrorMessage": "", "LastErrorWasAboutConnection": false, "Properties": { "ClassName":"TODBCConnectionProperties", "Address":"02CE2900", "Engine": "ODBC", "ServerName": "", "DatabaseNameSafe": "Driver=SQL Server;Server=nlsql012; Database=SASPlanet;Integrated Security=SSPI", "UserID": "", "DBMS": "MSSQL", "DBMSEngineName": "MSSQL", "BatchSendingAbilities": ["Create"], "BatchMaxSentAtOnce": 4096, "LoggedSQLMaxSize": 0, "LogSQLStatementOnException": false, "ForcedSchemaName": "dbo", "UseCache": false, "RollbackOnDisconnect": true, "StoreVoidStringAsNull": true } } }, "Message": "TODBCStatement - TODBCLib error: [HY104] [Microsoft][ODBC SQL Server Driver]Недопустимое значение точности (0)\r\n" }} } stack trace API 009D6ECF mORMot.TSQLRest.InternalLog (30684) 009DEE94 mORMot.TSQLRestClientURI.URI (33198) 009DCB1F mORMot.TSQLRestClientURI.ExecuteList (32586) 009D8131 mORMot.TSQLRest.MultiFieldValues (30990) 009D855C mORMot.TSQLRest.Retrieve (31056) 009CB557 mORMot.TSQLRecord.Create (27515) 00B6866C u_MarkSystemImplORMClientProvider.TMarkSystemImplORMClientProvider.InitUserID (431) 00B68B5E u_MarkSystemImplORMClientProvider.TMarkSystemImplORMClientProvider.Build (466) 00B67042 u_MarkSystemImplORMClientProvider.TMarkSystemImplORMClientProvider.Create (125) 00B69132 u_MarkSystemImplORM.TMarkSystemImplORM.Create (151) 00B69D40 u_MarkSystemImplFactoryORM.TMarkSystemImplFactoryORM.Build (128) 00B6FA65 u_MarkSystemImplChangeable.TMarkSystemImplChangeable.OnInitialization (177) 005DB61A u_BackgroundTask.TBackgroundTask.Execute (156) 005D96FD u_InterfacedThread.TThread4InterfacedThread.Execute (240) 00460E19 System.Classes.ThreadProc 004098FE System.ThreadWrapper 000000001BA14E1A " + TSQLRestServerDB(03258C40).URI(BEGIN root/User inlen=0) 000000001BA152EC $ trace TSQLRestServerDB(03258C40) BeginCurrentThread(TSynBackgroundThreadMethod) ThreadID=00001C68 ThreadCount=2 000000001BA153C2 $ SQL TSQLDatabase(053F23F8) 34us BEGIN TRANSACTION; 000000001BA153DD $ + TODBCConnection(04EF1B80).00AED8D1 SynDBODBC.TODBCConnection.Create (1071) 000000001BA153F3 $ - 00.000.007 000000001BA153FD $ + 00AED307 SynDBODBC.TODBCConnection.Connect (1015) 000000001BC432B9 $ info [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]Changed database context to 'SASPlanet'. (5701) [01000] [Microsoft][ODBC SQL Server Driver][SQL Server]Changed language setting to us_english. (5703) [01S00] [Microsoft][ODBC SQL Server Driver]Недопустимый атрибут строки соединения (0) 000000001BC4333F $ debug Connected to Microsoft SQL Server using SQLSRV32.DLL 10.50.2500 recognized as MSSQL 000000001BC4337E $ + TODBCStatement(0500B460).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001BC43403 $ - 00.000.042 000000001BC43412 $ + TODBCStatement(0500B460).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001BC43423 $ SQL TODBCStatement(0500B460) select GETDATE() 000000001BC925B6 $ - 00.103.913 000000001BCE1349 $ - 00.940.522 000000001BCE1488 " srvr TSQLRestServerDB(03258C40) BEGIN root/User ORM-Write -> 200 with outlen=0 in 941098 us 000000001BCE14DE " - 00.941.135 000000001BCE156D " + TSQLRestServerDB(03258C40).URI(POST root/User inlen=18) 000000001BCE1649 $ + TODBCStatement(0500B460).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001BCE174D $ - 00.000.083 000000001BCE175D $ + TODBCStatement(0500B460).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001BCE1775 $ SQL TODBCStatement(0500B460) select max(ID) from dbo.UserInfo 000000001BD7F0DF $ - 00.207.025 000000001BDCF578 $ + TODBCStatement(0500B460).00AEF96D SynDBODBC.TODBCStatement.Prepare (1617) 000000001BDCF614 $ - 00.000.050 000000001BDCF62C $ + TODBCStatement(0500B460).00AEF13C SynDBODBC.TODBCStatement.ExecutePrepared (1494) 000000001BDCF6A1 $ SQL TODBCStatement(0500B460) insert into dbo.UserInfo (ID,uName) values (1,'sasgis') 000000001BDCF7BC $ EXC EODBCException {"Statement":{"SQL":"insert into dbo.UserInfo (ID,uName) values (?,?)","SQLWithInlinedParams":"insert into dbo.UserInfo (ID,uName) values (1,'sasgis')","CurrentRow":0,"TotalRowsRetrieved":0,"Connection":{"DBMSName":"Microsoft SQL Server","DBMSVersion":"10.50.2500","DriverName":"SQLSRV32.DLL","Connected":true,"ServerTimeStampAtConnection":"2015-11-09T10:34:53","TotalConnectionCount":1,"TransactionCount":1,"InTransaction":true,"RollbackOnDisconnect":true,"LastErrorMessage":"","LastErrorWasAboutConnection":false,"Properties":{"Engine":"ODBC","ServerName":"","DatabaseNameSafe":"Driver=SQL Server;Server=nlsql012; Database=SASPlanet;Integrated Security=SSPI","UserID":"","DBMS":3,"DBMSEngineName":"MSSQL","BatchSendingAbilities":1,"BatchMaxSentAtOnce":4096,"LoggedSQLMaxSize":0,"LogSQLStatementOnException":false,"ForcedSchemaName":"dbo","UseCache":false,"RollbackOnDisconnect":true,"StoreVoidStringAsNull":true}}},"Message":"TODBCStatement - TODBCLib error: [HY104] [Microsoft][ODBC SQL Server Driver]Недопустимое значение точности (0)\r\n"} at 00AF01D9 SynDBODBC.TODBCLib.HandleError (1755) stack trace API 00AF01D9 SynDBODBC.TODBCLib.HandleError (1755) 00AEFC62 SynDBODBC.TODBCLib.Check (1674) 00AEF58D SynDBODBC.TODBCStatement.ExecutePrepared (1566) 00AEA500 mORMotDB.TSQLRestStorageExternal.ExecuteFromJSON (1856) 00AE7E5B mORMotDB.TSQLRestStorageExternal.EngineAdd (1243) 009E7EE0 mORMot.TSQLRestServerURIContext.ExecuteORMWrite (35758) 00A15F38 mORMot.BackgroundExecuteProc (50160) 00964F6E SynCommons.TSynBackgroundThreadMethod.Process (50848) 009649C3 SynCommons.TSynBackgroundThreadAbstract.Execute (50717) 00460E19 System.Classes.ThreadProc 004098FE System.ThreadWrapper 000000001BDCF9FF $ - 00.000.313 000000001BDCFB30 " debug TSQLRestServerDB(03258C40) TSQLRestRoutingREST.Error: { "errorCode":400, "errorText":"Bad Request" } 000000001BDCFB51 " srvr TSQLRestServerDB(03258C40) POST root/User ORM-Write -> 400 with outlen=49 in 313129 us 000000001BDCFB72 " - 00.313.145 000000001BDCFB7A " ERROR TSQLRestClientDB(02D0FD00) POST root/User returned 400 Bad Request with message { "errorCode":400, "errorText":"Bad Request" } stack trace API 009D6ECF mORMot.TSQLRest.InternalLog (30684) 009DEE94 mORMot.TSQLRestClientURI.URI (33198) 009DF893 mORMot.TSQLRestClientURI.EngineAdd (33347) 009D9B95 mORMot.TSQLRest.Add (31542) 009FB88D mORMot.TSQLRestClient.Add (41337) 00B68779 u_MarkSystemImplORMClientProvider.TMarkSystemImplORMClientProvider.InitUserID (440) 00B68B5E u_MarkSystemImplORMClientProvider.TMarkSystemImplORMClientProvider.Build (466) 00B67042 u_MarkSystemImplORMClientProvider.TMarkSystemImplORMClientProvider.Create (125) 00B69132 u_MarkSystemImplORM.TMarkSystemImplORM.Create (151) 00B69D40 u_MarkSystemImplFactoryORM.TMarkSystemImplFactoryORM.Build (128) 00B6FA65 u_MarkSystemImplChangeable.TMarkSystemImplChangeable.OnInitialization (177) 005DB61A u_BackgroundTask.TBackgroundTask.Execute (156) 005D96FD u_InterfacedThread.TThread4InterfacedThread.Execute (240) 00460E19 System.Classes.ThreadProc 004098FE System.ThreadWrapper 000000001BDCFC8B " EXC EMarkSystemORMError ("MarkSystemORM: ID is empty!") at 00B687A1 u_MarkSystemImplORMClientProvider.TMarkSystemImplORMClientProvider.InitUserID (441) stack trace API 00B687A1 u_MarkSystemImplORMClientProvider.TMarkSystemImplORMClientProvider.InitUserID (441) 00B68B5E u_MarkSystemImplORMClientProvider.TMarkSystemImplORMClientProvider.Build (466) 00B67042 u_MarkSystemImplORMClientProvider.TMarkSystemImplORMClientProvider.Create (125) 00B69132 u_MarkSystemImplORM.TMarkSystemImplORM.Create (151) 00B69D40 u_MarkSystemImplFactoryORM.TMarkSystemImplFactoryORM.Build (128) 00B6FA65 u_MarkSystemImplChangeable.TMarkSystemImplChangeable.OnInitialization (177) 005DB61A u_BackgroundTask.TBackgroundTask.Execute (156) 005D96FD u_InterfacedThread.TThread4InterfacedThread.Execute (240) 00460E19 System.Classes.ThreadProc 004098FE System.ThreadWrapper 000000001BDCFD8A " + TSQLRestServerDB(03258C40).URI(ABORT root inlen=0) 000000001BE1F82C $ SQL TSQLDatabase(053F23F8) 43us ROLLBACK TRANSACTION; 000000001BE1F8E7 " srvr TSQLRestServerDB(03258C40) ABORT root/ ORM-Write -> 200 with outlen=0 in 104702 us 000000001BE1F913 " - 00.104.726 000000001BE1F93B " EXC EMarkSystemORMError ("MarkSystemORM: ID is empty!") at 00B687A1 u_MarkSystemImplORMClientProvider.TMarkSystemImplORMClientProvider.InitUserID (441) stack trace API 00B687A1 u_MarkSystemImplORMClientProvider.TMarkSystemImplORMClientProvider.InitUserID (441) 00B68B5E u_MarkSystemImplORMClientProvider.TMarkSystemImplORMClientProvider.Build (466) 00B67042 u_MarkSystemImplORMClientProvider.TMarkSystemImplORMClientProvider.Create (125) 00B69132 u_MarkSystemImplORM.TMarkSystemImplORM.Create (151) 00B69D40 u_MarkSystemImplFactoryORM.TMarkSystemImplFactoryORM.Build (128) 00B6FA65 u_MarkSystemImplChangeable.TMarkSystemImplChangeable.OnInitialization (177) 005DB61A u_BackgroundTask.TBackgroundTask.Execute (156) 005D96FD u_InterfacedThread.TThread4InterfacedThread.Execute (240) 00460E19 System.Classes.ThreadProc 004098FE System.ThreadWrapper 000000001BE1FAFE " + TODBCConnection(04EF1B80).00AEDA3F SynDBODBC.TODBCConnection.Disconnect (1092) 000000001BE473A9 " - 00.051.944 000000001BE473D9 " + TODBCConnection(04EF1B00).00AEDA3F SynDBODBC.TODBCConnection.Disconnect (1092) 000000001BE6F264 " - 00.052.426 000000001BE6F299 " + TODBCConnection(04EF1700).00AEDA3F SynDBODBC.TODBCConnection.Disconnect (1092) 000000001BE97161 " - 00.052.446 000000001BE97694 " info TSQLRestClientDB(02D0FD00) TSQLRestClientDB.Destroy -> {"TSQLRestClientDB(02D0FD00)":{"LastErrorCode":200,"LastErrorMessage":"","MaximumAuthentificationRetry":0,"RetryOnceOnTimeout":false,"SessionID":1,"Model":{"TSQLModel(0500ACD0)":{"Root":"root","TableProps":[{"TSQLModelRecordProperties(02CFAC40)":{"Props":{"TSQLRecordProperties(02146550)":{"SQLTableName":"User","SQLTableRetrieveAllFields":"ID,uName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(02CFACD8)":{"Props":{"TSQLRecordProperties(02146390)":{"SQLTableName":"Category","SQLTableRetrieveAllFields":"ID,cName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(02CFAD70)":{"Props":{"TSQLRecordProperties(02146010)":{"SQLTableName":"CategoryView","SQLTableRetrieveAllFields":"ID,cvUser,cvCategory,cvVisible,cvMinZoom,cvMaxZoom"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FED550)":{"Props":{"TSQLRecordProperties(021461D0)":{"SQLTableName":"MarkImage","SQLTableRetrieveAllFields":"ID,miName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FED5E8)":{"Props":{"TSQLRecordProperties(03FF4880)":{"SQLTableName":"MarkDBMS","SQLTableRetrieveAllFields":"ID,mCategory,mImage,mAppearance,mName,mDesc,mGeoType,mGeoCount,mGeoLonSize,mGeoLatSize,mGeoWKB,mLeft,mRight,mBottom,mTop"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FED680)":{"Props":{"TSQLRecordProperties(03FF4A40)":{"SQLTableName":"MarkView","SQLTableRetrieveAllFields":"ID,mvUser,mvMark,mvCategory,mvVisible"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FED718)":{"Props":{"TSQLRecordProperties(03FF4C00)":{"SQLTableName":"MarkAppearance","SQLTableRetrieveAllFields":"ID,maColor1,maColor2,maScale1,maScale2"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FED7B0)":{"Props":{"TSQLRecordProperties(03FF4DC0)":{"SQLTableName":"MarkFTS","SQLTableRetrieveAllFields":"ID,mName,mDesc"}},"Kind":"CustomAutoID"}}]}}}} 000000001BE97797 " + TSQLRestServerDB(03258C40).00A20DED mORMotSQLite3.TSQLRestServerDB.Destroy (1050) 000000001BE977BE " + TSQLRestServerDB(03258C40).Shutdown 000000001BE977C4 " info TSQLRestServerDB(03258C40) CurrentRequestCount=0 000000001BE98647 " - 00.001.193 000000001BE98697 " info TSQLRestServerDB(03258C40) TSQLRestServerDB.Destroy -> {"TSQLRestServerDB(03258C40)":{"DB":{"TSQLDatabase(053F23F8)":{"FileName":":memory:","IsMemory":true,"UseCache":true,"TransactionActive":false,"BusyTimeout":0,"CacheSize":2000,"PageSize":1024,"PageCount":3,"FileSize":3072,"WALMode":false,"Synchronous":"Full","LockingMode":"Normal","MemoryMappedMB":0,"user_version":0,"OpenV2Flags":6,"BackupBackgroundInProcess":false,"BackupBackgroundLastTime":"","BackupBackgroundLastFileName":"","SQLite3Library":{"TSQLite3LibraryStatic(02CEC940)":{"Version":"3.9.1 with internal MM"}}}},"StatementLastException":"","NoAJAXJSON":true,"HandleAuthentication":false,"BypassORMAuthentication":[],"Stats":{"Success":3,"ServiceMethod":1,"ServiceInterface":0,"OutcomingFiles":0,"CurrentThreadCount":2,"Created":0,"Read":0,"Updated":0,"Deleted":0,"ClientsCurrent":0,"ClientsMax":0,"CurrentRequestCount":0,"Input":{"Bytes":406,"Text":"406 B"},"Output":{"Bytes":1683,"Text":"1683 B"},"InputThroughput":{"BytesPerSec":172,"Text":"172 B/s"},"OutputThroughput":{"BytesPerSec":715,"Text":"715 B/s"},"Processing":false,"TaskCount":5,"TotalTime":{"MicroSec":2353647,"Text":"2.35s"},"LastTime":{"MicroSec":104702,"Text":"104.70ms"},"MinimalTime":{"MicroSec":3514,"Text":"3.51ms"},"AverageTime":{"MicroSec":470729,"Text":"470.72ms"},"MaximalTime":{"MicroSec":991204,"Text":"991.20ms"},"PerSec":2,"Errors":2,"LastError":400},"StatLevels":["Tables","Methods","Interfaces","SQLite3"],"StaticVirtualTableDirect":true,"Model":{"TSQLModel(0500B0F0)":{"Root":"root","TableProps":[{"TSQLModelRecordProperties(03FEDDA0)":{"Props":{"TSQLRecordProperties(02146550)":{"SQLTableName":"User","SQLTableRetrieveAllFields":"ID,uName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDE38)":{"Props":{"TSQLRecordProperties(02146390)":{"SQLTableName":"Category","SQLTableRetrieveAllFields":"ID,cName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDED0)":{"Props":{"TSQLRecordProperties(02146010)":{"SQLTableName":"CategoryView","SQLTableRetrieveAllFields":"ID,cvUser,cvCategory,cvVisible,cvMinZoom,cvMaxZoom"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEDF68)":{"Props":{"TSQLRecordProperties(021461D0)":{"SQLTableName":"MarkImage","SQLTableRetrieveAllFields":"ID,miName"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE000)":{"Props":{"TSQLRecordProperties(03FF4880)":{"SQLTableName":"MarkDBMS","SQLTableRetrieveAllFields":"ID,mCategory,mImage,mAppearance,mName,mDesc,mGeoType,mGeoCount,mGeoLonSize,mGeoLatSize,mGeoWKB,mLeft,mRight,mBottom,mTop"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE098)":{"Props":{"TSQLRecordProperties(03FF4A40)":{"SQLTableName":"MarkView","SQLTableRetrieveAllFields":"ID,mvUser,mvMark,mvCategory,mvVisible"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE130)":{"Props":{"TSQLRecordProperties(03FF4C00)":{"SQLTableName":"MarkAppearance","SQLTableRetrieveAllFields":"ID,maColor1,maColor2,maScale1,maScale2"}},"Kind":"CustomAutoID"}},{"TSQLModelRecordProperties(03FEE1C8)":{"Props":{"TSQLRecordProperties(03FF4DC0)":{"SQLTableName":"MarkFTS","SQLTableRetrieveAllFields":"ID,mName,mDesc"}},"Kind":"CustomAutoID"}}]}}}} 000000001BE98AF0 # trace TSQLRestServerDB(03258C40) EndCurrentThread(TSynBackgroundThreadMethod) ThreadID=00001A80 ThreadCount=1 000000001BE98D6C # EXCOS EAccessViolation (C0000005) at 76F81D76 stack trace API 00AC16B3 SynDB.TSQLDBConnectionPropertiesThreadSafe.EndCurrentThread (6035) 00AEA64F mORMotDB.TSQLRestStorageExternal.EndCurrentThread (1873) 009EF054 mORMot.TSQLRestServer.EndCurrentThread (37302) 00964A79 SynCommons.TSynBackgroundThreadAbstract.Execute (50739) 00460E19 System.Classes.ThreadProc 004098FE System.ThreadWrapper 000000001BE99509 $ trace TSQLRestServerDB(03258C40) EndCurrentThread(TSynBackgroundThreadMethod) ThreadID=00001C68 ThreadCount=0 000000001BE996D0 $ EXCOS EAccessViolation (C0000005) at 76F81D76 stack trace API 00AC16B3 SynDB.TSQLDBConnectionPropertiesThreadSafe.EndCurrentThread (6035) 00AEA64F mORMotDB.TSQLRestStorageExternal.EndCurrentThread (1873) 009EF054 mORMot.TSQLRestServer.EndCurrentThread (37302) 00964A79 SynCommons.TSynBackgroundThreadAbstract.Execute (50739) 00460E19 System.Classes.ThreadProc 004098FE System.ThreadWrapper 000000001BE99D59 " - 00.003.100 000000001BE99DED " + TSQLDatabase(053F23F8).00974DA1 SynSQLite3.TSQLDatabase.Destroy (3807) 000000001BE99E08 " + 00976409 SynSQLite3.TSQLDatabase.DBClose (4295) 000000001BE99E17 " DB TSQLDatabase(053F23F8) closing ":memory:" 000000001BE99E30 " info TSQLRestStorageExternal(02CE2B20) TSQLRestStorageExternal.Destroy -> {"TSQLRestStorageExternal(02CE2B20)":{"Model":{"TSQLModel(0500B0F0)":{"Root":"","TableProps":[]}}}} 000000001BE99E7E " info TSQLRestStorageExternal(02CE2A10) TSQLRestStorageExternal.Destroy -> {"TSQLRestStorageExternal(02CE2A10)":{"Model":{"TSQLModel(0500B0F0)":{"Root":"","TableProps":[]}}}} 000000001BE99EA8 " info TSQLRestStorageExternal(02CE26E0) TSQLRestStorageExternal.Destroy -> {"TSQLRestStorageExternal(02CE26E0)":{"Model":{"TSQLModel(0500B0F0)":{"Root":"","TableProps":[]}}}} 000000001BE99ECC " info TSQLRestStorageExternal(02CE25D0) TSQLRestStorageExternal.Destroy -> {"TSQLRestStorageExternal(02CE25D0)":{"Model":{"TSQLModel(0500B0F0)":{"Root":"","TableProps":[]}}}} 000000001BE99EF5 " info TSQLRestStorageExternal(02CE24C0) TSQLRestStorageExternal.Destroy -> {"TSQLRestStorageExternal(02CE24C0)":{"Model":{"TSQLModel(0500B0F0)":{"Root":"","TableProps":[]}}}} 000000001BE99F15 " info TSQLRestStorageExternal(02CE22A0) TSQLRestStorageExternal.Destroy -> {"TSQLRestStorageExternal(02CE22A0)":{"Model":{"TSQLModel(0500B0F0)":{"Root":"","TableProps":[]}}}} 000000001BE99F35 " info TSQLRestStorageExternal(02CE2080) TSQLRestStorageExternal.Destroy -> {"TSQLRestStorageExternal(02CE2080)":{"Model":{"TSQLModel(0500B0F0)":{"Root":"","TableProps":[]}}}} 000000001BE99F55 " info TSQLRestStorageExternal(02CE0E70) TSQLRestStorageExternal.Destroy -> {"TSQLRestStorageExternal(02CE0E70)":{"Model":{"TSQLModel(0500B0F0)":{"Root":"","TableProps":[]}}}} 000000001BE9A03C " - 00.000.180 000000001BE9A064 " - 00.000.202 000000001BE9A0F1 " EXC EMarkSystemORMError ("MarkSystemORM: ID is empty!") at 00B687A1 u_MarkSystemImplORMClientProvider.TMarkSystemImplORMClientProvider.InitUserID (441) stack trace API 00B687A1 u_MarkSystemImplORMClientProvider.TMarkSystemImplORMClientProvider.InitUserID (441) 00B68B5E u_MarkSystemImplORMClientProvider.TMarkSystemImplORMClientProvider.Build (466) 00B67042 u_MarkSystemImplORMClientProvider.TMarkSystemImplORMClientProvider.Create (125) 00B69132 u_MarkSystemImplORM.TMarkSystemImplORM.Create (151) 00B69D40 u_MarkSystemImplFactoryORM.TMarkSystemImplFactoryORM.Build (128) 00B6FA65 u_MarkSystemImplChangeable.TMarkSystemImplChangeable.OnInitialization (177) 005DB61A u_BackgroundTask.TBackgroundTask.Execute (156) 005D96FD u_InterfacedThread.TThread4InterfacedThread.Execute (240) 00460E19 System.Classes.ThreadProc 004098FE System.ThreadWrapper 000000001BE9A27E " EXC EMarkSystemORMError ("MarkSystemORM: ID is empty!") at 00B687A1 u_MarkSystemImplORMClientProvider.TMarkSystemImplORMClientProvider.InitUserID (441) stack trace API