dhimenvora
Posts:7
 |
| 11/01/2011 11:19 |
|
I have created a DNN site and have used the report viewer from module master and have also configured properly.
Then I have added a report module in my page and I was able to see the parameters entry page for the reports and then I have made entry in the parameter and click on the view report and I have found the below error
"The underlying connection was closed: An unexpected error occurred on a receive.
Unable to read data from the transport connection: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond.
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond"
Can any one help me to resolve this issue
|
|
|
|
|
host
Posts:502
|
| 11/01/2011 11:26 |
|
Hello dhimenvora, do you see this with all reports or just this one particular report. It sounds to me like a report data source issue rather than an issue with the module. Can you create a simple report that just shows textbox with some value (e.g. the current date), then deploy it and view it from the module. If that works, the module is working fine and the issue is with your report.
One other thing to check, in the web.config, in the appSettings, the module does use the SiteSqlServer property from there, so please make sure your connection there for your DNN SQL Server is specified, sometimes people forget to have this value set. I don't think that is your issue here, but it is good to check. |
|
|
|
|
dhimenvora
Posts:7
|
| 11/01/2011 12:15 |
|
Hi There,
Thanks for quick reply
I have tried to show the simple report with just date and this also thrown me same issue
now can you please help for next.
Thanks
Dhimen Vora |
|
|
|
|
host
Posts:502
|
| 11/01/2011 12:27 |
|
| Fair enough, the next likely issue would be the connectiontimeout property in IIS for this site. By default in IIS 6 it is set to 2 minutes. Please check this. |
|
|
|
|
dhimenvora
Posts:7
|
| 11/01/2011 14:29 |
|
Hi There,
I have tried to add extra timeout but the issue is same
Is there any functionality to give time out between DNN to sql reporting service in reporting module and yes my reports are working fine at the reporting service url.
Thanks
Dhimen Vora |
|
|
|
|
host
Posts:502
|
| 11/01/2011 14:40 |
|
| There is none that I am aware of. Are you using whitespace compression on your portal? Is caching disabled in the module general settings? From the web server, (e.g. RDP into the web machine or from the console), can you access the reportserver and execute a report that way? I understand client machines may have no issues, but please do this from your web server to verify connectivity is fine from web server to report server. What version of DNN, IIS and the module are you using? |
|
|
|
|
dhimenvora
Posts:7
|
| 11/01/2011 14:47 |
|
I am using DNN community edition, IIS 7 and sql server repoting service 2008
And yes I am able to RDP to my server machines
can you please give me steps what I need to do as I have compared white space for the report parameter from DNN and also when I have checked the same in reporting service that was working
Can you please provide me steps? |
|
|
|
|
host
Posts:502
|
| 11/01/2011 15:00 |
|
| Are you using a proxy server of any sort on the web server? |
|
|
|
|
host
Posts:502
|
| 11/01/2011 15:01 |
|
| Also, can you please check the reporting services log files: http://msdn.microsoft.com/en-us/library/ms157403.aspx |
|
|
|
|
host
Posts:502
|
| 11/01/2011 15:03 |
|
| And on the web server (and client machine you are using) do you have AVG 8 installed or other antivirus? I have read that there are reports of this type of error with AVG 8 and SSRS. |
|
|
|
|
dhimenvora
Posts:7
|
| 11/02/2011 04:16 |
|
Hi there,
Have checked in the server there is not any Antivirus installed.
I have check the log file but I am not able to get entry of reports when I go through DNN application.
I am not using a proxy server of any sort on the web server.
Thanks
Dhimen Vora |
|
|
|
|
host
Posts:502
|
| 11/02/2011 08:52 |
|
| At this point I still think it is an issue specific to your environment, specifically with the communication between the web server and the report server. I have sent a request through skype so that we can connect there and do a teamviewer session to check this out sometime. I'd like to test connecting to my report server from your DNN instance to confirm my theories. |
|
|
|
|
dhimenvora
Posts:7
|
| 11/02/2011 08:59 |
|
Hey there,
You can add me on skype
My Skype ID is : dhimenv_Clarion
Thanks |
|
|
|
|
dhimenvora
Posts:7
|
| 11/02/2011 09:07 |
|
Thanks Ben for your precious time but I have found the solution for this
I was adding the Domain Name in the server setting in Module Manager but that was confliting so have removed that Domain Name and put that as blank and now this is working perfectlly.
Thanks
Dhimen Vora |
|
|
|
|