Error on Generating - Query on Entity has exceeded the hard limit of conditions in a single filter (300) about dlab.xrm.xrmtoolboxtools HOT 9 CLOSED

Can you shutdown the XTB, and then replace the Microsoft.PowerPlatofrm.Dataverse.ModelBuilder dll in your
XrmToolBox\Plugins\DLaB.EarlyBoundGeneratorV2 folder with this (might want to make a back up first), and try again?

Microsoft.PowerPlatform.Dataverse.ModelBuilderLib.zip

from dlab.xrm.xrmtoolboxtools.

@aboodh95 just checking to see if you had a chance to test the dll.

from dlab.xrm.xrmtoolboxtools.

Hi @daryllabar
After replacing the dll, i'm getting this error

`
System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.PowerPlatform.Dataverse.ModelBuilderLib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.PowerPlatform.Dataverse.ModelBuilderLib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'
at DLaB.EarlyBoundGeneratorV2.Logic.Create(IOrganizationService service)
at DLaB.EarlyBoundGeneratorV2.EarlyBoundGeneratorPlugin.b__49_0(BackgroundWorker w, DoWorkEventArgs e)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.PowerPlatform.Dataverse.ModelBuilderLib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.
File name: 'Microsoft.PowerPlatform.Dataverse.ModelBuilderLib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'
at DLaB.EarlyBoundGeneratorV2.Logic.Create(IOrganizationService service)
at DLaB.EarlyBoundGeneratorV2.EarlyBoundGeneratorPlugin.b__49_0(BackgroundWorker w, DoWorkEventArgs e)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

`

from dlab.xrm.xrmtoolboxtools.

Stink... I don't think I can build a MS dll and have it get loaded correctly...

from dlab.xrm.xrmtoolboxtools.

DLaB.EarlyBoundGeneratorV2.zip
Take two, you'll need to replace the DLaB.EarlyBoundGenratorV2.dll with the dll in the folder, and delete the DLaB.EarlyBoundGeneratorV2 folder and replace it with the one in the zip.

from dlab.xrm.xrmtoolboxtools.

Hi,
A new error is showing

CRM Authentication Type Detected: None
Tracking Generation Event.
Updating Builder Settings
Generating Early Bound Files
System.IO.FileLoadException: Could not load file or assembly 'Microsoft.PowerPlatform.Dataverse.ModelBuilderLib, Version=2.0.0.6, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. Strong name validation failed. (Exception from HRESULT: 0x8013141A)
File name: 'Microsoft.PowerPlatform.Dataverse.ModelBuilderLib, Version=2.0.0.6, Culture=neutral, PublicKeyToken=31bf3856ad364e35' ---> System.Security.SecurityException: Strong name validation failed. (Exception from HRESULT: 0x8013141A)
The Zone of the assembly that failed was:
MyComputer
at DLaB.EarlyBoundGeneratorV2.Logic.Create(IOrganizationService service)
at DLaB.EarlyBoundGeneratorV2.EarlyBoundGeneratorPlugin.b__49_0(BackgroundWorker w, DoWorkEventArgs e)

System.IO.FileLoadException: Could not load file or assembly 'Microsoft.PowerPlatform.Dataverse.ModelBuilderLib, Version=2.0.0.6, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. Strong name validation failed. (Exception from HRESULT: 0x8013141A)
File name: 'Microsoft.PowerPlatform.Dataverse.ModelBuilderLib, Version=2.0.0.6, Culture=neutral, PublicKeyToken=31bf3856ad364e35' ---> System.Security.SecurityException: Strong name validation failed. (Exception from HRESULT: 0x8013141A)
The Zone of the assembly that failed was:
MyComputer
at DLaB.EarlyBoundGeneratorV2.Logic.Create(IOrganizationService service)
at DLaB.EarlyBoundGeneratorV2.EarlyBoundGeneratorPlugin.b__49_0(BackgroundWorker w, DoWorkEventArgs e)

from dlab.xrm.xrmtoolboxtools.

Interesting, It works on my machine. I'll submit my PR To MS to fix it in the PAC. In the mean time, you could split up the number of entities that you are generating, and run it multiple times as an extremely painful work around?

from dlab.xrm.xrmtoolboxtools.

Hi,

Thanks for the work, I went back to V1 and it did work fine, but I want to share with you another issue regarding this error, the moment the error of 300 limits happens, the tool will stop working for other requests, until I close the app and re-open it,
to reproduce it, this is what I did

I connected to the org of client A, they have more than 500 entities, I got the error, I closed the tool.
I connected to the org of client B, they have around 40 entities, I got the same error, I checked the XML file, and only 40 entities were selected, I opened Fiddler, and runner the request, the client A entities were showeing in the request, After closing XrmToolBox, everything back to normal

I think it's caching the request in case it didn't succeed, but I just wanted to let you know about it

from dlab.xrm.xrmtoolboxtools.

Hmm.. that shouldn't be possible. I'm submitting the PR to MS now for the initial fix, will mark this as completed when I can reference their code, post them building and releasing.

from dlab.xrm.xrmtoolboxtools.