Views:

Applies to Product - Dynamics 365 Supply Chain Management

What’s happening?
Timeouts occurring in the IV service when making requests, resulting in HTTP 500 'Internal Server Error' messages. Additionally, issues with the debugger service causing interruptions.


Reason:

  • The timeouts in the IV service are likely caused by a significant amount of data in the on-hand tables, particularly in the WHSInventReserve table, which contains approximately 34 million records, of which approximately 98.4% can be safely deleted.
  • The debugger service interruptions may be related to the Unified online development being unavailable, resulting in 502 or 504 errors.
     
Resolution:
  • For the IV service timeouts:
  • Run the cleanup jobs to reduce the data in the WHSInventReserve table. This process is expected to improve performance significantly.
  • Ensure that the cleanup job is scheduled to run during off-business hours and that the maximum execution time is set appropriately.
  • Test the cleanup job in a non-production environment before implementing it in production.
  • Monitor the system for any further occurrences of timeouts after the cleanup jobs have been executed.
  • For the debugger service issues:
  • Launch the debugger in Visual Studio and wait for a few minutes to see if the issue persists.
  • If the issue disappears, continue to monitor it for a couple of days to ensure it does not reoccur.
  • If the problem persists, further investigation may be required to identify any underlying issues.
If the issue continues or if there are any new developments, please escalate the case for further assistance.