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

Post a Comment

Popular posts from this blog

Export DataTable or DataSet to CSV or XML

-
using System ; using System.Collections.Generic ; using System.Configuration ; using System.Data ; using System.Data.SqlClient ; using System.IO ; using System.Linq ; using System.Text ; using System.Web ; using System.Web.UI ; using System.Web.UI.WebControls ; using System.Xml.Serialization ; public partial class ExportReservationInfo : System . Web . UI . Page { #region Events protected void Page_Load ( object sender , EventArgs e ) { lblMsg . Text = "" ; if ( Page . IsPostBack ) { } } protected void btnExportToCSV_Click ( object sender , EventArgs e ) { string strReservationId = txtReservationId . Text . Trim (); DataSet ds ; try { int ReservationId = Convert . ToInt32 ( strReservationId ); ds = ExecuteQuery ( ReservationId ); //Export to CSV ExportToSpr...
Read more

Linux Command ref

-
Basic Operational Commands: Show users logged in: $who $who am i To list the files/Directories: $ls $ls -l Navigate to a location GoTo root directory: $cd / GoTo /home/oracle directory $cd /home/oracle GoTo 1 level up $cd .. To Concatenate files and print on the standard output $cat System Admin Commands : Show System info: $uname $uname -r Show kernel info $cat /etc/issue To determine available RAM and Swap space: $free To determine the Physical RAM size: $grep MemTotal /proc/meminfo To determine the size of configured Swap space: $grep SwapTotal /proc/meminfo To determine available disk space: $df -k $df -k /tmp $df -k /u01 To mount a PenDrive Insert pen drive into USB device, To mount pen drive use mout command. Find out device name using $fdisk –l You may see /dev/sda as pen drive and /dev/sda1 as partition. Now create directory in /mnt $mkdir -p /mnt/usbpen Mount pen $mount /dev/sda1 /mnt/usbpen
Read more