[solved] List index out of bounds when merging PostgreSQL physical model

Tetranos · November 13, 2017, 7:33am

Hi all,

When I try to merge a PostgreSQL physical model (generated from a logical one) with a previous version I get a “List index out of bounds (0)” error.

Looks like there is a bug with logical to physical conversion because it does not set the primary key name in physical model but even if i force it the merge step fails.

I’ve also tried to check my model but there is no error.

Here is the debug trace

EurekaLog 7.6.0.0 6E4B76CDA6FD364A9854EDF278B4D0BB 02C25F43BB08CA49A403D53722FB7B4E DA39A3EE5E6B4B0D3255BFEF95601890AFD80709 8A7FBA0198336B42B959349EB7AF3D40

Application:

1.1 Start Date : Mon, 13 Nov 2017 16:16:46 +0100
1.2 Name/Description: TDM.exe - (Toad Data Modeler)
1.3 Version Number : 6.3.3.2
1.4 Parameters :
1.5 Compilation Date: Tue, 12 Sep 2017 15:12:50 +0100
1.6 Up Time : 8 minute(s), 44 second(s)

Exception:

2.1 Date : Mon, 13 Nov 2017 16:25:31 +0100
2.2 Address : 0000000003916DBB
2.3 Module Name : TDM.exe - (Toad Data Modeler)
2.4 Module Version: 6.3.3.2
2.5 Type : EListError
2.6 Message : List index out of bounds (0).
2.7 ID : C6BF6A3A
2.8 Count : 1
2.9 Status : New
2.10 Note :
2.11 Sent : 0

User:

3.1 ID : galien_m
3.2 Name : DSI
3.3 Email :
3.4 Company : CG30
3.5 Privileges: SeLockMemoryPrivilege - OFF
SeIncreaseQuotaPrivilege - OFF
SeSecurityPrivilege - OFF
SeTakeOwnershipPrivilege - OFF
SeLoadDriverPrivilege - OFF
SeSystemProfilePrivilege - OFF
SeSystemtimePrivilege - OFF
SeProfileSingleProcessPrivilege - OFF
SeIncreaseBasePriorityPrivilege - OFF
SeCreatePagefilePrivilege - OFF
SeBackupPrivilege - OFF
SeRestorePrivilege - OFF
SeShutdownPrivilege - OFF
SeDebugPrivilege - OFF
SeSystemEnvironmentPrivilege - OFF
SeChangeNotifyPrivilege - ON
SeRemoteShutdownPrivilege - OFF
SeUndockPrivilege - OFF
SeManageVolumePrivilege - OFF
SeImpersonatePrivilege - ON
SeCreateGlobalPrivilege - ON
SeIncreaseWorkingSetPrivilege - OFF
SeTimeZonePrivilege - OFF
SeCreateSymbolicLinkPrivilege - OFF

Active Controls:

4.1 Form Class : TfWizFrameHostConvertorRun
4.2 Form Text : Models Merge
4.3 Control Class: TButton
4.4 Control Text : Finish

Computer:

5.1 Name : S0018690
5.2 Total Memory : 8463634432 (7,88 Gb)
5.3 Free Memory : 1840128000 (1,71 Gb)
5.4 Total Disk : 319547240448 (297,60 Gb)
5.5 Free Disk : 138249347072 (128,75 Gb)
5.6 System Up Time : 7 hour(s), 40 minute(s), 12 second(s)
5.7 Processor : Intel® Core™ i3-3110M CPU @ 2.40GHz
5.8 Display Mode : \.\DISPLAY1[PRIMARY]: 1920x1080x32 96 DPI @ 0x0, \.\DISPLAY2: 1366x768x32 96 DPI @ 1920x312
5.9 Display DPI : 96
5.10 Video Card : Intel® HD Graphics 4000 (driver 8.15.10.2712 - RAM 2214592512)
5.11 Printer : PDFCreator (driver 6.1.7600.16385)
5.12 Virtual Machine:

Operating System:

6.1 Type : Microsoft Windows 7 (64 bit)
6.2 Build # : 7601 (6.1.7601.18015)
6.3 Update : Service pack 1
6.4 Non-Unicode Language: French (040C)
6.5 Charset/ACP : 0/1252
6.6 Install Language : French (040C)
6.7 UI Language : French (040C)

Network:

7.1 IP Address: 000.000.000.000 - 000.000.000.000 - 000.000.000.000 - 010.077.030.051
7.2 Submask : 000.000.000.000 - 000.000.000.000 - 000.000.000.000 - 255.255.000.000
7.3 Gateway : 000.000.000.000 - 000.000.000.000 - 000.000.000.000 - 010.077.001.099
7.4 DNS 1 : 000.000.000.000 - 000.000.000.000 - 000.000.000.000 - 010.077.001.001
7.5 DNS 2 : 000.000.000.000 - 000.000.000.000 - 000.000.000.000 - 010.050.001.001
7.6 DHCP : ON - ON - ON - ON

Steps to reproduce:

8.1 Text:

Call Stack Information:

|Methods |Details|Stack |Address |Module |Offset |Source |Unit |Class |Procedure/Method |Line |

Comment=
7FFFFFFE
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Running Thread: ID=8840; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=thread: [ 2288 / 8840 ] is blocked
Comment=
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000060
00000060
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Running Thread: ID=6300; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=thread: [ 189C / 6300 ] is blocked
Comment=
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000060
00000060
00000060
00000060
00000060
00000060
00000060
00000060
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Running Thread: ID=5816; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=
Comment=
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000060
00000060
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Running Thread: ID=4644; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=thread: [ 1224 / 4644 ] is blocked
Comment=
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000060
00000060
00000060
00000060
00000060
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Running Thread: ID=856; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=thread: [ 0358 / 856 ] is blocked
Comment=
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Running Thread: ID=6664; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=
Comment=
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000060
00000060

Modules Information:

|Handle |Name |Description |Version |Size |Modified |Path |

|0000000000380000|SSGPW.dll |GDI Plus Interface DLL |1.0.1.9 |331264 |2016-12-07 13:29:46|C:\Program Files\Quest Software\Toad Data Modeler 6.3\Bin\ |
|0000000000400000|TDM.exe |Toad Data Modeler |6.3.3.2 |75255272|2017-09-12 15:14:04|C:\Program Files\Quest Software\Toad Data Modeler 6.3\Bin\ |
|000000000E850000|ssleay32.dll | | |331776 |2016-12-07 13:29:46|C:\Program Files\Quest Software\Toad Data Modeler 6.3\Bin\ |
|0000000020140000|libeay32.dll | | |1501696 |2016-12-07 13:29:46|C:\Program Files\Quest Software\Toad Data Modeler 6.3\Bin\ |
|0000000028170000|rpw10.dll |RTF to PDF Converter |10.0.0.6 |219648 |2016-12-07 13:29:46|C:\Program Files\Quest Software\Toad Data Modeler 6.3\Bin\ |
|0000000028810000|PDW11.DLL |PDF Writer |11.0.0.2 |481280 |2016-12-07 13:30:14|C:\Program Files\Quest Software\Toad Data Modeler 6.3\Bin\ |
|000000006EA70000|msvcr90.dll |Microsoft® C Runtime Library |9.0.30729.6161 |641360 |2015-01-06 13:43:00|C:\Windows\winsxs\amd64_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6161_none_08e61857a83bc251\ |
|000000006EB20000|msvcp90.dll |Microsoft® C++ Runtime Library |9.0.30729.6161 |853328 |2015-01-06 13:43:00|C:\Windows\winsxs\amd64_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.6161_none_08e61857a83bc251\ |
|0000000070050000|security.dll |Security Support Provider Interface |6.1.7600.16385 |5120 |2009-07-14 02:32:34|C:\Windows\System32\ |
|0000000074A30000|odbcint.dll |ODBC Resources |6.1.7600.16385 |229376 |2009-07-14 02:31:54|C:\Windows\System32\ |
|0000000076DF0000|kernel32.dll |DLL du client API BASE Windows NT |6.1.7601.23889 |1163264 |2017-08-11 07:34:55|C:\Windows\System32\ |
|0000000076F10000|user32.dll |DLL client de l’API uilisateur de Windows multi-utilisateurs|6.1.7601.23594 |1009152 |2016-11-10 17:32:41|C:\Windows\System32\ |
|0000000077010000|ntdll.dll |DLL Couche NT |6.1.7601.23889 |1732864 |2017-08-11 07:36:37|C:\Windows\System32\ |
|00000000771D0000|normaliz.dll |Unicode Normalization DLL |6.1.7600.16385 |2560 |2009-07-14 02:31:40|C:\Windows\System32\ |
|00000000771E0000|psapi.dll |Process Status Helper |6.1.7600.16385 |9216 |2009-07-14 02:41:53|C:\Windows\System32\ |
|0000000180000000|TEW23.dll |TE Edit Control |23.0.1.9 |2587648 |2016-12-07 13:30:16|C:\Program Files\Quest Software\Toad Data Modeler 6.3\Bin\ |
|000007FEEF060000|hhctrl.ocx |Contrôle de l’aide HTML Microsoft® |6.1.7600.16385 |701952 |2009-07-14 02:38:53|C:\Windows\System32\ |
|000007FEEF500000|mfc110u.dll |MFCDLL Shared Library - Retail Version |11.0.60610.1 |5619784 |2013-06-09 14:59:36|C:\Windows\System32\ |
|000007FEF1D10000|PS5UI.DLL |Interface utilisateur du pilote PostScript |0.3.9600.17415 |885248 |2014-11-21 10:19:36|C:\Windows\System32\spool\drivers\x64\3\ |
|000007FEF1DF0000|Faultrep.dll |DLL du rapport d’incident dans le mode utilisateur Windows |6.1.7601.17514 |355328 |2010-11-21 04:24:01|C:\Windows\System32\ |
|000007FEF23B0000|GdiPlus.dll |Microsoft GDI+ |6.1.7601.23894 |2171904 |2017-08-16 16:29:12|C:\Windows\winsxs\amd64_microsoft.windows.gdiplus_6595b64144ccf1df_1.1.7601.23894_none_145eb2808b8d6928\ |
|000007FEF2E80000|cscui.dll |IU de cache côté client |6.1.7601.17514 |498688 |2010-11-21 04:24:41|C:\Windows\System32\ |
|000007FEF3320000|oleacc.dll |Active Accessibility Core Component |7.0.0.0 |331776 |2011-08-27 06:37:48|C:\Windows\System32\ |
|000007FEF3A90000|jscript.dll |Microsoft ® JScript |5.8.9600.18817 |817664 |2017-09-07 22:00:47|C:\Windows\System32\ |
|000007FEF4160000|msxml3.dll |MSXML 3.0 SP11 |8.110.7601.23648 |1887744 |2017-01-11 19:01:03|C:\Windows\System32\ |
|000007FEF4360000|ntshrui.dll |Extensions de l’interpréteur de commandes pour le partage |6.1.7601.17755 |509952 |2012-01-04 11:44:20|C:\Windows\System32\ |
|000007FEF44A0000|msimg32.dll |GDIEXT Client DLL |6.1.7600.16385 |8192 |2009-07-14 02:41:29|C:\Windows\System32\ |
|000007FEF4730000|riched20.dll |Rich Text Edit Control, v3.1 |5.31.23.1230 |633344 |2010-11-21 04:24:15|C:\Windows\System32\ |
|000007FEF4C60000|wbemcomn.dll |WMI |6.1.7601.17514 |529408 |2010-11-21 04:23:56|C:\Windows\System32\ |
|000007FEF4CF0000|wbemdisp.dll |WMI Scripting |6.1.7600.16385 |266752 |2009-07-14 02:41:56|C:\Windows\System32\wbem\ |
|000007FEF4EC0000|api-ms-win-downlevel-shlwapi-l2-1-0.dll |ApiSet Stub DLL |6.2.9200.16492 |5632 |2014-09-30 12:58:33|C:\Windows\System32\ |
|000007FEF4EE0000|browcli.dll |Browser Service Client DLL |6.1.7601.17887 |59392 |2012-07-04 23:13:27|C:\Windows\System32\ |
|000007FEF54D0000|cscapi.dll |Offline Files Win32 API |6.1.7601.17514 |46080 |2010-11-21 04:23:51|C:\Windows\System32\ |
|000007FEF5940000|winspool.drv |Pilote de spouleur Windows |6.1.7601.17514 |442368 |2010-11-21 04:23:55|C:\Windows\System32\ |
|000007FEF5AE0000|api-ms-win-downlevel-advapi32-l2-1-0.dll|ApiSet Stub DLL |6.2.9200.16492 |3584 |2014-09-30 12:58:33|C:\Windows\System32\ |
|000007FEF6C10000|msvcr110.dll |Microsoft® C Runtime Library |11.0.51106.1 |849360 |2012-11-05 22:26:22|C:\Windows\System32\ |
|000007FEF7A60000|wer.dll |DLL du rapport d’erreurs Windows |6.1.7601.23877 |486400 |2017-07-14 16:29:15|C:\Windows\System32\ |
|000007FEF7DC0000|wmiutils.dll |WMI |6.2.9200.16398 |124928 |2012-08-21 14:08:28|C:\Windows\System32\wbem\ |
|000007FEF7F20000|wbemsvc.dll |WMI |6.2.9200.16398 |64512 |2012-08-21 14:37:29|C:\Windows\System32\wbem\ |
|000007FEF8110000|wbemprox.dll |WMI |6.2.9200.16398 |39424 |2012-08-21 14:07:40|C:\Windows\System32\wbem\ |
|000007FEF8130000|ntdsapi.dll |Active Directory Domain Services API |6.1.7600.16385 |152064 |2009-07-14 02:41:53|C:\Windows\System32\ |
|000007FEF81D0000|fastprox.dll |WMI Custom Marshaller |6.2.9200.16398 |857088 |2012-08-21 14:11:31|C:\Windows\System32\wbem\ |
|000007FEF84B0000|wbemcomn2.dll |WMI |6.2.9200.16398 |494592 |2012-08-21 14:08:20|C:\Windows\System32\ |
|000007FEF9330000|rasadhlp.dll |Remote Access AutoDial Helper |6.1.7600.16385 |16384 |2009-07-14 02:41:53|C:\Windows\System32\ |
|000007FEF9860000|googledrivesync64.dll |Google Drive shell extension |3.37.7411.4599 |774104 |2017-11-01 05:49:50|C:\Program Files (x86)\Google\Drive\ |
|000007FEF9BA0000|mapi32.dll |MAPI 1.0 étendue pour Windows NT |1.0.2536.0 |91648 |2015-11-14 00:09:16|C:\Windows\System32\ |
|000007FEF9BC0000|EhStorShell.dll |DLL d’extension d’environnement de stockage étendu Windows |6.1.7600.16385 |203264 |2009-07-14 02:40:36|C:\Windows\System32\ |
|000007FEF9F50000|dhcpcsvc.dll |Service client DHCP |6.1.7600.16385 |87040 |2009-07-14 02:40:28|C:\Windows\System32\ |
|000007FEF9F70000|dhcpcsvc6.DLL |Client DHCPv6 |6.1.7601.17970 |55296 |2012-10-09 19:17:13|C:\Windows\System32\ |
|000007FEFA140000|FWPUCLNT.DLL |API en mode utilisateur FWP/IPsec |6.1.7601.18283 |324096 |2013-10-12 03:29:08|C:\Windows\System32\ |
|000007FEFA2B0000|winnsi.dll |Network Store Information RPC interface |6.1.7601.23889 |25600 |2017-08-11 07:35:06|C:\Windows\System32\ |
|000007FEFA2C0000|IPHLPAPI.DLL |API de l’application d’assistance IP |6.1.7601.17514 |145920 |2010-11-21 04:24:16|C:\Windows\System32\ |
|000007FEFA460000|WindowsCodecs.dll |Microsoft Windows Codecs Library |6.2.9200.21830 |1424896 |2016-04-09 04:52:25|C:\Windows\System32\ |
|000007FEFA5E0000|odbc32.dll |ODBC Driver Manager |6.1.7601.17514 |720896 |2010-11-21 04:23:48|C:\Windows\System32\ |
|000007FEFA7F0000|wtsapi32.dll |Windows Remote Desktop Session Host Server SDK APIs |6.1.7600.16385 |54272 |2009-07-14 02:41:58|C:\Windows\System32\ |
|000007FEFA810000|slc.dll |Dll de client de gestion de licences du logiciel |6.1.7600.16385 |30720 |2009-07-14 02:41:54|C:\Windows\System32\ |
|000007FEFAAD0000|wkscli.dll |Workstation Service Client DLL |6.1.7601.17514 |71680 |2010-11-21 04:24:26|C:\Windows\System32\ |
|000007FEFAB20000|netapi32.dll |Net Win32 API DLL |6.1.7601.17887 |73216 |2012-07-04 23:16:43|C:\Windows\System32\ |
|000007FEFADC0000|dwmapi.dll |API du Gestionnaire de fenêtres du Bureau Microsoft |6.1.7601.18796 |82944 |2015-03-14 04:21:28|C:\Windows\System32\ |
|000007FEFADE0000|cscdll.dll |Offline Files Temporary Shim |6.1.7601.17514 |30208 |2010-11-21 04:23:51|C:\Windows\System32\ |
|000007FEFAF90000|ntmarta.dll |Fournisseur MARTA Windows NT |6.1.7600.16385 |162304 |2009-07-14 02:41:53|C:\Windows\System32\ |
|000007FEFB1E0000|uxtheme.dll |Bibliothèque de thèmes Ux Microsoft |6.1.7600.16385 |332288 |2009-07-14 02:41:56|C:\Windows\System32\ |
|000007FEFB2F0000|AcSignIcon.dll |AutoCAD component |20.0.51.0 |47944 |2014-02-07 11:02:36|C:\Windows\System32\ |
|000007FEFB310000|winmm.dll |DLL API MCI |6.1.7600.16385 |217600 |2009-07-14 02:41:56|C:\Windows\System32\ |
|000007FEFB350000|propsys.dll |Système de propriétés Microsoft |7.0.7601.17514 |1212416 |2010-11-21 04:23:55|C:\Windows\System32\ |
|000007FEFB4D0000|powrprof.dll |DLL d’assistance du profil d’alimentation |6.1.7600.16385 |167424 |2009-07-14 02:41:53|C:\Windows\System32\ |
|000007FEFB500000|comctl32.dll |Bibliothèque de contrôles de l’expérience utilisateur |6.10.7601.18837 |2030592 |2015-04-24 19:12:05|C:\Windows\winsxs\amd64_microsoft.windows.common-controls_6595b64144ccf1df_6.0.7601.18837_none_fa3b1e3d17594757|
|000007FEFBB20000|idndl.dll |Downlevel DLL |6.1.7600.16385 |37376 |2009-07-14 02:41:05|C:\Windows\System32\ |
|000007FEFBBB0000|wsock32.dll |Windows Socket 32-Bit DLL |6.1.7600.16385 |18432 |2009-07-14 02:41:58|C:\Windows\System32\ |
|000007FEFBDD0000|version.dll |Version Checking and File Installation Libraries |6.1.7600.16385 |29184 |2009-07-14 02:41:56|C:\Windows\System32\ |
|000007FEFBEA0000|WSHTCPIP.DLL |DLL d’application d’assistance Winsock2 (TL/IPv4) |6.1.7600.16385 |13312 |2009-07-14 02:41:58|C:\Windows\System32\ |
|000007FEFC120000|netutils.dll |Net Win32 API Helpers DLL |6.1.7601.17514 |29184 |2010-11-21 04:24:03|C:\Windows\System32\ |
|000007FEFC1F0000|rsaenh.dll |Microsoft Enhanced Cryptographic Provider |6.1.7600.16385 |281256 |2009-07-14 02:43:15|C:\Windows\System32\ |
|000007FEFC310000|dnsapi.dll |DNS DLL de l’API Client |6.1.7601.17570 |357888 |2011-03-03 07:24:15|C:\Windows\System32\ |
|000007FEFC480000|wship6.dll |DLL d’application d’assistance Winsock2 (TL/IPv6) |6.1.7600.16385 |13824 |2009-07-14 02:41:58|C:\Windows\System32\ |
|000007FEFC490000|mswsock.dll |Fournisseur de service Sockets 2.0 de Microsoft Windows |6.1.7601.23451 |327168 |2016-05-11 18:02:42|C:\Windows\System32\ |
|000007FEFC4F0000|cryptsp.dll |Cryptographic Service Provider API |6.1.7601.23471 |81920 |2016-06-14 18:16:25|C:\Windows\System32\ |
|000007FEFC640000|bcrypt.dll |Windows Cryptographic Primitives Library |6.1.7601.23889 |123904 |2017-08-11 07:34:51|C:\Windows\System32\ |
|000007FEFC700000|srvcli.dll |Server Service Client DLL |6.1.7601.17514 |128000 |2010-11-21 04:24:03|C:\Windows\System32\ |
|000007FEFC830000|secur32.dll |Security Support Provider Interface |6.1.7601.23889 |28160 |2017-08-11 07:35:03|C:\Windows\System32\ |
|000007FEFCAD0000|sspicli.dll |Security Support Provider Interface |6.1.7601.23889 |135680 |2017-08-11 07

Daril · November 14, 2017, 2:32am

Hello,

thank you for report. It is bug. I create issue TDM-3883, you can track this issue in RN. It will be fixed ASAP.

This issue is only for model that is in Project and it is not in root folder or first folder. So work around could be extract this model from Project merge it and insert again to project.

Daril

Tetranos · November 20, 2017, 7:00am

Hi Daril,

Workaroud works for the “merge” bug, thanks.

But there is also the bug of PK names that are not set when converting from logical to physical.

Regards,

dkretek · November 20, 2017, 10:53pm

Hi,

please could you describe the problem of missing PK name in more detail or could you provide us simple logical model (e.g. with 2 entities) when the PK names are not set after conversion to physical model?
The “merge” bug is fixed in the current BETA and also will be fixed in next full version.

Thank you

David

Daril · November 20, 2017, 10:53pm

Hi Tetranos,

I tried convert logical model to physical and key name is set right.

Please specify case where PK name are not convert from logical to physical model.

Do you have default settings in convert wizard?

Thanks