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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Access denied to method processReport

(0) ShareShare
ReportReport
Posted on by 5,994

To understand this question please follow this thread 

https://community.dynamics.com/ax/f/33/t/108159

This explained solution in above thread works for me also.

"If the permission node under the design of the SSRS report seems OK, as Brandon explained, you can try to export and re-import the SSRS report by XPO. For us, it solved the problem (on AX2012 R2 CU7) without having to add any permission on roles or privileges.

Under the hood, we found out that re-importing the report (re)generate data in the ModelSecurityPermission table of the model database, especially the permissions links between the report and the tables that it uses, and the data provider class.

"

NOW MY PROBLEM AND MAIN QUESTION IS:

I am also facing same problem after CU13 upgrade. i applied the same fix on test, re-imported the xpo and it did the trick and worked. 

Now problem i can not do these same steps in Production. I can not delete or manually import XPO on prod. We have Build process in place and we always use Modelstore deployment.

Let me know if someone has some directions with build process. 

Should i do above steps on Build server, like delete/re-import the object on build server and then regenerate the build ?

Thanks for any help

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Ajit Profile Picture
    8,755 on at

    If that is the only way to resolve that weird problem then yes we can follow the same steps on build server. I did fixed couple of times on build server due to some other issues.

  • Douglas Noel Profile Picture
    3,905 on at

    Hi,

    to my opinion this seems to be the only way (take advantage of the internal 'side effects' which happen during import/reimport of such report - maybe this bound to other object types too - xpo's, (re)building the ModelSecurityPermission entries between all participating AddOnObjects) doing this on build using the fullmodelstore deployment.

    The main problem is, to have an 'algorithm' for detecting such 'we have to use a reimport workaround' issues.

    Potential candidates are all reports which are part of any model update hotfix, independent if it's a CU or a 'single' fix.

    During the import of the models the relevant part of rebuilding the MSP entries seems to be not done, as in opposite of the import through xpo's)

    Think this is the main problem.

    Some kind of axutil command, which could be launched against the modelstore database, even prod, would be ideal to 'fix' such things, but this won't happen.

    Something like axutil reFixMSPAsDoneThroughXPOImport would be a dream.

    Regards Douglas

  • Douglas Noel Profile Picture
    3,905 on at

    Hi,

    forgot to mention, that such things (can't check this anymore) maybe part of a axutil schema command, which should be executed   after, at least, binary fix to synch changed modelstore sql object structures (tables, funcs, procs), but I don't think so.

    Regards Douglas

  • San Artham Profile Picture
    3,175 on at

    Hello Friends

    any permanent fix for this ? In our AX 2012 instance this issue is expanding to more and more Reports since last couple of months.

    As a work-around we have been exporting and importing these Report objects XPOs in our Build env.

    Thank you

    San

  • Rene Volkmer Profile Picture
    326 on at

    anyone with any update please?

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…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Ali Zaidi Profile Picture

Ali Zaidi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans