dinologic
Programmer
- Mar 21, 2005
- 1
I really hope someone (or several someones) can give me an idea of where to look to solve this problem. Here's my setup:
Crystal Reports X (v10)
Win 2003 Server
IIS6 (running in IIS5 isolation mode)
Classic ASP (no .Net in use though .Net 2.x is installed and running)
At some point today, I suddenly could not retrieve any reports at all from this server. They run fine in the designer but when I try to pull them up in a browser, the script times out. Strangely though, there is at least one report that is relatively simple that DOES load. These reports have been in place for 2-3 years.
There are 2 things that happened today almost simultaneously that could be factors in this equation. I rebooted the server because of a seemingly unrelated issue at almost the same time of day that my network adminstrator made a severe change to our network. I don't have the details, but what he did was demote the primary domain controller and add a new server running active directory. This is part of an ongoing plan to upgrade our entire network.
So - my first question is - does it seem more likely that the reboot caused the problem or could it be this change to the network? The reboot could have completed the installation of the last Windows update (from 1/16/2009) but I'm not entirely sure. You know when the update installs and you keep getting that annoying msgbox asking if you want to restart the computer? It's possible that it could have been in that state since mid-January. I was thinking my first step would be to back out that update. Other than that, the only idea I have is to reinstall Crystal Reports.
Any suggestions (or even just moral support!) are much appreciated!
Thx.
Here's the way I typically code the ASP page for each report (some of the delimiters may be missing...this is just a snippet):
Crystal Reports X (v10)
Win 2003 Server
IIS6 (running in IIS5 isolation mode)
Classic ASP (no .Net in use though .Net 2.x is installed and running)
At some point today, I suddenly could not retrieve any reports at all from this server. They run fine in the designer but when I try to pull them up in a browser, the script times out. Strangely though, there is at least one report that is relatively simple that DOES load. These reports have been in place for 2-3 years.
There are 2 things that happened today almost simultaneously that could be factors in this equation. I rebooted the server because of a seemingly unrelated issue at almost the same time of day that my network adminstrator made a severe change to our network. I don't have the details, but what he did was demote the primary domain controller and add a new server running active directory. This is part of an ongoing plan to upgrade our entire network.
So - my first question is - does it seem more likely that the reboot caused the problem or could it be this change to the network? The reboot could have completed the installation of the last Windows update (from 1/16/2009) but I'm not entirely sure. You know when the update installs and you keep getting that annoying msgbox asking if you want to restart the computer? It's possible that it could have been in that state since mid-January. I was thinking my first step would be to back out that update. Other than that, the only idea I have is to reinstall Crystal Reports.
Any suggestions (or even just moral support!) are much appreciated!
Thx.
Here's the way I typically code the ASP page for each report (some of the delimiters may be missing...this is just a snippet):
Code:
dim reportname
reportname = "main.rpt"
%>
<!-- #include file="AlwaysRequiredSteps.asp" -->
<%
'====================================================
'SELECTION FORMULA
'====================================================
selection_formula = "{main.ID} = 12345"
session("oRpt").DiscardSavedData
session("oRpt").RecordSelectionFormula = cstr(selection_formula)
%>
<!-- #include file="MoreRequiredSteps.asp" -->
<html>
<head><title>Report Title</title>
<meta HTTP-EQUIV="Cache-Control" CONTENT="no-cache">
<meta HTTP-EQUIV="Pragma" CONTENT="no-cache">
</head>
<body>
</body>
</html>
<%' INSTANTIATE THE VIEWER%>
<!-- #include file="SmartViewerActiveX.asp" -->