We help IT Professionals succeed at work.
Get Started

Crystal Reports Server XI Page Server error 42452 & 42451

Last Modified: 2013-12-02
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!
Watch Question
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE