CE 10 - Failed to load Database Information

[Stradlater]

I have been using Crystal Enterprise for a suitably long while now and have several installations across a few machines. However, I have just recently done my first installation on a machine that is physically miles away from a database server and heavily firewalled in between.

I have now got all our reports on the crystal server and all the relevant information on the database server. I have installed the oracle 9i client on the crystal server and the oracle client is happy with it's connection to the database server.

However, whenever I load a report, it always brings up this "Failed to load database information in report blahblah.rpt" It ALWAYS does it, regardless of what report it is I'm trying to run AND what the database logon information in the CMC says.

This is starting to get to a crucial stage and I'm at my wits end. Despite the fact that we have this $$$$$'s worth of crystal support, I'm getting minimal loving out of that.

Anyone got any ideas?

 

[Turkbear]

Hi,
Just so I understand ( because of the firewall issue):
From the Crystal machine that will be running the reports, you can use the Oracle SqlPlus( or some other Oracle tool)
to connect ( using the same user/pass/instance as the reports use) and retreive data from the 'distant' database server's instance. Is this correct?
Have you configured the CE Web Component Service to work with the firewall? ( the -requestport portnumber command line setting)







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Stradlater]

I can retrieve the data from the 'distant' database using Oracle sqlplus or any other oracle tool.

I haven't had to set the WCS to work with the firewall, as the Tomcat and the crystal installation are on the same box, so they are not effected by the firewall

 

[ShortyA]

Whoever looks after your firewalls should be able to provide assistance on if you are being blocked on the basis of your IP address and also the port you are coming in on.

However, I suspect that it is specifically your Job and Page Servers that are being blocked by the firewall. From what I remember (not on CE at the moment) you can specify which port pretty much every CE service runs on so you could set the Job and Page servers to a port that your firewall will allow (again chat with the firewall administrators to agree a port).

ShortyA