Hi Friends,

I have a report where i have to display student photo which is coming from the database field.when i run the report with that image it is giving below error 

after googling i found one suggestion to restart the 'Net.Pipe Listener Adapter' in local machine,but it requires a restart for couple of times and have to close the ssrs solution.If i rerun the report it works for some time and the above mentioned issue is reoccurring.did any one came across this problem or any suggestions are appreciated.

Thanks,

Sam

Please check for the hotfix,

http://support.microsoft.com/kb/2536401

http://support.microsoft.com/kb/2504602

Can you tell where images are stored? Is it in a fileserver? Also please post exact error message you got if possible.

Hi Visakh16,

Image path is saved in the database.I have shared the error and database query in my post.Please find it again.

Error:

Please suggest me some solution.

Thanks,

sam

Hi Ch. Rajen Singh,

As per my understanding the above error is related to preview processing.Can i apply the hot fixes suggested by you to solve this issue.If both are same then i will proceed further.

Please confirm.

Thanks,

Sam

Hi Samhith,

I have tested on my local environment and can't reproduce the issue, please check and test as below to provide us more details information due to this error message:

1. Did you get the same issue when you don't insert the image from the DB?
   Please close the designer and reopen to design an new report the same as this one to see if the issue persist
2. Please try to design the same report in report builder to see if you will get the same issue
3. Please deploy the report to report server to have a test.

If the restart of the designer and the recreate of the report didn't help, this error may relatted to the WCF, please try to add below code in the web.config file in the path like:
C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer
C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportManager

<behaviors>
 <endpointBehaviors>
   <behavior name="ServiceBehavior">
     <dataContractSerializer maxItemsInObjectGraph="2147483647"/>   
   </behavior>
 </endpointBehaviors>
</behaviors>

If you still have any problem, please feel free to ask.

Regards,
Vicky Liu

Hi Vicky Liu,

I will follow your suggestions & will let u know.

Thanks for your valuable time,

Sam.

Hi Visakh16,

Image path is saved in the database.I have shared the error and database query in my post.Please find it again.

Error:

Please suggest me some solution.

Thanks,

sam

Whats the datatype of photo field in the database?

The error message looks very generic and doesnt help much

see if this helps

http://stackoverflow.com/questions/16173835/wcf-error-the-server-did-not-provide-a-meaningful-reply

Hi Visakh,

photo field datatype is Varbinary and i still have the problem.It is not giving the error for the first run but giving after running the report for couple of times.After that giving error for other reports also which does not contain any photo related tables or fields.

Thanks,

Sam