web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Batch Job Error: 'Unable to Find the Report Design' While Running SSRS Report in D365FO

(4) ShareShare
ReportReport
Posted on by 631

Hello everyone,

I'm facing an issue with a custom SSRS report in D365 Finance & Operations.

 

What works:

When I run the report interactively (not in batch) with a small data set, it works fine and returns results within seconds.

 

What fails:

When I run the same report in batch, it fails with the error: An error occurred when running report Design in batch.
Contact your
system administrator for more information.




Additionally, I attempted to debug the batch job using batch.exe, but was unable to load symbols for the process. Despite several efforts, Visual Studio does not hit any breakpoints, making it difficult to trace the root cause inside the batch job.

Categories:
I have the same question (0)
  • Saalim Ansari Profile Picture
    631 on at
    Batch Job Error: 'Unable to Find the Report Design' While Running SSRS Report in D365FO

    Hii Jonas,

    I
    discussed the issue with the admin — the debugging problem is happening because the environment is running on an older version. Due to this, batch jobs cannot be debugged, and there's also a mismatch between the Sandbox and DEV environments.

    I’ve suggested either upgrading the version or redeploying the server, especially since the batch job for the report isn’t working in Production either.

  • Verified answer
    Jonas "Jones" Melgaard Profile Picture
    4,837 Super User 2025 Season 2 on at
    Batch Job Error: 'Unable to Find the Report Design' While Running SSRS Report in D365FO
    Yes, kind of. It still needs to process the data, and this will take the same amount of time. But it eliminates the timeouts. I've done it since the pattern was described in AX2012.
     
    But consider, if you have time and budget, optimizing the data processing.
  • Saalim Ansari Profile Picture
    631 on at
    Batch Job Error: 'Unable to Find the Report Design' While Running SSRS Report in D365FO

    Yes, that makes sense.

    I also started leaning toward the idea that the environment itself might be broken, especially since even standard reports fail in batch and symbols don’t load at all in batch.exe. The same code and setup work perfectly on another project server, so it really does point to an environment-specific issue.

    Redeploying the environment does sound like a clean and efficient solution at this point. I agree—spending time debugging a broken dev environment often ends up costing more than just setting up a fresh one.

    Also, I’ve noticed that when the report runs in interactive mode, it completes within seconds, but in with more records, it often throws this error:

    Exceeded 10 minutes timeout during report processing. Consider updating the report to pre-processing or reducing data using report filters.

    Error in UAT: 
    For more information about this error navigate to the report server on the local server machine, or enable remote errors

    Do you know if there’s a recommended way to fix or work around this? Would implementing pre-processing help avoid the timeout.

     

    Thanks again!

  • Jonas "Jones" Melgaard Profile Picture
    4,837 Super User 2025 Season 2 on at
    Batch Job Error: 'Unable to Find the Report Design' While Running SSRS Report in D365FO
    Ah, okay. It sounds like there are something completely wrong with that environment if it's not even trying to attach to the batch executor. 
     
    If it works somewhere else, I'd say they easy way to resolve it is to just redeploy the environment.
    I've never had any luck saving time trying to fix development environments. I consider these environments as disposable.
     
    Is that a solution?
  • Saalim Ansari Profile Picture
    631 on at
    Batch Job Error: 'Unable to Find the Report Design' While Running SSRS Report in D365FO

    Hi

    Yes, I'm using a custom controller, contract, and DP class. The contract class is clean and only used to pass parameters—no dialogs or UI interactions involved.

    Regarding the debugging issue:

    I’ve tried multiple times to debug the batch execution using breakpoints and attaching the debugger to w3wp.exe and batch.exe, but the symbols never get loaded. I even tried very simple batch classes with info() statements just to see if the debugger hits, but it doesn’t. This behavior only occurs on my current project server. I tried the same report (even a standard one) on a different project server, and it worked fine—batch ran successfully and symbols were loaded correctly.

    So, to clarify:

    Only SSRS reports fail in batch on my current environment. Custom and standard batch jobs run successfully (NOT SSRS Report).

    The standard and custom report works on a different project server. I got sames issue in standard as well as custom reports while running in batch job.
     

    For small case the report work fine without batch job and more records it throw error: 
    Exceeded 10 minutes timeout during report processing. Consider updating the report to pre-processing or reducing data using report filters. (Usually client run this Report using interactive mode)

    Debugger never attaches to batch.exe on the problematic server—symbols don’t load even for a test batch job.

    Let me know if you think this could be an environment/configuration issue or anything else I can try.

    Thanks!

  • Jonas "Jones" Melgaard Profile Picture
    4,837 Super User 2025 Season 2 on at
    Batch Job Error: 'Unable to Find the Report Design' While Running SSRS Report in D365FO
     
    It's really difficult to say, as we cannot see how you made the report.
    Are you using a custom controller, or your own? How have you built the contract? Is there a data provider etc.
     
    Unable to load symbols sounds odd to me, are you sure the debugger works? What if you try a write a simple batch job, and see if it get's picked up by the debugger,
  • Saalim Ansari Profile Picture
    631 on at
    Batch Job Error: 'Unable to Find the Report Design' While Running SSRS Report in D365FO

    Hi Raj,

    Thank
    you for your response and suggestions.

    Just to clarify a few points based on your feedback:

    There are no dialog() methods or UI elements used in the report. We use a proper contract class to handle input parameters.

    Regarding batch execution taking hours versus seconds in interactive mode — we observed that for small data (e.g., two Sales Orders), the report runs in seconds interactively, but when the same case is scheduled in batch, it takes hours and ultimately fails with a timeout. Could you please elaborate on how to fix this or what kind of data restrictions or optimizations should be in place to improve performance in batch mode?
     
    Your point about missing permissions for the batch user might be valid, especially since this error also appears in our production environment. Could you guide me on how to validate and fix permission issues for the batch user executing the report? (e.g., class access, data security roles, or required duties/privileges.)

    Previously, the report used a Regular table, but I’ve updated it to use a TempDB table. Unfortunately, the issue persists even after this change.

    I tested the one standard report on a different project server, and it worked fine there. I also tried running a standard SSRS report in batch on my current server, and it fails similarly — but other batch jobs (non-SSRS) run without issues. So it seems the problem is isolated to SSRS reports when executed via batch on this specific environment.

  • Raj Borad Profile Picture
    1,309 on at
    Batch Job Error: 'Unable to Find the Report Design' While Running SSRS Report in D365FO
    Hi Saalim,
     
    When a custom SSRS report works interactively but fails in batch in D365 Finance & Operations, it usually points to issues with permissions, data access, or report design not being batch-safe. Here are possible causes:
     
    - Code behind the report uses 'dialog' elements or UI-specific logic, which doesn't work in batch.
    - Query timing out or consuming too much memory in batch due to larger or unrestricted data.
    - Missing permissions for the batch user to access the data or execute specific classes.
     
    Does the controller or DP class use UI elements like 'dialog()' or 'info()'?
    Maybe it's the issue of TempDB/Inmemory table used in the report. 
     
     
    Thanks.
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

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

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 789 User Group Leader

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 607 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 497 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans