Dynamics Community Forum Thread Details

SQL Exception: Input Query Length Exceeding Maximum Limit in Dataverse Integration

Hello,

We are currently integrating using AppService to push data to Dataverse in a production environment, following this logic:

We retrieve data from an API to extract the customer's email and compare it with CRM.
If the account does not exist, we create the account.
We serialize the create/update lists separately.
Using a parallel "for each" loop, we send data in batches of 1,000 records per batch back to CRM APIs after generating the token.

We tried reducing the batch size to 10 records and even one record per batch and running the process without the parallel "for each" loop. However, in all cases, the calls are still failing.

When we trigger the process, the code fails with the attached error, suggesting that the query length is being exceeded. We have not found a way to catch which field is failing in order to increase its length.

Is there any investigation tool that could help identify the issue? We created a pre-validation plugin to check all field lengths, but it seems the plugin is not being triggered, indicating the process isn't even reaching the insert step in Dataverse.

Unfortunately, the customer cannot provide us with access to the production environment due to the sensitivity of their data.

Any assistance would be greatly appreciated.

Best regards,
Julien

Categories:

Customization / Solutions / SDK and API

Integration with Other Products

Quick Links

Leaderboard