[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Crystal Enterprise won't run report for remote web browser

Posted on 2007-08-09
12
Medium Priority
?
894 Views
Last Modified: 2008-01-09
Hello Experts,
I have a problem with Crystal Reports Enterprise and need some guidance. Here is what I have:
We have an aging server that I am replacing that currently runs Crystal Reports 8.5 and Enterprise version 8. Users access the Crystal Reports via a web browser pointed to www2.ourdomain.com where www2 is the file server I am replacing. It works fine and has for years. It is the default web server in IIS and basically the reports sit in a folder under wwwroot. example:  wwwroot\lumber\reportname.rpt and the web pages organizing them for the user are super simple html pages.
The new server is a member of the domain and an ADS "secondary" at the moment and everything else on it is working fine. It has DNS and is a secondary to the old server's DNS, and is pointing to itself for DNS resolution. It is called www3 and shows in DNS properly.
THE PROBLEM: In short, when accessing the report, it would open it up in Crystal Reports instead of running. I then found out I needed to register the ISAPI extensions on this web site for .cri,.csp, cwr,. and .rpt to the file wcinaspi.dll which I did (and rebooted.) Now I get a 404 "File not found" when trying to access the .rpt file from the web page.
IUSR_FPS02 is the user for anonymous access and for troubleshooting, I have given full control access to the root of wwwroot for this user.

In an attempt to make the Crystal service work like the old one I have done the following:
Installed Crystal Reports 8.5
Installed Crystal Enterprise 8
Copied the files from the old server inetpub\ wwwroot along with subdirectories to the new server.
Ran the report wizard without errors.
Registered the ISAPI dlls in IIS mgr and rebooted.
Double checked security permissions on \inetpub\wwwroot and subfolders (and report files.)
Checked that the Crystal Services are running (they are.)
Made the settings in IIS to be the same as they are on the old server:
Made sure any paths in the htm pages point to www3 instead of www2 (only a few.)
Double checked to make sure my Data Connector is correct (it is - I can access the Interbase database fine from other programs.
Made sure the report files really are where they are supposed to be (\inetpub\wwwroot\lumber )

Properties under iis mgr say that this server is running an old version of server extensions 2002, so I downloaded and applied and rebooted but it didn't make any change (even in iis mgr. I don't think it's related but thought I'd throw that in.)

As you can see, I am a networking guy, but I don't know JACK about Crystal reports. Any guidance will be appreciated.

0
Comment
Question by:ChrisHelvey
  • 9
11 Comments
 

Author Comment

by:ChrisHelvey
ID: 19663660
And another thing:
I cannot run the Crystal Management Console. I get a 404 file not found error on this URL:
http://fps02/crystal/enterprise/admin/redirect.csp 

(FPS02 is the name of the new server as well as www3)

It has the same files in that directory as the other server... I assume this has something to do with .csp registration, but I have done that and it shows up pointing to the correct .dll in IIS manager home directory tab. Soemthing tells me this is all related to why it doesn't work. I need to find out how this Crystal .dll registration works or how to verify it is in fact registered.
0
 

Author Comment

by:ChrisHelvey
ID: 19664157
I found a Crystal document telling how to check the registered .dlls for IIS. I am going to follow that, along with making sure the IUSR_FPS02 has sufficient permissions everywhere necessary according to the Crystal document published specifically about security permissions with Enterprise. Will follow up.
0
 

Author Comment

by:ChrisHelvey
ID: 19665746
Still no luck. I have added the script map key in the registry per the cr8_winsapi-Version8.pdf document from Crystal with .rpt, csp, cwr, and .cri and made sure the extensions in iis mgr show the full path name with quotes around them "C:\Program Files\Seagate Software\WCS\wcsinsapi.dll" for all the above extensions as well.
Then rebooted.
No audit security failures in the event log show up. So I don't think it's permissions.
I still get 404 File not found whenever it tries to access the .rpt (or the http://fps02/crystal/enterprise/admin/redirect.csp for that matter.)

I'm lost and don't know where to go next....what else can I check?
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 

Author Comment

by:ChrisHelvey
ID: 19665761
So, in IIS mgr. Should the registration for the dlls be in short format as the document says, or the long format with quotes? Currently in long format with quotes.
0
 

Author Comment

by:ChrisHelvey
ID: 19665860
And here is the log from IIS when trying to access the .rpt file:

#Software: Microsoft Internet Information Services 6.0
#Version: 1.0
#Date: 2007-08-09 20:21:39
#Fields: date time s-sitename s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status
2007-08-09 20:21:39 W3SVC1 10.0.0.2 GET /crystal/enterprise/admin - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 301 0 0
2007-08-09 20:21:39 W3SVC1 10.0.0.2 GET /crystal/enterprise/admin/Default.htm - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
2007-08-09 20:21:39 W3SVC1 10.0.0.2 GET /crystal/enterprise/admin/redirect.csp - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 404 2 1260
2007-08-09 20:35:38 W3SVC1 10.0.0.2 GET /crystal/enterprise/admin/default.htm - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
2007-08-09 20:35:38 W3SVC1 10.0.0.2 GET /crystal/enterprise/admin/redirect.csp - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 404 2 1260
2007-08-09 20:38:07 W3SVC1 10.0.0.2 GET /crystal/enterprise/admin/redirect.csp - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 404 2 1260
2007-08-09 20:38:16 W3SVC1 10.0.0.2 GET /Default.htm - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
2007-08-09 20:38:18 W3SVC1 10.0.0.2 GET /lumber_reports.html - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
2007-08-09 20:38:19 W3SVC1 10.0.0.2 GET /lumber_tally.html - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
2007-08-09 20:38:21 W3SVC1 10.0.0.2 GET /lumber/lumbertally.rpt user0=sysdba&password0=masterkey&init=actx 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 404 2 1260
2007-08-09 20:38:43 W3SVC1 10.0.0.2 GET /lumber/lumbertally.rpt user0=sysdba&password0=masterkey&init=actx 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 404 2 1260
2007-08-09 20:38:53 W3SVC1 10.0.0.2 GET /lumber/lumbertally.rpt - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 404 2 1260
2007-08-09 20:40:10 W3SVC1 10.0.0.2 GET /Default.htm - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0
2007-08-09 20:40:12 W3SVC1 10.0.0.2 GET /lumber_reports.html - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0
2007-08-09 20:40:13 W3SVC1 10.0.0.2 GET /lumber_tally.html - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 304 0 0
2007-08-09 20:40:13 W3SVC1 10.0.0.2 GET /lumber/lumbertally.rpt user0=sysdba&password0=masterkey&init=actx 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 404 2 1260
2007-08-09 20:44:38 W3SVC1 10.0.0.2 GET /Default.htm - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
2007-08-09 20:44:41 W3SVC1 10.0.0.2 GET /lumber_reports.html - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
2007-08-09 20:44:42 W3SVC1 10.0.0.2 GET /lumber_tally.html - 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 200 0 0
2007-08-09 20:44:46 W3SVC1 10.0.0.2 GET /lumber/netshort.rpt user0=sysdba&password0=masterkey&init=actx 80 - 10.0.0.2 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.2;+SV1;+.NET+CLR+1.1.4322;+.NET+CLR+2.0.50727) 404 2 1260
0
 

Author Comment

by:ChrisHelvey
ID: 19667164
I am seeing in the Crystal log that it is referring to my old server (IWPNT4) .
Where does this come from. Still getting 404 Page or directory not found.

Anyone?
0
 

Author Comment

by:ChrisHelvey
ID: 19667165
Here is the piece from the log:
2007-08-08 19:06:33 156 658 /crystal/enterprise/admin/en/infoobject.cwr?action=%2D10005%26id=123%26WCSLOGONTOKEN=IWPNT4%253A3C7B3C63AC5E4AE0971850492B99AFF0
2007-08-08 19:06:33 0 828 /crystal/enterprise/admin/en/infoobject.cwr?action=%2D10005%26WCSLOGONTOKEN=IWPNT4%253A3C7B3C63AC5E4AE0971850492B99AFF0%26cmd=path2%26id=123
0
 
LVL 42

Expert Comment

by:frodoman
ID: 19669302
Can you get into the crystal management console?  If so, have you checked manage servers to make sure everything in there is pointing to your new server?
0
 

Author Comment

by:ChrisHelvey
ID: 19670675
I still can't access the management console. I get 404 Fiie not found on http://fps02/crystal/enterprise/admin/redirect.csp  .

Anything .csp does not work. I have checked the registrations in IIS and tried them as short file names and long file names with quotes and with complete reboots in between. I also checked the registry and added the script map key with .rpt ..csp,. cwr. and .cri as stal document is stated in the documentation for troubleshooting the Web connector.

Still lost. I think I will now try another re-install, but I really think the problem is in the IIS registrations for the crystal web connector. Is there anyway to KNOW if the .dll is registered?
0
 

Author Comment

by:ChrisHelvey
ID: 19749110
Solved myself. In Windows 2003 IIS you need to "allow" specific ISAPI filters to run. Done in the management console.
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 19945932
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Screencast - Getting to Know the Pipeline
Suggested Courses
Course of the Month19 days, 16 hours left to enroll

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question