Original Message processed by David®

Re: Re-6: [IBO] Problems IBO 5.9,3 "NATURAL ORDER UNSUPORTTED" (21-Jul-2017 13:54)
From:   'Carlos H. Cantu' listas@warmboot.c
To:	'GMS - Ulrich Hutter' ulrich@... [IBObjects]

 

 

I'm sure Jason will fix this asap, if you can reproduce the problem in a simple application and send it to him.

[]s
Carlos H. Cantu
eBook Guia de Migração para o FB 3 - www.firebase.com.br/guiafb3.php
www.FireBase.com.br - www.firebirdnews.org - blog.firebase.com.br

hi jason

do you think you will find a solution? otherwise i have to find a workaround myself

thx


mit besten Grüßen aus Salzburg


Ulrich Hutter
Programmierung und Geschäftsführung

Original Message processed by David®   Re-5: [IBO] Problems IBO 5.9,3 "NATURAL ORDER UNSUPORTTED" (19-Jul-2017 14:51) From:   GMS - Ulrich Hutter To: IBObjects@yahoogroups.com

your code starting here (starting with last line IBODataset)

IB_Components.pas |IB_Components |TIB_InternalCursor|SysPrepareSQL |36919[298] |
IB_Components.pas |IB_Components |TIB_Statement |SysGetRawSQL |25726[124] |
|IB_StringList.pas |IB_StringList |TIB_StringList |Clear |618[12] |
|IB_Components.pas |IB_Components |TIB_Statement |SysExecPrepare |25528[217] |
|IB_Components.pas |IB_Components |TIB_Dataset |SysExecPrepare |31748[12] |
|IB_Components.pas |IB_Components | |DoExecPrepare |25434[135] |
|IB_Components.pas |IB_Components |TIB_Statement |SysPrepare |25476[118] |
|IB_Components.pas |IB_Components |TIB_Dataset |SysPrepare |31395[185] |
|IB_Components.pas |IB_Components |TIB_Statement |Prepare |25035[36] |
|IB_Components.pas |IB_Components | |ResetRefinementCriteria |41839[1050]|
|IB_Components.pas |IB_Components |TIB_BDataset |GrabCursorWithRevive |41914[331] |
||IB_Components.pas |IB_Components | |SysLookupKeyForFields |43224[610] |
||IB_Components.pas |IB_Components |TIB_BDataset |LookupKeyForFields |43406[1011]|
IB_Components.pas |IB_Components | |GetFinalResult |38972[32] |
|IB_Components.pas |IB_Components |TIB_BDataset |LocateRecord |39241[1918]|
IBODataset.pas |IBODataset |TIBODataset |LocateRecord |7999[236] |
IBODataset.pas |IBODataset |TIBODataset |Locate |7806[45]

mit besten Grüßen aus Salzburg


Ulrich Hutter
Programmierung und Geschäftsführung

Original Message processed by David®   Re-4: [IBO] Problems IBO 5.9,3 "NATURAL ORDER UNSUPORTTED" (19-Jul-2017 14:30) From:   'GMS - Ulrich Hutter' ulrich@... To: IBObjects@yahoogroups.com   hi jason here the CallStack from EurekaLog i can reproduce it every time EurekaLog 7.5.1.156 alpha 5 9CD9DDB9668CF443BC85C63C13B7E599 1EB5DE7771784B4DB58DE0AE215BF2B9 DA39A3EE5E6B4B0D3255BFEF95601890AFD80709 853D85FD5C8F334AAB4900F62B9AB771 Exception: ----------------------------------------- 2.2 Address: 008689F2 2.5 Type : EIB_Error 2.6 Message: Natural Order Unsupported. 2.7 ID : AFF2F9E2 2.11 Sent : 0 User: ---------------------------- 3.2 Name : ulrich 3.3 Email: ulrich@... Steps to reproduce: ------------ 8.1 Text: Call Stack Information: ---------------------------------------------------------- |Methods |Details|Stack |Address |Module |Offset |Source |Unit |Class |Procedure/Method |Line | ---------------------------------------------------------- |*Exception Thread: ID=3808; Parent=0; Priority=0 | |Class=; Name=MAIN | |DeadLock=0; Wait Chain= | |Comment= | |----------------------------------------------------------| |7FFFFFFE|04 |00000000|008689F2|FelixHaupt.exe|004689F2|IB_Components.pas |IB_Components |TIB_InternalCursor|SysPrepareSQL |36919[298] | |00000060|04 |0019F328|0084B144|FelixHaupt.exe|0044B144|IB_Components.pas |IB_Components |TIB_Statement |SysGetRawSQL |25726[124] | |00004020|04 |0019F34C|007A80DC|FelixHaupt.exe|003A80DC|IB_StringList.pas |IB_StringList |TIB_StringList |Clear |618[12] | |00000060|04 |0019F358|0084A99D|FelixHaupt.exe|0044A99D|IB_Components.pas |IB_Components |TIB_Statement |SysExecPrepare |25528[217] | |00000060|04 |0019F3FC|0085BE10|FelixHaupt.exe|0045BE10|IB_Components.pas |IB_Components |TIB_Dataset |SysExecPrepare |31748[12] | |00000060|04 |0019F410|0084A6A3|FelixHaupt.exe|0044A6A3|IB_Components.pas |IB_Components | |DoExecPrepare |25434[135] | |00000060|04 |0019F430|0084A80A|FelixHaupt.exe|0044A80A|IB_Components.pas |IB_Components |TIB_Statement |SysPrepare |25476[118] | |00000060|04 |0019F444|0085AA2D|FelixHaupt.exe|0045AA2D|IB_Components.pas |IB_Components |TIB_Dataset |SysPrepare |31395[185] | |00000060|04 |0019F464|008496D8|FelixHaupt.exe|004496D8|IB_Components.pas |IB_Components |TIB_Statement |Prepare |25035[36] | |00000060|04 |0019F47C|00876166|FelixHaupt.exe|00476166|IB_Components.pas |IB_Components | |ResetRefinementCriteria |41839[1050]| |00000060|04 |0019F4D8|0087657B|FelixHaupt.exe|0047657B|IB_Components.pas |IB_Components |TIB_BDataset |GrabCursorWithRevive |41914[331] | |00000060|04 |0019F4F4|0087A0BE|FelixHaupt.exe|0047A0BE|IB_Components.pas |IB_Components | |SysLookupKeyForFields |43224[610] | |00000060|04 |0019F530|0087A8DB|FelixHaupt.exe|0047A8DB|IB_Components.pas |IB_Components |TIB_BDataset |LookupKeyForFields |43406[1011]| |00000060|04 |0019F594|0086E094|FelixHaupt.exe|0046E094|IB_Components.pas |IB_Components | |GetFinalResult |38972[32] | |00000060|04 |0019F5AC|0086E97E|FelixHaupt.exe|0046E97E|IB_Components.pas |IB_Components |TIB_BDataset |LocateRecord |39241[1918]| |00000060|04 |0019F674|0090975C|FelixHaupt.exe|0050975C|IBODataset.pas |IBODataset |TIBODataset |LocateRecord |7999[236] | |00000060|04 |0019F6B0|00908FED|FelixHaupt.exe|00508FED|IBODataset.pas |IBODataset |TIBODataset |Locate |7806[45] | |00000060|04 |0019FB74|013F0167|FelixHaupt.exe|00FF0167|Rechnung.pas |Rechnung |TRechnungDlg |CalculateGastAdresse |1092[51] | |00000060|04 |0019FB80|013F3244|FelixHaupt.exe|00FF3244|Rechnung.pas |Rechnung |TRechnungDlg |Calculate |1865[92] | |00000060|04 |0019FB9C|013F34E8|FelixHaupt.exe|00FF34E8|Rechnung.pas |Rechnung |TRechnungDlg |GastChanged |1918[480] | |00000060|04 |0019FBD8|018A6D8A|FelixHaupt.exe|014A6D8A|GetGast.pas |GetGast |TGetGastDlg |GastChanged |262[242] | |00000060|04 |0019FC08|018A710A|FelixHaupt.exe|014A710A|GetGast.pas |GetGast |TGetGastDlg |SetOtherGast |338[70] | |00000060|04 |0019FC14|018A756E|FelixHaupt.exe|014A756E|GetGast.pas |GetGast |TGetGastDlg |SelectZimmer |412[942] | |00000060|04 |0019FCB0|018A7F91|FelixHaupt.exe|014A7F91|GetGast.pas |GetGast |TGetGastDlg |TimerSelectTimer |645[33] | |00000060|03 |0019FCC0|006F48EF|FelixHaupt.exe|002F48EF|Vcl.ExtCtrls.pas |Vcl.ExtCtrls |TTimer |Create | | |00000060|03 |0019FCEC|0051A234|FelixHaupt.exe|0011A234|System.Classes.pas|System.Classes| |StdWndProc | | |00000060|03 |0019FD04|744F2B59|user32.dll |00032B59|user32.dll |user32 | | (possible AddClipboardFormatListener+4713)| | |00000060|03 |0019FD30|744E50EE|user32.dll |000250EE|user32.dll |user32 | | (possible DispatchMessageW+2222) | | |00000060|03 |0019FE18|744E4A7D|user32.dll |00024A7D|user32.dll |user32 | | (possible DispatchMessageW+573) | | |00000060|03 |0019FE8C|744E484B|user32.dll |0002484B|user32.dll |user32 | |DispatchMessageW | | |00000020|03 |0019FE98|007727F7|FelixHaupt.exe|003727F7|Vcl.Forms.pas |Vcl.Forms |TApplication |ProcessMessage | | |00000020|03 |0019FEB4|0077283A|FelixHaupt.exe|0037283A|Vcl.Forms.pas |Vcl.Forms |TApplication |HandleMessage | | |00000020|03 |0019FED8|00772B6D|FelixHaupt.exe|00372B6D|Vcl.Forms.pas |Vcl.Forms |TApplication |Run | | |00004020|04 |0019FF08|01A310B6|FelixHaupt.exe|016310B6|FelixHaupt.dpr |FelixHaupt | |Initialization |404[1982] | |00004020|03 |0019FF84|74968742|kernel32.dll |00018742|KERNEL32.DLL |KERNEL32 | |BaseThreadInitThunk | | ---------------------------------------------------------- Modules Information: ---------------------------------------------------------- |Handle |Name |Description |Version |Size |Modified |Path | ---------------------------------------------------------- |00400000|FelixHaupt.exe |GMS Hotel Felix |12.1.0.0 |31279104|2017-07-19 14:25:00|D:\gms\felix\program_12\ | |0C0B0000|normaliz.dll |Unicode Normalization DLL |10.0.15063.0 |5120 |2017-03-18 22:58:47|C:\Windows\System32\ | |0F7F0000|msvcr71.dll |Microsoft® C Runtime Library |7.10.3052.4 |348160 |2003-02-21 04:42:22|C:\Windows\System32\ | |0F850000|cslibu-2-1.dll |Crystal Reports |11.5.12.1838 |1761280 |2009-12-02 03:06:08|C:\Windows\System32\ | |0FC30000|crqe_res_en.dll |Resource DLL for Crystal Query Engine |11.5.12.1838 |159744 |2009-12-02 02:29:40|C:\Program Files (x86)\Business Objects\Common\3.5\bin\ | |0FC60000|crqe_res_de.dll |Resource DLL for Crystal Query Engine |11.5.12.1838 |163840 |2009-12-02 02:29:40|C:\Program Files (x86)\Business Objects\Common\3.5\bin\ | |10000000|omikpfhm.dll |Omikron similarity and phonetics DLL |1.1.0.4 |94208 |2000-11-02 11:44:00|D:\gms\felix\program_12\ | |12000000|xerces-c_2_1_0.dll |Shared Library for Xerces-C Version 2.1.0 |2.1.0.0 |1961984 |2009-12-02 03:04:46|C:\Program Files (x86)\Business Objects\Common\3.5\bin\ | |248E0000|crqe.dll |Crystal Query Engine |11.5.12.1838 |2011136 |2009-12-02 02:33:12|C:\Program Files (x86)\Business Objects\Common\3.5\bin\ | |37830000|crpe32.dll |Crystal Reports Engine |11.5.12.1838 |8402432 |2009-12-02 03:29:04|C:\Program Files (x86)\Business Objects\Common\3.5\bin\ | |39E80000|u3lxcde.dll |User Function Library for Exchange |11.5.12.1838 |6656 |2009-12-02 03:06:32|C:\Program Files (x86)\Business Objects\Common\3.5\bin\ | |39F40000|u3lfrde.dll |32-bit UFL to calculate financial ratios |11.5.12.1838 |6656 |2009-12-02 03:07:42|C:\Program Files (x86)\Business Objects\Common\3.5\bin\ | |3B6A0000|U25dts.dll |Date Time String User Function Library |11.5.12.1838 |14848 |2009-12-02 02:41:16|C:\Program Files (x86)\Business Objects\Common\3.5\bin\ | |3BA80000|objectfactory.dll |Crystal Reports Object Factory Library 2.0 |11.5.12.1838 |94208 |2009-12-02 03:01:00|C:\Program Files (x86)\Business Objects\Common\3.5\bin\ | |3C0F0000|U3520de.dll |UF5 to convert 20th century dates to 21st century dates |11.5.12.1838 |4608 |2009-12-02 03:08:52|C:\Program Files (x86)\Business Objects\Common\3.5\bin\ | |3DA40000|u35dtde.dll |Date Time String User Function Library |11.5.12.1838 |4608 |2009-12-02 03:04:14|C:\Program Files (x86)\Business Objects\Common\3.5\bin\ | |3E170000|u2lcom.dll |Crystal Reports COM UFL Manager DLL |11.5.12.1838 |47616 |2009-12-02 02:41:26|C:\Program Files (x86)\Business Objects\Common\3.5\bin\ | |3E1F0000|u2l2000.dll |UFL to convert 20th century dates to 21st century dates |11.5.12.1838 |17920 |2009-12-02 02:41:52|C:\Program Files (x86)\Business Objects\Common\3.5\bin\ | |3EA40000|crpe32_res_de.dll |Crystal Reports Engine |11.5.12.1838 |1064960 |2009-12-02 03:04:44|C:\Program Files (x86)\Business Objects\Common\3.5\bin\ | |40CD0000|u3l20de.dll |UFL to convert 20th century dates to 21st century dates |11.5.12.1838 |4608 |2009-12-02 03:10:02|C:\Program Files (x86)\Business Objects\Common\3.5\bin\ | |40CF0000|u2lfinra.dll |32-bit UFL to calculate financial ratios |11.5.12.1838 |94208 |2009-12-02 02:42:22|C:\Program Files (x86)\Business Objects\Common\3.5\bin\ | |40E20000|u2ldts.dll |Date Time String User Function Library |11.5.12.1838 |13824 |2009-12-02 02:42:02|C:\Program Files (x86)\Business Objects\Common\3.5\bin\ | |41CC0000|crtowords_de.dll |Crystal Reports ToWords DLL |11.5.12.1838 |10240 |2009-12-02 03:01:44|C:\Program Files (x86)\Business Objects\Common\3.5\bin\ | |422F0000|u35s1de.dll |Sample User Function Library |11.5.12.1838 |4608 |2009-12-02 03:11:12|C:\Program Files (x86)\Business Objects\Common\3.5\bin\ | |43A70000|u3ldtde.dll |Date Time String User Function Library |11.5.12.1838 |4608 |2009-12-02 03:05:24|C:\Program Files (x86)\Business Objects\Common\3.5\bin\ | |448E0000|u2lexch.dll |User Function Library for Exchange |11.5.12.1838 |18944 |2009-12-02 02:42:16|C:\Program Files (x86)\Business Objects\Common\3.5\bin\ | |44980000|ufmanager.dll |ufmanager DLL |11.5.12.1838 |86016 |2009-12-02 02:43:04|C:\Program Files (x86)\Business Objects\Common\3.5\bin\ | |45230000|prompt.dll |Prompting Module |11.5.12.1838 |1245184 |2009-12-02 03:08:08|C:\Program Files (x86)\Business Objects\Common\3.5\bin\ | |45BA0000|u25samp1.dll |Sample User Function Library |11.5.12.1838 |17408 |2009-12-02 02:42:50|C:\Program Files (x86)\Business Objects\Common\3.5\bin\ | |45C00000|saxserialize.dll |Crystal Reports EROM XML Serializer |11.5.12.1838 |217088 |2009-12-02 02:49:24|C:\Program Files (x86)\Business Objects\Common\3.5\bin\ | |460A0000|u252000.dll |UF5 to convert 20th century dates to 21st century dates |11.5.12.1838 |13312 |2009-12-02 02:41:38|C:\Program Files (x86)\Business Objects\Common\3.5\bin\ | |46480000|security.dll |Security Support Provider Interface |10.0.15063.0 |4608 |2017-03-18 22:58:49|C:\Windows\System32\ | |49AA0000|cxlib-3-1.dll |Crystal Cross Platform Library |11.5.12.1838 |1343488 |2009-12-02 02:25:54|C:\Windows\System32\ | |49C00000|cxlibw-3-1.dll |Crystal Cross Platform Library |11.5.12.1838 |1339392 |2009-12-02 02:22:22|C:\Windows\System32\ | |53000000|fssl-1-2-1-2.dll |Enterprise Thread Library |1.2.1.2 |585728 |2009-12-02 02:52:50|C:\Windows\System32\ | |59620000|libOCAHelperw-3-1.dll |BusinessObjects Enterprise |11.5.12.1838 |1601536 |2009-12-02 02:47:14|C:\Windows\System32\ | |597C0000|libOCASecurityw-2-0.dll|BusinessObjects Enterprise |11.5.12.1838 |819200 |2009-12-02 02:54:50|C:\Windows\System32\ | |5D360000|MFC71DEU.DLL |MFC Language Specific Resources |7.10.3077.0 |65536 |2003-03-18 20:44:34|C:\Windows\System32\ | |5DF30000|vaultcli.dll |Clientbibliothek für den Anmeldeinformationstresor |10.0.15063.0 |201216 |2017-03-18 22:58:49|C:\Windows\System32\ | |5DF70000|FBCLIENT.DLL |Firebird SQL Server |3.0.1.32609 |1324032 |2016-09-27 10:54:12|C:\Windows\System32\ | |5E0C0000|symsrv.dll |Symbol Server |6.12.2.633 |131856 |2017-04-13 21:32:58|C:\Program Files (x86)\Neos Eureka S.r.l\EurekaLog 7\Bin\ | |5E300000|mshtml.dll |Microsoft (R) HTML-Anzeige |11.0.15063.483 |19335168|2017-07-07 08:05:45|C:\Windows\System32\ | |5F690000|ieframe.dll |Internet Browser |11.0.15063.483 |11870720|2017-07-07 08:05:32|C:\Windows\System32\ | |604A0000|log_xn_system.dll |BusinessObjects Enterprise |11.5.12.1838 |2674688 |2009-12-02 02:32:04|C:\Program Files (x86)\Business Objects\BusinessObjects Enterprise 11.5\win32_x86\ | |61360000|dbghelp.dll |Windows Image Helper |6.12.2.633 |1213200 |2017-04-13 21:32:58|C:\Program Files (x86)\Neos Eureka S.r.l\EurekaLog 7\Bin\ | |614B0000|tapi32.dll |Microsoft® Windows(TM) Telefonie-API-Client-DLL |10.0.15063.0 |194048 |2017-03-18 22:58:54|C:\Windows\System32\ | |62400000|cryptdll.dll |Cryptography Manager |10.0.15063.0 |57408 |2017-03-18 22:58:46|C:\Windows\System32\ | |62420000|msv1_0.dll |Microsoft Authentication Package v1.0 |10.0.15063.483 |349600 |2017-07-07 08:29:06|C:\Windows\System32\ | |63000000|etc-1-0-12-4.dll |Enterprise Thread Library |1.0.12.21 |86016 |2009-12-02 02:39:30|C:\Windows\System32\ | |634F0000|msvcp110_win.dll |Microsoft® STL110 C++ Runtime Library |10.0.15063.0 |411184 |2017-03-18 22:58:44|C:\Windows\System32\ | |63620000|dbghelp.dll |Windows Image Helper |10.0.15063.447 |1285120 |2017-06-20 06:38:28|C:\Windows\System32\ | |63A40000|mlang.dll |Multisprachunterstützungs-DLL |10.0.15063.0 |198656 |2017-03-18 22:58:47|C:\Windows\System32\ | |63BE0000|olepro32.dll |OLEPRO32.DLL |10.0.15063.447 |89088 |2017-06-20 06:30:22|C:\Windows\System32\ | |63C00000|oledlg.dll |OLE-Benutzerschnittstellen-Unterstützung |10.0.15063.0 |137728 |2017-03-18 22:58:41|C:\Windows\System32\ | |63C30000|oleacc.dll |Active Accessibility Core Component |7.2.15063.447 |331776 |2017-06-20 06:49:36|C:\Windows\System32\ | |63CB0000|shdocvw.dll |Shelldokumentobjekt und Steuerungsbibliothek |10.0.15063.0 |223744 |2017-03-18 22:58:57|C:\Windows\System32\ | |64000000|ebus-3-3-2-5.dll |Enterprise Bus Library |3.3.2.24 |1732608 |2009-12-02 02:42:08|C:\Windows\System32\ | |64E70000|msIso.dll |Isolation Library for Internet Explorer |11.0.15063.138 |364032 |2017-06-19 00:37:12|C:\Windows\System32\ | |64EE0000|NtlmShared.dll |NTLM Shared Functionality |10.0.15063.0 |33128 |2017-03-18 22:58:50|C:\Windows\System32\ | |64FB0000|mapi32.dll |Erweiterte MAPI 1.0 für Windows NT |1.0.2536.0 |94720 |2017-03-18 22:58:42|C:\Windows\System32\ | |65330000|wer.dll |Windows-Fehlerbericht-DLL |10.0.15063.0 |609048 |2017-03-18 22:58:48|C:\Windows\System32\ | |653D0000|dbgcore.dll |Windows Core Debugging Helpers |10.0.15063.0 |133632 |2017-03-18 22:58:49|C:\Windows\System32\ | |65700000|dsreg.dll |AD/AAD User Device Registration |10.0.15063.0 |475136 |2017-03-18 22:58:46|C:\Windows\System32\ | |65FF0000|twinapi.appcore.dll |twinapi.appcore |10.0.15063.332 |1266544 |2017-06-19 00:37:12|C:\Windows\System32\ | |66130000|dcomp.dll |Microsoft DirectComposition Library |10.0.15063.483 |949920 |2017-07-07 08:30:55|C:\Windows\System32\ | |66220000|dataexchange.dll |Data exchange |10.0.15063.0 |254464 |2017-03-18 22:58:54|C:\Windows\System32\ | |663F0000|msvfw32.dll |DLL für Microsoft Video für Windows |10.0.15063.0 |124416 |2017-03-18 22:58:45|C:\Windows\System32\ | |66420000|avicap32.dll |AVI Capture Window Class |10.0.15063.0 |69120 |2017-03-18 22:58:45|C:\Windows\System32\ | |666B0000|Faultrep.dll |Windows-Benutzermodus-Absturzberichterstattungs-DLL |10.0.15063.0 |359552 |2017-03-18 22:58:49|C:\Windows\System32\ | |66720000|idndl.dll |Downlevel DLL |10.0.15063.0 |8192 |2017-03-18 22:58:40|C:\Windows\System32\ | |66DE0000|uiautomationcore.dll |Microsoft-Benutzeroberflächenautomatisierung |7.2.15063.447 |1451008 |2017-06-20 06:38:49|C:\Windows\System32\ | |671B0000|usermgrcli.dll |UserMgr API DLL |10.0.15063.0 |55872 |2017-03-18 22:58:48|C:\Windows\System32\ | |671C0000|CoreUIComponents.dll |Microsoft Core UI Components Dll |10.0.15063.483 |2259760 |2017-07-07 08:37:56|C:\Windows\System32\ | |673F0000|CoreMessaging.dll |Microsoft CoreMessaging Dll |10.0.15063.483 |583160 |2017-07-07 08:23:46|C:\Windows\System32\ | |67480000|TextInputFramework.dll |"TextInputFramework.DYNLINK" |10.0.15063.0 |401920 |2017-03-18 22:58:44|C:\Windows\System32\ | |676F0000|GdiPlus.dll |Microsoft GDI+ |10.0.15063.483 |1448960 |2017-07-07 08:14:30|C:\Windows\WinSxS\x86_microsoft.windows.gdiplus_6595b64144ccf1df_1.1.15063.483_none_9e9856e456d5e776\ | |6D920000|dxgi.dll |DirectX Graphics Infrastructure |10.0.15063.0 |551200 |2017-03-18 22:58:52|C:\Windows\System32\ | |6D9B0000|d3d11.dll |Direct3D 11 Runtime |10.0.15063.0 |2417840 |2017-03-18 22:58:52|C:\Windows\System32\ | |6DC20000|dwmapi.dll |Microsoft Desktopfenster-Manager-API |10.0.15063.483 |125344 |2017-07-07 08:57:23|C:\Windows\System32\ | |6DC50000|uxtheme.dll |Microsoft UxTheme-Bibliothek |10.0.15063.0 |474112 |2017-03-18 22:58:57|C:\Windows\System32\ | |6DCF0000|tiptsf.dll |Textdienstframework für Bildschirmtastatur und Schreibbereich|10.0.15063.0 |515488 |2017-03-20 06:43:20|C:\Program Files (x86)\Common Files\Microsoft Shared\Ink\ | |6DDF0000|wldp.dll |Windows-Sperrungsrichtlinie |10.0.15063.0 |59456 |2017-03-18 22:58:46|C:\Windows\System32\ | |6DE00000|srpapi.dll |SRP-API-DLL |10.0.15063.0 |122880 |2017-03-18 22:58:47|C:\Windows\System32\ | |6DF30000|wkscli.dll |Workstation Service Client DLL |10.0.15063.0 |57920 |2017-03-18 22:58:47|C:\Windows\System32\ | |6DF60000|sxs.dll |Fusion 2.5 |10.0.15063.0 |542936 |2017-03-18 22:58:40|C:\Windows\System32\ | |6E000000|winsta.dll |Winstation Library |10.0.15063.0 |254720 |2017-03-18 22:58:58|C:\Windows\System32\ | |6E050000|wtsapi32.dll |Windows Remote Desktop Session Host Server SDK APIs |10.0.15063.0 |53272 |2017-03-18 22:58:58|C:\Windows\System32\ | |6E110000|WinTypes.dll |Windows-Basistypen-DLL |10.0.15063.0 |856416 |2017-03-18 22:58:48|C:\Windows\System32\ | |6E650000|netutils.dll |Net Win32 API Helpers DLL |10.0.15063.0 |37256 |2017-03-18 22:58:49|C:\Windows\System32\ | |6E700000|netapi32.dll |Net Win32 API DLL |10.0.15063.0 |68776 |2017-03-18 22:58:48|C:\Windows\System32\ | |70300000|winrnr.dll |LDAP RnR Provider DLL |10.0.15063.0 |23040 |2017-03-18 22:58:42|C:\Windows\System32\ | |70310000|nlaapi.dll |Network Location Awareness 2 |10.0.15063.0 |63488 |2017-03-18 22:58:48|C:\Windows\System32\ | |70330000|pnrpnsp.dll |PNRP-Namespaceanbieter |10.0.15063.0 |70144 |2017-03-18 22:59:50|C:\Windows\System32\ | |70350000|NapiNSP.dll |E-Mail-Namenshimanbieter |10.0.15063.0 |54784 |2017-03-18 22:58:45|C:\Windows\System32\ | |70D10000|FWPUCLNT.DLL |FWP/IPsec Benutzermodus-API |10.0.15063.0 |285184 |2017-03-18 22:58:48|C:\Windows\System32\ | |70D60000|rasadhlp.dll |Remote Access AutoDial Helper |10.0.15063.0 |12800 |2017-03-18 22:58:45|C:\Windows\System32\ | |71230000|msvcr100.dll |Microsoft® C Runtime Library |10.0.40219.325 |773968 |2011-06-11 01:58:52|C:\Windows\System32\ | |71D40000|dhcpcsvc.dll |DHCP Clientdienst |10.0.15063.0 |62976 |2017-03-18 22:58:44|C:\Windows\System32\ | |71D60000|dhcpcsvc6.DLL |DHCPv6-Client |10.0.15063.0 |57344 |2017-03-18 22:58:44|C:\Windows\System32\ | |71F70000|msimg32.dll |GDIEXT Client DLL |10.0.15063.0 |7168 |2017-03-18 22:58:59|C:\Windows\System32\ | |72010000|iertutil.dll |Laufzeit-Hilfsprogramm für Internet Explorer |11.0.15063.483 |2165752 |2017-07-07 08:30:41|C:\Windows\System32\ | |72230000|urlmon.dll |OLE32-Erweiterung für Win32 |11.0.15063.483 |1626624 |2017-07-07 08:00:13|C:\Windows\System32\ | |723D0000|secur32.dll |Security Support Provider Interface |10.0.15063.0 |23040 |2017-03-18 22:58:50|C:\Windows\System32\ | |723E0000|version.dll |Version Checking and File Installation Libraries |10.0.15063.0 |27424 |2017-03-18 22:58:58|C:\Windows\System32\ | |723F0000|ntmarta.dll |Windows NT MARTA-Anbieter |10.0.15063.0 |152440 |2017-03-18 22:58:50|C:\Windows\System32\ | |72420000|propsys.dll |Microsoft-Eigenschaftensystem |7.0.15063.0 |1465360 |2017-03-18 22:58:51|C:\Windows\System32\ | |72590000|comctl32.dll |Bibliothek für Steuerelemente |6.10.15063.0 |2139040 |2017-03-18 22:58:58|C:\Windows\WinSxS\x86_microsoft.windows.common-controls_6595b64144ccf1df_6.0.15063.483_none_6dad63fefc436da8\| |72940000|rsaenh.dll |Microsoft Enhanced Cryptographic Provider |10.0.15063.0 |183448 |2017-03-18 22:58:47|C:\Windows\System32\ | |72970000|cryptsp.dll |Cryptographic Service Provider API |10.0.15063.0 |67760 |2017-03-18 22:58:48|C:\Windows\System32\ | |729C0000|mswsock.dll |Microsoft Windows Sockets 2.0-Dienstanbieter |10.0.15063.0 |305568 |2017-03-18 22:58:44|C:\Windows\System32\ | |72A10000|wsock32.dll |Windows Socket 32-Bit DLL |10.0.15063.0 |16384 |2017-03-18 22:58:48|C:\Windows\System32\ | |72A50000|winmmbase.dll |Base Multimedia Extension API DLL |10.0.15063.0 |129736 |2017-03-18 22:58:45|C:\Windows\System32\ | |72D40000|winspool.drv |Windows-Spoolertreiber |10.0.15063.138 |429568 |2017-06-19 00:37:12|C:\Windows\System32\ | |72DB0000|mpr.dll |Router-DLL für Mehrfachanbieter |10.0.15063.0 |86296 |2017-03-18 22:58:49|C:\Windows\System32\ | |72DD0000|wininet.dll |Interneterweiterungen für Win32 |11.0.15063.483 |2859520 |2017-07-07 08:01:50|C:\Windows\System32\ | |730A0000|winmm.dll |MCI API-DLL |10.0.15063.0 |135440 |2017-03-18 22:58:45|C:\Windows\System32\ | |730D0000|bcrypt.dll |Bibliothek mit kryptografischen Primitiven von Windows |10.0.15063.0 |93536 |2017-03-18 22:58:47|C:\Windows\System32\ | |73100000|dnsapi.dll |DNS-Client-API-DLL |10.0.15063.0 |508344 |2017-03-18 22:58:44|C:\Windows\System32\ | |73750000|IPHLPAPI.DLL |IP-Hilfs-API |10.0.15063.0 |187544 |2017-03-18 22:58:44|C:\Windows\System32\ | |73C20000|CRYPTBASE.dll |Base cryptographic API DLL |10.0.15063.0 |31592 |2017-03-18 22:58:44|C:\Windows\System32\ | |73C30000|sspicli.dll |Security Support Provider Interface |10.0.15063.0 |124544 |2017-03-18 22:58:44|C:\Windows\System32\ | |73C50000|combase.dll |Microsoft COM für Windows |10.0.15063.447 |2330520 |2017-06-20 07:04:39|C:\Windows\System32\ | |73E90000|windows.storage.dll |Microsoft WinRT Storage-API |10.0.15063.483 |5820984 |2017-07-07 08:31:01|C:\Windows\System32\ | |74420000|oleaut32.dll |OLEAUT32.DLL |10.0.15063.332 |606960 |2017-06-19 00:37:06|C:\Windows\System32\ | |744C0000|user32.dll |Client-DLL für Windows USER-API (mehrere Benutzer) |10.0.15063.0 |1292872 |2017-03-18 22:59:00|C:\Windows\System32\ | |74600000|msvcp_win.dll |Microsoft® C Runtime Library |10.0.15063.0 |491232 |2017-03-18 22:58:44|C:\Windows\System32\ | |74850000|ole32.dll |Microsoft OLE für Windows |10.0.15063.483 |988168 |2017-07-07 08:26:36|C:\Windows\System32\ | |74950000|kernel32.dll |Client-DLL für Windows NT-Basis-API |10.0.15063.296 |599576 |2017-06-19 00:37:09|C:\Windows\System32\ | |74A20000|gdi32full.dll |GDI Client DLL |10.0.15063.413 |1409048 |2017-06-19 00:37:06|C:\Windows\System32\ | |74BA0000|comdlg32.dll |DLL für gemeinsame Dialoge |10.0.15063.483 |952832 |2017-07-07 08:02:02|C:\Windows\System32\ | |74C90000|bcryptPrimitives.dll |Windows Cryptographic Primitives Library |10.0.15063.138 |354360 |2017-06-19 00:37:06|C:\Windows\System32\ | |74CF0000|advapi32.dll |Erweiterte Windows 32 Base-API |10.0.15063.0 |480920 |2017-03-18 22:58:39|C:\Windows\System32\ | |74D70000|cfgmgr32.dll |Configuration Manager DLL |10.0.15063.0 |226816 |2017-03-18 22:58:49|C:\Windows\System32\ | |74DB0000|msasn1.dll |ASN.1 Runtime APIs |10.0.15063.447 |49656 |2017-06-20 07:04:50|C:\Windows\System32\ | |74DC0000|SHCore.dll |SHCORE |10.0.15063.0 |569264 |2017-03-18 22:58:54|C:\Windows\System32\ | |74E50000|gdi32.dll |GDI Client DLL |10.0.15063.483 |129184 |2017-07-07 08:31:24|C:\Windows\System32\ | |74E80000|shlwapi.dll |Shell Light-weight-Hilfsprogrammbibliothek |10.0.15063.0 |277432 |2017-03-18 22:58:56|C:\Windows\System32\ | |74ED0000|msvcrt.dll |Windows NT CRT DLL |7.0.15063.0 |769608 |2017-03-18 22:58:44|C:\Windows\System32\ | |74F90000|imagehlp.dll |Windows NT Image Helper |10.0.15063.168 |95584 |2017-06-19 00:37:07|C:\Windows\System32\ | |74FB0000|psapi.dll |Process Status Helper |10.0.15063.0 |17112 |2017-03-18 22:58:39|C:\Windows\System32\ | |74FC0000|sechost.dll |Host for SCM/SDDL/LSA Lookup APIs |10.0.15063.0 |257792 |2017-03-18 22:58:44|C:\Windows\System32\ | |75010000|nsi.dll |NSI User-mode interface DLL |10.0.15063.0 |20216 |2017-03-18 22:57:35|C:\Windows\System32\ | |75020000|ws2_32.dll |Windows Socket 2.0-32-Bit-DLL |10.0.15063.0 |415864 |2017-03-18 22:58:44|C:\Windows\System32\ | |75090000|crypt32.dll |Krypto-API32 |10.0.15063.296 |1557288 |2017-06-19 00:37:06|C:\Windows\System32\ | |75630000|wintrust.dll |Microsoft Trust Verification APIs |10.0.15063.0 |276880 |2017-03-18 22:58:46|C:\Windows\System32\ | |75680000|imm32.dll |Multi-User Windows IMM32 API Client DLL |10.0.15063.0 |143672 |2017-03-18 22:59:00|C:\Windows\System32\ | |756B0000|clbcatq.dll |COM+ Configuration Catalog |2001.12.10941.16384|521728 |2017-03-18 22:58:41|C:\Windows\System32\ | |757A0000|powrprof.dll |Power Profile Helper DLL |10.0.15063.0 |276400 |2017-03-18 22:58:48|C:\Windows\System32\ | |758E0000|msctf.dll |MSCTF-Server-DLL |10.0.15063.332 |1333136 |2017-06-19 00:37:06|C:\Windows\System32\ | |75A30000|rpcrt4.dll |Remoteprozeduraufruf-Laufzeitumgebung |10.0.15063.447 |787712 |2017-06-20 07:13:24|C:\Windows\System32\ | |75AF0000|kernel.appcore.dll |AppModel API Host |10.0.15063.0 |47096 |2017-03-18 22:58:46|C:\Windows\System32\ | |75B00000|KERNELBASE.dll |Client-DLL für Windows NT-Basis-API |10.0.15063.483 |1839872 |2017-07-07 08:39:01|C:\Windows\System32\ | |75CD0000|win32u.dll |Win32u |10.0.15063.0 |81176 |2017-03-18 22:58:59|C:\Windows\System32\ | |75D00000|profapi.dll |User Profile Basic API |10.0.15063.0 |59456 |2017-03-18 22:58:44|C:\Windows\System32\ | |75D10000|ucrtbase.dll |Microsoft® C Runtime Library |10.0.15063.447 |1150784 |2017-06-20 07:14:59|C:\Windows\System32\ | |75E30000|shell32.dll |Allgemeine Windows-Shell-DLL |10.0.15063.483 |20373408|2017-07-07 08:26:56|C:\Windows\System32\ | |77180000|ntdll.dll |DLL für NT-Layer |10.0.15063.447 |1620368 |2017-06-20 07:15:11|C:\Windows\System32\ | |7C120000|atl71.dll |ATL Module for Windows (Unicode) |7.10.3077.0 |89088 |2003-03-18 19:05:50|C:\Windows\System32\ | |7C250000|mfc71u.dll |MFCDLL Shared Library - Retail Version |7.10.3077.0 |1047552 |2003-03-18 21:12:12|C:\Windows\System32\ | |7C3A0000|msvcp71.dll |Microsoft® C++ Runtime Library |7.10.3077.0 |499712 |2003-03-18 20:14:52|C:\Windows\System32\ | ---------------------------------------------------------- Processes Information: ---------------------- Assembler Information: ---------------------------------------------------------- ; Base Address: $868000, Allocation Base: $400000, Region Size: 18653184 ; Allocation Protect: PAGE_EXECUTE_WRITECOPY, Protect: PAGE_EXECUTE_READ ; State: MEM_COMMIT, Type: MEM_IMAGE ; ; ; IB_Components.TIB_InternalCursor.SysPrepareSQL (Line=36909 - Offset=230) ; ---------------------------------------------------------- 008689AE 8D45F4 LEA EAX, [EBP-$0C] 008689B1 BA00908600 MOV EDX, $00869000 ; ($00869000) IB_Components.TIB_InternalCursor.SysPrepareSQL (Line=37027) UNICODE: '<=' IB_Components.TIB_InternalCursor.SysPrepareSQL (Line=37027) 008689B6 E8E951BAFF CALL -$45AE17 ; ($0040DBA4) System._UStrLAsg 008689BB EB3A JMP +$3A ; ($008689F7) IB_Components.TIB_InternalCursor.SysPrepareSQL (Line=36921) ; ; Line=36911 - Offset=245 ; ----------------------- 008689BD 807DFB00 CMP BYTE PTR [EBP-5], 0 008689C1 740F JZ +$0F ; ($008689D2) IB_Components.TIB_InternalCursor.SysPrepareSQL (Line=36914) ; ; Line=36912 - Offset=251 ; ----------------------- 008689C3 8D45F4 LEA EAX, [EBP-$0C] 008689C6 BAEC8F8600 MOV EDX, $00868FEC ; ($00868FEC) IB_Components.TIB_InternalCursor.SysPrepareSQL (Line=37027) UNICODE: '>=' IB_Components.TIB_InternalCursor.SysPrepareSQL (Line=37027) 008689CB E8D451BAFF CALL -$45AE2C ; ($0040DBA4) System._UStrLAsg 008689D0 EB25 JMP +$25 ; ($008689F7) IB_Components.TIB_InternalCursor.SysPrepareSQL (Line=36921) ; ; Line=36914 - Offset=266 ; ----------------------- 008689D2 8D45F4 LEA EAX, [EBP-$0C] 008689D5 BA24908600 MOV EDX, $00869024 ; ($00869024) IB_Components.TIB_InternalCursor.SysPrepareSQL (Line=37027) UNICODE: '>' IB_Components.TIB_InternalCursor.SysPrepareSQL (Line=37027) 008689DA E8C551BAFF CALL -$45AE3B ; ($0040DBA4) System._UStrLAsg 008689DF EB16 JMP +$16 ; ($008689F7) IB_Components.TIB_InternalCursor.SysPrepareSQL (Line=36921) ; ; Line=36919 - Offset=281 ; ----------------------- 008689E1 B934908600 MOV ECX, $00869034 ; ($00869034) IB_Components.TIB_InternalCursor.SysPrepareSQL (Line=37027) UNICODE: 'Natural Order Unsupported' IB_Components.TIB_InternalCursor.SysPrepareSQL (Line=37027) 008689E6 B201 MOV DL, 1 008689E8 A188A47C00 MOV EAX, [$007CA488] ; Delphi Class "EIB_Error" 008689ED E86A51C0FF CALL -$3FAE96 ; ($0046DB5C) System.Exception.Create ; ; Line=36919 - Offset=298 ; ----------------------- 008689F2 E88143BAFF CALL -$45BC7F ; ($0040CD78) System._RaiseExcept ; <-- EXCEPTION ; ; Line=36921 - Offset=303 ; ----------------------- 008689F7 8B45F4 MOV EAX, [EBP-$0C] 008689FA BA00908600 MOV EDX, $00869000 ; ($00869000) IB_Components.TIB_InternalCursor.SysPrepareSQL (Line=37027) UNICODE: '<=' IB_Components.TIB_InternalCursor.SysPrepareSQL (Line=37027) 008689FF E8EC62BAFF CALL -$459D14 ; ($0040ECF0) System._UStrEqual 00868A04 740F JZ +$0F ; ($00868A15) IB_Components.TIB_InternalCursor.SysPrepareSQL (Line=36922) 00868A06 8B45F4 MOV EAX, [EBP-$0C] 00868A09 BA14908600 MOV EDX, $00869014 ; ($00869014) IB_Components.TIB_InternalCursor.SysPrepareSQL (Line=37027) UNICODE: '<' IB_Components.TIB_InternalCursor.SysPrepareSQL (Line=37027) 00868A0E E8DD62BAFF CALL -$459D23 ; ($0040ECF0) System._UStrEqual 00868A13 750F JNZ +$0F ; ($00868A24) IB_Components.TIB_InternalCursor.SysPrepareSQL (Line=36924) ; ; Line=36922 - Offset=333 ; ----------------------- 00868A15 8D45F0 LEA EAX, [EBP-$10] 00868A18 BA14908600 MOV EDX, $00869014 ; ($00869014) IB_Components.TIB_InternalCursor.SysPrepareSQL (Line=37027) UNICODE: '<' IB_Components.TIB_InternalCursor.SysPrepareSQL (Line=37027) 00868A1D E88251BAFF CALL -$45AE7E ; ($0040DBA4) System._UStrLAsg 00868A22 EB43 JMP +$43 ; ($00868A67) IB_Components.TIB_InternalCursor.SysPrepareSQL (Line=36929) ; ; Line=36924 - Offset=348 ; ----------------------- 00868A24 8B45F4 MOV EAX, [EBP-$0C] 00868A27 BAEC8F8600 MOV EDX, $00868FEC ; ($00868FEC) IB_Components.TIB_InternalCursor.SysPrepareSQL (Line=37027) UNICODE: '>=' IB_Components.TIB_InternalCursor.SysPrepareSQL (Line=37027) 00868A2C E8BF62BAFF CALL -$459D41 ; ($0040ECF0) System._UStrEqual 00868A31 740F JZ +$0F ; ($00868A42) IB_Components.TIB_InternalCursor.SysPrepareSQL (Line=36925) Registers: ----------------------------- EAX: 0019F1D0 EDI: 00000001 EBX: 00000000 ESI: 0EEDFADE ECX: 00000007 EBP: 0019F228 EDX: 00000000 ESP: 0019F1D0 EIP: 75BEB802 FLG: 00000212 EXP: 008689F2 STK: 0019F1D0 Stack: Memory Dump: ------------------ ---------------------------------------------------------- 04702D84: 16971450 008689F2: E8 81 43 BA FF 8B 45 F4 BA 00 90 86 00 E8 EC 62 ..C...E........b 04702D80: 0043E489 00868A02: BA FF 74 0F 8B 45 F4 BA 14 90 86 00 E8 DD 62 BA ..t..E........b. 04702D7C: 00000021 00868A12: FF 75 0F 8D 45 F0 BA 14 90 86 00 E8 82 51 BA FF .u..E........Q.. 04702D78: 137F125C 00868A22: EB 43 8B 45 F4 BA EC 8F 86 00 E8 BF 62 BA FF 74 .C.E........b..t 04702D74: 0019F2B4 00868A32: 0F 8B 45 F4 BA 24 90 86 00 E8 B0 62 BA FF 75 0F ..E..$.....b..u. 04702D70: 0019F324 00868A42: 8D 45 F0 BA 24 90 86 00 E8 55 51 BA FF EB 16 B9 .E..$....UQ..... 04702D6C: 0F1F3930 00868A52: 74 90 86 00 B2 01 A1 88 A4 7C 00 E8 FA 50 C0 FF t........|...P.. 04702D68: 01A3F728 00868A62: E8 11 43 BA FF 83 7D E0 00 74 34 68 A8 90 86 00 ..C...}..t4h.... 04702D64: 00818334 00868A72: 8B 45 FC FF B0 A0 05 00 00 68 C0 90 86 00 8D 45 .E.......h.....E 04702D60: 1E479D30 00868A82: EC BA 03 00 00 00 E8 53 61 BA FF 55 8D 55 EC 8D .......Sa..U.U.. 04702D5C: 008689F7 00868A92: 45 E0 B9 01 00 00 00 E8 2E FD FF FF 59 EB 45 8B E...........Y.E. 04702D58: 00000007 00868AA2: 45 FC 8B 80 98 05 00 00 8B 80 C0 02 00 00 8B 10 E............... 04702D54: 75BEB802 00868AB2: FF 52 14 48 7C 26 8D 45 D4 8B 4D EC BA D4 90 86 .R.H|&.E..M..... 04702D50: 00000000 00868AC2: 00 E8 90 60 BA FF 8B 4D D4 B2 01 A1 4C BC 45 00 ...`...M....L.E. 04702D4C: 00000001 00868AD2: E8 85 50 C0 FF E8 9C 42 BA FF EB 08 8D 45 EC E8 ..P....B.....E.. 04702D48: 0EEDFADE 00868AE2: 96 4C BA FF 83 7D DC 00 74 34 68 A8 90 86 00 8B .L...}..t4h..... mit besten Grüßen aus Salzburg Ulrich Hutter Programmierung und Geschäftsführung Original Message processed by David® RE: Re-2: [IBO] Problems IBO 5.9,3 "NATURAL ORDER UNSUPORTTED" (18-Jul-2017 23:33) From: 'IBO Support List' supportlist@ibob To:IBObjects@yahoogroups.com It would be very helpful if I could at least get the callstack for it. I will address this and get a patch out ASAP. Thanks Jason From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] Sent: Tuesday, July 18, 2017 11:48 AM To: IBObjects@yahoogroups.com Subject: Re-2: [IBO] Problems IBO 5.9,3 "NATURAL ORDER UNSUPORTTED" hi i have the same problem with Delphi 10.2 Tokyo since update to newest IBO thx mit besten Grüßen aus Salzburg Ulrich Hutter Programmierung und Geschäftsführung Original Message processed by David® Re: [IBO] Problems IBO 5.9,3 "NATURAL ORDER UNSUPORTTED" (18-Jul-2017 15:25) From: Tomasz Tyrakowski t.tyrakowski@sol- To:IBObjects@yahoogroups.com On 17.07.2017 at 16:40, rodrigo_ogioni@... [IBObjects] wrote: > I am doing a test with the IBO in version 5.9.3 and in some operations the message is appearing: > "NATURAL ORDER UNSUPORTTED" Serveral of our customers reported the same error. It appears in a nondeterministic manner, a few times a day, in different parts of the application, and cannot be reproduced (until it pops up again a few hours later in a different place). The very same user can do exactly the same thing a moment later (after logging in again) and no error appears. The exception is thrown by TIB_InternalCursor.SysPrepareSQL method (IB_Components.pas:36919), but at the first glance I'd say it should either throw the exception for a given SQL query or not (i.e. it should be possible to reproduce the error, but it's not). I'm using 5.9.3, too, Delphi XE7 at the moment (upgrading to 10 soon). Any hints what could cause it? Any workarounds? Our support hotline is getting hot ;) regards Tomasz -- __--==============================--__ __--== Tomasz Tyrakowski ==--__ __--== SOL-SYSTEM ==--__ __--== http://www.sol-system.pl ==--__ __--==============================--__ [Non-text portions of this message have been removed]