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)

No data found in second SSRS report instance

(0) ShareShare
ReportReport
Posted on by 2,699

Hi,

I have setup a UAT environment for testing, which is a clone of our LIVE environment.

The AOS instance for live is 01 and the UAT instance is 02 - these both reside on the same physical AOS server.

I have two different SQL reporting server instances - both on different physical servers.

I have followed all the steps from the MSDN webpage about setting up multiple SSRS instances but it is still not working.

I have created a new Report server configuration in my UAT environment - when I click on Validate it is successful.

I have managed to deploy all the reports out to the correct folder and as far as I can see the permissions in the reportmanager section of SSRS are all correct.

The SSRS service logon account is the same as my BC account.

I have changed all the config files in reportmanager and reportserver folders as per documentation.

Now when I run the report - it loads fine but it is as if no data is being passed from the temp tables and or SQL query into the SSRS report - it comes up with a blank shell.

This is probably something simple but I have spent all day on this and would welcome suggestions other than a reposting of the microsoft article.

*This post is locked for comments

I have the same question (0)
  • Kauto Profile Picture
    2,699 on at

    Does anyone have any ideas on this - the reports are generating fine, but no data is coming out with the report?

  • Kauto Profile Picture
    2,699 on at

    In the log of the new SSRS instance - when I run the report I get the following error if this helps:  

    extensionfactory!ReportServer_0-5!4f90!03/24/2015-09:00:31:: e ERROR: Exception caught instantiating TERADATA report server extension: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Teradata.Client.Provider, Version=12.0.0.0, Culture=neutral, PublicKeyToken=76b417ee2e04956c' or one of its dependencies. The system cannot find the file specified.

    File name: 'Teradata.Client.Provider, Version=12.0.0.0, Culture=neutral, PublicKeyToken=76b417ee2e04956c'

  • Verified answer
    Kauto Profile Picture
    2,699 on at

    It would appear I have a resolution to this - the issue appeared to lie in the need to CREATE A NEW AX CONFIGURATION and then export this into the bin folder of the SSRS instance - a restart of SSRS and then no issue reports sending data correctly.

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
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