We help IT Professionals succeed at work.

Crystal Reports Server XI Page Server error 42452 & 42451

Hello CR server gurus!

I've been working on setting up a CR Server XI installation to publish my Peachtree Quantum CR reports to the web.
I've installed the CRSXI and everything is working fine EXCEPT the reports are not displaying. This occurs the same way on the localhost as well as remote client systems.
 
I can connect the objects to the reports via ODBC AND DSN and both bring up the report's options, if I put in the correct credentials and path in the process-->database -->custom login fields. I run the report and then ultimately an error in the Windows Server Application log appears.
First there is an ERROR 42452, "A Failure occurred while the Page Server was processing report, "blah blah" for user "blah blah"
Next there is an information alert 42451 "A Page Server subprocess was forced to terminate"
this is when the report returns the error, "Your request could not be completed because a failure occurred while the report was being processed. Please contact your system administrator "and closes. Well, I'm the system administrator and I don't know anymore about it!  

I've run through the CR2008 installed on this system and tested the reports, they work perfectly fine. The logons all check out and if I enter them incorrectly into the CRS object properties, I get "failed to logon" errors or "failed to access ODBC connection" and so on which tell me the reports are authenticating but failing to process.
the path statements in the object properties are NOT UNC paths and all resolve easily. The CRSXI is installed on a C:\ drive and the temp folders are all within the C:\ drive so I'm assuming they access to write the temp files they need to write to generate the report.
 
I've published the reports manually as well as with the publishing wizard, both return the same problems.

I've reached a wall guys and gals and need your assistance greatly!
thanks!
Comment
Watch Question

Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
WHich version of CR and CRS are you using?

Please open each and check the HELP --> ABOUT CRYSTAL

THere may be some incompatibility between CRS XI and CR2008.
Are you using optional parameters?

mlmcc

Author

Commented:
Hi mlmcc,
CR = Version 12.2.0.290
CRS = 11.5.3.438

Optional parameters = not that I know of, how can I confirm?
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Open the report in Crystal and check the parameters
Select each parameter
Right click it
Click EDIT

mlmcc

Author

Commented:
Hi mlmcc,
The only parameters in this test report are:

(LineItem.ItemClass) = [1,3,9,10,11] and
(@QTYOnHand) <> 0 and
(LineItem.ItemID) = (?Item ID Range)

do you believe it is a matter of these parameters that could be corrupting the output?
If so, why would it differ from CR 12 to CRS 11?

Is this something you'd think needs to be removed or is it better to upgrade to the latest CRS and get SAP support involved?

thanks,
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
I am not sure.  It may be that CR 2008 can't be used on CRS XI

mlmcc
I'll have to contact SAP, no one I've spoken with can figure out why it is not working.