Applies to Product - Dynamics 365 Finance
What’s happening?
The customer reported an issue where a batch job encountered an error after running for an extended period. The error message indicated that an error occurred while starting a TTS transaction.
Reason:
The investigation revealed that a temporary issue occurred with TempDB due to a high volume of processing that utilized TempDB, which led to interruptions in the execution of queries running at that time.
Resolution:
- Review the server logs to identify any long-running queries or processes that may have contributed to the issue.
- Check for any external environmental factors that could have caused errors or locks during the execution of the batch job.
- If applicable, analyze the specific queries that were running during the time of the error, particularly those that involved TempDB usage.
- For further assistance, refer to the documentation on troubleshooting batch failures and identifying the owner of a class being executed by a batch task.
- Batch Landing Page TSG - Batch - TSG Landing Page