Crystal Report Load Report Failed

i put our code on our windows server 2003  , IIS6
the crystal report works couple of times and the we have the error load report failed

olease see attached image


here is the code

 private void LoadLibrary()
    {
        try
        {
             
            CrystalDecisions.Shared.ConnectionInfo connectionInfo = new CrystalDecisions.Shared.ConnectionInfo();
            connectionInfo.DatabaseName = "x";
            connectionInfo.ServerName = "y";
            connectionInfo.UserID = "z";
            connectionInfo.Password = "a";


            CrystalDecisions.CrystalReports.Engine.ReportDocument crdProgressTarget = new CrystalDecisions.CrystalReports.Engine.ReportDocument();



            string FileName;
            FileName = Server.MapPath("Reports/rAsset.rpt");//""




            Random MyRandomNumber = new Random();
            tmpReportName = FileName.Replace(".rpt", "").Replace(".ltr", "") + MyRandomNumber.Next().ToString() + ".rpt";
            System.IO.File.Copy(FileName, tmpReportName, true);

            crdProgressTarget.Load(tmpReportName);

           
            CrystalDecisions.Shared.TableLogOnInfo crtablelogoninfo;
               foreach (CrystalDecisions.CrystalReports.Engine.Table crtable in crdProgressTarget.Database.Tables)
            {
                crtablelogoninfo = crtable.LogOnInfo;
                crtablelogoninfo.ConnectionInfo = connectionInfo;
                crtable.ApplyLogOnInfo(crtablelogoninfo);
            }
                       
            CrystalDecisions.Shared.ParameterValues crpPCId = new CrystalDecisions.Shared.ParameterValues();

            crpPCId.AddValue(PCId);



            crdProgressTarget.DataDefinition.ParameterFields["PCId"].ApplyCurrentValues(crpPCId);

            crv.ReportSource = crdProgressTarget;


            crv.DataBind();

        }
        catch (Exception Ex)
        {
            lblError.Text = Ex.Message + Ex.InnerException + Ex.Source;
        }

       

    }
LF.JPG
kamal_2002Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

coronoahcoroCommented:
I think you need to call the Close and Dispose method from the report object when you unload the report in order to fix this problem.
0
kamal_2002Author Commented:
im already doing that at page unload also their is a registry value for job work limits i increase it to maximium but problem still their
0
mlmccCommented:
Are you trying to run multiple reports in a single run or is this multiple runs of the application?

mlmcc
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

kamal_2002Author Commented:
we have only one report but there is more than 200 user access the rreport at the same time
0
mlmccCommented:
Crystal does have a limit on concurrent open connections.  I believe the default is 5.  So only 5 users can access reports at the same time.

mlmcc
0
kamal_2002Author Commented:
i think the time between the users maybe is 1 minute so lets say in 10 minute
nore than 80 time the report is access
0
mlmccCommented:
As I stated there is a limit of 5 concurrent accesses.

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
kamal_2002Author Commented:
this is didnt help me too much and im now just recyckung the application pool every time it stuck
0
kamal_2002Author Commented:
is the problem for 5 concurrent accesses. related to license issues??
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.