Using Entity.Attributes as source for DataVirtualGrid gives error

Toad Data Modeler
1

Hi,

I'm trying to add a DataVirtualGrid to my customized "Entity Properties" form.

This actually worked in Toad 5.4 but now we are porting the model to 6.5.5 and a "component damaged" error raises when we open the form.

19
Schermata 2019-05-17 alle 01.51.19.png934×682 22.2 KB

So I finally decided to re-design the customized form in 6.5.5, from scratch.

Unfortunately, when I select Entity -> Attributes as data source for the DataVirtualGrid, an unmanaged error appears and data is not loaded.

23
Schermata 2019-05-17 alle 01.45.23.png1170×1288 90.9 KB

Note that if I select, for example, Entity -> Indexes, no error is given and the data loads correctly in the grid.

Glad if you can help me.
Thanks

2

Hi Tommaso,
between versions can be on forms some changes that can be in conflict with your customization. From message I See that panel "PaTop" has been removed or has now different parent controls.

I tried Data Grid on Entity by your post, but all is OK.

If you share with me your package or packages(if there are some dependencies) with changes (ClaPackage.txg) I can check it.
Second choice is delete this package and make this modification again.
If you are willing send me your package please send is to email petr.daricek@quest.com .

Best Regards
Petr

3

I tried to delete all packages, just for trial, but I get the same error.
Did you try to do the operation on a Oracle 10g ERD?

4

Actually I tried that on a clean Oracle 10g ERD and it works. So I think it is probably related to our (very complicated) ERD.

I will try to edit the ClaPackage using a clean ERD, but it would be nicer to solve that error.

5

Hi Tommaso,
yes I tried it on Oracle 10g ERD. On sample model Videorental. All works fine.
Can you send us at least all eurekalog(on your screenshot is link to click here, after click there you will see details and you are able to copy it to text file) .

Thanks
Daril

6

Sorry for being late but I had a lot to do at work.
Now I'm retrying to get it working.

First of all, here are the logs you requested:

Application:

1.1 Start Date : Fri, 14 Jun 2019 17:36:09 +0200
1.2 Name/Description: TDM.exe - (Toad Data Modeler)
1.3 Version Number : 6.5.6.4
1.4 Parameters :
1.5 Compilation Date: Fri, 5 Apr 2019 11:47:58 +0200
1.6 Up Time : 3 minute(s), 26 second(s)

Exception:

2.1 Date : Fri, 14 Jun 2019 17:39:35 +0200
2.2 Address : 0000000001BCEB02
2.3 Module Name : TDM.exe - (Toad Data Modeler)
2.4 Module Version: 6.5.6.4
2.5 Type : EAccessViolation
2.6 Message : Access violation at address 0000000001BCEB02 in module 'TDM.exe'. Read of address 0000000000000000.
2.7 ID : 01F33296
2.8 Count : 1
2.9 Status : New
2.10 Note :
2.11 Sent : 0

User:

3.1 ID : tmp
3.2 Name : tmp
3.3 Email :
3.4 Company :
3.5 Privileges: SeShutdownPrivilege - OFF
SeChangeNotifyPrivilege - ON
SeUndockPrivilege - OFF
SeIncreaseWorkingSetPrivilege - OFF
SeTimeZonePrivilege - OFF

Active Controls:

4.1 Form Class : TFFormDesignerObjectInspector
4.2 Form Text : Object Inspector
4.3 Control Class: TLMDPropsPageInplaceEdit
4.4 Control Text : Attributes

Computer:

5.1 Name : DESKTOP-AOV821A
5.2 Total Memory : 4294430720 (4.00 Gb)
5.3 Free Memory : 2227548160 (2.07 Gb)
5.4 Total Disk : 63846739968 (59.46 Gb)
5.5 Free Disk : 49774575616 (46.36 Gb)
5.6 System Up Time : 7 hour(s), 37 minute(s), 39 second(s)
5.7 Processor : Intel(R) Core(TM) i7-7500U CPU @ 2.70GHz
5.8 Display Mode : 1690 x 928, 32 bit
5.9 Display DPI : 96
5.10 Video Card : VMware SVGA 3D (driver 8.16.1.1)
5.11 Printer : Microsoft Print To PDF (driver 10.0.17134.191)
5.12 Virtual Machine: VMWare Workstation

Operating System:

