Share
Report
265Hi everyone,
We have an issue in our AX 2012 R3 CU9 PROD environment where out of the box reports (no modifications) will sporadically start to show as null or miss values. There are no filters or anything that would prevent the reports from running.
1. Expense Report (Blank)
2. Per Diem Per Employee (Blank)
3. Base Data > Projects (Blank)
4. General Journal entry (Missing 'Approved by')
They will work fine for days or weeks, then randomly will just start to miss data. The ONLY thing we have been able to do to correct is to bring down all AOS' and bring them back up, this will clear the issue. We are trying to find the source of the problem or find a way to resolve this mid-day without bringing down all of the services. We have tried:
1. Running cache clear on all AOS'
2. Restarting the SSRS service/server
3. Running a clear cache job provided by MS
4. Re-deploying the report
We have tried engaging Microsoft and in the traces it looks like the query is becoming corrupted somehow. They are having trouble narrowing down the problem because we only see this in our PROD instance, not in test. It also happens so sporadically and we can't have these reports down for long so we can only troubleshoot in PROD.
*This post is locked for comments
All responses (
Answers (
