Unable to connect: incorrect logon parameters: error

[markVII]

I have a bizzare problem displaying a report in Crystal Enterprise. The report contains a subreport, and both are calling the same Oracle 8i stored procedure to access data.

The report works fine in Crystal IDE, but posted into Crystal Enterprise, it behaves differently.
1. Scheduling report runs and finishes successfully. An attempt to display it results in an error: "Unable to connect: incorrect logon parameters. File ~...." etc. When Refresh button is pressed, reports is displayed without any problem.

2. If instead of scheduling, a View option is selected, the report displayes without any problem.

Now, the subreport is placed in details section of the main report. I have tried put it into Page Header section, Page Footer section etc. The results are exactly the same as described above.
Did anybody hd encountered this problem?

 

[synapsevampire]

Sounds very odd, though why would you place a SP in the details if placing it in the page header work? Anyway, I'll assume that this was just for testing purposes.

It sounds like some overview is required, and you should consider putting some effort into posts to include:

Crystal version
Database used
Connectivity used
Example data
Expected output

CE has it's own DLL's and proceses slightly differently. Applying the service packs is critical:

http://support.businessobjects.com/fix/hot/si75/?ref=default.asp_selectlist

How you're connecting to the database can be very critical, for instance a common mistake is to use the Oracle ODBC driver, which almost always causes problems at some point.

Hopefully the service pack will solve this. If not, try scheduling it to an RTF export and check those results (I assume that you're scheduling to an RPT format, but that's another unknown).

-k

 

[markVII]

I am using Crystal Reports 8.5, and Crystal Enterprise 9.0
Putting the subreport into page header works, but I need 6 subreports each printed on its own page sharing the same header. Putting subreports into details seems like a logical choice. If CE is configured to produce PDF output, everything works just fine...
----------------------------------
Crystal version 8.5/ CE 9.0 (no service packs)
Database used Oracle 8i, through stored prod.
Connectivity used ODBC, native Crystal Driver
Example data nothing special, four columns returned by a stored procedure
Expected output crystal...I guess, I'll have to use PDF...
----------------------------------
My search lead me to this article:

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

While it talks about Lawson OLE DB provider, I have a hunch that this is somehow related...

Thank you for your response!