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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Abnormal action in my ...
Microsoft Dynamics AX (Archived)

Abnormal action in my environment

(0) ShareShare
ReportReport
Posted on by Ahmed Issa 249

Hello everybody,

At the beginning will describe the structure of my environment, it consists of two DB Machine in always on availability group and has two  AOS on two different machines.  One of them is a service business logic for clients and the other works as a batch server, also it hosts Reporting Service like shown in the image below. 

Environment-Structure.png

Today there are some abnormal problems that I can't understand. Any Temp table which is used by any RDP class I cannot view its data when the type is changed to regular. I want to view the data for tracing purposes because most of the reports that use them do not get correct data. The reports are showing cached data I comment insert code in RDP class and the report still shown data. I concluded that by commenting the insert code in the RDP class and the report still shows the same data.

We already tried full CIL Compile, sync the Data Dictionary, Restart AOS service, and RS service but it didn't solve the problem.

Eventually, a friend told me to export XPO of report project and delete all of the project components and delete the SSRS Report from Report folder in RS Manager and restart AOS and RS services then import the project and deploy the report again. The report displays correct data after this cycle for two days but still can't view Temp table content when changed to regular. Now the report is not showing correct data again. I can't understand where is the problem or how to solve it.

 Note all of these reports were working fine before.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    I am having the same problem with RDP reports. When the report was developed it was working fine. Then I modified the code in the processReport method but the changes are not reflected in the report. I checked my code a couple of times and every thing seems to be ok. I also tried commenting the entire code like you, still the report is showing data. 

    Some how the process code of RDP is cached somewhere. Did you find any other solution?

  • Verified answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    First of all, you are not supposed to make any changes to a Production environment directly. You should be troubleshooting it in a copy of your Prod environment such as Quality Assurance, Staging, or Test system. Doing changes directly in AOT in Production can disrupt the business, cause AOS crashes, invalidate user cache files in the Windows user profile for current AX AOT sessions, and a lot more problems.

    And about the issue, it is not a good approach and will not show you the correct results necessarily if you change the table type from temporary to regular, since the AX SRS reporting engine has a cleanup routine executing anyway which removes data based on the transaction identifier once the report execution is finished. If you do have data in those tables, it has to be truncated, since there is nothing supposed to be there if there are no reports currently running.

    The reliable way to test this is if you have a look at the query or code executing for fetching the data during the processing, you could do this in a job for example.

    Alternatively you could use the SQL Query Profiler tool to capture data collection, and see what query statements are executing. Then validate it manually if that is matching with the expected results on what shall be included in the report. If not, you most likely have done changes to your metadata, which is not reflected on the reporting datasource. In that case you need to refresh the SSRS report datasource in Visual Studio, delete the report from the reporting folder, and redeploy indeed.

  • Ahmed Issa Profile Picture
    Ahmed Issa 249 on at

    Hi Vilmos,

    Thanks for your prompt replay.

    I know changing Temp to regular is not the best practice. it was just an attempt to look at the data.

    Currently, the situation is as follows :

    1- TempTable type is TempDB

    2-The RDP class has no code in process report and has no query as a parameter.

    3-Refreshed data source in VS and redeployed the report.

    4- Restart RS Services.

    but the report still showing data. The expected result is an empty report.

    Regards.

  • Suggested answer
    Vilmos Kintera Profile Picture
    Vilmos Kintera 46,149 on at

    Again, you need to look at the debugger / AX Trace parser capture / SQL Profiler query capture to see how does it fetch the data, from which you could make assumptions for the cause of the problem.

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…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans