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) / Can't open a repor...
Microsoft Dynamics AX (Archived)

Can't open a report through report server

(0) ShareShare
ReportReport
Posted on by swetha desai 152

Hello All,

I created a simple SSRS report in D365 FO onebox environment, and ended up with the rsReportContextParametervalue cannot be null error when i run the report through report server. However, when i debug it and run it from VSTS, i can see the report opening up. 

When i checked the event viewer for some clue on the type of error when opening through report server url, i see that i have multiple  exceptions like

- An exception occurred during DB access execution 

- unexpected error occurred during RDCE process

I checked a number of blogs on this, where there are suggestions to rename the parameter and redploy. However in D365 FO, these system generated parameters cannot be renamed or deleted.

Any help around this is greatly appreciated

Thanks,

Swetha K Desai

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Amir Nazim Profile Picture
    Amir Nazim 5,994 on at

    refresh your metadata on report design or restart the reporting service (if it is dev box)

    looks like you have added some contract parms and later deleted that from your contract and Report design is not in sync.

  • swetha desai Profile Picture
    swetha desai 152 on at

    Amir,

    Thanks for the response.

    But, restarting reporting services did not work.

    How do i refresh the report design metadata? I am working on onebox D365 FO environment.

    Thanks,

    Swetha K Desai

  • swetha desai Profile Picture
    swetha desai 152 on at

    Sukrut,

    Tried it and it did not seem to work. The problem is none of my reports, be it query based or RDP based run through report server.

    Is this something to do with the execution account access to report server DB? I am not very sure what credentials should the permissions in SQL Reporting DB be given to?

    I am working on onebox environment for D365 finance and operations. Any suggestions around it?

    Thanks,

    Swetha K Desai

  • swetha desai Profile Picture
    swetha desai 152 on at

    Sukrut,

    My application version is 1611 - platform update 10.

    Thanks,

    Swetha K Desai

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
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Scott_itD Profile Picture

Scott_itD 2 Community Manager

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans