We are using AX 2012 R3 CU9. We have 2 AOS Servers & one of them is main AOS server where users connect & 2nd is a batch server. All the batch jobs are working fine on the server, except the sales invoice posting job. We are using the standard utility to post invoices. Since last few days, the job gets stuck at 99.2% during execution and never completes executing. We have to cancel & we rerun it & same issue happens. We tried to reschedule a new job & faced the same issue. Is there a particular reason why all jobs are working except this one?
Update: We found that the job completed after 2.5 hours after we changed the batch thread count to 20. It takes around 10 seconds for the job to go from 0% to 99.2%. Is there a way to get it to complete faster? It took this much time to post 5 invoices.
Do indexing respective tables, and use trace it might help you https://anithasantosh.wordpress.com/2017/02/27/trace-parser-ax2012/.
Hi Otis, we perform indexing daily. The issue is resolved on production environment but it is still occurring on DEV Server. To resolve on PROD, we restarted all AOS (starting with AOS1 & then batch AOS), then performed full CIL on all.
On DEV server, it doesn't complete even after a day.
Aos and batch server restart is not a permanent solution. Pls check the code if you could able to optimize queries or bp deviation ,,etc.