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

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

SSRS report unable to rendered from AX 2009

(0) ShareShare
ReportReport
Posted on by 735

Hi Everyone,

I have gotten an assignment to modify SSRS report developed in AX 2009 (Business Logic). I have done minor modification (just changed the width of the columns and the orientation from portrait to landscape). In VS, in preview mode the report renders fine, but when I tried to open it from AX client it stays in “Loading” mode endlessly, it’s similar to when it’s trying to retrieve the data to long, but without any succeed. Below the screenshots from VS and from AX + properties of the MenuItem. I was trying to reload the AOS and SSRS, but without any effect, also I was trying to deploy the report from VS, but not succeed as well. AOS and SSRS are deployed on the same server.

Does anybody faced with such problem? Can you please suggest how to fix this?

AX

AX_5F00_small.jpg

*This post is locked for comments

I have the same question (0)
  • Ragoza Oleksandr Profile Picture
    735 on at
    RE: SSRS report unable to rendered from AX 2009

    Hi UMESH, Hi Faisal

    Thank you for you help.

    Oleksandr

  • Verified answer
    Faisal Fareed Profile Picture
    10,796 User Group Leader on at
    RE: SSRS report unable to rendered from AX 2009

    Hi Ragoza,

    You can search "ERROR" keyword in your log file and mostly the main cause of any error is pointed at the end of log files. I did a quick search here and found "ERROR: An exception has occurred in data set 'MainDataset'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'MainDataset'. ---> System.Threading.ThreadAbortException: Thread was being aborted."

    It seems there is something wrong with your dataset or query, if you revert your changes after taking a backup and see how it goes.

    You can also search few more errors in your log file as I suggested above.

  • Verified answer
    Umesh Pandit Profile Picture
    9,303 User Group Leader on at
    RE: SSRS report unable to rendered from AX 2009

    technet.microsoft.com/.../gg724094.aspx

  • Ragoza Oleksandr Profile Picture
    735 on at
    RE: SSRS report unable to rendered from AX 2009

    Hi Rik,

    thank you for quick response. I have checked this folder (in my case the path is: C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles) and found quite many txt.files there. For sure, this files related to my report (I was trying to find the name of the report in these txt files by using search), but due to the lack of experience I'm not able to read it properly. Can you suggest - how to define where the problem is? This what I have in my log file (this is a peace):

    <Header>

     <Product>Microsoft SQL Server Reporting Services Version 2009.0100.4290.00 ((KJ_SP2_QFE-CU).130805-1229 )</Product>

     <Locale>English (United States)</Locale>

     <TimeZone>FLE Daylight Time</TimeZone>

     <Path>C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\Logfiles\ReportServerService__06_17_2015_00_05_26.log</Path>

     <SystemName>AX0</SystemName>

     <OSName>Microsoft Windows NT 6.1.7601 Service Pack 1</OSName>

     <OSVersion>6.1.7601</OSVersion>

     <ProcessID>44872</ProcessID>

     <Virtualization>Hypervisor</Virtualization>

    </Header>

    <ProcessorArchitecture>AMD64</ProcessorArchitecture>

    <ApplicationArchitecture>AMD64</ApplicationArchitecture>

    ...

    appdomainmanager!DefaultDomain!a514!06/17/2015-09:58:12:: i INFO: Appdomain:6 ReportServer_MSSQLSERVER_0-3-130789978919472441 started.

    appdomainmanager!ReportServer_0-3!a514!06/17/2015-09:58:25:: i INFO: RS authentication mode is 4; effective ASP.NET authentication mode is Windows. vdir=/ReportServer.

    appdomainmanager!DefaultDomain!a514!06/17/2015-09:58:25:: i INFO: Appdomain:6 ReportServer_MSSQLSERVER_0-3-130789978919472441 initialized (#3).

    webserver!ReportServer_0-3!c078!06/17/2015-09:59:18:: i INFO: Reporting Web Server started

    webserver!ReportServer_0-3!a514!06/17/2015-09:59:18:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnhandledHttpApplicationException: , Microsoft.ReportingServices.Diagnostics.Utilities.UnhandledHttpApplicationException: The report server encountered an unhandled exception in HttpApplication. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerHttpRuntimeClientDisconnectionException: A client has disconnected from the Report Server Web service application domain ReportServer_MSSQLSERVER_0-3-130789978919472441. No corrective action is required. An error code has been submitted to ASP.NET to release the connection. The error code is 800708CA. ---> System.Runtime.InteropServices.COMException: This network connection does not exist. (Exception from HRESULT: 0x800708CA)

      --- End of inner exception stack trace ---;

    resourceutilities!ReportServer_0-3!c078!06/17/2015-09:59:18:: i INFO: Reporting Services starting SKU: Developer

    library!ReportServer_0-3!a514!06/17/2015-09:59:18:: i INFO: Catalog SQL Server Edition = Developer

    crypto!ReportServer_0-3!a514!06/17/2015-09:59:18:: i INFO: Initializing crypto as user: WIU\axsql_srs

    ...

    library!ReportServer_0-3!9720!06/17/2015-13:33:40:: w WARN: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. ---> System.Threading.ThreadAbortException: Thread was being aborted.

    webserver!ReportServer_0-3!9720!06/17/2015-13:33:40:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnhandledHttpApplicationException: , Microsoft.ReportingServices.Diagnostics.Utilities.UnhandledHttpApplicationException: The report server encountered an unhandled exception in HttpApplication. ---> System.Web.HttpException: Request timed out.

      --- End of inner exception stack trace ---;

    webserver!ReportServer_0-3!bef4!06/17/2015-13:33:55:: i INFO: Reporting Web Server stopped

    processing!ReportServer_0-3!c2fc!06/17/2015-13:33:55:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'MainDataset'. ---> System.Threading.ThreadAbortException: Thread was being aborted.

      at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)

      at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)

      at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

      at Microsoft.Dynamics.Framework.Reports.AxDataMethodExecuter.ResolveAndExecuteMethod(String typeAndMethodName, DataParameterCollection parameters)

      at Microsoft.Dynamics.Framework.Reports.AxDataMethodConnection.AxDataMethodCommand.OnExecuteReader(CommandBehavior behavior)

      at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.RunEmbeddedQuery(Boolean& readerExtensionsSupported, Boolean& readerFieldProperties, List`1 queryParams, Object[] paramValues)

      --- End of inner exception stack trace ---;

    processing!ReportServer_0-3!be18!06/17/2015-13:33:55:: e ERROR: An exception has occurred in data set 'MainDataset'. Details: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Query execution failed for dataset 'MainDataset'. ---> System.Threading.ThreadAbortException: Thread was being aborted.

    processing!ReportServer_0-3!be18!06/17/2015-13:33:55:: i INFO: Some other thread has already aborted processing.

    processing!ReportServer_0-3!c4d8!06/17/2015-13:33:55:: e ERROR: Data source 'AutoGen___BusinessLogic': An error has occurred. Details: System.Threading.ThreadAbortException: Thread was being aborted.

      at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.ProcessConcurrent(Object threadSet)

      at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.Process()

    processing!ReportServer_0-3!c2fc!06/17/2015-13:33:55:: e ERROR: Data source 'AutoGen___BusinessLogic': An error has occurred. Details: System.Threading.ThreadAbortException: Thread was being aborted.

      at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSet.ProcessConcurrent(Object threadSet)

      at Microsoft.ReportingServices.OnDemandProcessing.RuntimeDataSource.ProcessConcurrent(Object threadSet)

    processing!ReportServer_0-3!a2bc!06/17/2015-13:33:55:: i INFO: Some other thread has already aborted processing.

    processing!ReportServer_0-3!be18!06/17/2015-13:33:55:: i INFO: Some other thread has already aborted processing.

    processing!ReportServer_0-3!c094!06/17/2015-13:33:55:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: , Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. ---> System.Threading.ThreadAbortException: Thread was being aborted.

      at Microsoft.ReportingServices.OnDemandProcessing.OnDemandProcessingContext.CheckAndThrowIfAborted()

      at Microsoft.ReportingServices.OnDemandProcessing.RetrievalManager.FetchData(Boolean mergeTran)

      at Microsoft.ReportingServices.OnDemandProcessing.RetrievalManager.PrefetchData(ReportInstance reportInstance, ParameterInfoCollection parameters, Boolean mergeTran)

      at Microsoft.ReportingServices.OnDemandProcessing.Merge.FetchData(ReportInstance reportInstance, Boolean mergeTransaction)

      at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessOdpReport(Report report, OnDemandMetadata odpMetadataFromSnapshot, ProcessingContext pc, Boolean snapshotProcessing, Boolean reprocessSnapshot, Boolean processUserSortFilterEvent, Boolean processWithCachedData, ErrorContext errorContext, DateTime executionTime, StoreServerParameters storeServerParameters, GlobalIDOwnerCollection globalIDOwnerCollection, SortFilterEventInfoMap oldUserSortInformation, EventInformation newUserSortInformation, String oldUserSortEventSourceUniqueName, ExecutionLogContext executionLogContext, OnDemandProcessingContext& odpContext)

      at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension newRenderer, DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory metaDataChunkFactory, IChunkFactory yukonCompiledDefinition)

         --- End of inner exception stack trace ---;

    library!ReportServer_0-3!c094!06/17/2015-13:33:55:: w WARN: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing. ---> System.Threading.ThreadAbortException: Thread was being aborted.

    httpruntime!ReportServer_0-3!c094!06/17/2015-13:33:55:: e ERROR: Failed to process request, pipeline=0x4A1A240:

    rshost!rshost!c654!06/17/2015-13:33:56:: e ERROR: Failed to process request 0x80131014, pipeline=0x0000000004A1A320.

    appdomainmanager!DefaultDomain!b644!06/17/2015-13:34:00:: i INFO: Appdomain:6 ReportServer_MSSQLSERVER_0-3-130789978919472441 unregistered.

    rshost!rshost!b644!06/17/2015-13:34:00:: i INFO: Application domain type ReportServer statistics: created: 3, unloaded: 3, failed: 0, timed out: 0.

  • dekaasboer Profile Picture
    1,530 on at
    RE: SSRS report unable to rendered from AX 2009

    Do you see anything in the log of the reporting server or in the event viewer self? There might be something going wrong in the data connection when running the report from AX.

    c:\Program Files\Microsoft SQL Server\MSRS11.default\Reporting Services\LogFiles

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…

Mansi Soni – Community Spotlight

We are honored to recognize Mansi Soni as our August 2025 Community…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Syed Haris Shah Profile Picture

Syed Haris Shah 9

#2
Mea_ Profile Picture

Mea_ 4

#3
KP-31070522-0 Profile Picture

KP-31070522-0 3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans