Crsytal Reports are not working in IIS with NFS sharing

[Former Member]

Dears,

Can anyone please help me in resolving the crystal report issue, as we are facing some challenges to run the reports when we come through the IIS.

1) our set up is high available environment such as 4 VM servers including the IIS running on the same machines(number 4 IIS servers) and top it we have F5 load balancer to distribute the load.

2) And about FRS(file repository system) , our windows team has created NFS ,but unfortunately when we access through IIS, the reports are not working at all.Though we can run the reports directly through the Crystal reports console(excluding the IIS)

3) Alternately, we planned to go with local folder & shared the same among the 4 servers & when we checked , we can generate the reports through the IIS & with local file sharing.

In short, we cannot run the reports through the IIS + NFS sharing..

It would be great help for me, if you could look into our config file for any wrong configuration..

<?xml version="1.0" encoding="UTF-8"?>

<!--

Note: As an alternative to hand editing this file you can use the

web admin tool to configure settings for your application. Use

the Website->Asp.Net Configuration option in Visual Studio.

A full list of settings and comments can be found in

machine.config.comments usually located in

\Windows\Microsoft.Net\Framework\v2.x\Config

-->

<configuration>

<configSections>

<sectionGroup name="businessObjects">

<sectionGroup name="crystalReports">

<section name="crystalReportViewer" type="System.Configuration.NameValueSectionHandler" />

</sectionGroup>

</sectionGroup>

</configSections>

<businessObjects>

<crystalReports>

<crystalReportViewer>

<add key="resourceURI" value="../crystalreportviewers" />

</crystalReportViewer>

</crystalReports>

</businessObjects>

<appSettings>

<add key="CrystalImageCleaner-AutoStart" value="true" />

<add key="CrystalImageCleaner-Sleep" value="60000" />

<add key="CrystalImageCleaner-Age" value="120000" />

<!-- Ener the Crystal Report Server 2013 host name or ip address-->

<add key="serverName" value="xx.xx.xxx.xx" />

<!--Enter the user name for logging in to Crystal Report Server 2013.-->

<add key="userName" value="administrator" />

<!--Enter the password for logging in to Crystal Report Server 2013.-->

<add key="userPassword" value="xxxxxxx" />

<!--Enter the user name for logging in to database server-->

<add key="DBUserID" value="xxxxxx" />

<!--Enter the password for logging in to database.-->

<add key="DBPassword" value="xxxxxxxx" />

<add key="ResfulWebServiceUrl" value="http://VIPhostname:6405/biprws" />

<add key="OpenDocumentUrl" value="http://VIPhostname:8080/BOE/OpenDocument/opendoc/openDocument.jsp?" />

</appSettings>

<connectionStrings />

<system.web>

<!--

Set compilation debug="true" to insert debugging

symbols into the compiled page. Because this

affects performance, set this value to true only

during development.

-->

<compilation debug="true">

<assemblies>

<add assembly="CrystalDecisions.Enterprise.Viewing.ReportSource, Version=14.0.3500.0, Culture=neutral,

PublicKeyToken=692fbea5521e1304" />

<add assembly="CrystalDecisions.CrystalReports.TemplateEngine, Version=14.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304"

/>

<add assembly="CrystalDecisions.Enterprise.Framework, Version=14.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" />

<add assembly="CrystalDecisions.Enterprise.InfoStore, Version=14.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" />

<add assembly="CrystalDecisions.CrystalReports.Engine, Version=14.0.3500.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304" />

<add assembly="CrystalDecisions.ReportAppServer.ObjectFactory, Version=14.0.3500.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"

/>

<add assembly="CrystalDecisions.ReportAppServer.Controllers, Version=14.0.3500.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"

/>

<add assembly="CrystalDecisions.ReportAppServer.ClientDoc, Version=14.0.3500.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304" />

<add assembly="CrystalDecisions.ReportAppServer.ReportDefModel, Version=14.0.3500.0, Culture=neutral,

PublicKeyToken=692FBEA5521E1304" />

<add assembly="CrystalDecisions.ReportAppServer.CommonObjectModel, Version=14.0.3500.0, Culture=neutral,

PublicKeyToken=692FBEA5521E1304" />

<add assembly="CrystalDecisions.ReportAppServer.DataDefModel, Version=14.0.3500.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"

/>

<add assembly="CrystalDecisions.ReportSource, Version=14.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" />

<add assembly="CrystalDecisions.Shared, Version=14.0.3500.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304" />

<add assembly="CrystalDecisions.Web, Version=14.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" />

<add assembly="CrystalDecisions.ReportAppServer.XmlSerialize, Version=14.0.3500.0, Culture=neutral, PublicKeyToken=692FBEA5521E1304"

/>

</assemblies>

</compilation>

<!--

The <authentication> section enables configuration

of the security authentication mode used by

ASP.NET to identify an incoming user.

-->

<authentication mode="Windows" />

<!--

The <customErrors> section enables configuration

of what to do if/when an unhandled error occurs

during the execution of a request. Specifically,

it enables developers to configure html error pages

to be displayed in place of a error stack trace.

<customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">

<error statusCode="403" redirect="NoAccess.htm" />

<error statusCode="404" redirect="FileNotFound.htm" />

</customErrors>

-->

<httpHandlers>

<add verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web,

Version=14.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" />

</httpHandlers>

<pages />

<customErrors mode="Off" />

<identity impersonate="true" />

</system.web>

<system.webServer>

<handlers>

<add name="CrystalImageHandler.aspx_GET" verb="GET" path="CrystalImageHandler.aspx" type="CrystalDecisions.Web.CrystalImageHandler,

CrystalDecisions.Web, Version=14.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" preCondition="integratedMode" />

</handlers>

<validation validateIntegratedModeConfiguration="false" />

</system.webServer>

</configuration>

Thanks in advance..

[former_member11696]

Hi Pramod,

Load Balancers MUST use Sticky Sessions for CR to work properly so the report session stays on one Server.

Check the Load Balancer help file on how to enable that feature.

Don