database logon information

[goodprg]

I have published a report in Crystal Enterprise. In the database tab I have username and password and the prompt user for logon info is unchecked. Still it is asking me for the db info when I try to preview it.

Thanks

 

[Turkbear]

Hi,
After you supply it, does the report run as expected?
BTW, What version of CE, how are you previewing it and what database is used?

 

[goodprg]

no it doesn't run. It just keeps on asking logon information. I am CE9 and database is Oracle 9i

 

[midearth]

Maybe this will help.

http://support.businessobjects.com/library/kbase/articles/c2013268.asp

The only problem I've had after loading this hot-fix is that it "un-fixed" some other functionalities such as exporting to pdf and WORD which I'm now trying to resolve.

 

[goodprg]

My report is not based on a query it is based on a table and it is a very simple report which just lists everything in the database.

There are some other reports is CE which runs just fine and I don't know why? I am new to CE that is why I created a simple report and tried to publish and preview it but it failed. The other reports which runs fine were created by some other person who doesn't work here anymore.

Thanks for all the help.

 

[Turkbear]

Hi,
Do other reports using the same database table run OK?

If not, check the Oracle client installation on the CE server to be sure the tnsnames.ora file is correct..
( try using SqlPLus from the CE server to connect to the same database table)

 

[goodprg]

How do I connect to SQL Plus from CE?

Thanks,

 

[Turkbear]

Hi,
If the Oracle client was installed with the standard options, there should be an entry in the Start menu ( under Oracle..Application Development Tools maybe) for SqlPlus.

The program itself is :
<YOUR_ORACLE_HOME>/bin/sqlplusw.exe

 

[goodprg]

Hi

It was a tnsnames issue. It worked but now when I enter all the parameters and run the report(it takes some time to get the result atleast 3-4 min) I get this Error - Timeout waiting for Crystal Pageserver to respond.

What does this mean?

Thanks again for your prompt help.

 

[Turkbear]

Hi,
It usually means that the query used by the report is inefficient and that it takes to long to return data to Crystal..

Try the sql in SqlPLus ( use the database..show Sql Query, copy the code and open a sqlplus session . paste the select statement and see what happens)

Also check the timeout values for the Pageserver ( minutes before an idle connection is closed)

 

[goodprg]

Hi,

How do I check the timeout value for Pageserver?

Regards,

 

[Turkbear]

HI,
In the CMC you wil find it in the servers section..Click on the pageserver entry and it will be there..( In V8.5 it is 'Minutes before an Idle job is closed', in V10 there are additional options, but I do not know what is in v9)

 

[goodprg]

The setting of "Minutes before an Idle job is closed" is 20 .

Does it mean that page server will wait for 20 min to get further requests from idle connection. And if no requests are there it will time out.

What should be the idle value for this parametr?

Thank You so much.

 

[KingfisherINC]

This error is actually Internet Explorer timing out after five minutes before the first page comes back, I'm not sure if you can change this.

It is not related to the "Minutes before an Idle job is closed"

Kingfisher

 

[Turkbear]

Hi,
Yes, that's what it means, but I doubt that it is causing the problem ( upon further reflection).


Were you able to try the query in SqlPlus?

It still seems like a bad query that just takes too long to return data for some reason.

 

[goodprg]

This query takes about 5 minutes to run. The report come back in 5 minutes when I preview it in Crystal reports.

What should I do so that I can preview this report from CE?

Thanks

 

[KingfisherINC]

Try this:

(1) Add a ReceiveTimeout DWORD value with a data value of (<number of seconds>)*1000 in the following registry key:

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings

For example, if you want the timeout duration to be 8 minutes, set the ReceiveTimeout data value to 480000 (<480>*1000).

(2) Restart your computer.

Kingfisher