Skip to content

Instantly share code, notes, and snippets.

@synopse

synopse/gist:3bda4a90a40e40d2c7abc607544d6512

Created May 4, 2021 14:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save synopse/3bda4a90a40e40d2c7abc607544d6512 to your computer and use it in GitHub Desktop.
Save synopse/3bda4a90a40e40d2c7abc607544d6512 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
D:\Work\nepark\bin\epark_ext_work.exe 0.0.0.0 (2021-05-04 14:46:49)
Host=K6 User=alpi CPU=4xIntel(R)Core(TM)i7-5500UCPU@2.40GHz(x86)*9-6-15620:FFFBEBBFBFFBFA7FAB271C020000000000 OS=23.0=10.0.19042 Wow64=1 Freq=10000000
Environment variables=ALLUSERSPROFILE=C:\ProgramData APPDATA=C:\Users\alpin_000\AppData\Roaming COLUMNS=80 CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files CommonProgramFiles=C:\Program Files (x86)\Common Files CommonProgramW6432=C:\Program Files\Common Files COMPUTERNAME=K6 ComSpec=C:\WINDOWS\system32\cmd.exe CORONA_PATH=D:\devel\Corona Labs\Corona\ CORONA_ROOT=D:\devel\Corona Labs\Corona\Native CORONA_SDK_PATH=D:\devel\Corona Labs\Corona\ DriverData=C:\Windows\System32\Drivers\DriverData FP_NO_HOST_CHECK=NO FPS_BROWSER_APP_PROFILE_STRING=Internet Explorer FPS_BROWSER_USER_PROFILE_STRING=Default HOMEDRIVE=C: HOMEPATH=\Users\alpin_000 LINES=24 LOCALAPPDATA=C:\Users\alpin_000\AppData\Local LOGONSERVER=\\K6 NUMBER_OF_PROCESSORS=4 OneDrive=C:\Users\alpin_000\OneDrive OneDriveConsumer=C:\Users\alpin_000\OneDrive OPENSSL_CONF=C:\OpenSSL-Win32\bin\openssl.cfg OS=Windows_NT Path=C:\ProgramData\Oracle\Java\javapath;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Delphi7SE\bin;C:\Program Files (x86)\Delphi7SE\Projects\BPL;C:\FPC\3.0.0rc1\bin\i386-Win32;C:\Program Files\OpenVPN\bin;D:\devel\mips\insight;C:\Program Files\Calibre2\;C:\Program Files (x86)\Skype\Phone\;D:\devel\TDM-GCC-32\bin;D:\devel\TDM-GCC-64\bin;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files\TortoiseSVN\bin;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\Git\cmd;C:\Program Files\NVIDIA Corporation\NVIDIA NvDLISR;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files (x86)\IVI Foundation\VISA\WinNT\Bin;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\dotnet\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\;D;C:\Program Files\TortoiseGit\bin;D:\Tool\vlc-2.2.1;C:\Users\alpin_000\AppData\Local\Microsoft\WindowsApps;C:\Users\alpin_000\AppData\Local\Microsoft\WindowsApps;C:\Program Files (x86)\Nmap;C:\Users\alpin_000\.dotnet\tools PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC PROCESSOR_ARCHITECTURE=x86 PROCESSOR_ARCHITEW6432=AMD64 PROCESSOR_IDENTIFIER=Intel64 Family 6 Model 61 Stepping 4, GenuineIntel PROCESSOR_LEVEL=6 PROCESSOR_REVISION=3d04 ProgramData=C:\ProgramData ProgramFiles(x86)=C:\Program Files (x86) ProgramFiles=C:\Program Files (x86) ProgramW6432=C:\Program Files PSModulePath=C:\WINDOWS\system32\WindowsPowerShell\v1.0\Modules\ PUBLIC=C:\Users\Public SESSIONNAME=Console SystemDrive=C: SystemRoot=C:\WINDOWS TEMP=C:\Users\ALPIN_~1\AppData\Local\Temp TMP=C:\Users\ALPIN_~1\AppData\Local\Temp UOIPME_REG_PATH=C:\Program Files\Intel Corporation\USB over IP USERDOMAIN=K6 USERDOMAIN_ROAMINGPROFILE=K6 USERNAME=alpi USERPROFILE=C:\Users\alpin_000 VBOX_MSI_INSTALL_PATH=C:\Program Files\Oracle\VirtualBox\ VXIPNPPATH=C:\Program Files (x86)\IVI Foundation\VISA\ windir=C:\WINDOWS
TSynLog 1.18.5268 2021-05-04T11:45:43
20210504 11465616 + SynSQLite3.TSQLDatabase(01c91d10).DBOpen epark_ext_work.db3
20210504 11465616 SQL SynSQLite3.TSQLDatabase(01c91d10) 206us epark_ext_work.db3 PRAGMA page_size=4096 = true
20210504 11465616 SQL SynSQLite3.TSQLDatabase(01c91d10) 781us epark_ext_work.db3 PRAGMA cache_size=10000 = true
20210504 11465616 SQL SynSQLite3.TSQLDatabase(01c91d10) 115us epark_ext_work.db3 select count(*) from sqlite_master = true
20210504 11465616 DB SynSQLite3.TSQLDatabase(01c91d10) "D:\Work\nepark\bin\epark_ext_work.db3" database file (108 KB) opened with PageSize=4096 CacheSize=10000 (39 MB)
20210504 11465616 - 00.002.616
20210504 11465620 SQL SynSQLite3.TSQLDatabase(01c91d10) 203us epark_ext_work.db3 returned 8 rows SELECT name FROM sqlite_master WHERE type='table' AND name NOT LIKE 'sqlite_%';
20210504 11465620 DB DataModel.TDbServer(067a7fa0) CreateMissingTables on {"TSQLDatabase(01c91d10)":{"FileName":"D:\\Work\\nepark\\bin\\epark_ext_work.db3","UseCache":true,"CacheSize":10000,"PageSize":4096,"PageCount":27,"FileSize":110592,"Synchronous":"smFull","OpenV2Flags":6,"SQLite3Library":{"TSQLite3LibraryStatic(01ccc1b8)":{"Version":"3.28.0 with internal MM"}}}}
20210504 11465620 DB DataModel.TDbServer(067a7fa0) GetTables=["CompanyData","DataJournal","FPDocument","FPItem","InvSettings","KeyGenerator","TagsColorList"]
20210504 11465620 SQL DataModel.TDbServer(067a7fa0) 62us CREATE INDEX IF NOT EXISTS IndexDataJournalSiteIdentifier ON DataJournal(SiteIdentifier);
20210504 11465620 SQL DataModel.TDbServer(067a7fa0) 58us CREATE INDEX IF NOT EXISTS IndexDataJournalRecordKey ON DataJournal(RecordKey);
20210504 11465620 SQL DataModel.TDbServer(067a7fa0) 56us CREATE INDEX IF NOT EXISTS IndexDataJournalDonorKey ON DataJournal(DonorKey);
20210504 11465620 SQL DataModel.TDbServer(067a7fa0) 56us CREATE INDEX IF NOT EXISTS IndexDataJournalDonorSiteIdentifier ON DataJournal(DonorSiteIdentifier);
20210504 11465620 SQL DataModel.TDbServer(067a7fa0) 56us CREATE INDEX IF NOT EXISTS IndexTagsColorListTagType ON TagsColorList(TagType);
20210504 11465620 SQL DataModel.TDbServer(067a7fa0) 55us CREATE INDEX IF NOT EXISTS IndexTagsColorListTagCode ON TagsColorList(TagCode);
20210504 11465620 SQL DataModel.TDbServer(067a7fa0) 55us CREATE INDEX IF NOT EXISTS IndexTagsColorListTagColor ON TagsColorList(TagColor);
20210504 11465620 SQL DataModel.TDbServer(067a7fa0) 55us CREATE INDEX IF NOT EXISTS IndexCompanyDataCode ON CompanyData(Code);
20210504 11465620 SQL DataModel.TDbServer(067a7fa0) 55us CREATE INDEX IF NOT EXISTS IndexCompanyDataName ON CompanyData(Name);
20210504 11465620 SQL DataModel.TDbServer(067a7fa0) 55us CREATE INDEX IF NOT EXISTS IndexFPDocumentState ON FPDocument(State);
20210504 11465620 SQL DataModel.TDbServer(067a7fa0) 55us CREATE INDEX IF NOT EXISTS IndexFPDocumentCreateTS ON FPDocument(CreateTS);
20210504 11465620 SQL DataModel.TDbServer(067a7fa0) 54us CREATE INDEX IF NOT EXISTS IndexFPDocumentPrintTS ON FPDocument(PrintTS);
20210504 11465620 SQL DataModel.TDbServer(067a7fa0) 54us CREATE INDEX IF NOT EXISTS IndexFPDocumentDocRef ON FPDocument(DocRef);
20210504 11465620 SQL DataModel.TDbServer(067a7fa0) 55us CREATE INDEX IF NOT EXISTS IndexFPDocumentRef ON FPDocument(Ref);
20210504 11465620 SQL DataModel.TDbServer(067a7fa0) 55us CREATE INDEX IF NOT EXISTS IndexFPItemDocID ON FPItem(DocID);
20210504 11465620 SQL DataModel.TDbServer(067a7fa0) 55us CREATE INDEX IF NOT EXISTS IndexFPItemRef ON FPItem(Ref);
20210504 11465620 + epark_ext_module.TEPExtClientDatabase(067ac400).CallBackGet tags/Timestamp
20210504 11465620 + DataModel.TDbServer(067a7fa0).URI GET tags/Timestamp in=0 B
20210504 11465620 srvr DataModel.TDbServer(067a7fa0) GET tags/Timestamp Method=200 out=12 B in 80us
20210504 11465620 ret DataModel.TDbServer(067a7fa0) 135644232555
20210504 11465620 - 00.000.087
20210504 11465620 ret epark_ext_module.TEPExtClientDatabase(067ac400) 135644232555
20210504 11465620 - 00.000.102
20210504 11465620 + DataModel.TDbServer(067a7fa0).URI GET tags in=78 B
20210504 11465620 SQL DataModel.TDbServer(067a7fa0) 306us returned 0 row as 108 B SELECT ID,TagType,TagCode,TagColor,TagCheckType,Reason,More FROM TagsColorList
20210504 11465620 res SynSQLite3.TSQLDatabase(01c91d10) {"fieldCount":7,"values":["ID","TagType","TagCode","TagColor","TagCheckType","Reason","More"],"rowCount":0}
20210504 11465620 srvr DataModel.TDbServer(067a7fa0) GET tags/ Read=200 out=108 B in 342us
20210504 11465620 - 00.000.353
20210504 11465620 DB DataModel.TDbServer(067a7fa0) prepared 22us epark_ext_work.db3 SELECT ID FROM DataJournal WHERE TableIdentifier=? ORDER BY ID DESC LIMIT 1
20210504 11465620 SQL DataModel.TDbServer(067a7fa0) 103us returned 0 row as 46 B SELECT ID FROM DataJournal WHERE TableIdentifier=:(2): ORDER BY ID DESC LIMIT 1
20210504 11465620 res SynSQLite3.TSQLDatabase(01c91d10) {"fieldCount":1,"values":["ID"],"rowCount":0}
20210504 11465627 EXC EResNotFound ("Resource \"TColoredListForm.lrf\" not found") [] at $0044625C $00446417 $0090D6B1 TRESTTABLEBASEFORM__FORMCREATE, line 274 of resttablebaseunit.pas $0042CE65 TCOLOREDLISTFORM__FORMCREATE, line 97 of coloredlistunit.pas $0041F47D TCUSTOMFORM__DOCREATE, line 939 of ./include/customform.inc $0041D98A TCUSTOMFORM__AFTERCONSTRUCTION, line 149 of ./include/customform.inc $00423F7E TFORM__CREATE, line 3184 of ./include/customform.inc $0042EBBD INITIALIZEMODULEIFNEEDED, line 552 of epark_ext_module.pas $00431268 EPARK_EXT_MODULE_$$_init$, line 1401 of epark_ext_module.pas $00410E84
20210504 11470055 cache SynSQLite3.TSQLDatabase(01c91d10) epark_ext_work.db3 cache flushed
20210504 11470055 SQL SynSQLite3.TSQLDatabase(01c91d10) 20us epark_ext_work.db3 BEGIN TRANSACTION;
20210504 11470055 SQL DataModel.TDbServer(067a7fa0) 207us returned 1 row as 135 B SELECT ID,SiteIdentifier,LastKeyTaken,Site,SiteDescription,Ordinal,Version,UpdateOn FROM KeyGenerator ORDER BY Ordinal
20210504 11470055 res SynSQLite3.TSQLDatabase(01c91d10) [{"ID":1,"SiteIdentifier":5693,"LastKeyTaken":1,"Site":"K6","SiteDescription":"K6 Description","Ordinal":0,"Version":"","UpdateOn":0}]
20210504 11470055 cache SynSQLite3.TSQLDatabase(01c91d10) epark_ext_work.db3 cache flushed
20210504 11470055 SQL SynSQLite3.TSQLDatabase(01c91d10) 11us epark_ext_work.db3 COMMIT TRANSACTION;
20210504 11470060 + SynDBODBC.TODBCConnection(081ee990).Create
20210504 11470060 - 00.000.005
20210504 11470060 +
20210504 11470144 info [01000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Changed database context to 'epark'. (5701) [01000] [Microsoft][SQL Server Native Client 10.0][SQL Server]Changed language setting to us_english. (5703)
20210504 11470144 debug Connected to Microsoft SQL Server using sqlncli10.dll 11.00.2100 recognized as MSSQL
20210504 11470144 - 00.747.944
20210504 11470144 + SynSQLite3.TSQLDatabase(01c94a10).DBOpen epark_ext_work.ext.db3
20210504 11470144 SQL SynSQLite3.TSQLDatabase(01c94a10) 12us epark_ext_work.ext.db3 PRAGMA page_size=4096 = true
20210504 11470144 SQL SynSQLite3.TSQLDatabase(01c94a10) 234us epark_ext_work.ext.db3 PRAGMA cache_size=10000 = true
20210504 11470144 SQL SynSQLite3.TSQLDatabase(01c94a10) 70us epark_ext_work.ext.db3 select count(*) from sqlite_master = true
20210504 11470144 DB SynSQLite3.TSQLDatabase(01c94a10) "D:\Work\nepark\bin\epark_ext_work.ext.db3" database file (4 KB) opened with PageSize=4096 CacheSize=10000 (39 MB)
20210504 11470144 - 00.001.238
20210504 11470144 + mORMotDB.TSQLRestStorageExternal(08346b68).Create TSQLKeyGenerator
20210504 11470144 - 00.000.000
20210504 11470144 info mORMotDB.TSQLRestStorageExternal(08346b68) TSQLKeyGenerator {"TODBCConnectionProperties(01c16ad8)":{"Engine":"ODBC","DatabaseNameSafe":"DRIVER={SQL Server Native Client 10.0};SERVER=tcp:192.168.0.5,1433;DATABASE=epark;UID=alpi;PWD=***;WSID=K6;APP=epark_ext_work.exe","UserID":"ALPI","DBMS":"dMSSQL","DBMSEngineName":"MSSQL","BatchSendingAbilities":["cCreate"],"BatchMaxSentAtOnce":4096,"ForcedSchemaName":"dbo","UseCache":true,"RollbackOnDisconnect":true,"StoreVoidStringAsNull":true}} Server={"TDbServer(082c6048)":{"DB":{"TSQLDatabase(01c94a10)":{"FileName":"D:\\Work\\nepark\\bin\\epark_ext_work.ext.db3","UseCache":true,"CacheSize":10000,"PageSize":4096,"PageCount":1,"FileSize":4096,"Synchronous":"smFull","OpenV2Flags":6,"SQLite3Library":{"TSQLite3LibraryStatic(01ccc1b8)":{"Version":"3.28.0 with internal MM"}}}},"Stats":{"StartDate":"2021-05-04 11:47:01","Input":{"Text":"0 B"},"Output":{"Text":"0 B"},"InputThroughput":{"Text":"0 B/s"},"OutputThroughput":{"Text":"0 B/s"},"TotalTime":{"Text":"0us"},"LastTime":{"Text":"0us"},"MinimalTime":{"Text":"0us"},"AverageTime":{"Text":"0us"},"MaximalTime":{"Text":"0us"}},"StatLevels":["mlTables","mlMethods","mlInterfaces","mlSQLite3"],"StaticVirtualTableDirect":true,"ServerTimestamp":135644232561}}
20210504 11470144 + SynDBODBC.TODBCStatement(067c3ae8).Prepare
20210504 11470144 - 00.000.052
20210504 11470144 + SynDBODBC.TODBCStatement(067c3ae8).ExecutePrepared
20210504 11470144 SQL SynDBODBC.TODBCStatement(067c3ae8) 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) = 'XTKEYGENERATOR'
20210504 11470145 - 00.010.767
20210504 11470145 debug mORMotDB.TSQLRestStorageExternal(08346b68) GetFields=[{"ColumnName":"ID","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":"ftInt64","ColumnIndexed":false},{"ColumnName":"SiteIdentifier","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":"ftInt64","ColumnIndexed":false},{"ColumnName":"LastKeyTaken","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":"ftInt64","ColumnIndexed":false},{"ColumnName":"Site","ColumnTypeNative":"nvarchar","ColumnLength":32,"ColumnPrecision":0,"ColumnScale":-1,"ColumnType":"ftUTF8","ColumnIndexed":false},{"ColumnName":"SiteDescription","ColumnTypeNative":"nvarchar","ColumnLength":128,"ColumnPrecision":0,"ColumnScale":-1,"ColumnType":"ftUTF8","ColumnIndexed":false},{"ColumnName":"Ordinal","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":"ftInt64","ColumnIndexed":false},{"ColumnName":"Version","ColumnTypeNative":"nvarchar","ColumnLength":-1,"ColumnPrecision":0,"ColumnScale":-1,"ColumnType":"ftUTF8","ColumnIndexed":false},{"ColumnName":"UpdateOn","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":"ftInt64","ColumnIndexed":false}]
20210504 11470145 + SynDBODBC.TODBCStatement(067c3ae8).Prepare
20210504 11470145 - 00.000.026
20210504 11470145 + SynDBODBC.TODBCStatement(067c3ae8).ExecutePrepared
20210504 11470145 SQL SynDBODBC.TODBCStatement(067c3ae8) select SiteIdentifier,LastKeyTaken,Site,SiteDescription,Ordinal,Version,UpdateOn,ID from dbo.XTKeyGenerator order by Ordinal
20210504 11470145 - 00.005.255
20210504 11470145 SQL DataModel.TDbServer(082c6048) 22.08ms returned 1 row as 20 B SELECT Version FROM KeyGenerator ORDER BY Ordinal LIMIT 1
20210504 11470145 res SynSQLite3.TSQLDatabase(01c94a10) [{"Version":"2.2"}]
20210504 11470605 + mORMotDB.TSQLRestStorageExternal(08348a18).Create TSQLDataJournal
20210504 11470605 - 00.000.000
20210504 11470605 info mORMotDB.TSQLRestStorageExternal(08348a18) TSQLDataJournal {"TODBCConnectionProperties(01c16ad8)":{"Engine":"ODBC","DatabaseNameSafe":"DRIVER={SQL Server Native Client 10.0};SERVER=tcp:192.168.0.5,1433;DATABASE=epark;UID=alpi;PWD=***;WSID=K6;APP=epark_ext_work.exe","UserID":"ALPI","DBMS":"dMSSQL","DBMSEngineName":"MSSQL","BatchSendingAbilities":["cCreate"],"BatchMaxSentAtOnce":4096,"ForcedSchemaName":"dbo","UseCache":true,"RollbackOnDisconnect":true,"StoreVoidStringAsNull":true}} Server={"TDbServer(082c6048)":{"DB":{"TSQLDatabase(01c94a10)":{"FileName":"D:\\Work\\nepark\\bin\\epark_ext_work.ext.db3","UseCache":true,"CacheSize":10000,"PageSize":4096,"PageCount":1,"FileSize":4096,"Synchronous":"smFull","OpenV2Flags":6,"SQLite3Library":{"TSQLite3LibraryStatic(01ccc1b8)":{"Version":"3.28.0 with internal MM"}}}},"Stats":{"StartDate":"2021-05-04 11:47:01","Input":{"Text":"0 B"},"Output":{"Text":"0 B"},"InputThroughput":{"Text":"0 B/s"},"OutputThroughput":{"Text":"0 B/s"},"TotalTime":{"Text":"0us"},"LastTime":{"Text":"0us"},"MinimalTime":{"Text":"0us"},"AverageTime":{"Text":"0us"},"MaximalTime":{"Text":"0us"}},"StatLevels":["mlTables","mlMethods","mlInterfaces","mlSQLite3"],"StaticVirtualTableDirect":true,"ServerTimestamp":135644232565}}
20210504 11470605 warn mORMotDB.TSQLRestStorageExternal(08348a18) TSQLDataJournal.Operation: Field name "Operation" is not compatible with MSSQL
20210504 11470605 warn mORMotDB.TSQLRestStorageExternal(08348a18) -> TSQLDataJournal.Operation mapped to "Operation_"
20210504 11470605 + SynDBODBC.TODBCStatement(067c3bf8).Prepare
20210504 11470605 - 00.000.040
20210504 11470605 + SynDBODBC.TODBCStatement(067c3bf8).ExecutePrepared
20210504 11470605 SQL SynDBODBC.TODBCStatement(067c3bf8) 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) = 'XTDATAJOURNAL'
20210504 11470606 - 00.015.267
20210504 11470606 debug mORMotDB.TSQLRestStorageExternal(08348a18) GetFields=[{"ColumnName":"ID","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":"ftInt64","ColumnIndexed":false},{"ColumnName":"SiteIdentifier","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":"ftInt64","ColumnIndexed":false},{"ColumnName":"TableIdentifier","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":"ftInt64","ColumnIndexed":false},{"ColumnName":"RecordKey","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":"ftInt64","ColumnIndexed":false},{"ColumnName":"Operation","ColumnTypeNative":"int","ColumnLength":0,"ColumnPrecision":10,"ColumnScale":0,"ColumnType":"ftInt64","ColumnIndexed":false},{"ColumnName":"Stamp","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":"ftInt64","ColumnIndexed":false},{"ColumnName":"DonorKey","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":"ftInt64","ColumnIndexed":false},{"ColumnName":"DonorSiteIdentifier","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":"ftInt64","ColumnIndexed":false}]
20210504 11470606 cache SynSQLite3.TSQLDatabase(01c94a10) epark_ext_work.ext.db3 cache flushed
20210504 11470606 + SynDBODBC.TODBCStatement(067c3bf8).Prepare
20210504 11470606 - 00.000.033
20210504 11470606 + SynDBODBC.TODBCStatement(067c3bf8).ExecutePrepared
20210504 11470606 SQL SynDBODBC.TODBCStatement(067c3bf8) ALTER TABLE dbo.XTDataJournal ADD Operation_ int
20210504 11470607 - 00.017.492
20210504 11470607 + SynDBODBC.TODBCStatement(067c3d08).Prepare
20210504 11470607 - 00.000.060
20210504 11470607 + SynDBODBC.TODBCStatement(067c3d08).ExecutePrepared
20210504 11470607 SQL SynDBODBC.TODBCStatement(067c3d08) 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) = 'XTDATAJOURNAL'
20210504 11470608 - 00.008.767
20210504 11470608 debug mORMotDB.TSQLRestStorageExternal(08348a18) GetFields=[{"ColumnName":"ID","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":"ftInt64","ColumnIndexed":false},{"ColumnName":"SiteIdentifier","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":"ftInt64","ColumnIndexed":false},{"ColumnName":"TableIdentifier","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":"ftInt64","ColumnIndexed":false},{"ColumnName":"RecordKey","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":"ftInt64","ColumnIndexed":false},{"ColumnName":"Operation","ColumnTypeNative":"int","ColumnLength":0,"ColumnPrecision":10,"ColumnScale":0,"ColumnType":"ftInt64","ColumnIndexed":false},{"ColumnName":"Stamp","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":"ftInt64","ColumnIndexed":false},{"ColumnName":"DonorKey","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":"ftInt64","ColumnIndexed":false},{"ColumnName":"DonorSiteIdentifier","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":"ftInt64","ColumnIndexed":false},{"ColumnName":"Operation_","ColumnTypeNative":"int","ColumnLength":0,"ColumnPrecision":10,"ColumnScale":0,"ColumnType":"ftInt64","ColumnIndexed":false}]
20210504 11470937 EXC ESQLite3Exception {"ErrorCode":1,"SQLite3ErrorCode":"secERROR","Message":"Error SQLITE_ERROR (1) [SELECT DonorKey FROM DataJournal WHERE DonorSiteIdentifier=? AND TableIdentifier=? ORDER BY ID DESC LIMIT 1] using 3.28.0 - no such column: ID, extended_errcode=1"} [] at $006BB391 SQLITE3_CHECK, line 5484 of D:/devel/fpcupdeluxe/ccr/mORMotFPC/SynSQLite3.pas $006BABBB TSQLREQUEST__PREPARE, line 5358 of D:/devel/fpcupdeluxe/ccr/mORMotFPC/SynSQLite3.pas $006BB5A8 TSQLSTATEMENTCACHED__PREPARE, line 5658 of D:/devel/fpcupdeluxe/ccr/mORMotFPC/SynSQLite3.pas $00644171 TSQLRESTSERVERDB__PREPARESTATEMENT, line 768 of D:/devel/fpcupdeluxe/ccr/mORMotFPC/SQLite3/mORMotSQLite3.pas $00644344 TSQLRESTSERVERDB__GETANDPREPARESTATEMENT, line 793 of D:/devel/fpcupdeluxe/ccr/mORMotFPC/SQLite3/mORMotSQLite3.pas $006469C5 TSQLRESTSERVERDB__MAINENGINELIST, line 1356 of D:/devel/fpcupdeluxe/ccr/mORMotFPC/SQLite3/mORMotSQLite3.pas $0061B5BC TSQLRESTSERVER__ENGINELIST, line 44351 of D:/devel/fpcupdeluxe/ccr/mORMotFPC/SQLite3/mORMot.pas $00606B0B TSQLREST__EXECUTELIST, line 37196 of D:/devel/fpcupdeluxe/ccr/mORMotFPC/SQLite3/mORMot.pas $006047EE TSQLREST__MULTIFIELDVALUE, line 36223 of D:/devel/fpcupdeluxe/ccr/mORMotFPC/SQLite3/mORMot.pas $00603FC0 TSQLREST__ONEFIELDVALUE, line 35996 of D:/devel/fpcupdeluxe/ccr/mORMotFPC/SQLite3/mORMot.pas $0064C5C5 TSQLSERVERCOREDB__TABLELDK, line 675 of datamodelcore.pas $0042EE96 NEEDSSYNC, line 607 of epark_ext_module.pas $0042EDD6 SYNCLOCALTOEXTERN, line 620 of epark_ext_module.pas $0042F5D4 INITIALIZEEXTDB, line 778 of epark_ext_module.pas $0042BDDE TFORM1__BUTTON3CLICK, line 94 of epark_ext_work_unit.pas $00518858 TCONTROL__CLICK, line 2932 of ./include/control.inc $0053576A TBUTTONCONTROL__CLICK, line 55 of ./include/buttoncontrol.inc
20210504 11471010 res {"TSQLDatabase(01c94a10)":{"FileName":"D:\\Work\\nepark\\bin\\epark_ext_work.ext.db3","IsMemory":false,"UseCache":true,"TransactionActive":false,"BusyTimeout":0,"CacheSize":10000,"PageSize":4096,"PageCount":1,"FileSize":4096,"WALMode":false,"Synchronous":"smFull","LockingMode":"lmNormal","MemoryMappedMB":0,"user_version":0,"OpenV2Flags":6,"BackupBackgroundInProcess":false,"BackupBackgroundLastTime":"","BackupBackgroundLastFileName":"","SQLite3Library":{"TSQLite3LibraryStatic(01ccc1b8)":{"Version":"3.28.0 with internal MM"}}}}
20210504 11471010 SQL DataModel.TDbServer(067a7fa0) 120us returned 0 row as 46 B SELECT ID FROM DataJournal WHERE TableIdentifier=:(2): ORDER BY ID DESC LIMIT 1
20210504 11471010 res SynSQLite3.TSQLDatabase(01c91d10) {"fieldCount":1,"values":["ID"],"rowCount":0}
20210504 11471010 + SynDBODBC.TODBCStatement(067c3bf8).Prepare
20210504 11471010 - 00.000.045
20210504 11471010 + SynDBODBC.TODBCStatement(067c3bf8).ExecutePrepared
20210504 11471010 SQL SynDBODBC.TODBCStatement(067c3bf8) select top(1) DonorKey from dbo.XTDataJournal where DonorSiteIdentifier=5693 and TableIdentifier=3 order by ID desc
20210504 11471010 - 00.009.617
20210504 11471010 SQL DataModel.TDbServer(067a7fa0) 162us returned 0 row as 46 B SELECT ID FROM DataJournal WHERE TableIdentifier=:(3): ORDER BY ID DESC LIMIT 1
20210504 11471010 res SynSQLite3.TSQLDatabase(01c91d10) {"fieldCount":1,"values":["ID"],"rowCount":0}
20210504 11471010 + SynDBODBC.TODBCStatement(067c3bf8).ExecutePrepared
20210504 11471010 SQL SynDBODBC.TODBCStatement(067c3bf8) select top(1) DonorKey from dbo.XTDataJournal where DonorSiteIdentifier=5693 and TableIdentifier=4 order by ID desc
20210504 11471011 - 00.007.500
20210504 11471011 SQL DataModel.TDbServer(067a7fa0) 165us returned 0 row as 46 B SELECT ID FROM DataJournal WHERE TableIdentifier=:(4): ORDER BY ID DESC LIMIT 1
20210504 11471011 res SynSQLite3.TSQLDatabase(01c91d10) {"fieldCount":1,"values":["ID"],"rowCount":0}
20210504 11471011 + SynDBODBC.TODBCStatement(067c3bf8).ExecutePrepared
20210504 11471011 SQL SynDBODBC.TODBCStatement(067c3bf8) select top(1) DonorKey from dbo.XTDataJournal where DonorSiteIdentifier=5693 and TableIdentifier=5 order by ID desc
20210504 11471011 - 00.005.934
20210504 11471011 SQL DataModel.TDbServer(067a7fa0) 135us returned 0 row as 46 B SELECT ID FROM DataJournal WHERE TableIdentifier=:(5): ORDER BY ID DESC LIMIT 1
20210504 11471011 res SynSQLite3.TSQLDatabase(01c91d10) {"fieldCount":1,"values":["ID"],"rowCount":0}
20210504 11471011 + epark_ext_module.TEPExtClientDatabase(08348078).CallBackGet tags/Timestamp
20210504 11471011 + DataModel.TDbServer(082c6048).URI GET tags/Timestamp in=0 B
20210504 11471011 srvr DataModel.TDbServer(082c6048) GET tags/Timestamp Method=200 out=12 B in 15us
20210504 11471011 ret DataModel.TDbServer(082c6048) 135644232569
20210504 11471011 - 00.000.022
20210504 11471011 ret epark_ext_module.TEPExtClientDatabase(08348078) 135644232569
20210504 11471011 - 00.000.028
20210504 11471011 + DataModel.TDbServer(082c6048).URI GET tags in=81 B
20210504 11471011 + mORMotDB.TSQLRestStorageExternal(08348d38).Create TSQLTagsColorList
20210504 11471011 - 00.000.000
20210504 11471011 info mORMotDB.TSQLRestStorageExternal(08348d38) TSQLTagsColorList {"TODBCConnectionProperties(01c16ad8)":{"Engine":"ODBC","DatabaseNameSafe":"DRIVER={SQL Server Native Client 10.0};SERVER=tcp:192.168.0.5,1433;DATABASE=epark;UID=alpi;PWD=***;WSID=K6;APP=epark_ext_work.exe","UserID":"ALPI","DBMS":"dMSSQL","DBMSEngineName":"MSSQL","BatchSendingAbilities":["cCreate"],"BatchMaxSentAtOnce":4096,"ForcedSchemaName":"dbo","UseCache":true,"RollbackOnDisconnect":true,"StoreVoidStringAsNull":true}} Server={"TDbServer(082c6048)":{"DB":{"TSQLDatabase(01c94a10)":{"FileName":"D:\\Work\\nepark\\bin\\epark_ext_work.ext.db3","UseCache":true,"CacheSize":10000,"PageSize":4096,"PageCount":1,"FileSize":4096,"Synchronous":"smFull","OpenV2Flags":6,"SQLite3Library":{"TSQLite3LibraryStatic(01ccc1b8)":{"Version":"3.28.0 with internal MM"}}}},"StatementLastException":"ESQLite3Exception {\r\n\t\"ClassName\":\"ESQLite3Exception\",\r\n\t\"Address\":\" $006BB391 SQLITE3_CHECK, line 5484 of D:/devel/fpcupdeluxe/ccr/mORMotFPC/SynSQLite3.pas\",\r\n\t\"ErrorCode\": 1,\r\n\t\"SQLite3ErrorCode\": \"secERROR\",\r\n\t\"Message\": \"Error SQLITE_ERROR (1) [SELECT DonorKey FROM DataJournal WHERE DonorSiteIdentifier=? AND TableIdentifier=? ORDER BY ID DESC LIMIT 1] using 3.28.0 - no such column: ID, extended_errcode=1\"\r\n}","Stats":{"StartDate":"2021-05-04 11:47:01","Success":1,"ServiceMethod":1,"CurrentRequestCount":1,"Input":{"Bytes":72,"Text":"72 B"},"Output":{"Bytes":67,"Text":"67 B"},"InputThroughput":{"BytesPerSec":4800000,"Text":"4.5 MB/s"},"OutputThroughput":{"BytesPerSec":4466666,"Text":"4.2 MB/s"},"TaskCount":1,"TotalTime":{"MicroSec":15,"Text":"15us"},"LastTime":{"MicroSec":15,"Text":"15us"},"MinimalTime":{"MicroSec":15,"Text":"15us"},"AverageTime":{"MicroSec":15,"Text":"15us"},"MaximalTime":{"MicroSec":15,"Text":"15us"},"PerSec":66666},"StatLevels":["mlTables","mlMethods","mlInterfaces","mlSQLite3"],"StaticVirtualTableDirect":true,"ServerTimestamp":135644232569}}
20210504 11471011 + SynDBODBC.TODBCStatement(067c3e18).Prepare
20210504 11471011 - 00.000.037
20210504 11471011 + SynDBODBC.TODBCStatement(067c3e18).ExecutePrepared
20210504 11471011 SQL SynDBODBC.TODBCStatement(067c3e18) 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) = 'XTTAGSCOLORLIST'
20210504 11471012 - 00.009.426
20210504 11471012 debug mORMotDB.TSQLRestStorageExternal(08348d38) GetFields=[{"ColumnName":"ID","ColumnTypeNative":"bigint","ColumnLength":0,"ColumnPrecision":19,"ColumnScale":0,"ColumnType":"ftInt64","ColumnIndexed":false},{"ColumnName":"TagType","ColumnTypeNative":"nvarchar","ColumnLength":8,"ColumnPrecision":0,"ColumnScale":-1,"ColumnType":"ftUTF8","ColumnIndexed":false},{"ColumnName":"TagCode","ColumnTypeNative":"nvarchar","ColumnLength":32,"ColumnPrecision":0,"ColumnScale":-1,"ColumnType":"ftUTF8","ColumnIndexed":false},{"ColumnName":"TagColor","ColumnTypeNative":"int","ColumnLength":0,"ColumnPrecision":10,"ColumnScale":0,"ColumnType":"ftInt64","ColumnIndexed":false},{"ColumnName":"TagCheckType","ColumnTypeNative":"int","ColumnLength":0,"ColumnPrecision":10,"ColumnScale":0,"ColumnType":"ftInt64","ColumnIndexed":false},{"ColumnName":"Reason","ColumnTypeNative":"nvarchar","ColumnLength":128,"ColumnPrecision":0,"ColumnScale":-1,"ColumnType":"ftUTF8","ColumnIndexed":false},{"ColumnName":"More","ColumnTypeNative":"nvarchar","ColumnLength":-1,"ColumnPrecision":0,"ColumnScale":-1,"ColumnType":"ftUTF8","ColumnIndexed":false}]
20210504 11471012 + SynDBODBC.TODBCStatement(067c3e18).Prepare
20210504 11471012 - 00.000.032
20210504 11471012 + SynDBODBC.TODBCStatement(067c3e18).ExecutePrepared
20210504 11471012 SQL SynDBODBC.TODBCStatement(067c3e18) select TagType,TagCode,TagColor,TagCheckType,Reason,More,ID from dbo.XTTagsColorList
20210504 11471013 - 00.007.814
20210504 11471013 SQL DataModel.TDbServer(082c6048) 22.76ms returned 2 rows as 208 B SELECT RowID,TagType,TagCode,TagColor,TagCheckType,Reason,More FROM TagsColorList
20210504 11471013 res SynSQLite3.TSQLDatabase(01c94a10) [{"rowid":1,"TagType":"rfid","TagCode":"FGHI","TagColor":0,"TagCheckType":3,"Reason":"","More":""},{"rowid":5020955,"TagType":"reg","TagCode":"ABCDE","TagColor":0,"TagCheckType":3,"Reason":null,"More":null}]
20210504 11471013 srvr DataModel.TDbServer(082c6048) GET tags/ Read=200 out=208 B in 22.79ms
20210504 11471013 - 00.022.806
20210504 11471013 + SynDBODBC.TODBCStatement(067c3f28).Prepare
20210504 11471013 - 00.000.039
20210504 11471013 + SynDBODBC.TODBCStatement(067c3f28).ExecutePrepared
20210504 11471013 SQL SynDBODBC.TODBCStatement(067c3f28) select top(1) ID from dbo.XTDataJournal where TableIdentifier=2 order by ID desc
20210504 11471013 - 00.006.302
20210504 11471729 info epark_ext_module.TEPExtClientDatabase(067ac400) Destroy tags
20210504 11471729 + DataModel.TDbServer(067a7fa0).Destroy tags
20210504 11471729 + DataModel.TDbServer(067a7fa0).Shutdown() tags CurrentRequestCount=0
20210504 11471730 - 00.012.923
20210504 11471730 info DataModel.TDbServer(067a7fa0) Destroy tags
20210504 11471730 + SynSQLite3.TSQLDatabase(01c91d10).Destroy epark_ext_work.db3
20210504 11471730 + SynSQLite3.TSQLDatabase(01c91d10).DBClose
20210504 11471730 DB SynSQLite3.TSQLDatabase(01c91d10) closing "D:\Work\nepark\bin\epark_ext_work.db3" 108 KB
20210504 11471730 - 00.000.374
20210504 11471730 - 00.000.387
20210504 11471730 - 00.013.376
20210504 11471730 info epark_ext_module.TEPExtClientDatabase(08348078) Destroy tags
20210504 11471730 + DataModel.TDbServer(082c6048).Destroy tags
20210504 11471730 + DataModel.TDbServer(082c6048).Shutdown() tags CurrentRequestCount=0
20210504 11471731 - 00.015.017
20210504 11471731 info mORMotDB.TSQLRestStorageExternal(08346b68) Destroy tags
20210504 11471731 info mORMotDB.TSQLRestStorageExternal(08348a18) Destroy tags
20210504 11471731 info mORMotDB.TSQLRestStorageExternal(08348d38) Destroy tags
20210504 11471731 info DataModel.TDbServer(082c6048) Destroy tags
20210504 11471731 + SynSQLite3.TSQLDatabase(01c94a10).Destroy epark_ext_work.ext.db3
20210504 11471731 + SynSQLite3.TSQLDatabase(01c94a10).DBClose
20210504 11471731 DB SynSQLite3.TSQLDatabase(01c94a10) closing "D:\Work\nepark\bin\epark_ext_work.ext.db3" 4 KB
20210504 11471731 - 00.000.348
20210504 11471731 - 00.000.360
20210504 11471731 - 00.015.470
20210504 11471732 + SynDBODBC.TODBCConnection(081ee990).Disconnect
20210504 11471742 - 00.178.033
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment