SAP crystal reports Load report failed error after deploying

Posted by Sampath1750 under C# on 7/8/2013 | Points: 10 | Views : 9481 | Status : [Member] | Replies : 5
Hi all,

My application is running in production which developed in Asp.net 4.0 and reports are in crystal Report 13. the back end is sql server 2008, i am constanly facing the problem that 'Load Report Failed'. Once i restart the IIS website, the problem is rectified. we are unable to identify whether this problem due to application bug or missing configuration in any IIS setting. Could any one help us to reslove this problem?

i searched in google, i got below sollution, but problem not fixed.
click run -> regedit ->
HKEY_LOCAL_MACHINE\SOFTWARE\SAP BUSINESSOBJECTS\CRYSTAL REPORTS FOR .NET FRAMEWORK 4.0\REPORT APPLICATION SERVER\IN PROC SERVER\PrintJobLimit changed 75 to -1.

Thanks




Responses

Posted by: Vuyiswamb on: 7/8/2013 [Member] [MVP] [Administrator] NotApplicable | Points: 25

Up
0
Down
i think you still did not find the root of your Problem, please check the "Application" log in the Event Log , you might find the real issue there.


Thank you for posting at Dotnetfunda
[Administrator]

Sampath1750, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sampath1750 on: 7/8/2013 [Member] Starter | Points: 25

Up
0
Down
I got Loading report failed issue in Log file.
after restart the iis, problem is fixed

Sampath1750, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 7/8/2013 [Member] [MVP] [Administrator] NotApplicable | Points: 25

Up
0
Down
please post what you see in your log file make sure you remove sensitive issue is there are any.

Thank you for posting at Dotnetfunda
[Administrator]

Sampath1750, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sampath1750 on: 7/8/2013 [Member] Starter | Points: 25

Up
0
Down
some times Loading report failed, some times database logon failed issue.

Sampath1750, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vaibhavbrahme on: 7/9/2013 [Member] Starter | Points: 25

Up
0
Down
Check your sql query, is it working properly or not.
or try this code i m usng to extract the crystal report
SqlConnection cn;
SqlDataAdapter da;
DataSet ds=new DataSet();
protected void Page_Load(object sender, EventArgs e)
{
cn = new SqlConnection(ConfigurationManager.ConnectionStrings["con1"].ToString());
if (!IsPostBack)
{

ReportDocument rep = new ReportDocument();
rep.Load(Server.MapPath("CrystalReport.rpt"));
rep.SetDatabaseLogon("sa", "sql");
CrystalReportViewer1.ReportSource = rep;
CrystalReportViewer1.RefreshReport();
}


Sampath1750, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response