6.1 Type : Microsoft Windows 10 (64 bit)
6.2 Build # : 1803 (10.0.17134.706)
6.3 Update :
6.4 Non-Unicode Language: English (0409)
6.5 Charset/ACP : 0/1252
6.6 Install Language : English (0409)
6.7 UI Language : English (0409)

image
image954×688 43.5 KB

7

Also, I tried to edit forms from scratch, but I receive some errors on our ERD when opening an Entity properties form.

It opens blank with the same error as above in the Message window:

Error during evaluation of method GetPropertyMethod in property 'PERAttributeOR10.DataEnabled'
Name of Class: TPERAttribute
Name of Factory: PERAttributeOR10

Message: Access violation at address 0000000001BCEB02 in module 'TDM.exe'. Read of address 0000000000000000

image
image633×561 20.7 KB

Then when I close it, I get an Access Violation error:

Application:

1.1 Start Date : Fri, 14 Jun 2019 17:44:46 +0200
1.2 Name/Description: TDM.exe - (Toad Data Modeler)
1.3 Version Number : 6.5.6.4
1.4 Parameters :
1.5 Compilation Date: Fri, 5 Apr 2019 11:47:58 +0200
1.6 Up Time : 3 minute(s), 31 second(s)

Exception:

2.1 Date : Fri, 14 Jun 2019 17:48:17 +0200
2.2 Address : 0000000003268CDC
2.3 Module Name : TDM.exe - (Toad Data Modeler)
2.4 Module Version: 6.5.6.4
2.5 Type : EAccessViolation
2.6 Message : Access violation at address 0000000003268CDC in module 'TDM.exe'. Read of address 0000000000000000.
2.7 ID : FC96586F
2.8 Count : 1
2.9 Status : New
2.10 Note :
2.11 Sent : 0

User:

3.1 ID : tmp
3.2 Name : tmp
3.3 Email :
3.4 Company :
3.5 Privileges: SeShutdownPrivilege - OFF
SeChangeNotifyPrivilege - ON
SeUndockPrivilege - OFF
SeIncreaseWorkingSetPrivilege - OFF
SeTimeZonePrivilege - OFF

Active Controls:

4.1 Form Class : TFMain
4.2 Form Text : Toad Data Modeler 6.5 [C:\Users\tmp\Desktop\ApplicationData.txp]
4.3 Control Class: TLogViewVT
4.4 Control Text :

Computer:

5.1 Name : DESKTOP-AOV821A
5.2 Total Memory : 4294430720 (4.00 Gb)
5.3 Free Memory : 2235379712 (2.08 Gb)
5.4 Total Disk : 63846739968 (59.46 Gb)
5.5 Free Disk : 49771929600 (46.35 Gb)
5.6 System Up Time : 7 hour(s), 47 minute(s), 0 second(s)
5.7 Processor : Intel(R) Core(TM) i7-7500U CPU @ 2.70GHz
5.8 Display Mode : 1690 x 928, 32 bit
5.9 Display DPI : 96
5.10 Video Card : VMware SVGA 3D (driver 8.16.1.1)
5.11 Printer : Microsoft Print To PDF (driver 10.0.17134.191)
5.12 Virtual Machine: VMWare Workstation

Operating System:

6.1 Type : Microsoft Windows 10 (64 bit)
6.2 Build # : 1803 (10.0.17134.706)
6.3 Update :
6.4 Non-Unicode Language: English (0409)
6.5 Charset/ACP : 0/1252
6.6 Install Language : English (0409)
6.7 UI Language : English (0409)

image
image885×578 30.7 KB

If I use the package with a blank Oracle 10g model, it loads the Entity properties form but it gives same error when saving domain for a field:

Application:

1.1 Start Date : Fri, 14 Jun 2019 17:51:46 +0200
1.2 Name/Description: TDM.exe - (Toad Data Modeler)
1.3 Version Number : 6.5.6.4
1.4 Parameters :
1.5 Compilation Date: Fri, 5 Apr 2019 11:47:58 +0200
1.6 Up Time : 1 minute(s), 58 second(s)

Exception:

2.1 Date : Fri, 14 Jun 2019 17:53:45 +0200
2.2 Address : 0000000001BCEB02
2.3 Module Name : TDM.exe - (Toad Data Modeler)
2.4 Module Version: 6.5.6.4
2.5 Type : EAccessViolation
2.6 Message : Access violation at address 0000000001BCEB02 in module 'TDM.exe'. Read of address 0000000000000000.
2.7 ID : 01F33296
2.8 Count : 1
2.9 Status : New
2.10 Note :
2.11 Sent : 0

