Crystal Report FAQ Error and Fixes

CrystalReports

Crystal Report

Versions:

CrystalReports.com
CrystalReports.com/download/
Crystal Reports, Developer for Visual Studio Downloads

Common Errors

for runtime version: 13.0.22.2668


Error: Failed to load database information.

Details:

Error in File rpt*** 17596_15752_{FC2EA1BF-082D-4345-947E-BE235A441BFD}.rpt: Failed to load database information.

Details:

System.Web.HttpExceptionThe file '/gsk/Reports/HRM/Viewer/CrystalImageHandler.aspx' does not exist.

System.Web.HttpException (0x80004005): The file '/gsk/Reports/HRM/Viewer/CrystalImageHandler.aspx' does not exist.
   at System.Web.UI.Util.CheckVirtualFileExists(VirtualPath virtualPath)
   at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
   at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
   at System.Web.Compilation.BuildManager.GetVirtualPathObjectFactory(VirtualPath virtualPath, HttpContext context, Boolean allowCrossApp, Boolean throwIfNotFound)
   at System.Web.Compilation.BuildManager.CreateInstanceFromVirtualPath(VirtualPath virtualPath, Type requiredBaseType, HttpContext context, Boolean allowCrossApp)
   at System.Web.UI.PageHandlerFactory.GetHandlerHelper(HttpContext context, String requestType, VirtualPath virtualPath, String physicalPath)
   at System.Web.UI.PageHandlerFactory.GetHandler(HttpContext context, String requestType, String virtualPath, String path)
   at System.Web.HttpApplication.MaterializeHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Solution:

Open IIS Manager >> Select the Application Pool >> right click >> Advanced Settings… set Properties:

Enable 32-bit application: True

in some previous solutions it was also suggested to set, which is not required for this version

Managed Pipeline Mode: Classic


Error: Load report failed.

Details:

