AX2012 : Troubleshooting SSRS error "The socket connection has been disposed. Object name:\’System.ServiceModel.Channels.SocketConnection\’"

Written in

by

Rachit Garg

Hi Friends,

Recently we faced issue at one client using AX2012 FP CU4 , on running the below standard AX reports, we had no customizations in these reports and other reports in systems were running fine:

·        General Ledger > Reports >Project > Transaction >Ledger updates -Consumption report
·        General Ledger > Reports >Project > Transaction >Ledger updates – on-account transactions.

The reports were running fine when executing for shorter date ranges so we were having doubt that the report rendering was getting timed out due to large volume of data.

On searching in LCS, my doubt was confirmed as  I found resolution for the same error message, for customer ageing report, below is link:

https://fix.lcs.dynamics.com/Issue/Solution?bugId=3129125&qc=6948a944b173c583fdcf4eb33265edcd

We have to increase the default SSRS timeout configuration settings on the report server, server configuration and business connector configuration on the SSRS server. The below link from Dynamics AX BI team which has more details on how to do it:
http://blogs.msdn.com/b/dynamicsaxbi/archive/2013/02/14/how-to-addressing-ssrs-session-timeouts.aspx

If you are facing the same error then worth trying this out.  Have a great day.

Tags

Categories

Leave a comment

Wait, does the nav block sit on the footer for this theme? That's bold.

Brewing thought

Explore world of Microsoft Dynamics 365

Explore the style variations available. Go to Styles > Browse styles.