Can't load report after I reformat my server HDD

[ringo]

Hi,

Today I had formatted my server HDD to do some re-partition. After that, I installed back my web application and found out that I can't open to view the report anymore. I have done a few testing as below:

My web application is written in ASP.NET and running in Windows Server 2003 with IIS6. The database is MS SQL 2005 Standard Edition installed in same server. The report is created as "MRT" format and when my web application will pass the query string into it to open the report.......

1) Create a sample report which extract only a few lines of record, this report can be opened but very slow (around 10 ~ 15 seconds)

2) Create a sample report which extract around 200+ records, this report cannot be opened, it just display blank page and continue process

3) I put my web application in another Windows Server 2003, but the database still in original server and this time all reports can display

Anyone have any idea what the above problem? Please help, I spent almost ~8 hours but still find out why.

And FYI, the sample report I created is a very simple report, nothing fancy, just a "SELECT" query and display multiple rows of records in report.

[Andrew]

Hello,

Please check the server settings.
Possibly, too little of processor time is given for your process, or not all permissions are set.

Thank you.

[ringo]

Thanks Andrew......yes, we figured out it's something to do with the server configuration because some other issues happened too besides the report. So we decided to move the web application to another server but this time everything work fine except the report is still having issue.

This time, when we open the report, sometimes it display but sometimes it doesn't (only the navigator on top appear with number of pages but the report content is empty). We tested for the same report, let say 10 times, only around 2~3 times report is displayed correctly.

Below is one of my sample report code:

StiReport report = new StiReport();
report.Load("PackingList.mrt);

StiSqlDatabase sqlDB = new StiSqlDatabase();
sqlDB = (StiSqlDatabase)report.Dictionary.Databases["Conn"];
sqlDB.ConnectionString = connectionStr;

string sqlQuery;

sqlQuery = "some sql query"

StiSqlSource myDataSource = new StiSqlSource("Conn", "tLotTrack_Ship_Main", "tLotTrack_Ship_Main", sqlQuery);
report.Dictionary.Databases.Clear();
report.Dictionary.Databases.Add(new StiSqlDatabase("Conn", connectionStr));
report.Dictionary.DataSources.Clear();
report.Dictionary.DataSources.Add(myDataSource);
report.Dictionary.Synchronize();
report.Dictionary.Connect();
report.DataSources["tLotTrack_Ship_Main"].SynchronizeColumns();
report.Render();
StiWebViewer1.Report = report;

Pls note that, I have tried with both RederMode AjaxWithCache or UseCach but same result occured. Everything was working just fine when the application is running in old server.....pls help me because all my users are starting complain

[ringo]

Update:

User reported after the server is restart, everything work fine but two hours later, problem re-appears....

[ringo]

Another Update:

I create a very simple report with only one line of text (no connection to database at all) and same problem happened. Report open a few times ok, then not ok, after sometime, report can be opened again.

PLEASE PLEASE help, this problem is really killing me

[Ivan]

Hello,

Please try to allocate much memory on the report server for the process.

Thank you.

[ringo]

I finally got the problem solved by trial and error.....what I did is to set the CacheMode = "Session" for the Report. However, I would like to know what is the different between "Session" and "Page" for the CacheMode?

[Vladimir]

Hello,

If the cache mode is set to Session, then rendered report will be stored in the user session. Otherwise, rendered report is stored in a server cache.

Thank you.

[ringo]

So, if I set back to CacheMode="Page" and the above error happened again, does it means that my server cache is not enough to process the report? FYI, I'm trying just open a sample report with one line of text only (without any connection to database) but I still can't open the report every time (try to open 10 times, may first 3 times ok, then the rest is not ok.....but after a while, it's ok again and the same pattern repeat). And another thing is the server is running on Windows Server 2003 with 2GB of RAM.

[Vladimir]

Hello,

Most likely, you have a limited cache size in the IIS server settings.

Thank you.