User:

3.1 ID : tmp
3.2 Name : tmp
3.3 Email :
3.4 Company :
3.5 Privileges: SeShutdownPrivilege - OFF
SeChangeNotifyPrivilege - ON
SeUndockPrivilege - OFF
SeIncreaseWorkingSetPrivilege - OFF
SeTimeZonePrivilege - OFF

Active Controls:

4.1 Form Class : TFmPERAttributeEditOR10
4.2 Form Text : Attribute Properties - Entity1
4.3 Control Class: TButton
4.4 Control Text : &OK

Computer:

5.1 Name : DESKTOP-AOV821A
5.2 Total Memory : 4294430720 (4.00 Gb)
5.3 Free Memory : 2293374976 (2.14 Gb)
5.4 Total Disk : 63846739968 (59.46 Gb)
5.5 Free Disk : 49771347968 (46.35 Gb)
5.6 System Up Time : 7 hour(s), 51 minute(s), 53 second(s)
5.7 Processor : Intel(R) Core(TM) i7-7500U CPU @ 2.70GHz
5.8 Display Mode : 1690 x 928, 32 bit
5.9 Display DPI : 96
5.10 Video Card : VMware SVGA 3D (driver 8.16.1.1)
5.11 Printer : Microsoft Print To PDF (driver 10.0.17134.191)
5.12 Virtual Machine: VMWare Workstation

Operating System:

6.1 Type : Microsoft Windows 10 (64 bit)
6.2 Build # : 1803 (10.0.17134.706)
6.3 Update :
6.4 Non-Unicode Language: English (0409)
6.5 Charset/ACP : 0/1252
6.6 Install Language : English (0409)
6.7 UI Language : English (0409)

image
image951×756 59.2 KB

Please help. We are desperate because we need to port our model to the new Toad 6.5 due to the Wscript issue in Win10 update 1809.

8

Hello Tommaso,

thank you for the log, it helps us. Do you use an attribute with domain in entity? I was able reproduce your error only when I added DataVirtualGrid to entity with attribute of type domain. After I set "Attributes" in DataList and "Entity" in DataSource the same error appears.
I've created issue TDM-5450 for this error and it will be probably fixed in the new version.
We are sorry you are having trouble with TDM and as a temporary workaround I can only recommend not use the domains in attributes at this time.

Regards,
Dave

9

Yes, we use domains widespread over our model. In fact, as I wrote up here:

If I use the package with a blank Oracle 10g model, it loads the Entity properties form but it gives same error when saving domain for a field

if I start with a clean model, modify the form and then try to save a domain for an attribute, I get in the same situation.

Unfortunately not using the domains is not an applicable workaround for our case, as stated before we use them all over our model and we also export them to our ORM.

Hope it will be fixed in the upcoming version.

Meanwhile, I opened two other topics about issues I encountered re-customizing forms:
DataVirtualGrid "InplaceEdit" gone in TOAD 6?
PERAttribute custom property does not appear when customizing forms
Please give them a look, maybe there's something else to fix in the new version :frowning:

10

Hi Tommaso.

Next workaround is delete your user package - this is true if you have all changes (new properties and edited forms) in user package.
User packages are defaultly saved in Path: C:\Users\USERNAME\Documents\Toad Data Modeler\Standard Installation\Packages\{DCB5CB9B-CF65-4350-86B5-285D246FC5AC}

Regards,
Mario

11

We are still working with 5.3 so a workaround is not necessary for now.

Instead we look forward to have a new version with this and the other issues fixed, so we can port our full configuration.

As stated before, we need to port our model to the new Toad 6.5 due to the Wscript issue in Win10 update 1809.

12

I want to report that I also tried the new 7.0 version, but it suffer from all the issues I recently filed.

13

Yes, we know it. Version 7.0 has been released a week ago so it could not be fixed yet.

Regards,
Dave

14

Yes, I know that it could have not been fixed, it was just for completeness.

15

OK and thank you for your help to find these issues.

Dave

16

Hello,

any update on this?

Do you plan to release a fixed 6.x or 7.x version anytime soon?

17

Hi,

This is in plan for next version 7.1 (apparently in the fall).

Regards,

Mario

18

Is it not possible to release a minor patch for this specific issue ?
(the other two can be worked around)

This is blocking our entire update to latest Toad version.

19

News on 7.1 release?

20

Yes,
version 7.1 will be released at the end of this month (GA date is set to 21 October) and all your mentioned bugs should be fixed.
Regards
David