Article

From the AX Blogs: Fix a Common SSRS Report Deployment Error; ‘SQL Sentry’ Tool for Database Performance Monitoring; Multiple Models per Layer in AX6

by Jared Berezin
,

How to Fix a Common SSRS Report Deployment Issue: Brandon George: "If you have deployed the SSRS [SQL Server Reporting Services] Report Lib.'s from Dynamics AX 2009 before, you might have ran into some timeout issues... An error message, sometimes with great detail will show up during the Reports Deployment process... Basically the thread trying to do the deploy is timing out writing to the Report Server. Most likely the cause is related to the amount of language files / cultures that are trying to be deployed for the given ReportLib. A simple change can be done to help fix this issue:

  1. Open the AOT
  2. Expand Data Dictionary > Tables > LanguageTable > Fields
  3. Right click on the 'LabelFile' field and choose properties
  4. Change the Visible property to 'Yes'
  5. Save the change
  6. Right click on the LanguageTable and choose Open
  7. In the table, uncheck the Label file field for any languages that are not needed
  8. Deploy the ReportLibs again that were having issues

‘SQL Sentry' May Have Merit for Monitoring Database Performance: DaxGuy provides his initial impression with screenshots: "Recently I was investigating some DB related issue by using SQL Native tools like DMV's, Activity Monitor, DTA etc and also looking for some other utilities which would provide some ...

FREE Membership Required to View Full Content:

Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here

Get full access
Dynamics AX
About Jared Berezin
Jared Berezin serves as a contributing writer to MSDynamicsWorld.com. With combined interests in technology and science, Jared previously served as a writer for Dana-Farber Cancer Institute, drafting scientific narrative reports on the latest advancements in cancer research. Jared has also served as associate marketing specialist for International Data Corporation (IDC), a market research firm. In this position, he planned and executed strategic marketing initiatives for IDC's software and services research programs, and wrote outbound communications to the press, existing clients, and prospects. Jared also has experience working for several local newspapers in eastern Massachusetts. Jared graduated with honors from Colby College with a BA in English and creative writing.
More about Jared Berezin