ScriptResource.axd?d=dwY9oWetJoJoVpgL6Zq8OLw4JJKyc_g6cmP3C6_IFzKj7ce38k5vHXQLEjlHCAV1KAQEF7AxEEKJj_OmoMAnFcEa-QW8KkIz-eFkuxf2_0vwJ5Ma5QT33ucaggVr2LP-pfuZFObs4VS19ZaG2pINCKEPYLXe-h2O9wLfX2cCA8E1&t=ffffffff9a9577e8:5 Uncaught Sys.WebForms.PageRequestManagerServerErrorException: Sys.WebForms.PageRequestManagerServerErrorException: Load report failed.
    at Function.Error.create (http://localhost/gsk/ScriptResource.axd?d=NJmAwtEo3Ipnlaxl6CMhvpGWnaSegNDTQAncPVSJDNDLj1OLpzAX_FYDLdG1YlsayalcHRCGWNiHD5csDhGoCjn4P0YMlI9VaRONlnqj9MlMs2ik2WqOBZBkuaNk4Eegty1miXm2SZHxETxUtBxMS3WHwesaZ-Q0ilYGcsjVnQ41&t=ffffffff9a9577e8:5:2736)
    at Sys.WebForms.PageRequestManager._createPageRequestManagerServerError (http://localhost/gsk/ScriptResource.axd?d=dwY9oWetJoJoVpgL6Zq8OLw4JJKyc_g6cmP3C6_IFzKj7ce38k5vHXQLEjlHCAV1KAQEF7AxEEKJj_OmoMAnFcEa-QW8KkIz-eFkuxf2_0vwJ5Ma5QT33ucaggVr2LP-pfuZFObs4VS19ZaG2pINCKEPYLXe-h2O9wLfX2cCA8E1&t=ffffffff9a9577e8:5:11490)
    at Sys.WebForms.PageRequestManager._parseDelta (http://localhost/gsk/ScriptResource.axd?d=dwY9oWetJoJoVpgL6Zq8OLw4JJKyc_g6cmP3C6_IFzKj7ce38k5vHXQLEjlHCAV1KAQEF7AxEEKJj_OmoMAnFcEa-QW8KkIz-eFkuxf2_0vwJ5Ma5QT33ucaggVr2LP-pfuZFObs4VS19ZaG2pINCKEPYLXe-h2O9wLfX2cCA8E1&t=ffffffff9a9577e8:5:29608)
    at Sys.WebForms.PageRequestManager._onFormSubmitCompleted (http://localhost/gsk/ScriptResource.axd?d=dwY9oWetJoJoVpgL6Zq8OLw4JJKyc_g6cmP3C6_IFzKj7ce38k5vHXQLEjlHCAV1KAQEF7AxEEKJj_OmoMAnFcEa-QW8KkIz-eFkuxf2_0vwJ5Ma5QT33ucaggVr2LP-pfuZFObs4VS19ZaG2pINCKEPYLXe-h2O9wLfX2cCA8E1&t=ffffffff9a9577e8:5:25637)
    at Array.<anonymous> (http://localhost/gsk/ScriptResource.axd?d=NJmA...

Reason:

Crystal Report files are not present in the target location, which might have left-out during build and publishing application

Solution:

Open Visual Studio, select all the CrystalReport.rpt files, right click to set Properties"

Build Action: Content (can also be Embedded Resource)
CopyToOutputDirectory: Always (can also be Copy if Newer)


Error: Validation of 0viewstate MAC failed

Details:

Sys.WebForms.PageRequestManagerServerErrorException: Sys.WebForms.PageRequestManagerServerErrorException: Validation of 0viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that <machineKey> configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster.

Solution:

Run following commands:

cd /d %windir%\Microsoft.NET\Framework64\v4.0.30319
cd /d %windir%\Microsoft.NET\Framework\v4.0.30319
aspnet_regiis -ga "IIS APPPOOL\DefaultAppPool"

Ref: https://support.microsoft.com/en-us/help/2915218/resolving-view-state-message-authentication-code-mac-errors


Error: Cannot resolve the collation conflict between “Latin1_General_CI_AS”

Message:

System.Data.SqlClient.SqlException
Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation.

Details:

System.Web.HttpUnhandledException (0x80004005): Exception of type 'System.Web.HttpUnhandledException' was thrown. ---> System.Data.SqlClient.SqlException (0x80131904): Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation.
   at HR3PLO_GSK.DAL.PPP.ReportsDAL.getMontlyHeadCountData(String year) in E:\Ismail\GitLab\HR3PLO_GSK\src\HR3PLO_GSK.DAL\PPP\ReportsDAL.cs:line 809
   at HR3PLO_GSK.Web.Reports.PPP.Viewer.rptMonthlyHeadCount.ShowReport(String year) in E:\Ismail\GitLab\HR3PLO_GSK\src\HR3PLO_GSK.WebApp\Reports\PPP\Viewer\rptMonthlyHeadCount.aspx.cs:line 36
   at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
   at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
ClientConnectionId:bb052ba2-5fec-4f05-8024-288e5926b29b
Error Number:468,State:9,Class:16
   at System.Web.UI.Page.HandleError(Exception e)
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   at System.Web.UI.Page.ProcessRequest()
   at System.Web.UI.Page.ProcessRequest(HttpContext context)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Cause:

This issue occurs because the collations of the catalog databases for Azure SQL Database differ from the collations of the replication databases at the publisher and the subscriber.

Solution:

This issue is fixed in the following updates:

Ref: https://support.microsoft.com/en-us/help/3131443/fix-cannot-resolve-the-collation-conflict-error-when-you-apply-a-snaps

Also check the “Collation” between database server and instance are same, which is mostly SQL_Latin1_General_CP1_CI_AS

Comments

Popular posts from this blog

Sql Server Script Generator

Stored Procedure to prevent sql injection with optional parameters and server side Paging and Sorting

MS Sql Server Local DB