web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... DIXF SSISHelper.Transi...

Finance | Project Operations, Human Resources, ...

Suggested Answer

DIXF SSISHelper.TransientRowNotFoundException' was thrown.

(2) Share

Report

Report

Posted on by CU14041826-0

4

D365 FO DIXF throws an error "SSISHelper.TransientRowNotFoundException' was thrown." when we are importing a file with size 3000 KB. The data entity used is composite entity and the file is in XML format.

Same file work when we split to multiple with smaller size.

Do we have any limitation for the file size or do we have any Config to modify the limit?

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Holly Huffman 6,554 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Good morning, afternoon, or evening :) depending on your location!

The error you're experiencing, SSISHelper.TransientRowNotFoundException, typically points to limitations or constraints in the data import/export framework (DIXF) of Dynamics 365 Finance and Operations (D365FO).

1. File Size Limitations in DIXF

Default Limit: DIXF may have default limitations on file size or data volume, especially when dealing with composite entities and XML files. This is influenced by factors like SQL Server memory constraints and framework performance.

Splitting Files: The fact that the file works after splitting suggests that the limitation could be tied to memory handling or transaction size.

2. Configuration to Modify the Limit

You can attempt the following configurations to address this limitation:

Batch Framework Parameters: Ensure that batch processing is optimized to handle larger file sizes. Increasing the batch size or enabling asynchronous processing can help.

SQL Server Configuration: Adjust SQL Server settings, such as max memory and transaction timeout, to accommodate larger files.

DIXF Buffer Size: Increase the buffer size used by DIXF to process larger files. This is typically done through environment-specific configurations.

Timeout Settings: Check and adjust timeout settings in DIXF to allow longer processing times for larger files.

3. Alternative Solutions

Pre-Split Files: If the file can be split into smaller parts without loss of data integrity, automate the splitting process before import.

Simplify Composite Entities: If possible, reduce the complexity of the composite entity by breaking it down into simpler entities for more efficient import handling.

Optimize XML File Design: Ensure that the XML file is designed efficiently, with minimal redundancy and optimized structure.

4. Suggestions Moving Forward

If none of the above solutions resolve the issue, consider raising a support ticket with Microsoft. They may provide additional guidance or patches specific to DIXF handling.

Test various configurations in a sandbox environment to identify the exact limit and verify the effectiveness of the changes before applying them to production.

Hope this helps some!

Was this reply helpful? Yes No
Martin Dráb 239,035 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

My clients often use much larger files without such a problem. Are you consistently getting this error? Does it happen with other data entities as well? Can you get the stack trace of the exception?

Don't pay attention to Holly, she's either a bot or someone spamming this forum with AI-generated replies, often completely meaningless. For example, of course that you can't "Adjust SQL Server settings, such as max memory and transaction timeout" in T2+ environments, as there is no SQL Server at all the and the Azure SQL instances are managed by Microsoft.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Giorgio Bonacorsi 659

#2

André Arnaud de Cal... 465 Super User 2026 Season 1

#3

Syed Haris Shah 304 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans